ORA-03113: end-of-file on communication channel

[Former Member]

Dear Expert Team ,

When I am starting oracle database its give  Ora-03113.

I am unable to start Oracle , I have done all process , but not able to alert.

Please find the process that I have taken and Alert log files in the attachment.

I will be very thanks full to your valuable guidance

Regards

Oracle Startup fail.txt.zip

[Former Member]

Dear

by seeing your log some may says you have made changes to oracle parameters you do one thing if you have backup of initSID.ora  just replace initSID.ora with existing one it will start

it may happen you made changes to shared_pool_size 

Kindly look into this

startup

ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance

ORACLE instance started.

Total System Global Area 3541028864 bytes

Fixed Size                  2187592 bytes

Variable Size            1778388664 bytes

Database Buffers         1744830464 bytes

Redo Buffers               15622144 bytes

Database mounted.

ORA-03113: end-of-file on communication channel   

Process ID: 8326

Session ID: 76 Serial number: 5

Regards

[Former Member]

Yes  you are correct , this is our test server. In this  I was reduce oraarch file system size and extended  other data file system size . that time owner was done root:root .

But  when  I am checking  via DB02 in this database 0.0 GB .

database

Name         DEFAULT                         Filling degree:

DB system:        ORA

Size:                 0.00 GB                Total size:                   0.00 GB

Free Size:         0.00 GB                Total free size:              0.00 GB

Used:               0 %                        Total used:                      0 %

Why its show 0.0 Gb

Regards

[Former Member]

Dear

your owner should be orasid : dba to make any changes at database level

Regards

[former_member182657]

Hi Pooja,

ORA-16014: log 1 sequence# 1 not archived, no available destinations

Have you performed or changed any parameter under your database.Kindly share .If possible also share value for profile parameter

SQL> show parameter archive_dest ,

and if not set than define the log archive destination and also check for enough free space on the system.

Regards,

Gaurav

[Former Member]

When I check  archive destination , It show below command.

SQL> show parameter archive_dest;

NAME                                 TYPE        VALUE

------------------------------------ ----------- ------------------------------

log_archive_dest                     string

log_archive_dest_1                   string      LOCATION=/oracle/PRD/oraarch/P

                                                 RDarch

log_archive_dest_10                  string

log_archive_dest_11                  string

log_archive_dest_12                  string

log_archive_dest_13                  string

log_archive_dest_14                  string

log_archive_dest_15                  string

log_archive_dest_16                  string

log_archive_dest_17                  string

NAME                                 TYPE        VALUE

------------------------------------ ----------- ------------------------------

log_archive_dest_18                  string

log_archive_dest_19                  string

log_archive_dest_2                   string

log_archive_dest_20                  string

log_archive_dest_21                  string

log_archive_dest_22                  string

log_archive_dest_23                  string

log_archive_dest_24                  string

log_archive_dest_25                  string

log_archive_dest_26                  string

log_archive_dest_27                  string

NAME                                 TYPE        VALUE

------------------------------------ ----------- ------------------------------

log_archive_dest_28                  string

log_archive_dest_29                  string

log_archive_dest_3                   string

log_archive_dest_30                  string

log_archive_dest_31                  string

log_archive_dest_4                   string

log_archive_dest_5                   string

log_archive_dest_6                   string

log_archive_dest_7                   string

log_archive_dest_8                   string

log_archive_dest_9                   string

NAME                                 TYPE        VALUE

------------------------------------ ----------- ------------------------------

log_archive_dest_state_1             string      enable

log_archive_dest_state_10            string      enable

log_archive_dest_state_11            string      enable

log_archive_dest_state_12            string      enable

log_archive_dest_state_13            string      enable

log_archive_dest_state_14            string      enable

log_archive_dest_state_15            string      enable

log_archive_dest_state_16            string      enable

log_archive_dest_state_17            string      enable

log_archive_dest_state_18            string      enable

log_archive_dest_state_19            string      enable

NAME                                 TYPE        VALUE

------------------------------------ ----------- ------------------------------

log_archive_dest_state_2             string      enable

log_archive_dest_state_20            string      enable

log_archive_dest_state_21            string      enable

log_archive_dest_state_22            string      enable

log_archive_dest_state_23            string      enable

log_archive_dest_state_24            string      enable

log_archive_dest_state_25            string      enable

log_archive_dest_state_26            string      enable

