Problem Accessing Multiple Databases Services

I'm running Oracle Enterprise 8.0.4 on an NT Workstation 4.0/SP4 machine. I'm running Oracle standalone.

Problem: I've created two databases and can't figure out how to access the one that is not currently set as the default.

One database is called 'ORCL' and one called 'ORC0'. Each of these databases has an associated OracleService and OracleStart service running in NT. If ORCL is set as the default database and I try to run SQL on ORCO by logging in as User Name: System, Password: Manager, Host String: ORC0, I get the ORA-12154 error. The same happens if I try to access ORCL while ORC0 is the default. The only way I currently can get around this is to got to the registry and set the ORACLE_SID to the database I'm currently interested in.

How do I configure Oracle so that I merely have to enter the appropriate Host String to access the database of I'm interested in?

Nathan Adams

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Tue Dec 28 1999 - 14:39:44 CST