Hi,
After a long time I have an error of ora-00600.
One of my Database is Oracle Express10.2.0.1.0
Cause:
In log we were receiving these errors.
Oracle Server was not resolving HOSTNAME.
Mon Jan 7 14:58:48 2008Errors in file /usr/lib/oracle/xe/app/oracle/admin/XE/udump/xe_ora_2462.trc:ORA-00600: internal error code, arguments: [keltnfy-ldmInit], [46], [1], [], [], [], [], []USER: terminating instance due to error 600
Solution:
added an entry for localhost in /etc/hosts.
open /etc/hosts file
vi /etc/hosts
:0:1 localhost.localdomain localhost
alter this to ....
127.0.0.1 localhost.localdomain localhost
or
ip_of_your_DBbox localhost.localdomain localhost
after that now check
-bash-3.1$ sqlplus
SQL*Plus: Release 10.2.0.1.0 - Production on Mon Jan 7 15:05:56 2008
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Enter user-name: /as sysdba
Connected to:Oracle Database 10g Express Edition Release 10.2.0.1.0 - Production
SQL> select count(*) from tab;
COUNT(*)
----------
3535
So, Be Happy!
Subscribe to:
Post Comments (Atom)
3 comments:
Keep up the good work.
thank you for the help i would have a disaster in here , i will add something if u dont mind
the host name in /etc/hosts must match the output of the command #hostname if not use the comand # hostname localhost.localdomain
thank you again
Thank You
You saved my day !
Thanks
Post a Comment