| ORA-16403: shut down in progress - remote connection is not permitted [message #623359] |
Tue, 09 September 2014 05:00  |
 |
manishdba007
Messages: 27
Registered: September 2014
Location: India
|
Junior Member |
|
|
Hi All,
We are noticing an unobvious error in our dataguard enviourment.
Belwo is i am pasting alert log of primary and standby -:
Primary
Errors in file /data01/app/oracle/diag/rdbms/scppprd/SCPPPRD/trace/SCPPPRD_nsa2_20777.trc:
ORA-16403: shut down in progress - remote connection is not permitted
Tue Sep 09 09:10:19 2014
ARC0: Attempting destination LOG_ARCHIVE_DEST_2 network reconnect (270)
ARC0: Destination LOG_ARCHIVE_DEST_2 network reconnect abandoned
FAL[server, ARC0]: Error 270 creating remote archivelog file 'SCPPPRD.DR'
FAL[server, ARC0]: FAL archive failed, see trace file.
ARCH: FAL archive failed. Archiver continuing
ORACLE Instance SCPPPRD - Archival Error. Archiver continuing.
Tue Sep 09 09:16:10 2014
Fatal NI connect error 12170.
VERSION INFORMATION:
TNS for Linux: Version 11.2.0.3.0 - Production
Oracle Bequeath NT Protocol Adapter for Linux: Version 11.2.0.3.0 - Production
TCP/IP NT Protocol Adapter for Linux: Version 11.2.0.3.0 - Production
Time: 09-SEP-2014 10:42:49
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: 110
nt OS err code: 0
Client address: (ADDRESS=(PROTOCOL=tcp)(HOST=193.195.90.200)(PORT=53983))
standby -
***********************************************************************
Fatal NI connect error 12170.
VERSION INFORMATION:
TNS for Linux: Version 11.2.0.3.0 - Production
Oracle Bequeath NT Protocol Adapter for Linux: Version 11.2.0.3.0 - Production
TCP/IP NT Protocol Adapter for Linux: Version 11.2.0.3.0 - Production
Time: 09-SEP-2014 10:02:36
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: 110
nt OS err code: 0
Client address: (ADDRESS=(PROTOCOL=tcp)(HOST=161.163.163.1)(PORT=55648))
Tue Sep 09 10:14:22 2014
RFS[70]: Selected log 8 for thread 1 sequence 77113 dbid -1018318687 branch 810406051
Tue Sep 09 10:14:22 2014
Media Recovery Waiting for thread 1 sequence 77113 (in transit)
Recovery of Online Redo Log: Thread 1 Group 8 Seq 77113 Reading mem 0
Mem# 0: +RECO/scppprd/onlinelog/group_8.3336.824052077
mrp process is running fine
SQL> !ps -ef|grep -i mrp
oracle 22568 1 0 Sep01 ? 00:00:00 ora_mrp0_SCPPPRD
oracle 29467 25806 0 10:26 pts/0 00:00:00 /bin/bash -c ps -ef|grep -i mrp
oracle 29470 29467 0 10:26 pts/0 00:00:00 grep -i mrp
archive destination has enough room-
NAME TOTAL_MB FREE_MB
CRS 3075 2151
DATA 819120 308607
RECO 204780 184942
both databases are up from last 300 days. everything is running fine but suddenly we are getting these errors with timeout errors.
Log sequence are same on both sides. I am looking for a parmanent fix.
My doubts are -
1) what is the root cause ?
2) does it impact on production enviourment ?
3) what can be a good fix ?
Greatly appreciate if someone can help to troubleshoot.
Please let me know if further info needed.
Regards
Manish Sharma
91-9620983507
|
|
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
