ORA-00600: internal error code, arguments: [kmgs_parameter_update_timeout_1], [17510]
November 1, 2012 Leave a comment
Error message:
ORA-00600: internal error code, arguments: [kmgs_parameter_update_timeout_1], [17510], [], [], [], [], [], [], [], [], [], []
ORA-17510: Attempt to do i/o beyond file size
One of the solution:
1. First of all check oracle file permissions.
cd $ORACLE_HOME/bin
ls -l oracle-r-xr-s–x 1 oracle oinstall 210824720 Sep 15 2010 oracle
As you can see , my oracle file permissions are wrong, because it should be -rwsr-s—x.
So change it:
chmod 6751 oracle
ls -l oracle
-rwsr-s–x 1 oracle oinstall 210824720 Sep 15 2010 oracle
2. Re-create spfile.
The problem may be caused by a possible corruption of spfile. Oracle is not able to write entry into the spfile and the error occurs.
The solution:
export ORACLE_SID=orcl
sqlplus / as sysdba
create pfile from spfile;
shutdown immediate;
startup pfile=’/u01/app/oracle/product/11.2.0/db_1/dbs/initorcl.ora’;
create spfile from pfile=’/u01/app/oracle/product/11.2.0/db_1/dbs/initorcl.ora’;
shutdown immediate;
startup;
Good Luck!