Re: Can't create a second database on Oracle 7.3/VMS 7.1!

From: der1004_at_cus.cam.ac.uk (Duncan Reed) >> Well Oracleins seems to setup all the logicals (environment variables) correctly. i.e. ora_sid, directories e.t.c. It then seems to just ignore them and tries to connect to the other db. <<

 If you can not get into sqlplus, try sqldba or svrmgrl. If they work, but sqlplus does not I believe it has to do with sqlnet. There is a file, maybe a com file, but probably sqlnet.ora that has to have the new sid added to it. If you are using sqlnet version 2 you also need to modify listener.ora and tnsnames.ora.

Mark Powell -- Oracle 7 Certified DBA
- The only advice that counts is the advice that you follow so follow your own advice - Received on Sat Feb 14 1998 - 00:00:00 CST