Oracle 执行netca 时报错 An unexpected exception has been detected in native code outside the VM 的解决方案
安装好oracle 10后,配置网络监听,执行 netca ,报错如下:
Oracle Net Services Configuration: An unexpected exception has been detected in native code outside the VM. Unexpected Signal : 11 occurred at PC=0xB7E52093 Function=index+0x63
library=/lib/tls/libc.so.6 current java thread: at oracle.net.common.netgetenv.getdnsdomain(native method) at oracle.net.ca.configureprofile.setdefaultprofileparams(unknown source) at oracle.net.ca.initialsetup.setupconfigobjects(unknown source) at oracle.net.ca.initialsetup.(Unknown Source) at oracle.net.ca.NetCA.main(Unknown Source) Dynamic libraries: 08048000-08056000 r-xp 00000000 03:06 263311 /u01/oracle/product/10.2.0/db/jdk/jre/bin/java 08056000-08059000 rwxp 0000d000 03:06 263311 /u01/oracle/product/10.2.0/db/jdk/jre/bin/java 08059000-08365000 rwxp 08059000 00:00 0 [heap] a90b4000-a90c3000 r-xp 00000000 03:06 15511 /lib/tls/libresolv-2.3.2.so a90c3000-a90c4000 rwxp 0000f000 03:06 15511 /lib/tls/libresolv-2.3.2.so [...] b7f28000-b7f30000 r-xp 00000000 03:06 263228 /u01/oracle/product/10.2.0/db/jdk/jre/lib/i386/native_threads/libhpi.so b7f30000-b7f31000 rwxp 00007000 03:06 263228 /u01/oracle/product/10.2.0/db/jdk/jre/lib/i386/native_threads/libhpi.so b7f32000-b7f48000 r-xp 00000000 03:06 15468 /lib/ld-2.3.2.so b7f48000-b7f49000 rwxp 00015000 03:06 15468 /lib/ld-2.3.2.so bf833000-bf848000 rwxp bf833000 00:00 0 [stack] ffffe000-fffff000 ---p 00000000 00:00 0 [vdso] Heap at VM Abort: Heap def new generation total 576K, used 345K [0xab7b0000, 0xab850000, 0xabc90000) eden space 512K, 60% used [0xab7b0000, 0xab7fd228, 0xab830000) from space 64K, 58% used [0xab840000, 0xab849508, 0xab850000) to space 64K, 0% used [0xab830000, 0xab830000, 0xab840000) tenured generation total 1408K, used 544K [0xabc90000, 0xabdf0000, 0xaf7b0000) the space 1408K, 38% used [0xabc90000, 0xabd18148, 0xabd18200, 0xabdf0000) compacting perm gen total 4096K, used 3573K [0xaf7b0000, 0xafbb0000, 0xb37b0000) the space 4096K, 87% used [0xaf7b0000, 0xafb2d678, 0xafb2d800, 0xafbb0000) Local Time = Tue Oct 23 21:36:23 2007 Elapsed Time = 6 # # The exception above was detected in native code outside the VM # # Java VM: Java HotSpot™ Client VM (1.4.2_08-b03 mixed mode) # # An error report file has been saved as hs_err_pid9698.log. # Please refer to the file for further information. #
错误的原因是未在 /etc/hosts 文件中添加hostname对应的ip地址。
解决:
查看主机名shell下执行 hostname 譬如 hostnameAAA
查看ip地址,执行ifconfig 譬如 xxx.xxx.x.xxx
vi /etc/hosts
在 127.0.0.1 这一行的下面添加一行:
XXX.XXX.X.XXX hostnameAAA
保存即可。
怎样解决ORA-01078 & LRM-00109错误
SQL> startup
ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file '/opt/oracle/products/10.1.0.3/db_1/dbs/initrawdb.ora'
解决办法:
cp $ORACLE_BASE/admin/$ORACLE_SID/pfile/init.ora /opt/oracle/products/10.1.0.3/db_1/dbs/initrawdb.ora
> sqlplus /nolog
SQL*Plus: Release 10.1.0.3.0 - Production on Thu Jun 8 13:16:00 2006
Copyright (c) 1982, 2004, Oracle. All rights reserved.
SQL> conn / as sysdba
Connected to an idle instance.
SQL> startup
ORACLE instance started.
Total System Global Area 167772160 bytes
Fixed Size 778212 bytes
Variable Size 57679900 bytes
Database Buffers 109051904 bytes
Redo Buffers 262144 bytes
Database mounted.
Database opened.
SQL>
问题解决!
注:Oracle在启动过程中,需要读取参数文件(pfile/spfile)来创建实例.Oracle在启动过程中,寻找参数文件的顺序为:spfile.ora,spfile.ora,init.ora.
问题补充:错误信息:
SQL> conn sys/oracle@xzomc as sysdba
Connected to an idle instance.
SQL> startup pfile=/oracleapp/u01/app/oracle/admin/xzomc/pfile/initgomcr.ora
LRM-00109: could not open parameter file '/oracleapp/u01/app/oracle/admin/xzomc/pfile/initgomcr.ora'
ORA-01078: failure in processing system parameters
解决办法:
$ cp $ORACLE_BASE/admin/xzomc/pfile/init.ora.728200794421 /oracleapp/u01/app/oracle/product/10.2.0/dbs/initrawdb.ora
SQL> conn sys/oracle@xzomc as sysdba;
Connected to an idle instance.
SQL> startup pfile=$ORACLE_BASE/admin/xzomc/pfile/init.ora.728200794421
ORACLE instance started.
Total System Global Area 2550136832 bytes
Fixed Size 1980808 bytes
Variable Size 536872568 bytes
Database Buffers 1996488704 bytes
Redo Buffers 14794752 bytes
Database mounted.
Database opened.
也可能是oracle_sid的问题,问题出在设置oracle用户.bash_profile文件的oracle_sid变量时,写为了 oracle_sid=wilson ,在startup的时候报错,其实真正的数据库实例名称是venus。