Thursday, September 29, 2016

ORA-03113: end-of-file on communication channel (ORA-19809: limit exceeded for recovery files)

Cause: Archive log location are full.

SQL> startup;
ORACLE instance started.

Total System Global Area 2137886720 bytes
Fixed Size                  2177456 bytes
Variable Size            1342178896 bytes
Database Buffers          788529152 bytes
Redo Buffers                5001216 bytes
Database mounted.
ORA-03113: end-of-file on communication channel
Process ID: 3952
Session ID: 127 Serial number: 3


SQL>

From Alert Log

ARC0: STARTING ARCH PROCESSES COMPLETE
Errors in file d:\app\diag\rdbms\orcl\orcl\trace\orcl_ora_3952.trc:
ORA-16038: log 1 sequence# 1420 cannot be archived
ORA-19809: limit exceeded for recovery files
ORA-00312: online log 1 thread 1: 'D:\APP\ORADATA\ORCL\REDO_01.LOG'
USER (ospid: 3952): terminating the instance due to error 16038
Instance terminated by USER, pid = 3952


Solution:

SQL> conn /as sysdba
Connected to an idle instance.
SQL> startup mount;
ORACLE instance started.

Total System Global Area 2137886720 bytes
Fixed Size                  2177456 bytes
Variable Size            1342178896 bytes
Database Buffers          788529152 bytes
Redo Buffers                5001216 bytes
Database mounted.
SQL> ALTER SYSTEM SET DB_RECOVERY_FILE_DEST_SIZE=400G scope=both;

System altered.

SQL> alter database open;

Database altered.

SQL>

Sunday, September 4, 2016

Weblogic server started but console is not opening.

Check the Weblogic server log ($DOMAIN_HOME/servers/AdminServer/security) for making sure that Weblogic server are started successfully.

If service started successfully check the firewall is blocking or not. If firewall is blocking then stop the firewall.

[root@weblogic2 oracle]# chkconfig iptables off
[root@weblogic2 oracle]#
[root@weblogic2 oracle]#
[root@weblogic2 oracle]# service iptables stop
iptables: Flushing firewall rules:                         [  OK  ]
iptables: Setting chains to policy ACCEPT: filter          [  OK  ]
iptables: Unloading modules:                               [  OK  ]
[root@weblogic2 oracle]#