Re: V$INSTANCE view in 8.1.6

If you did use SID=UAR with oradim that is your explanation. Without any doubt the sid is being maintained in the controlfile, and v$instance is a view on the controlfile. IOW you need to delete the sid (if you do that in commandline mode the database files are not deleted), edit init<sid>.ora, change the name of the controlfiles in both init<sid>.ora and on disk, and create a new instance. If you do this again in commandline mode, it will not create a new database.

Hth,

Sybrand Bakker, Oracle DBA

"EElliott" <elliottel_at_my-deja.com> wrote in message news:8rfthl$cml$1_at_nnrp1.deja.com...
> 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.
Received on Wed Oct 04 2000 - 15:22:23 CDT