Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-3136

YEDec 19 2010 — edited Jan 3 2011

Hi,
I install Oracle in AIX. But I often get error messages.
I set inbound_connect_timeout=0, but I still get the same errors.
Please help me!
Thanks
==============================================
***********************************************************************

Fatal NI connect error 12170.

VERSION INFORMATION:
TNS for IBM/AIX RISC System/6000: Version 11.1.0.6.0 - Production
TCP/IP NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.1.0.6.0 - Production
Oracle Bequeath NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.1.0.6.0 - Production
Time: 21-DEC-2010 03:54:04
Tracing not turned on.
Tns error struct:
ns main err code: 12535

TNS-12535: TNS:operation timed out
ns secondary err code: 12560
nt main err code: 505

TNS-00505: Operation timed out
nt secondary err code: 78
nt OS err code: 0
Client address: (ADDRESS=(PROTOCOL=tcp)(HOST=172.16.218.251)(PORT=51841))
Tue Dec 21 06:02:30 2010
Beginning log switch checkpoint up to RBA [0x625.2.10], SCN: 491461180
Thread 1 advanced to log sequence 1573
Current log# 4 seq# 1573 mem# 0: /oradata/redo04a.rdo
Current log# 4 seq# 1573 mem# 1: /oradata/redo04b.rdo
Tue Dec 21 06:07:35 2010
Completed checkpoint up to RBA [0x625.2.10], SCN: 491461180
Tue Dec 21 11:59:06 2010
FAST_START_MTTR_TARGET 20 is out of the valid MTTR range, use 21 instead.
Tue Dec 21 12:00:06 2010
FAST_START_MTTR_TARGET 20 is out of the valid MTTR range, use 22 instead.
Tue Dec 21 14:11:53 2010
Beginning log switch checkpoint up to RBA [0x626.2.10], SCN: 491629199
Thread 1 advanced to log sequence 1574
Current log# 1 seq# 1574 mem# 0: /oradata/redo01a.rdo
Current log# 1 seq# 1574 mem# 1: /oradata/redo01b.rdo
Tue Dec 21 14:16:56 2010
Completed checkpoint up to RBA [0x626.2.10], SCN: 491629199
Tue Dec 21 21:00:00 2010
Setting Resource Manager plan SCHEDULER[0x2C0A]:DEFAULT_MAINTENANCE_PLAN via scheduler window
Setting Resource Manager plan DEFAULT_MAINTENANCE_PLAN via parameter
Tue Dec 21 21:00:06 2010
Tue Dec 21 21:00:06 2010
Logminer Bld: Lockdown Complete. DB_TXN_SCN is UnwindToSCN (LockdownSCN) is 491752003
Tue Dec 21 21:00:11 2010
Begin automatic SQL Tuning Advisor run for special tuning task "SYS_AUTO_SQL_TUNING_TASK"
Tue Dec 21 21:03:00 2010
FAST_START_MTTR_TARGET 20 is out of the valid MTTR range, use 21 instead.
Tue Dec 21 21:03:11 2010
End automatic SQL Tuning Advisor run for special tuning task "SYS_AUTO_SQL_TUNING_TASK"
Tue Dec 21 21:03:54 2010
Beginning log switch checkpoint up to RBA [0x627.2.10], SCN: 491788729
Thread 1 advanced to log sequence 1575
Current log# 5 seq# 1575 mem# 0: /oradata/redo05a.rdo
Current log# 5 seq# 1575 mem# 1: /oradata/redo05b.rdo
Tue Dec 21 21:05:32 2010
Completed checkpoint up to RBA [0x627.2.10], SCN: 491788729
Tue Dec 21 23:52:38 2010
FAST_START_MTTR_TARGET 20 is out of the valid MTTR range, use 21 instead.
Wed Dec 22 01:00:00 2010
Clearing Resource Manager plan via parameter
Wed Dec 22 03:56:50 2010
Beginning log switch checkpoint up to RBA [0x628.2.10], SCN: 491930685
Thread 1 advanced to log sequence 1576
Current log# 2 seq# 1576 mem# 0: /oradata/redo02a.rdo
Current log# 2 seq# 1576 mem# 1: /oradata/redo02b.rdo
Wed Dec 22 04:01:53 2010
Completed checkpoint up to RBA [0x628.2.10], SCN: 491930685
Wed Dec 22 04:35:38 2010

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

Fatal NI connect error 12170.

VERSION INFORMATION:
TNS for IBM/AIX RISC System/6000: Version 11.1.0.6.0 - Production
TCP/IP NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.1.0.6.0 - Production
Oracle Bequeath NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.1.0.6.0 - Production
Time: 22-DEC-2010 04:35:38
Tracing not turned on.
Tns error struct:
ns main err code: 12535

TNS-12535: TNS:operation timed out
ns secondary err code: 12560
nt main err code: 505

TNS-00505: Operation timed out
nt secondary err code: 78
nt OS err code: 0
Client address: (ADDRESS=(PROTOCOL=tcp)(HOST=172.16.218.251)(PORT=61121))
Wed Dec 22 05:58:57 2010

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

Fatal NI connect error 12170.

VERSION INFORMATION:
TNS for IBM/AIX RISC System/6000: Version 11.1.0.6.0 - Production
TCP/IP NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.1.0.6.0 - Production
Oracle Bequeath NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.1.0.6.0 - Production
Time: 22-DEC-2010 05:58:57
Tracing not turned on.
Tns error struct:
ns main err code: 12535

TNS-12535: TNS:operation timed out
ns secondary err code: 12560
nt main err code: 505

TNS-00505: Operation timed out
nt secondary err code: 78
nt OS err code: 0
Client address: (ADDRESS=(PROTOCOL=tcp)(HOST=172.16.218.251)(PORT=61249))
Wed Dec 22 07:14:06 2010
Beginning log switch checkpoint up to RBA [0x629.2.10], SCN: 491993396
Thread 1 advanced to log sequence 1577
Current log# 3 seq# 1577 mem# 0: /oradata/redo03a.rdo
Current log# 3 seq# 1577 mem# 1: /oradata/redo03b.rdo
Wed Dec 22 07:19:05 2010
Completed checkpoint up to RBA [0x629.2.10], SCN: 491993396

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 31 2011

Added on Dec 19 2010

#general-database-discussions

18 comments

827 views