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 - 00:39:43 CDT
