文章描述了在Oracle数据库中遇到无法打开配置助手界面和创建监听的错误，给出了相应的解决方案。通过在root用户下执行xhost+命令解除访问控制，并切换到oracle用户运行netca，成功打开配置助手。对于创建监听失败的问题，解决方案是删除原有的监听文件后重新配置，最终成功启动监听。
1、错误：打不开监听的配置助手界面
[oracle@MyRhelNew ~]$ netca
Oracle Net Services Configuration:
No protocol specified
Error: null
Check the trace file for details: /home/oracle/oracle/cfgtoollogs/netca/trace_OraDb11g_home1-2304132PM5415.log
Oracle Net Services configuration failed. The exit code is 1
解决方案：
在root下赋权：
[root@MyRhelNew 桌面]# xhost +
access control disabled, clients can connect from any host
[root@MyRhelNew 桌面]# su - oracle
[oracle@MyRhelNew ~]$ netca
Oracle Net Services Configuration:
成功打开！
2、错误：配置不了监听：Could not create Listener
[oracle@MyRhelNew ~]$ netca
Oracle Net Services Configuration:
ListenerException: Could not create Listener: TNS-04414: File error
解决方案：
将原监听文件删除。
[oracle@MyRhelNew ~]$ netca
Oracle Net Services Configuration:
Configuring Listener:LISTENER
Listener configuration complete.
Oracle Net Listener Startup:
Running Listener Control:
/home/oracle/oracle/product/10201/bin/lsnrctl start LISTENER
Listener Control complete.
Listener started successfully.
Oracle Net Services configuration successful. The exit code is 0
成功！
扫一扫
3万+
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
