Re: HELP! Need Explanation of this Trace

First, IPC is tried, because sqlnet.ora has AUTOMATIC_IPC=ON. As that only works when within the same machine (Inter Program Call), it will fail. Then, TCP/IP is tried. The host, being called, is db21. The address is resolved (you should be able to 'ping db21' and get a response). However, thatīs the end of it.

Is the oracle listerner up and running on db21? Is db21 the right machine to connect to? You could download the SQL*Net manuals from technet.oracle.com/doc. Membership is free.

Kikuma Yoshida wrote:

> Hello all,
> I need someone to decipher this misterious log.
> I am network managment person and pulled into the connectivity
> problem with oracle SQLNET client getting access to the
> ORACLE Server. I don't know much about the ORACLE SQLNET.
> Can someone in this news group could please point out what
> is in this trace log and point me out a manual that I can
> read so I can understand the error messsages in the future.
>
> Thank you in Advance.
>
> --- TRACE CONFIGURATION INFORMATION FOLLOWS ---
> New trace stream is "C:\ORAWIN\NETWORK\LOG\sqlnet.trc"
> New trace level is 6
> --- TRACE CONFIGURATION INFORMATION ENDS ---
>
> --- PARAMETER SOURCE INFORMATION FOLLOWS ---
> Attempted load of system pfile source C:\ORAWIN\network\admin\sqlnet.ora
> Parameter source loaded successfully
>
> Attempted load of local pfile source C:\DB2\INQ\sqlnet.ora
> Parameter source was not loaded
>
> -> PARAMETER TABLE LOAD RESULTS FOLLOW <-
> Successful parameter table load
> -> PARAMETER TABLE HAS THE FOLLOWING CONTENTS <-
> AUTOMATIC_IPC = ON
> TRACE_DIRECTORY_CLIENT = C:\ORAWIN\NETWORK\LOG
> SQLNET.EXPIRE_TIME = 20
> LOG_FILE_CLIENT = CLIENT
> LOG_DIRECTORY_CLIENT = C:\ORAWIN\NETWORK\LOG
> TRACE_LEVEL_CLIENT = ADMIN
> NAMES.DEFAULT_ZONE = world
> NAMES.DEFAULT_DOMAIN = world
> --- PARAMETER SOURCE INFORMATION ENDS ---
>
> --- LOG CONFIGURATION INFORMATION FOLLOWS ---
> Attempted open of log stream "C:\ORAWIN\NETWORK\LOG\client.log"
> Successful stream open
> --- LOG CONFIGURATION INFORMATION ENDS ---
>
> Unable to get data from navigation file tnsnav.ora
> -<ERROR>- construction of local names file failed
> system names file is C:\ORAWIN\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 C:\ORAWIN\network\admin\tnsnames.ora
> success
> Inserting IPC address into connect descriptor returned from nncin2a().
> Calling address: (DESCRIPTION=(CONNECT_DATA=(SID=chrs)(GLOBAL_NAME=chrs.db21)(CID=(PROGRAM=C:\DB2\INQ\DB2INQ.EXE)(HOST=Windows PC)(USER=OraUser)))(ADDRESS_LIST=(ADDRESS=(PROTOCOL=ipc)(KEY=chrs.db21))(ADDRESS=(COMMUNITY=db21)(PROTOCOL=TCP)(Host=db21)(Port=
> 1521))))
> 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=chrs.db21)))
> Calling with outgoing connect data (DESCRIPTION=(CONNECT_DATA=(SID=chrs)(GLOBAL_NAME=chrs.db21)(CID=(PROGRAM=C:\DB2\INQ\DB2INQ.EXE)(HOST=Windows PC)(USER=OraUser)))(ADDRESS_LIST=(ADDRESS=(COMMUNITY=db21)(PROTOCOL=TCP)(Host=db21)(Port=1521))))
> (DESCRIPTION=(EMPTY=0)(ADDRESS=(PROTOCOL=ipc)(KEY=chrs.db21)))
> -<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=db21)(PROTOCOL=TCP)(Host=db21)(Port=1521)))
> Calling with outgoing connect data (DESCRIPTION=(CONNECT_DATA=(SID=chrs)(GLOBAL_NAME=chrs.db21)(CID=(PROGRAM=C:\DB2\INQ\DB2INQ.EXE)(HOST=Windows PC)(USER=OraUser)))(ADDRESS_LIST=(ADDRESS=(COMMUNITY=db21)(PROTOCOL=TCP)(Host=db21)(Port=1521))))
> (DESCRIPTION=(EMPTY=0)(ADDRESS=(COMMUNITY=db21)(PROTOCOL=TCP)(Host=db21)(Port=1521)))
> port resolved to 1521
> looking up IP addr for host: db21
> connecting...
> opening transport...
> -<ERROR>- soc -1 error - operation=3, ntresnt[0]=530, ntresnt[1]=47, ntresnt[2]=0
> -<ERROR>- unable to open transport
> -<ERROR>- nsres: id=0, op=1, ns=12560, ns2=0; nt[0]=530, nt[1]=47, 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: 47
> -<ERROR>- nt OS err code: 0
> -<ERROR>- Couldn't connect, returning 12203
> No Routing global data found
Received on Thu Aug 05 1999 - 09:10:04 CDT