About Me

My photo
Bangalore, India
I am an Oracle Certified Professional working in SAP Labs. Everything written on my blog has been tested on my local environment, Please test before implementing or running in production. You can contact me at amit.rath0708@gmail.com.

Thursday, July 25, 2013

ORA-00600: internal error code, arguments: [keltnfy-ldmInit], [46], [1], [], [], [], [], []

Yesterday When I was trying to start my Oracle Database I got below mentioned error :-

SQL> startup pfile='/home/oracle/oracle/product/10.2.0/db_1/dbs/initamit.ora'
ORA-00600: internal error code, arguments: [keltnfy-ldmInit], [46], [1], [], [], [], [], []

Cause :-

Logs shows Oracle server not able to resolve hostname of the server. The argument 46 in ORA - 600 error code indicates that Oracle not able to get hostname information from OS .

I have restarted my Oracle Database server and then I got this error.

Solution :-

Check hostname of the server in /etc/hosts file and with hostname command. Both should give you same name.

-bash-3.2$ hostname
new
-bash-3.2$ cat /etc/hosts
# Do not remove the following line, or various programs
# that require network functionality will fail.
127.0.0.1       localhost.localdomain localhost
::1             localhost6.localdomain6 localhost6
172.16.1.185 database database.local

Values in /etc/hosts file and hostname command are different . Change the enteries in /etc/hosts file as below:-

-bash-3.2$ cat /etc/hosts
# Do not remove the following line, or various programs
# that require network functionality will fail.
127.0.0.1       localhost.localdomain localhost
::1             localhost6.localdomain6 localhost6
172.16.1.185 new.local new

-bash-3.2$ hostname
new
-bash-3.2$ hostname -f
new.local

Now try to start your Oracle database it will start.

SQL> startup pfile='/home/oracle/oracle/product/10.2.0/db_1/dbs/initamit.ora'
ORACLE instance started.

Total System Global Area 1043886080 bytes
Fixed Size                  2213384 bytes
Variable Size             666896888 bytes
Database Buffers          364904448 bytes
Redo Buffers                9871360 bytes
Database mounted.
Database opened.

I hope this article helped you.

Regards,
Amit Rath

No comments:

Post a Comment