Home » RDBMS Server » Server Administration » oracle hang (aix 6.1 oracle:11.2.0.3)
oracle hang [message #552841] Sun, 29 April 2012 07:01 Go to next message
lerry
Messages: 16
Registered: December 2011
Junior Member
all of the client cann't connect the db,
and using sqlplus / as sysdba also cann't login
there are many error of TNS-12535 and in the listener.log
alert.log:
Sun Apr 29 18:10:36 2012
opidcl aborting process unknown ospid (42992060) as a result of ORA-604
Sun Apr 29 18:10:54 2012
opidcl aborting process unknown ospid (26280196) as a result of ORA-604
Sun Apr 29 18:11:02 2012
opidcl aborting process unknown ospid (15401310) as a result of ORA-604
Sun Apr 29 18:11:10 2012
opidcl aborting process unknown ospid (32506354) as a result of ORA-604
Sun Apr 29 18:11:27 2012
opidcl aborting process unknown ospid (25821220) as a result of ORA-604
Sun Apr 29 18:11:41 2012


***********************************************************************

Fatal NI connect error 12170.

VERSION INFORMATION:
TNS for IBM/AIX RISC System/6000: Version 11.2.0.3.0 - Production
TCP/IP NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 - Production
Oracle Bequeath NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 - Production
Time: 29-APR-2012 18:11:41
Tracing not turned on.
Tns error struct:
ns main err code: 12535

TNS-12535: TNS:operation timed out
ns secondary err code: 12606
nt main err code: 0
nt secondary err code: 0
nt OS err code: 0
Client address: (ADDRESS=(PROTOCOL=tcp)(HOST=10.3.57.107)(PORT=1650))
Sun Apr 29 18:11:42 2012


***********************************************************************

Fatal NI connect error 12170.

VERSION INFORMATION:
TNS for IBM/AIX RISC System/6000: Version 11.2.0.3.0 - Production
TCP/IP NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 - Production
Oracle Bequeath NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.3.0 - Production
Time: 29-APR-2012 18:11:42
Tracing not turned on.
Tns error struct:
ns main err code: 12535

TNS-12535: TNS:operation timed out
ns secondary err code: 12606
nt main err code: 0
nt secondary err code: 0
nt OS err code: 0
Client address: (ADDRESS=(PROTOCOL=tcp)(HOST=10.3.57.107)(PORT=1651))
Sun Apr 29 18:11:47 2012


listener.log:
TNS-12518: TNS:listener could not hand off client connection
TNS-12547: TNS:lost contact
TNS-12560: TNS:protocol adapter error
TNS-00517: Lost contact
IBM/AIX RISC System/6000 Error: 32: Broken pipe

Re: oracle hang [message #552846 is a reply to message #552841] Sun, 29 April 2012 08:44 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>IBM/AIX RISC System/6000 Error: 32: Broken pipe
Indicates problem at OS level.


what clues exist within Oracle's "ALERT" log file?
what clues exist within OS "messages"file?
Re: oracle hang [message #552850 is a reply to message #552841] Sun, 29 April 2012 09:54 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
Those messages in your alert log have no significance, they are there in most databases from 11.x onwards. You can suppress them by disabling listener ADR logging, see note [ID 1286376.1] and many others.
So your problem is that you can't connect. If you post your sqlplus session where you try to connect, formatted properly with code tags, then perhaps someone can help. Do it like this, showing the complete attempt:
c:\users\john\home>sqlplus / as sysdba

SQL*Plus: Release 11.2.0.3.0 Production on Sun Apr 29 15:52:08 2012

Copyright (c) 1982, 2011, Oracle.  All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - Production
With the Partitioning, Oracle Label Security, OLAP, Data Mining,
Oracle Database Vault and Real Application Testing options


Session altered.

orcl>

Re: oracle hang [message #552870 is a reply to message #552850] Sun, 29 April 2012 21:02 Go to previous messageGo to next message
lerry_wu
Messages: 12
Registered: December 2011
Junior Member
when i login in sqlplus,it display, there are no connected and always stay in here

sqlplus / as sysdba

SQL*Plus: Release 11.2.0.3.0 Production on Mon Apr 30 09:58:39 2012

Copyright (c) 1982, 2011, Oracle. All rights reserved.
Re: oracle hang [message #552871 is a reply to message #552870] Sun, 29 April 2012 21:13 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
what clues exist within Oracle's "ALERT" log file?
what clues exist within OS "messages"file?

[Updated on: Sun, 29 April 2012 21:14]

Report message to a moderator

Re: oracle hang [message #552883 is a reply to message #552870] Mon, 30 April 2012 00:55 Go to previous message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
Quote:
post your sqlplus session where you try to connect, formatted properly with code tags, then perhaps someone can help.
Previous Topic: Before ORA-00600 ERROR
Next Topic: Problems with Oracle XE on win xp
Goto Forum:
  


Current Time: Thu Mar 28 03:20:37 CDT 2024