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