目录
一、一开始netca报错，dbca不报错。
Oracle Net Services Configuration:
#
# A fatal error has been detected by the Java Runtime Environment:
#
# SIGSEGV (0xb) at pc=0x00007fc7acb44a15, pid=26294, tid=140497720002304
#
# JRE version: Java(TM) SE Runtime Environment (8.0_91-b14) (build 1.8.0_91-b14)
二、手动加上listener.ora后，可以启动监听了，但dbca报错，报相同的java core dump。
三、删除掉listener.ora后，再运行dbca就OK了。所以先创建dbca，再解决netca无法创建问题。
四、解决netca流程如下：
1、进行监听创建时，报错信息：
[oracle@localhost ~]$ netca
Oracle Net Services Configuration:
#
# A fatal error has been detected by the Java Runtime Environment:
#
# SIGSEGV (0xb) at pc=0x00007fc7acb44a15, pid=26294, tid=140497720002304
#
# JRE version: Java(TM) SE Runtime Environment (8.0_91-b14) (build 1.8.0_91-b14)
# Java VM: Java HotSpot(TM) 64-Bit Server VM (25.91-b14 mixed mode linux-amd64 compressed oops)
# Problematic frame:
# C [libclntsh.so.12.1+0x5eca15] snlinGetAddrInfo+0x985
#
# Failed to write core dump. Core dumps have been disabled. To enable core dumping, try "ulimit -c unlimited" before starting Java again
#
# An error report file with more information is saved as:
# /data/u01/app/oracle/product/12.2.0/dbhome_1/network/tools/hs_err_pid26294.log
#
# If you would like to submit a bug report, please visit:
# http://bugreport.java.com/bugreport/crash.jsp
# The crash happened outside the Java Virtual Machine in native code.
# See problematic frame for where to report the bug.
#
/data/u01/app/oracle/product/12.2.0/dbhome_1/bin/netca: line 179: 26294 Aborted (core dumped) $JRE $JRE_OPTIONS -classpath $CLASSPATH oracle.net.ca.NetCA $*
2、分析：
网上资料大多解释为java 版本问题，需要使用oracle的jdk程序，用centos自带的openjdk不好用，但我按照文档卸载openjdk，安装oracle的，也不好用
https://blog.csdn.net/wen524/article/details/88104688
3、手动建立监听，不使用netca
（1）创建listener.ora文件，并做静态注册
oracle用户进入$ORACLE_HOME/network/admin中创建vi listener.ora,增加如下配置：
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.110.64.2)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = qlorclprd)
(ORACLE_HOME = /data/u01/app/oracle/product/12.2.0/dbhome_1)
(SID_NAME = qlorclprd)
)
)
注：如果不使用ip地址，使用localhost时，会报如下错误：
4、启动监听，正常
5、配置tnsnames.ora远程访问：
6、sqlplus 远程访问
文章评论