ORA-12203 and SQL*Net V1/V2

Greetings all -

I have the following setup:

Various Oracle 7.1.4 servers running SQL*Net V2 and something I assume is V1. It is started by using a command called 'tcpctl' and reads a file in /etc/oratab that has info on local instances.

Various Oracle 7.3.2 servers running Sql*Net V2.

Problem:

On the 7.1.4 machines, I cannot connect via the command 'sqlplus system/pass_at_xxx', where 'xxx' is ANY machine in the local tnsnames.ora file (7.3 or 7.1). I get the '12154 could not resolve service name' error. If I try to connect via the command 'sqlplus system/pass_at_xxx.world', I get '12203 unable to connect to destination'.

Other info:

There are no problems with the 7.3.2 boxes interacting.

Via my client, I can ping and connect with SQL*Plus to all instances on the 7.1.4 boxes.

On the 7.3.2 boxes, I can successfully use the 'sqlplus system/pass_at_xxx', where 'xxx' is one of the 7.1.4 instances.

I cannot kill the tcpctl connectivity.

Is it not attempting to use the tnsnames.ora file because it thinks it is a V1 connection ? Do I need to add something to the /etc/oratab file ?

Any help would be appreciated. If possible, could you reply to both the NG and my email address ?

Thanks in advance !  

Brett
zgeist_at_ee.net Received on Thu May 29 1997 - 00:00:00 CDT