OraFAQ Forum: Server Utilities » Another ora-12560 error. Needs to work by Fri.

Home » RDBMS Server » Server Utilities » Another ora-12560 error. Needs to work by Fri.

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Another ora-12560 error. Needs to work by Fri. [message #71057]

Tue, 03 September 2002 16:02

RYAN
Messages: 22
Registered: December 2000

Junior Member

Hi guys.
I know this question was asked a little while ago but the advice offered on that thread didn't help for my error. Basicaly, I'm a recent graduate of a school which provided us with oracle 8 and I know how to use it however when it comes to the backend stuff(go to regedit, set oracle_sid, etc), I know absolutely nothing.
Basically, I get the error ORA-12560: TNS:protocol adaptor error after trying to sign in to oracle.
I'm running Win 2000 and my ORACLE_SID is currently listed as "scott".
If it's possible could someone please give me step by step instructions in where to go to fix this. I have my first job interview since graduating school on Friday and he wants to see some of the work I've done with oracle and I'm getting a little nervous that I won't have it fixed in time. I would be most appreciative.
Thanks in advance.
-Ryan

Report message to a moderator

Re: Another ora-12560 error. Needs to work by Fri. [message #71058 is a reply to message #71057]

Tue, 03 September 2002 19:30

sunil bhola
Messages: 58
Registered: July 2002

Member

Do one thing
set the oracle_sid="your database name" at command prompt
c:>set oracle_sid=sunil
to show the oracle_sid
type
c:>set oracle_sid

or do one thing(through regedt32)

go to hkey_local_machine=>oracle=>oracle_sid="database name"

Report message to a moderator

Re: Another ora-12560 error. Needs to work by Fri. [message #71063 is a reply to message #71057]

Wed, 04 September 2002 08:26

RYAN
Messages: 22
Registered: December 2000

Junior Member

::set the oracle_sid="your database name" at command prompt::

Sorry if this sounds like a stupid question but where can I look to find out what my database name is? Thanks again.
-Ryan

Report message to a moderator

Re: Another ora-12560 error. Needs to work by Fri. [message #71201 is a reply to message #71063]

Tue, 24 September 2002 02:42

Robert Kuhlmann
Messages: 35
Registered: March 2002

Member

connet internal or someone with the DBA role
and
select name from v$database;

Report message to a moderator

Previous Topic:	Re: FREE OCP PAPERS
Next Topic:	How to copy table from user to another user in another server

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Jan 10 21:58:50 CST 2025