Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

ORA-12560 Error

Status
Not open for further replies.

baselbj

Programmer
Apr 17, 2002
18
0
0
JO
Hi all,
About my problem I tried to find a solution to this problem so I searched the internet for its purpose but nothing works. First you must know that I am working on PC with no network connection and with winXp/sp2.
The problem comes when I try to connect to a database which is shutdown. Where I use:
1. sqlplus /nolog
2. connect / as sysdba
3. I am within ORA_DBA group.
4. The error ORA-12560 appears.

And I do test the following:
1. Tnsping: works ok.
2. Ping the hostname and ip: works ok.
3. Comment and uncomment SQLNET.AUTHENTICATION_SERVICES= (NTS) in "sqlnet.ora": nothing happened.
4. The service works perfectly fro windows services.
5. If I connect using the same steps before while the database is started up the connection works and o problems occurs.
6. the trace file for the connection problem is:



[14-August -2005 04:00:06:750] --- TRACE CONFIGURATION INFORMATION FOLLOWS ---
[14-August -2005 04:00:06:750] New trace stream is E:\oracle\product\10.1.0\Trace\clienttrace_1740.trc
[14-August -2005 04:00:06:750] New trace level is 16
[14-August -2005 04:00:06:750] --- TRACE CONFIGURATION INFORMATION ENDS ---
[14-August -2005 04:00:06:750] --- PARAMETER SOURCE INFORMATION FOLLOWS ---
[14-August -2005 04:00:06:750] Attempted load of system pfile source E:\oracle\product\10.1.0\Db_1\NETWORK\ADMIN\sqlnet.ora
[14-August -2005 04:00:06:750] Parameter source loaded successfully
[14-August -2005 04:00:06:750]
[14-August -2005 04:00:06:750] Attempted load of local pfile source C:\Documents and Settings\a\sqlnet.ora
[14-August -2005 04:00:06:750] Parameter source was not loaded
[14-August -2005 04:00:06:750]
[14-August -2005 04:00:06:750] -> PARAMETER TABLE LOAD RESULTS FOLLOW <-
[14-August -2005 04:00:06:750] Successful parameter table load
[14-August -2005 04:00:06:750] -> PARAMETER TABLE HAS THE FOLLOWING CONTENTS <-
[14-August -2005 04:00:06:750] TRACE_LEVEL_SERVER = SUPPORT
[14-August -2005 04:00:06:750] TRACE_LEVEL_CLIENT = SUPPORT
[14-August -2005 04:00:06:750] NAMES.DIRECTORY_PATH = (TNSNAMES, EZCONNECT)
[14-August -2005 04:00:06:750] TRACE_DIRECTORY_CLIENT = E:\oracle\product\10.1.0\Trace
[14-August -2005 04:00:06:750] TRACE_DIRECTORY_SERVER = E:\oracle\product\10.1.0\Trace
[14-August -2005 04:00:06:750] SQLNET.AUTHENTICATION_SERVICES = (NTS)
[14-August -2005 04:00:06:750] TRACE_UNIQUE_CLIENT = on
[14-August -2005 04:00:06:750] TRACE_FILE_CLIENT = ClientTrace
[14-August -2005 04:00:06:750] TRACE_FILE_SERVER = ServerTrace
[14-August -2005 04:00:06:750] --- PARAMETER SOURCE INFORMATION ENDS ---
[14-August -2005 04:00:06:750] --- LOG CONFIGURATION INFORMATION FOLLOWS ---
[14-August -2005 04:00:06:750] Log stream will be "C:\Documents and Settings\a\sqlnet.log"
[14-August -2005 04:00:06:750] Log stream validation not requested
[14-August -2005 04:00:06:750] --- LOG CONFIGURATION INFORMATION ENDS ---

