Home » RDBMS Server » Server Administration » ORA-16403: shut down in progress - remote connection is not permitted (11.2.0.3.0 , Linux 2.6.18-274.el5)
ORA-16403: shut down in progress - remote connection is not permitted [message #623359] Tue, 09 September 2014 05:00 Go to next message
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
Re: ORA-16403: shut down in progress - remote connection is not permitted [message #623361 is a reply to message #623359] Tue, 09 September 2014 05:18 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Times-out are from the network, check it.

Re: ORA-16403: shut down in progress - remote connection is not permitted [message #623363 is a reply to message #623361] Tue, 09 September 2014 05:23 Go to previous messageGo to next message
manishdba007
Messages: 27
Registered: September 2014
Location: India
Junior Member
i am not sure from where to start..? Everything is running fine .
Re: ORA-16403: shut down in progress - remote connection is not permitted [message #623364 is a reply to message #623363] Tue, 09 September 2014 05:26 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Check with your network admin.
Try to connect from primary server to standby database with SQL*Plus, and from standby server to primary database.

Re: ORA-16403: shut down in progress - remote connection is not permitted [message #623365 is a reply to message #623364] Tue, 09 September 2014 05:30 Go to previous message
manishdba007
Messages: 27
Registered: September 2014
Location: India
Junior Member
Thanks for your qucik response.
Previous Topic: Fatal NI connect error 12170.
Next Topic: Install database with dbca and response file.
Goto Forum:
  


Current Time: Thu Mar 28 08:21:39 CDT 2024