log_archive_dest_state_27            string      enable

log_archive_dest_state_28            string      enable

log_archive_dest_state_29            string      enable

NAME                                 TYPE        VALUE

------------------------------------ ----------- ------------------------------

log_archive_dest_state_3             string      enable

log_archive_dest_state_30            string      enable

log_archive_dest_state_31            string      enable

log_archive_dest_state_4             string      enable

log_archive_dest_state_5             string      enable

log_archive_dest_state_6             string      enable

log_archive_dest_state_7             string      enable

log_archive_dest_state_8             string      enable

log_archive_dest_state_9             string      enable

standby_archive_dest                 string      ?/dbs/arch

SQL>

Regards

[divyanshu_srivastava3]

HI Pooja,

Please provide the output of "select group #,sequence #, STATUS from v$log; "

Regards,

Divyanshu

[former_member225142]

Hi Pooja,

Can you please check the File system usage and see if the space is free or not?

Regards,

Meenu Hans

[Reagan]

ARCH: Error 19504 Creating archive log file to '/oracle/PRD/oraarch/PRDarch1_1_855734697.dbf'
Errors in file /oracle/PRD/saptrace/diag/rdbms/prd/PRD/trace/PRD_ora_7900.trc:
ORA-16038: log 1 sequence# 1 cannot be archived
ORA-19504: failed to create file ""
ORA-00312: online log 1 thread 1: '/oracle/PRD/origlogA/log_g11m1.dbf'
ORA-00312: online log 1 thread 1: '/oracle/PRD/mirrlogA/log_g11m2.dbf'
USER (ospid: 7900): terminating the instance due to error 16038

Check whether the file system /oracle/PRD/oraarch is full or not.

Regards

RB

[Former Member]

Its has enough space.

dev/vgsap/PRD_oraarch     9568256   19848 8951640    0% /oracle/PRD/oraarch

I check Alert Log , Its show.

sapprd1:oraprd 14> tail -300 alert_PRD.log

===========> alert_PRD.log

ARCH: Archival stopped, error occurred. Will continue retrying

ORACLE Instance PRD - Archival Error

ORA-16014: log 1 sequence# 1 not archived, no available destinations

ORA-00312: online log 1 thread 1: '/oracle/PRD/origlogA/log_g11m1.dbf'

ORA-00312: online log 1 thread 1: '/oracle/PRD/mirrlogA/log_g11m2.dbf'

Archiver process freed from errors. No longer stopped

Tue Aug 19 11:14:48 2014

Incremental checkpoint up to RBA [0x4.302d9.0], current log tail at RBA [0x4.302d9.0]

Tue Aug 19 11:16:20 2014

ARCH: Archival stopped, error occurred. Will continue retrying

ORACLE Instance PRD - Archival Error

ORA-16038: log 1 sequence# 1 cannot be archived

ORA-19504: failed to create file ""

ORA-00312: online log 1 thread 1: '/oracle/PRD/origlogA/log_g11m1.dbf'

ORA-00312: online log 1 thread 1: '/oracle/PRD/mirrlogA/log_g11m2.dbf'

Tue Aug 19 11:16:20 2014

Archiver process freed from errors. No longer stopped

Please suggest .

Regards

[Former Member]

Dear Team,

I was check that  oraarch directory owner was root:root.

drwxr-xr-x   2 oraprd     dba             96 Aug 16 08:05 mirrlogA

drwxr-xr-x   2 oraprd     dba             96 Aug 16 08:05 mirrlogB

drwxr-xr-x   3 root       root          1024 Aug 16 11:18 oraarch 

drwxr-xr-x   3 oraprd     dba             96 Aug 16 08:05 oraflash

Then I was  change oraprd:dba  .

Now my Oracle and SAP is working  fine.

Regards

Pooja

[Reagan]

Your problem is either with the file system space or not properly mounted.

Are you able to create files under that file system ?

su - oraprd

touch /oracle/PRD/oraarch/test

If yes then stop the database and unmount and mount the file system.

Start the database.

Regards

RB

[Former Member]

Hi,

Error clearly says

ORA-19504: failed to create file ""

And permissions shows

drwxr-xr-x   3 root       root          1024 Aug 16 11:18 oraarch  

Where only user root has access ro write a file in oraarch. It has resolved after changing the permissons to orasid:dba because you gave required access to orasid.

Regards,

Nick Loy