Re: 2 instances looking at the same database

> Ya beauty. This is exactly the answer I was looking for. Now that you have
> spelt it out for me, I realise that perhaps with enough lateral thinking I
> could have worked this out myself. Sometimes you get too close to the
> problem and go off on a tangent.

SQL*Net basics are really simple once you understand them ;-)

> On a final note, is it possible to rename an instance ? Is it as simple as
> changing the oratab, init{SID}.ora ( and contents ) ?

It may not be complete, but it's something like this:

shutdown database

copy init<oldsid>.ora to init<newsid>.ora. Don't think it needs any editing. Remember : the database name doesn't change only the SID.

edit oratab, .profile, tnsnames.ora

export ORACLE_SID=<newsid>

startup the database
select * from v$database; gives you the database name select * from v$thread; gives you the sid

change listener.ora
reload listener

Have fun,
Rob. Received on Mon Jun 25 2001 - 21:47:23 CEST