MULTIPLE DATABASES ON ORACLE8

From: <vpenmatsa_at_hotmail.com>
Date: Sun, 28 Feb 1999 00:38:37 GMT
Message-ID: <7ba36c$aha$1@nnrp1.dejanews.com>

Hi all,

I'm having Oracle 8.0.5 on Windows NT ....

I created a new database (apart from the default ORCL database) & gave it a SID = 'ATMD' , I started the required 'OracleServiceATMD' & 'OracleStartATMD' services & also made sure that my TNSnames.ora & Listener.ora file have the changes to accomodate this new database . I'm able to connect to this database through Instance Manager , Security Manager & also SQLWorkSheet , but when I try to connect to Svrmgr30 , it gives me -- 'ORA-error TNS - could not connect to destination ' ............

So, can U give me any ideas on this ..... ?

also, do we need to have separate 'TNSnames.ora', 'Listener.ora' or a separate Listener service for this new database ... ?

Thanx , by .

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Sat Feb 27 1999 - 18:38:37 CST