This is a bug of oracle. If gather schema takes much time it doesn't complete the full operation and WRI$_OPTSTAT_HISTHEAD_HISTORY keeps up growing. It exhausts the SYSAUX tablespace. Oracle recommends a patch to be applied to resolve the above problem. But, in our case there is some
Showing posts with label Database Issues. Show all posts
Showing posts with label Database Issues. Show all posts
ORA-27123 error during oracle database start
Issue
While starting the oracle database 10g [10.1.0.5.0], we get the following error.
ORA-27123: unable to attach to shared memory segment
While starting the oracle database 10g [10.1.0.5.0], we get the following error.
ORA-27123: unable to attach to shared memory segment
opidcl aborting process unknown ospid (xxxx_xxxxxxx) due to error ORA-28
In oracle database version 11.1.0.7, we have encountered the following error message.
opidcl aborting process unknown ospid (12874_47230856307152) due to error ORA-28
opidcl aborting process unknown ospid (12874_47230856307152) due to error ORA-28
ORA-10173 Dynamic Sampling time out error
In the alert log file, we have encountered the following error.
ORA-10173 Dynamic Sampling time-out error
ORA-10173 Dynamic Sampling time-out error
Subscribe to:
Posts
(
Atom
)