Database Characterset is US7ASCII
Drop Relation ADR_CONTROL
Errors in file /u01/app/oracle/diag/rdbms/oracle/oracle/trace/oracle_ora_67199.trc:
ORA-48316: relation [ADR_CONTROL] unavailable or cannot be created
ORA-48122: error with opening the ADR block file [/u01/app/oracle/diag/rdbms/oracle/oracle/metadata/ADR_CONTROL.ams] [0]
ORA-27041: unable to open file
Linux-x86_64 Error: 13: Permission denied
Additional information: 2
Errors in file /u01/app/oracle/diag/rdbms/oracle/oracle/trace/oracle_ora_67199.trc:
ORA-48316: relation [ADR_CONTROL] unavailable or cannot be created
ORA-48122: error with opening the ADR block file [/u01/app/oracle/diag/rdbms/oracle/oracle/metadata/ADR_CONTROL.ams] [0]
ORA-27041: unable to open file
Linux-x86_64 Error: 13: Permission denied
Additional information: 2
Error 48316 happened during db open, shutting down database
USER (ospid: 67199): terminating the instance due to error 48316
Instance terminated by USER, pid = 67199
ORA-1092 signalled during: alter database "oracle" open resetlogs...
opiodr aborting process unknown ospid (67199) as a result of ORA-1092
SOLUTION:
Drop Relation ADR_CONTROL
Errors in file /u01/app/oracle/diag/rdbms/oracle/oracle/trace/oracle_ora_67199.trc:
ORA-48316: relation [ADR_CONTROL] unavailable or cannot be created
ORA-48122: error with opening the ADR block file [/u01/app/oracle/diag/rdbms/oracle/oracle/metadata/ADR_CONTROL.ams] [0]
ORA-27041: unable to open file
Linux-x86_64 Error: 13: Permission denied
Additional information: 2
Errors in file /u01/app/oracle/diag/rdbms/oracle/oracle/trace/oracle_ora_67199.trc:
ORA-48316: relation [ADR_CONTROL] unavailable or cannot be created
ORA-48122: error with opening the ADR block file [/u01/app/oracle/diag/rdbms/oracle/oracle/metadata/ADR_CONTROL.ams] [0]
ORA-27041: unable to open file
Linux-x86_64 Error: 13: Permission denied
Additional information: 2
Error 48316 happened during db open, shutting down database
USER (ospid: 67199): terminating the instance due to error 48316
Instance terminated by USER, pid = 67199
ORA-1092 signalled during: alter database "oracle" open resetlogs...
opiodr aborting process unknown ospid (67199) as a result of ORA-1092
SOLUTION:
To solve the issue, use the following alternatives:
The anti-virus scanner had additional processes running during the time-frame. Disabling the anti-virus scanner can resolve this issue
1. Disable Anti-Virus
2. Resolve the OS level Anti-Virus privilege issue(s) if there are any
3. Re-enable Anti-Virus
Note: There are no OS level permission issue on the directory and even changing permissions to 770 or 777 doesn't resolve the issue. This is the Anti-Virus which is preventing from writing the ADR logs
To stop McAffe & it's Scanner, do the following:
/etc/init.d/cma stop
/etc/init.d/nails stop
/etc/init.d/nails stop
No comments:
Post a Comment