Current Position:Home > I have serious problem,please help me.....

I have serious problem,please help me.....

Update:11-30Source: network consolidation
Advertisement
Hi all;
i have a big problem.... i can't connect to my database orcl2. whenever i write
c:>sqlplus "/as sysdba"
it does not do anything. The following row is
c:>
if i write c:>sqlplus /nolog
it goes to another cmd screen
sql>..................
but i get errror while sql>conn [email protected] as sysdba
tns could not resolve service name... i'm in trouble.. whenever i attempt to do;
i looked in TNSNAMES.ora file, and host name with sid names are true.It is no doubt that there is no problem there.... please i have to connect to my database as soon as possible.Thanks for your help now on..Best regards......

The Best Answer

Advertisement
You can use tnsping to "ping" the listener, or something else that occupies the port (with various results), but it will not tell you if a service/sid is available or not on that listener.
C:\>tnsping (description=(address=(protocol=tcp)(host=localhost)(port=1521))
(connect_data=(sid=nothing_here))) 3
TNS Ping Utility for 32-bit Windows: Version 10.2.0.1.0 - Production on 13-NOV-2006 21:56:31
Copyright (c) 1997, 2005, Oracle.  All rights reserved.
Attempting to contact (description=(address=(protocol=tcp)(host=localhost)(port=1521))
(connect_data=(sid=nothing_here)))
OK (30 msek)
OK (0 msek)
OK (10 msek)Message was edited by:
orafad
  • A problem with threads Update:10-11

    I am trying to implement some kind of a server listening for requests. The listener part of the app, is a daemon thread that listens for connections and instantiates a handling daemon thread once it gets some. However, my problem is that i must be ab

  • A problem with Threads and MMapi Update:10-11

    I am tring to execute a class based on Game canvas. The problem begin when I try to Play both a MIDI tone and to run an infinit Thread loop. The MIDI tone "Stammers". How to over come the problem? Thanks in advance Kobi See Code example below: i

  • J2ME problem with threads Update:10-11

    Hi all, I would like to ask you for a help. I need to write a small program at my university. I started to write a midlet which function would be to countdown time for sports activities. I woul like to start a new thread - the one that counts down -

  • Problem with threads within applet Update:10-11

    Hello, I got an applet, inside this applet I have a singleton, inside this singleton I have a thread. this thread is running in endless loop. he is doing something and go to sleep on and on. the problem is, when I refresh my IE6 browser I see more th

  • Problem with Threads and a static variable Update:10-11

    I have a problem with the code below. I am yet to make sure that I understand the problem. Correct me if I am wrong please. Code functionality: A timer calls SetState every second. It sets the state and sets boolean variable "changed" to true. T

  • Problem with threads running javaw Update:10-11

    Hi, Having a problem with multi thread programming using client server sockets. The program works find when starting the the application in a console using java muti.java , but when using javaw multi.java the program doesnt die and have to kill it in

  • Problem with Threads and "plase wait..."-Window Update:10-11

    Hi everyone, I have a problem that I'm not able to solve in any way... I have a time-consuming task (a file decryption) which I execute in a separate thread; I've used the SwingWorker class, like suggested by sun-tutorial, and it works right. The pro

  • Problem with threads in j2me Update:10-11

    im using jdk 1.6 with java wtk 2.1 ya i know.. 2.1 is a jdk1.4 source but im using souce as 1.4 during compiliation so thats not the prob this is my code package org.learn; import javax.microedition.midlet.MIDlet; import javax.microedition.lcdui.Aler

  • Problem with threads and camera. Update:10-11

    Hi everybody! I've a problem with taking snapshot. I would like to display a loading screen after it take snapshot ( sometimes i have to wait few seconds after i took snapshot. Propably photo is being taken in time where i have to wait). I was trying

  • Problem with threads and graphics Update:10-11

    I have a thread that chooses paths for a Travelling salesman problem, it then calls a TSPdraw class and passes it the path, which the class then draws. the problem is when i have two threads it creates two windows but only draws a path in one of them