Re: ***DBA question--Help please

There is an environment variable in the registry ORACLE_SID, by default set to ORCL. If you change it to TEST, then the TEST database will become your default.

I am not clear on how you currently access the TEST database using svrmgr. I use the syntax 'connect id/password_at_2:test' as an example. This works the same way in svrmgr, sql*plus, enterprise manager, etc.

BTW, i am running under Oracle 7.3.4 If you are using Oracle 8 then things might have changed, although for backwards compatibility I doubt Oracle would have stopped supporting the above syntax.

I hope this helps,

Manmohan

BAMBAM6235_at_AOL.COM wrote:
>
> Hi all,
>
> I have created two databases on one NT box. I have the original
> database 'ORCL' that I can connect to as the default without
> specifying a connect string. The second database 'TEST' has been
> created and the services are running but don't know how to connect to
> it. The question is how do I connect to TEST through SQL*Plus or
> another application? I can connect through svrmgr and can log in as
> 'SYS', SYSTEM, and INTERNAL. I can also create users, query, etc.
> Any help would be greatly appreciated.
>
> Thanks
> Rick
Received on Sun Mar 14 1999 - 12:30:54 CST