今天项目上利用运行netca创建监听时报错,(运行netmgr可以弹出窗口,未测试是否可以建立监听)
报错信息:
[oracle@BSS-WG2 ~]$netca
Oracle Net Services Configuration:
#
# An unexpected error has been detected by HotSpot Virtual Machine:
#
# SIGSEGV (0xb) at pc=0x002bb9b3, pid=6447, tid=4160280784
#
# Java VM: Java HotSpot(TM) Client VM (1.4.2_14-b05 mixed mode)
# Problematic frame.:
# C [libc.so.6+0x6e9b3] index+0x63
#
# An error report file with more information is saved as hs_err_pid6447.log
#
# If you would like to submit a bug report, please visit:
# http://java.sun.com/webapps/bugreport/crash.jsp
#
/app/oracle/product/10.2.0 _1/bin/netca: line 190: 6447 Aborted $JRE -mx64m $SRVM_PROPERTY_DEFS -Dsun.java2d.font.DisableAlgorithmicStyles=true -classpath $CLASSPATH oracle.net.ca.NetCA $*
[oracle@BSS-WG2 ~]$
报错原因:运行netca时可能需要获取主机名和相应ip,netca应该是从/etc/hosts/文件中获取主机名和ip。但本主机的/etc/hosts中配置主机名和ip的记录被注释掉了,导致necta获取不到相关信息报错。
解决过程:
查看主机ip
[oracle@BSS-WG2 ~]$ /sbin/ifconfig
eth0 Link encap:Ethernet HWaddr 00:18:8B:E5:E5:9D
inet addr:134.161.9.132 Bcast:134.161.9.255 Mask:255.255.255.0
inet6 addr: fe80::218:8bff:fee5:e59d/64 Scope:Link
UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1
RX packets:1938345 errors:0 dropped:0 overruns:0 frame.:0
TX packets:1784385 errors:0 dropped:0 overruns:0 carrier:0
collisions:0 txqueuelen:1000
RX bytes:1219179624 (1.1 GiB) TX bytes:1118035659 (1.0 GiB)
Interrupt:90
eth0:0 Link encap:Ethernet HWaddr 00:18:8B:E5:E5:9D
inet addr:134.160.25.11 Bcast:134.160.25.255 Mask:255.255.255.0
UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1
Interrupt:90
lo Link encap:Local Loopback
inet addr:127.0.0.1 Mask:255.0.0.0
inet6 addr: ::1/128 Scope:Host
UP LOOPBACK RUNNING MTU:16436 Metric:1
RX packets:2036475 errors:0 dropped:0 overruns:0 frame.:0
TX packets:2036475 errors:0 dropped:0 overruns:0 carrier:0
collisions:0 txqueuelen:0
RX bytes:1224569606 (1.1 GiB) TX bytes:1224569606 (1.1 GiB)
查看主机名
[oracle@BSS-WG2 ~]$hostname
BSS-WG2
查看/etc/hosts文件
# Do not remove the following line, or various programs
# that require network functionality will fail.
::1 localhost.localdomain localhost BSS-WG2
#134.161.9.132 BSS-WG2
#134.160.25.11 BSS-WG2
发现:运行ifconfig、hostname 都可以得到ip和主机名,且正确。但/etc/hosts文件里的相关ip和主机名都给注释掉了。问题可能出在这里
解决办法:将hosts文件中的#134.161.9.132 BSS-WG2---->134.161.9.132 BSS-WG2后netca运行成功。
127.0.0.1 localhost.localdomain localhost
总结:
在网上查找此问题还会引起如下问题
问题现象1. sqlplus中无法启动实例
psdb@ssm /home/oracle$ sqlplus / as sysdba
SQL*Plus: Release 10.2.0.3.0 - Production on Fri Jun 5 23:37:21 2009
Copyright (c) 1982, 2006, Oracle. All Rights Reserved.
Connected to an idle instance.
SQL> startup;
ORA-00600: internal error code, arguments: [keltnfy-ldmInit], [46], [1], [], [], [], [], []
问题现象2:无法使用dbca创建实例
在使用dbca图形化界面创建数据库实例的时候有两种错误形式。
第一种报错形式和上面netca报错信息类似。
第二种报错形式是,在确认创建数据库的时候,弹出一个小对话框提示ORA-00600 [keltnfy-ldmInit], [46]错误。
Metalink相关描述
针对上面提到的“问题现象一”错误,Metalink上有篇详细描述的文章,又进一步探索需求的朋友可以参考一下:
Startup Database Produces Ora-00600: [Keltnfy-Ldminit]
Doc ID: 336447.1 Type: PROBLEM
Modified Date : 23-OCT-2008 Status: PUBLISHED
: