SQL*Netv2 Mac error 12203 ?
Date: 1996/10/09
Message-ID: <2471686110.91337304_at_cornut.fr>
Hi,
We have just installed SQL*Net v2 for Macintosh and we got a 12203 error when trying to connect. We are using a TCP/IP protocol adapter. We are able to access the server in Telnet and if we type the following command on the shell prompt of an Oracle user :
sqldba mode=line
connect system/manager_at_CISERVER
we can connect to the CISERVER without any problem. We use the same tnsnames.ora on the server and on the Macintosh.
Here is our client.log file :
Fatal OSN connect error 12203, connecting to:
(DESCRIPTION=(CONNECT_DATA=(SID=oracle7)(CID=(PROGRAM=NetTest)(HOST=mac)(USER=Roger)))(ADDRESS_LIST=(ADDRESS=(PROTOCOL=ipc)(KEY=SUNCI))(ADDRESS=(COMMUNITY=TCPCOM)(PROTOCOL=TCP)(HOST=192.9.205.6)(PORT=1525))))
VERSION INFORMATION:
TNS for Mac: Version 2.0.15.0.0 - Production atk Time: 30-SEP-96 10:35:33
Tracing to file: Macintosh HD:Desktop Folder:Developpement:Oracle Home Net 2:network:trace:client.trc
Tns error struct:
nr err code: 12203
TNS-12203: TNS:unable to connect to destination ns main err code: 12560
TNS-12560: TNS:protocol adapter error ns secondary err code: 0
nt main err code: 530
TNS-00530: Protocol adapter error
Here is our client.trc file :
- TRACE CONFIGURATION INFORMATION FOLLOWS --- New trace stream is "Macintosh HD:Desktop Folder:Developpement:Oracle Home Net 2:network:trace:client.trc" New trace level is 6
- TRACE CONFIGURATION INFORMATION ENDS ---
- PARAMETER SOURCE INFORMATION FOLLOWS --- Attempted load of system pfile source Macintosh HD:Desktop Folder:Developpement:Oracle Home Net 2:network:admin:sqlnet.ora Parameter source loaded successfully
Attempted load of local pfile source Macintosh HD:Desktop Folder:Developpement:Oracle Home Net 2:sqlnet.ora Parameter source was not loaded
-> PARAMETER TABLE LOAD RESULTS FOLLOW <-
Successful parameter table load
-> PARAMETER TABLE HAS THE FOLLOWING CONTENTS <-
TRACE_LEVEL_CLIENT = admin
TRACE_DIRECTORY_CLIENT = Macintosh HD:Desktop Folder:Developpement:Oracle
Home Net 2:network:trace:
LOG_DIRECTORY_CLIENT = Macintosh HD:Desktop Folder:Developpement:Oracle
Home Net 2:network:log:
LOG_FILE_CLIENT = Client
TRACE_FILE_CLIENT = Client
--- PARAMETER SOURCE INFORMATION ENDS ---
- LOG CONFIGURATION INFORMATION FOLLOWS --- Attempted open of log stream "Macintosh HD:Desktop Folder:Developpement:Oracle Home Net 2:network:log:client.log" Successful stream open
- LOG CONFIGURATION INFORMATION ENDS ---
-<ERROR>- construction of local names file failed
system names file is Macintosh HD:Desktop Folder:Developpement:Oracle Home Net 2:network:admin:tnsnames.ora
initial retry timeout for all servers is 500 csecs max request retries per server is 2
default zone is [root]
Using nncin2a() to build connect descriptor for (possibly remote) database. initial load of Macintosh HD:Desktop Folder:Developpement:Oracle Home Net 2:network:admin:tnsnames.ora
success
Inserting IPC address into connect descriptor returned from nncin2a(). Calling address:
(DESCRIPTION=(CONNECT_DATA=(SID=oracle7)(CID=(PROGRAM=NetTest)(HOST=mac)(USER=Roger)))(ADDRESS_LIST=(ADDRESS=(PROTOCOL=ipc)(KEY=SUNCI))(ADDRESS=(COMMUNITY=TCPCOM)(PROTOCOL=TCP)(HOST=192.9.205.6)(PORT=1525)))) Getting local community information
Looking for local addresses setup by nrigla No addresses in the preferred address list TNSNAV.ORA is not present. No local communities entry. Getting local address information
Address list being processed...
No community information so all addresses are "local" Resolving address to use to call destination or next hop Processing address list...
No community entries so iterate over address list This is a local community access
Got routable address information
Making call with following address information: (DESCRIPTION=(EMPTY=0)(ADDRESS=(PROTOCOL=ipc)(KEY=SUNCI))) Calling with outgoing connect data
(DESCRIPTION=(CONNECT_DATA=(SID=oracle7)(CID=(PROGRAM=NetTest)(HOST=mac)(USER=Roger)))(ADDRESS_LIST=(ADDRESS=(COMMUNITY=TCPCOM)(PROTOCOL=TCP)(HOST=192.9.205.6)(PORT=1525)))) (DESCRIPTION=(EMPTY=0)(ADDRESS=(PROTOCOL=ipc)(KEY=SUNCI)))
-<ERROR>- nsres: id=0, op=13, ns=12538, ns2=12560; nt[0]=508, nt[1]=0,
nt[2]=0
Call failed...
Call made to destination
Processing address list so continuing
Getting local community information
Looking for local addresses setup by nrigla No addresses in the preferred address list TNSNAV.ORA is not present. No local communities entry. Getting local address information
Address list being processed...
NULL local community so indicate that this is a local address Return local community destination information Got routable address information
Making call with following address information: (DESCRIPTION=(EMPTY=0)(ADDRESS=(COMMUNITY=TCPCOM)(PROTOCOL=TCP)(HOST=192.9.205.6)(PORT=1525))) Calling with outgoing connect data
(DESCRIPTION=(CONNECT_DATA=(SID=oracle7)(CID=(PROGRAM=NetTest)(HOST=mac)(USER=Roger)))(ADDRESS_LIST=(ADDRESS=(COMMUNITY=TCPCOM)(PROTOCOL=TCP)(HOST=192.9.205.6)(PORT=1525)))) (DESCRIPTION=(EMPTY=0)(ADDRESS=(COMMUNITY=TCPCOM)(PROTOCOL=TCP)(HOST=192.9.205.6)(PORT=1525))) connecting...
opening transport...
-<ERROR>- unable to open transport
-<ERROR>- nsres: id=0, op=1, ns=12560, ns2=0; nt[0]=530, nt[1]=32, nt[2]=0
connect attempt failed
Call failed...
Call made to destination
Processing address list so continuing
Getting local community information
Looking for local addresses setup by nrigla No addresses in the preferred address list TNSNAV.ORA is not present. No local communities entry. Getting local address information
Address list being processed...
Processed all addresses in address list. Failed to make contact. Exiting NRICALL with following termination result -1
-<ERROR>- error from nricall
-<ERROR>- nr err code: 12203
-<ERROR>- ns main err code: 12560
-<ERROR>- ns (2) err code: 0
-<ERROR>- nt main err code: 530
-<ERROR>- nt (2) err code: 32
-<ERROR>- nt OS err code: 0
-<ERROR>- Couldn't connect, returning 12203
If any one can help,
Thanks in advance,
Roger FLATTIN
rflattin_at_cornut.fr
----->> On our site a SHAREWARE Query Tool <<---------
Frederic BOUQUET Client/Server & SQL RDBMS email: fbouquet_at_cornut.fr http://www.cornut.fr/Received on Wed Oct 09 1996 - 00:00:00 CEST