You need to setup sqlnet.
Probably running Net easy config will do, but the Net8 assistant should
definitely generate a correct sqlnet setup.
You need to specify
- the protocol (TCP/IP)
- the host
- the port number (usually 1521)
- the SID (ORCL)
For the second database repeat that and specify ORC0 as the sid.
You should end up with two sqlnet service names ORCL and ORC0.
Now simply use sqlplus80 system/manager_at_ORCL or system/manager_at_ORC0
and that should be it.
Hth,
--
Sybrand Bakker, Oracle DBA
<adamsn99_at_my-deja.com> wrote in message news:84b6o2$fbo$1_at_nnrp1.deja.com...
> 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 - 15:18:07 CST
