| oracle hang [message #552841] |
Sun, 29 April 2012 07:01  |
 |
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 #552850 is a reply to message #552841] |
Sun, 29 April 2012 09:54  |
John Watson
Messages: 8960
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 #552883 is a reply to message #552870] |
Mon, 30 April 2012 00:55 |
John Watson
Messages: 8960
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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
