oracle Listener failed to start. See the error message(s) above

admin · 发表于 2018-10-13 11:52:29

Listener failed to start. See the error message(s) above

检查监听程序的配置文件内容
cat /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
# listener.ora Network Configuration File: /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
# Generated by Oracle configuration tools.

LISTENER =
  (DESCRIPTION_LIST =
(DESCRIPTION =
   (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
   (ADDRESS = (PROTOCOL = TCP)(PORT = 1521))
)
  )

ADR_BASE_LISTENER = /u01/app/oracle

检查监听日志：
[oracle@oracle alert]$ cd /u01/app/oracle/product/11.2.0/dbhome_1/network/log/
[oracle@oracle log]$ ls
[oracle@oracle log]$

没日志，尴尬了

查看PATH

[oracle@pro ~]$ echo $PATH

/usr/kerberos/bin:/usr/local/bin:/bin:/usr/bin:/usr/X11R6/bin:/opt//bin:/sbin/ifconfig:/opt/oracle/product/10.2.0/bin:/opt//bin:/opt//bin:/opt/oracle/product/10.2.0/bin:/opt//bin

[oracle@pro ~]$

发现没有/sbin 于是在.bash_profile 文件添加 /sbin

PATH=$PATH:$HOME/bin:/sbin

执行source .bash_profile 让刚才修改的内容生效

admin · 发表于 2018-10-13 12:11:31

$ lsnrctl start

LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 13-OCT-2018 12:08:38

Copyright (c) 1991, 2009, Oracle.  All rights reserved.

Starting /u01/app/oracle/product/11.2.0/dbhome_1/bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 11.2.0.1.0 - Production
System parameter file is /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
Log messages written to /u01/app/oracle/diag/tnslsnr/oracle/listener/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=oracle.domain.com)(PORT=1521)))

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
STATUS of the LISTENER
------------------------
Alias                   LISTENER
Version                TNSLSNR for Linux: Version 11.2.0.1.0 - Production
Start Date             13-OCT-2018 12:08:42
Uptime                   0 days 0 hr. 0 min. 2 sec
Trace Level             off
Security                ON: Local OS Authentication
SNMP                   OFF
Listener Parameter File /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
Listener Log File       /u01/app/oracle/diag/tnslsnr/oracle/listener/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=oracle.domain.com)(PORT=1521)))
The listener supports no services
The command completed successfully

admin · 发表于 2018-10-13 12:18:01

vim .bash_profile
^[[B^[[B^[[B[oracle@oracle ~]$ vim .bash_profile

ORACLE_BASE=/u01/app/oracle
ORACLE_HOME=$ORACLE_BASE/product/11.2.0/dbhome_1
ORACLE_HOME_LISTNER=$ORACLE_BASE/product/11.2.0/dbhome_1
ORACLE_SID=clouddb
PATH=$ORACLE_HOME/bin:$PATH
export ORACLE_BASE ORACLE_HOME ORACLE_HOME_LISTNER ORACLE_SID PATH
ORACLE_TERM=xterm
export ORACLE_TERM
TNS_ADMIN=$ORACLE_HOME/network/admin
export TNS_ADMIN
#set the user languages
#NLS_LANG="SIMPLIFIED CHINESE_CHINA".GBK
#LC_CTYPE=zh_CN.GBK
#LC_ALL=zh_CN.UTF8
#LANG=zh_CN.GBK
LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib
CLASSPATH=$ORACLE_HOME/jdk/jre:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib
export NLS_LANG LC_CTYPE LC_ALL LANG LD_LIBRARY_PATH CLASSPATH
umask 022

admin · 发表于 2018-10-13 12:34:57

添加文件
执行添加加密的建立password文件

[oracle@dd ~]$orapwd file=/app/oracle/product/10.2.0/dbs/orapwprice.ora password=111111 entries=10 force=y
因为是linux所以文件明是orapw+实例.ora
window是pwd+实例.ora

		自动登录	找回密码
密码			注册

oracle Listener failed to start. See the error message(s) above

浏览过的版块