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
