Newbie Question: DB Name

[Quehay]

Sorry to muck up the waters with a newbie question...

I installed the 8.0.4 Personal Edition for Win 95 so that I could practice at home. I'm trying to connect with a demo copy of PL/SQL developer, but having trouble with the db name. I can log on Scott/Tiger with SQL*Plust--no problem.

But, I don't know the name of my "Server/Instance". This is using just the PC (no listener and TNS...I think).

What is a script that will tell me the database?

THANKS!

 

[Quehay]

Dear Newbie:

Do keyword seach first under 'database name' !!

carp (MIS) Jul 8, 2001
You might try looking at your init.ora file. Its name should include the name of your SID (e.g., if your init.ora file name is called initORCL.ora, your SID is ORCL). Also, the database's name should be contained in the init.ora file under the parameter DB_NAME.

 

[rtefft]

If you can login using Scott, you can also try "select name from v$database" to get it. You may have to login as SYS for this one as it is usually not accessible to other accounts without a grant. I use this to set my SQL*Plus prompt to the name of the database whenever I connect.
____________________________
Rich Tefft
PL/SQL Programmer