Oracle Database Discussions

Hi,

I see alot of trc files, almost each time I connect to oracle ??
Even when doing a simple pfile creation...


-bash-3.00$ sqlplus /nolog
SQL*Plus: Release 10.1.0.3.0 - Production on Tue Dec 27 22:21:05 2005
Copyright (c) 1982, 2004, Oracle. All rights reserved.
SQL> CONNECT / AS SYSDBA
Connected to an idle instance.
SQL> CREATE PFILE='/export/home/oracle/pfile' FROM SPFILE;
File created.
SQL> EXIT
Disconnected


Above work creates a trc file, with some strange "unable get data..."?

Please help me to sort this out.


I have log enabled and can see trc files containing:
-bash-3.00$ cat see_sqlnet.ora_599.trc
[27-DEC-2005 22:21:07:823] --- TRACE CONFIGURATION INFORMATION FOLLOWS ---
[27-DEC-2005 22:21:07:823] New trace stream is /export/home/oracle/see_sqlnet.ora_599.trc
[27-DEC-2005 22:21:07:823] New trace level is 4
[27-DEC-2005 22:21:07:823] --- TRACE CONFIGURATION INFORMATION ENDS ---
[27-DEC-2005 22:21:07:823] --- PARAMETER SOURCE INFORMATION FOLLOWS ---
[27-DEC-2005 22:21:07:823] Attempted load of system pfile source /u01/app/oracle/product/10.1.0.3/db_1/network/admin/sqlnet.ora
[27-DEC-2005 22:21:07:823] Parameter source loaded successfully
[27-DEC-2005 22:21:07:823]
[27-DEC-2005 22:21:07:823] Attempted load of local pfile source /export/home/oracle/.sqlnet.ora
[27-DEC-2005 22:21:07:823] Parameter source loaded successfully
[27-DEC-2005 22:21:07:823]
[27-DEC-2005 22:21:07:823] -> PARAMETER TABLE LOAD RESULTS FOLLOW <-
[27-DEC-2005 22:21:07:823] Successful parameter table load
[27-DEC-2005 22:21:07:823] -> PARAMETER TABLE HAS THE FOLLOWING CONTENTS <-
[27-DEC-2005 22:21:07:823] trace_level_client = USER
[27-DEC-2005 22:21:07:823] NAMES.DIRECTORY_PATH = (TNSNAMES)
[27-DEC-2005 22:21:07:823] trace_file_client = see_sqlnet.ora
[27-DEC-2005 22:21:07:823] trace_directory_client = /export/home/oracle
[27-DEC-2005 22:21:07:823] NAMES.DEFAULT_DOMAIN = school.com
[27-DEC-2005 22:21:07:823] --- PARAMETER SOURCE INFORMATION ENDS ---
[27-DEC-2005 22:21:07:823] --- LOG CONFIGURATION INFORMATION FOLLOWS ---
[27-DEC-2005 22:21:07:823] Log stream will be "/export/home/oracle/sqlnet.log"
[27-DEC-2005 22:21:07:823] Log stream validation not requested
[27-DEC-2005 22:21:07:824] --- LOG CONFIGURATION INFORMATION ENDS ---

