OraFAQ Forum: Server Utilities

Home » RDBMS Server » Server Utilities » Finding DB name

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

Finding DB name [message #71070]

Wed, 04 September 2002 22:23

RYAN
Messages: 22
Registered: December 2000

Junior Member

Hi guys.
I posted a topic the other day about an error I was getting and Sunil had said to use my database name as my sid. My only question is how can I find out what my database name is. I didn't install oracle onto my computer. My school did it for us so I have no clue as to what they may have named the database. Please help. An interviewer wants to see a few of my projects(all of which are using oracle)Friday morning and I'm getting very nervous I may be going to his office empty handed. Thanks.
-Ryan

Report message to a moderator

Re: Finding DB name [message #71071 is a reply to message #71070]

Wed, 04 September 2002 22:47

Raj
Messages: 411
Registered: November 1998

Senior Member

Hi,

If you have DBA rights or login as user:system/manager,

Select * from v$databases;

it will list the database names.

raj

Report message to a moderator

Re: Finding DB name [message #71075 is a reply to message #71071]

Thu, 05 September 2002 07:35

RYAN
Messages: 22
Registered: December 2000

Junior Member

Actually, I can't do that.
The error I'm getting(ORA-12560: TNS Protocol Adaptor Error) won't allow me to sign in.
Is there any other way to find out the database name?

Report message to a moderator

Re: Finding DB name [message #71079 is a reply to message #71075]

Thu, 05 September 2002 17:19

Lena
Messages: 17
Registered: August 2002

Junior Member

Check it under your tnsnames.ora the instance name is listed there...

Report message to a moderator

Previous Topic:	urgent
Next Topic:	Re: I have a problem with my loggin in SQL PLUS

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun May 05 22:31:25 CDT 2024