[14-August -2005 04:00:06:750] nigini: entry
[14-August -2005 04:00:06:750] nigini: Count in the NL global area is now 1
[14-August -2005 04:00:06:750] nigini: Count in NI global area now: 1
[14-August -2005 04:00:06:750] nrigbi: entry
[14-August -2005 04:00:06:750] nrigbni: entry
[14-August -2005 04:00:06:750] nrigbni: Unable to get data from navigation file tnsnav.ora
[14-August -2005 04:00:06:750] nrigbni: exit
[14-August -2005 04:00:06:750] nrigbi: exit
[14-August -2005 04:00:06:750] nigini: exit
[14-August -2005 04:00:06:750] niqname: Hst is already an NVstring.
[14-August -2005 04:00:06:750] niqname: Inserting CID.
[14-August -2005 04:00:06:750] niotns: entry
[14-August -2005 04:00:06:750] niotns: niotns: setting up interrupt handler...
[14-August -2005 04:00:06:750] niotns: Not trying to enable dead connection detection.
[14-August -2005 04:00:06:750] niotns: Calling address: (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=BEQ)(PROGRAM=oracle)(ARGV0=oracleORCL)(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))')))(CONNECT_DATA=(SID=ORCL)(CID=(PROGRAM=E:\oracle\product\10.1.0\db_1\bin\sqlplus.exe)(HOST=BASEL)(USER=a))))
[14-August -2005 04:00:06:750] nscall: entry
[14-August -2005 04:00:06:750] nsmal: entry
[14-August -2005 04:00:06:750] nsmal: 212 bytes at 0x11e3e68
[14-August -2005 04:00:06:750] nsmal: normal exit
[14-August -2005 04:00:06:750] nscall: connecting...
[14-August -2005 04:00:06:750] nladini: entry
[14-August -2005 04:00:06:750] nladini: exit
[14-August -2005 04:00:06:750] nladget: entry
[14-August -2005 04:00:06:750] nladget: exit
[14-August -2005 04:00:06:750] nsc2addr: entry
[14-August -2005 04:00:06:750] nsc2addr: (DESCRIPTION=(ADDRESS=(PROTOCOL=BEQ)(PROGRAM=oracle)(ARGV0=oracleORCL)(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(CONNECT_DATA=(SID=ORCL)(CID=(PROGRAM=E:\oracle\product\10.1.0\db_1\bin\sqlplus.exe)(HOST=BASEL)(USER=a))))
[14-August -2005 04:00:06:750] nlpcaini: entry
[14-August -2005 04:00:06:750] nlpcaini: prg = oracle
[14-August -2005 04:00:06:750] nlpcaini: arg[0] = oracleORCL
[14-August -2005 04:00:06:750] nlpcaini: arg[1] = (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
[14-August -2005 04:00:06:750] nlpcaini: exit
[14-August -2005 04:00:06:750] nsc2addr: normal exit
[14-August -2005 04:00:06:750] nsopen: entry
[14-August -2005 04:00:06:750] nsmal: entry
[14-August -2005 04:00:06:750] nsmal: 536 bytes at 0x11efac0
[14-August -2005 04:00:06:750] nsmal: normal exit
[14-August -2005 04:00:06:750] nsopenmplx: entry
[14-August -2005 04:00:06:750] nsmal: entry
[14-August -2005 04:00:06:750] nsmal: 1632 bytes at 0x11f1008
[14-August -2005 04:00:06:750] nsmal: normal exit
[14-August -2005 04:00:06:750] nsiorini: entry
[14-August -2005 04:00:06:750] nsbal: entry
[14-August -2005 04:00:06:750] nsbgetfl: entry
[14-August -2005 04:00:06:750] nsbgetfl: normal exit
[14-August -2005 04:00:06:750] nsmal: entry
[14-August -2005 04:00:06:750] nsmal: 84 bytes at 0x11ef928
[14-August -2005 04:00:06:750] nsmal: normal exit
[14-August -2005 04:00:06:750] nsbal: normal exit
[14-August -2005 04:00:06:750] nsiorini: exit (0)
[14-August -2005 04:00:06:750] nscpxget: entry
[14-August -2005 04:00:06:750] nscpxget: normal exit
[14-August -2005 04:00:06:750] nsopenalloc_nsntx: nlhthput on mplx_ht_nsgbu:ctx=11efac0, nsntx=11f1008
[14-August -2005 04:00:06:750] nsopenmplx: normal exit
[14-August -2005 04:00:06:750] nsopen: opening transport...
[14-August -2005 04:00:06:750] ntpcon: entry
[14-August -2005 04:00:06:750] ntpcon: toc = 1
[14-August -2005 04:00:06:750] sntpcall: entry
[14-August -2005 04:00:06:750] snlpcss: entry
[14-August -2005 04:00:06:750] snlpcss: Unable to spawn Oracle oracle (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq))) ORCL, error 2.
[14-August -2005 04:00:06:750] sntpcall: exit
[14-August -2005 04:00:06:750] ntpcon: exit
[14-August -2005 04:00:06:750] nserror: entry
[14-August -2005 04:00:06:750] nserror: nsres: id=0, op=65, ns=12560, ns2=0; nt[0]=530, nt[1]=2, nt[2]=0; ora[0]=0, ora[1]=0, ora[2]=0
[14-August -2005 04:00:06:750] nsopen: unable to open transport
[14-August -2005 04:00:06:750] nsiocancel: entry
[14-August -2005 04:00:06:750] nsiofrrg: entry
[14-August -2005 04:00:06:750] nsbfr: entry
[14-August -2005 04:00:06:750] nsbaddfl: entry
[14-August -2005 04:00:06:750] nsbaddfl: normal exit
[14-August -2005 04:00:06:750] nsbfr: normal exit
[14-August -2005 04:00:06:750] nsiofrrg: exit
[14-August -2005 04:00:06:750] nsiocancel: exit
[14-August -2005 04:00:06:750] nsopenfree_nsntx: nlhthdel from mplx_ht_nsgbu, ctx=11efac0 nsntx=11f1008
[14-August -2005 04:00:06:750] nsiocancel: entry
[14-August -2005 04:00:06:750] nsiofrrg: entry
[14-August -2005 04:00:06:750] nsiofrrg: exit
[14-August -2005 04:00:06:750] nsiocancel: exit
[14-August -2005 04:00:06:750] nsmfr: entry
[14-August -2005 04:00:06:750] nsmfr: 1632 bytes at 0x11f1008
[14-August -2005 04:00:06:750] nsmfr: normal exit
[14-August -2005 04:00:06:750] nsmfr: entry
[14-August -2005 04:00:06:750] nsmfr: 536 bytes at 0x11efac0
[14-August -2005 04:00:06:750] nsmfr: normal exit
[14-August -2005 04:00:06:750] nsopen: error exit
[14-August -2005 04:00:06:750] nsclose: entry
[14-August -2005 04:00:06:750] nsclose: normal exit
[14-August -2005 04:00:06:750] nladget: entry
[14-August -2005 04:00:06:750] nladget: exit
[14-August -2005 04:00:06:750] nsmfr: entry
[14-August -2005 04:00:06:750] nsmfr: 212 bytes at 0x11e3e68
[14-August -2005 04:00:06:750] nsmfr: normal exit
[14-August -2005 04:00:06:750] nladtrm: entry
[14-August -2005 04:00:06:750] nladtrm: exit
[14-August -2005 04:00:06:750] nscall: error exit
[14-August -2005 04:00:06:750] nioqper: error from nscall
[14-August -2005 04:00:06:750] nioqper: ns main err code: 12560
[14-August -2005 04:00:06:750] nioqper: ns (2) err code: 0
[14-August -2005 04:00:06:750] nioqper: nt main err code: 530
[14-August -2005 04:00:06:750] nioqper: nt (2) err code: 2
[14-August -2005 04:00:06:750] nioqper: nt OS err code: 0
[14-August -2005 04:00:06:750] niomapnserror: entry
[14-August -2005 04:00:06:750] niqme: entry
[14-August -2005 04:00:06:750] niqme: reporting NS-12560 error as ORA-12560
[14-August -2005 04:00:06:750] niqme: exit
[14-August -2005 04:00:06:750] niomapnserror: exit
[14-August -2005 04:00:06:750] niotns: Couldn't connect, returning 12560
[14-August -2005 04:00:06:750] niotns: exit
[14-August -2005 04:00:06:750] nsbfrfl: entry
[14-August -2005 04:00:06:750] nsbrfr: entry
[14-August -2005 04:00:06:750] nsbrfr: nsbfs at 0x11ef928, data at 0x11f1670.
[14-August -2005 04:00:06:750] nsbrfr: normal exit
[14-August -2005 04:00:06:750] nsbfrfl: normal exit
[14-August -2005 04:00:06:750] nigtrm: Count in the NI global area is now 0
[14-August -2005 04:00:06:750] nrigbd: entry
[14-August -2005 04:00:06:750] nrigbd: exit
[14-August -2005 04:00:06:750] nigtrm: Count in the NL global area is now 0
[14-August -2005 04:00:06:750] nlse_term_audit: entry
[14-August -2005 04:00:06:750] nlse_term_audit: exit


Please Help
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top