虚拟机centos7中刚装了oracle11g,没重启前一切正常
重启后发现客户端无法连接到数据库了
SQL*Plus: Release 11.2.0.1.0 Production on 星期五 11月 16 15:05:18 2018 Copyright (c) 1982, 2010, Oracle. All rights reserved. 请输入用户名: system@orcl 输入口令: ERROR: ORA-12541: TNS: 无监听程序
登陆服务器看一下监听状态
[root@lzr ~]# lsnrctl status LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 16-NOV-2018 15:07:55 Copyright (c) 1991, 2009, Oracle. All rights reserved. Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521))) STATUS of the LISTENER ------------------------ Alias LISTENER Version TNSLSNR for Linux: Version 11.2.0.1.0 - Production Start Date 16-NOV-2018 15:00:14 Uptime 0 days 0 hr. 7 min. 45 sec Trace Level off Security ON: Local OS Authentication SNMP OFF Listener Parameter File /data/oracle/product/11.2.0/db_1/network/admin/listener.ora Listener Log File /data/oracle/diag/tnslsnr/lzr/listener/alert/log.xml Listening Endpoints Summary... (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1521))) Services Summary... Service "ORCL" has 1 instance(s). Instance "ORCL", status UNKNOWN, has 1 handler(s) for this service... The command completed successfully
实例ORCL状态为UNKNOWN,有点不太懂了,百度了一下之后
发现可能是hostname出现了问题
我在重启之前用命令
#hostnamectl set-hostname lzr
修改过hostname
先打开/etc/hosts检查一下
[root@lzr ~]# vi /etc/hosts 127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4 ::1 localhost localhost.localdomain localhost6 localhost6.localdomain6
添加新的一行
[root@lzr ~]# vi /etc/hosts 127.0.0.1 lzr 127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4 ::1 localhost localhost.localdomain localhost6 localhost6.localdomain6
然后wq保存退出
现在我将数据库重启
[root@lzr ~]# sqlplus SQL*Plus: Release 11.2.0.1.0 Production on Fri Nov 16 15:25:52 2018 Copyright (c) 1982, 2009, Oracle. All rights reserved. Enter user-name: sys as sysdba Enter password: Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options SQL> shutdown immediate Database closed. Database dismounted. ORACLE instance shut down. SQL> startup ORACLE instance started. Total System Global Area 1185853440 bytes Fixed Size 2212776 bytes Variable Size 738200664 bytes Database Buffers 436207616 bytes Redo Buffers 9232384 bytes Database mounted. Database opened.
再将监听重启,查看状态
[root@lzr ~]# lsnrctl LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 16-NOV-2018 15:31:17 Copyright (c) 1991, 2009, Oracle. All rights reserved. Welcome to LSNRCTL, type "help" for information. LSNRCTL> stop Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521))) The command completed successfully LSNRCTL> start Starting /data/oracle/product/11.2.0/db_1/bin/tnslsnr: please wait... TNSLSNR for Linux: Version 11.2.0.1.0 - Production System parameter file is /data/oracle/product/11.2.0/db_1/network/admin/listener.ora Log messages written to /data/oracle/diag/tnslsnr/lzr/listener/alert/log.xml Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=lzr)(PORT=1521))) Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521))) STATUS of the LISTENER ------------------------ Alias LISTENER Version TNSLSNR for Linux: Version 11.2.0.1.0 - Production Start Date 16-NOV-2018 15:31:21 Uptime 0 days 0 hr. 0 min. 5 sec Trace Level off Security ON: Local OS Authentication SNMP OFF Listener Parameter File /data/oracle/product/11.2.0/db_1/network/admin/listener.ora Listener Log File /data/oracle/diag/tnslsnr/lzr/listener/alert/log.xml Listening Endpoints Summary... (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=lzr)(PORT=1521))) Services Summary... Service "ORCL" has 1 instance(s). Instance "ORCL", status UNKNOWN, has 1 handler(s) for this service... The command completed successfully LSNRCTL> status Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521))) STATUS of the LISTENER ------------------------ Alias LISTENER Version TNSLSNR for Linux: Version 11.2.0.1.0 - Production Start Date 16-NOV-2018 15:31:21 Uptime 0 days 0 hr. 0 min. 8 sec Trace Level off Security ON: Local OS Authentication SNMP OFF Listener Parameter File /data/oracle/product/11.2.0/db_1/network/admin/listener.ora Listener Log File /data/oracle/diag/tnslsnr/lzr/listener/alert/log.xml Listening Endpoints Summary... (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=lzr)(PORT=1521))) Services Summary... Service "ORCL" has 1 instance(s). Instance "ORCL", status UNKNOWN, has 1 handler(s) for this service... The command completed successfully
好像和之前没有什么变化
去数据库中注册一下监听
[root@lzr ~]# sqlplus SQL*Plus: Release 11.2.0.1.0 Production on Fri Nov 16 15:32:54 2018 Copyright (c) 1982, 2009, Oracle. All rights reserved. Enter user-name: sys as sysdba Enter password: Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options SQL> alter system register 2 ; System altered.
再出来查看一下监听状态
[root@lzr ~]# lsnrctl LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 16-NOV-2018 15:33:35 Copyright (c) 1991, 2009, Oracle. All rights reserved. Welcome to LSNRCTL, type "help" for information. LSNRCTL> status Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521))) STATUS of the LISTENER ------------------------ Alias LISTENER Version TNSLSNR for Linux: Version 11.2.0.1.0 - Production Start Date 16-NOV-2018 15:31:21 Uptime 0 days 0 hr. 2 min. 15 sec Trace Level off Security ON: Local OS Authentication SNMP OFF Listener Parameter File /data/oracle/product/11.2.0/db_1/network/admin/listener.ora Listener Log File /data/oracle/diag/tnslsnr/lzr/listener/alert/log.xml Listening Endpoints Summary... (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=lzr)(PORT=1521))) Services Summary... Service "ORCL" has 2 instance(s). Instance "ORCL", status UNKNOWN, has 1 handler(s) for this service... Instance "orcl", status READY, has 1 handler(s) for this service... Service "orclXDB" has 1 instance(s). Instance "orcl", status READY, has 1 handler(s) for this service... The command completed successfully
看上去正常了,status ready
现在回到客户端中测试一下连接
C:\Users\lzr>sqlplus SQL*Plus: Release 11.2.0.1.0 Production on 星期五 11月 16 15:34:10 2018 Copyright (c) 1982, 2010, Oracle. All rights reserved. 请输入用户名: system@orcl 输入口令: 连接到: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options SQL> show user USER 为 "SYSTEM"
可以正常使用客户端连接了
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/31060213/viewspace-2220380/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/31060213/viewspace-2220380/