[27-DEC-2005 22:21:07:824] nrigbni: Unable to get data from navigation file tnsnav.ora
[27-DEC-2005 22:21:07:824] niotns: Not trying to enable dead connection detection.
[27-DEC-2005 22:21:07:824] niotns: Calling address: (DESCRIPTION=(ADDRESS=(PROTOCOL=beq)(PROGRAM=/u01/app/oracle/product/10.1.0.3/db_1/bin/oracle)(ARGV0=oracletestdb1)(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))')(DETACH=NO))(CONNECT_DATA=(CID=(PROGRAM=)(HOST=testhost)(USER=oracle))))
[27-DEC-2005 22:21:07:824] nscall: connecting...
[27-DEC-2005 22:21:07:825] nsc2addr: (DESCRIPTION=(ADDRESS=(PROTOCOL=beq)(PROGRAM=/u01/app/oracle/product/10.1.0.3/db_1/bin/oracle)(ARGV0=oracletestdb1)(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))')(DETACH=NO))(CONNECT_DATA=(CID=(PROGRAM=)(HOST=testhost)(USER=oracle))))
[27-DEC-2005 22:21:07:825] nsopen: opening transport...
[27-DEC-2005 22:21:07:825] sntpcall: not detaching from parent with additional fork
[27-DEC-2005 22:21:07:827] sntpcall: About to exec /u01/app/oracle/product/10.1.0.3/db_1/bin/oracle:
[27-DEC-2005 22:21:07:850] sntpcall: result string is NTP0 600
[27-DEC-2005 22:21:07:850] sntpcall: hdl[IR]=11, hdl[IW]=10
[27-DEC-2005 22:21:07:850] nsopen: transport is open
[27-DEC-2005 22:21:07:850] nsnainit: inf->nsinfflg[0]: 0x1 inf->nsinfflg[1]: 0x1
[27-DEC-2005 22:21:07:850] nsopen: global context check-in (to slot 0) complete
[27-DEC-2005 22:21:07:851] nscon: doing connect handshake...
[27-DEC-2005 22:21:07:851] nscon: sending NSPTCN packet
[27-DEC-2005 22:21:07:851] nscon: sending 243 bytes connect data
[27-DEC-2005 22:21:07:851] nsdo: 243 bytes to NS buffer
[27-DEC-2005 22:21:07:851] nscon: got NSPTAC packet
[27-DEC-2005 22:21:07:851] nscon: connect handshake is complete
[27-DEC-2005 22:21:07:851] nscon: nsctxinf[0]=0x1, [1]=0x1
[27-DEC-2005 22:21:07:851] nsnainconn: inf->nsinfflg[0]: 0x1 inf->nsinfflg[1]: 0x1
[27-DEC-2005 22:21:07:851] nsnasend: bytes to send: 145
[27-DEC-2005 22:21:07:851] nsdo: 145 bytes to NS buffer
[27-DEC-2005 22:21:07:851] nsnareceive: buffer address: 0x803f454 bytes wanted: 2048
[27-DEC-2005 22:21:07:851] nsnareceive: calling NS to receive 2048 bytes into address 0x803f454
[27-DEC-2005 22:21:07:851] nsdo: 129 bytes from NS buffer
[27-DEC-2005 22:21:07:852] nsnareceive: received 129 bytes
[27-DEC-2005 22:21:07:852] nsnareceive: no more data to receive - returning
[27-DEC-2005 22:21:07:852] nsnareceive: total bytes received: 129
[27-DEC-2005 22:21:07:855] nsrdr: got NSPTMK packet
[27-DEC-2005 22:21:07:855] nioqrc: Recieve: returning error: 3111
[27-DEC-2005 22:21:07:855] nsdo: sending NSPTMK packet
[27-DEC-2005 22:21:07:855] nsrdr: got NSPTMK packet
[27-DEC-2005 22:21:07:855] nserror: nsres: id=0, op=70, ns=12582, ns2=0; nt[0]=0, nt[1]=0, nt[2]=0; ora[0]=0, ora[1]=0, ora[2]=0
[27-DEC-2005 22:21:07:855] nserror: nsres: id=0, op=70, ns=12630, ns2=0; nt[0]=0, nt[1]=0, nt[2]=0; ora[0]=0, ora[1]=0, ora[2]=0
[27-DEC-2005 22:21:07:857] nsrdr: got NSPTMK packet
[27-DEC-2005 22:21:07:857] nioqrc: Recieve: returning error: 3111
[27-DEC-2005 22:21:07:857] nsdo: sending NSPTMK packet
[27-DEC-2005 22:21:07:857] nsrdr: got NSPTMK packet
[27-DEC-2005 22:21:07:857] nserror: nsres: id=0, op=70, ns=12582, ns2=0; nt[0]=0, nt[1]=0, nt[2]=0; ora[0]=0, ora[1]=0, ora[2]=0
[27-DEC-2005 22:21:07:857] nserror: nsres: id=0, op=70, ns=12630, ns2=0; nt[0]=0, nt[1]=0, nt[2]=0; ora[0]=0, ora[1]=0, ora[2]=0
[27-DEC-2005 22:21:14:486] nstimarmed: no timer allocated
[27-DEC-2005 22:21:14:486] nsclose: closing transport
[27-DEC-2005 22:21:14:486] nsclose: global context check-out (from slot 0) complete

Please advice!