V$INSTANCE view in 8.1.6

Hi.

We are running 8.1.6 on NT here. This is a newly installed DB, not migrated from 8.

I have a question about the INSTANCE_NAME column in the V$INSTANCE table.

When I select this column, for my DB the value is UAR.

Yet, in my init.ora file I have instance_name defined as uardb and I use this value all over to connect via ODBC, JDBC, etc.

Where is the Instance_name getting populated from in the v$instance table??

I did use SID=UAR when creating my DB with the ORADIM command. (Here's that statement: ORADIM -new -startmode auto -sid UAR -intpwd RDBMS - maxusers 10 -pfile d:\oracle\ora81\admin\UAR\pfile\initUAR.ora). I had thought in 8.1.6 that the SID wasn't really used any more.

This is causing us some problems as we get the instance_name value from the V$INSTANCE table to construct our JDBC clause to run part of our app. It is erroring out (Connection refused is the error we see ERR=12505). Have I set up something incorrectly?? Can I get this value somewhere else??

I am still searching through the Newsgroups and Docs to see what I can find, but so far I haven't had much luck! If you can point to some good info on this too that would be great!

--
Thanks for the help!

E. Elliott


Sent via Deja.com http://www.deja.com/
Before you buy.