Re: ***DBA question--Help please

I think that you need to use the Oracle Net8 Easy Config program and add an Alias for the TEST instance.
You current connections are using the 'beq-local' (Oracle Bequeth Adapter) and are performing RPC-style communications with the DBMS. The syntax is different between SQL*Net 1.x (Oracle7) and SQL*Net 2.x/Oracle8; it's user/password_at_2:instance (2: = TwoTask Driver) and user/password_at_alias respectively.

As an exercise to foster understanding; look at your %OracleHome%\Net8\Admin\TNSNames.ora file (Please don't change it.) before and after running the Oracle Net8 Easy Config program. (Note the linkages/Instance Name)

Mike Rose

Manmohan Mann wrote in message <36EC00A5.76A5EADF_at_hotmail.com>...
>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.

>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?
Received on Sun Mar 14 1999 - 14:20:21 CST