Monday, April 11, 2011

Problems with host name

If you get a lot of dump files generated and this error in your alert log:

Warning: keltnfy call to ldmInit failed with error 46

Check that your host name can be resolved and the IP address is correct; in this example in Linux you can see that the name is missing from /etc/hosts:

MYHOST:mydb> uname -n
MYHOST
MYHOST:mydb> cat /etc/hostname
MYHOST
MYHOST:mydb> 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
MYHOST:mydb> ping MYHOST
ping: unknown host MYHOST
MYHOST:mydb> sqlplus /

SQL*Plus: Release 10.2.0.4.0 - Production on Tue Jul 13 10:01:38 2010

Copyright (c) 1982, 2007, Oracle. All Rights Reserved.


Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing
options

SQL> set linesize 150
SQL> select INSTANCE_NAME, HOST_NAME, STATUS from v$instance;

INSTANCE_NAME HOST_NAME STATUS
---------------- ---------- ---------------
mydb MYHOST OPEN

SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release
10.2.0.4.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing
options

No comments:

Post a Comment