Re: Help SQL*Net(7.0.16 -> 6.0.36) connection

srinivas_at_cs.utep.edu writes:
|>
|> I have problem with sqlnet. I have Oracle running on two SUN systems.
|> I have DBA permissions.
|>
|>_________________________ _________________________
|>|m/c 1 (borderbase) | connects |m/c 2 (mickey) |
|>|---------------------- |------------------>>|---------------------- |
|>|Oracle 6.0.36.7.1 | |Oracle 7.0.16.4 |
|>|SQL*Net TCP/IP 1.2.7.3.1| |SQL*Net TCP/IP 1.2.7.7.1|
|>|SID UTEP |<<------------------|SID IM3 |
|>-------------------------- fails ------------------------
|>
|>___________________________________________________________________________
|> borderbase | mickey
|> |
|>1.tcpctl stat _at_mickey works |1. tcpctl stat @borderbase
|>**(for owner oracle in both) | tcputl: network read error :permission denied
|>2.checkTCP shows no error |2. checkTCP shows no erros
|>3.aliases in sqlnet |3. aliases in /etc/tnsnames.ora & /etc/sqlnet
|>--------------------------------------------------------------------------
|> On mickey
|> 1. tnsnames.ora has oracle as owner dba as group with 644 permissions.
|> tnsnames.ora contains only two lines
|> UTS T:borderbase:UTEP <--
|> MIC T:mickey:IM3 <--
|> 2. Errors on mickey for sqlplus for given strig are
|>
|> % sqlplus scott/tiger_at_T:borderbase:UTEP <--
|> ERROR: ORA-06401: NETCMN: invalid driver designator
|> (Cnct err, can't get err txt. See Servr Msgs & Codes Manual)
|>
|> % sqlplus scott/tiger_at_UTS <--
|> ERROR: ORA-12154: TNS:could not resolve database name
|>
|> ftp, telnet works on both sides. I would appreciate if someone can let me
|> know what is the problem and how i could rectify it. Thanks for your time
|> and help.

The main problem you are encountering seems to be the ORA-6401. This implies that the SQL*Net V1 TCP driver was not linked into the tool that you are using to try to connect to UTEP. ORA-12154 might just mean that the tnsnames.ora file cannot be found. You did not specify which directory this is in. On SunOS, it can be placed in the /etc directory. Solaris would be in the /var/opt/oracle directory (there are other legal directories and those are documented somewhere). If it is in a directory where it can be found, just make sure the alias starts right at the beginning of the line and all lines above it that should be commented out are commented out.

The problem with tcpctl has something to do with the new version of tcputl not being able to communicate with an older version of orasrv. Not a serious problem.

Hope this helps.
Roderick Manalac
Oracle Corporation Received on Fri Sep 30 1994 - 00:09:31 CET