Error during database startup ORA-00221 ORA-00206 ORA-00202

Error during database startup

ORA-00221: error on write to control file
ORA-00206: error in writing (block 1, # blocks 1) of control file
ORA-00202: control file: '/oracle/DQ1/sapdata1/cntrl/cntrlDQ1.dbf'
ORA-27041: unable to open file
Linux-x86_64 Error: 13: Permission denied

Additional information: 3

ORA-01110: data file 1: '/oracle/DQ1/sapdata1/system_1/system.data1'
ORA-01114: IO error writing block to file 1 (block # 1)
ORA-27041: unable to open file
Linux-x86_64 Error: 13: Permission denied

Additional information: 3

Cause:

Incorrect file permissions for database files / control files

Solution:

$ chown -R oracle:oinstall sapdata*

Error during database startup

ORA-09925: Unable to create audit trail file
Linux-x86_64 Error: 13: Permission denied
Additional information: 9925

Cause #1:
Incorrect file permissions for SAPTRACE directory

Solution #1:
$ chown -R oracle:oinstall saptrace

Cause #2:
Incorrect audit trace file destination

Solution #2:
Check database parameter audit_file_dest in SPFILE and set to correct value

Cause #3:
No write permissions in default audit file destinations.
<ORACLE_BASE>/admin/<ORACLE_SID>/adump directory does not exist

Solution #3:
Create default audit file destinations with correct permissions for oracle:oinstall

[root]# cd <ORACLE_BASE>
[root]# mkdir -p admin/<ORACLE_SID>/adump
[root]# chown -R oracle:oinstall admin/<ORACLE_SID>/adump

1st default: <ORACLE_BASE>/admin/<ORACLE_SID>/adump
2nd default: <ORACLE_HOME>/rdbms/audit
3rd default: AUDIT_FILE_DEST (only when instance is started)

Error during database startup
ORA-00221: error on write to control file
ORA-00206: error in writing (block 1, # blocks 1) of control file
ORA-00202: control file: '/oracle/DQ1/origlogA/cntrl/cntrlDQ1.dbf'
ORA-27041: unable to open file
Linux-x86_64 Error: 13: Permission denied

Additional information: 3

Cause:
Incorrect file permissions for redo log files / control files

Solution:
$ chown -R oracle:oinstall origlog*
$ chown -R oracle:oinstall mirrlog*

Error during database operation
Mon Sep 15 16:09:01 2014
ARCH: Archival stopped, error occurred. Will continue retrying
ORACLE Instance DQ1 - Archival Error
ORA-16038: log 1 sequence# 65 cannot be archived
ORA-19504: failed to create file ""
ORA-00312: online log 1 thread 1: '/oracle/DQ1/origlogA/log_g11m1.dbf'
ORA-00312: online log 1 thread 1: '/oracle/DQ1/mirrlogA/log_g11m2.dbf'
ARCH: Archival stopped, error occurred. Will continue retrying
ORACLE Instance DQ1 - Archival Error
ORA-16014: log 1 sequence# 65 not archived, no available destinations
ORA-00312: online log 1 thread 1: '/oracle/DQ1/origlogA/log_g11m1.dbf'
ORA-00312: online log 1 thread 1: '/oracle/DQ1/mirrlogA/log_g11m2.dbf'

Cause:
Incorrect file permissions for archive destination

Solution
$ chown -R oracle:oinstall oraarch

Error during clone Oracle Home operation

% ./config04_clone_oh.sh

DESCRIPTION: This script runs the clone command (clone.pl) for the Oracle home.

Cloning Oracle home /oracle/QO1/112_64
./config04_clone_oh.sh[56]: /oracle/QO1/112_64/clone/bin/clone.pl: cannot execute

OUI finished with return code 126
%

Cause:
Incorrect ownership of files in Oracle Home.

Files in Oracle home still belong to ora<dbsid>, not to 'oracle'.

The script config03_set_swowner.sh did not recursively change
the ownership to 'oracle' because variable C_ORACLE_HOME uses
the Runtime Oracle Home <OHRDBMS> instead of Installation Oracle Home <IHRDBMS>.

% ls -l /oracle/QO1/112_64/clone/bin/clone.pl
-rwxr-xr-x 1 oraqo1 dba 17067 Mar 16 2011 /oracle/QO1/112_64/clone/bin/clone.pl
%

Solution #1:
Check config03_set_swowner.sh and change C_ORACLE_HOME to Installation Oracle Home

Example: config03_set_swowner.sh
#export C_ORACLE_HOME=/oracle/<SID>/112_64
export C_ORACLE_HOME=/oracle/<SID>/11204

Rerun the script.

% ls -l /oracle/QO1/112_64/clone/bin/clone.pl
ls -l /oracle/QO1/112_64/clone/bin/clone.pl
-rwxr-xr-x 1 oracle oinstall 17067 Mar 16 2011 /oracle/QO1/112_64/clone/bin/clone.pl
%

Solution #2:
Rerun the assistant 'clone_assistant.sh'. When you enter the path for Oracle home, make sure
that you use the <IHRDBMS>, not the <OHRDBMS>.

0 comments:

Post a Comment