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

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

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


检查监听日志:
$ cd /u01/app/oracle/product/11.2.0/dbhome_1/network/log/
$ ls
$


没日志,尴尬了

查看PATH$ 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$发现没有/sbin 于是在.bash_profile 文件添加 /sbinPATH=$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
^[$ 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文件

$orapwd file=/app/oracle/product/10.2.0/dbs/orapwprice.ora password=111111 entries=10 force=y
因为是linux所以文件明是orapw+实例.ora
window是pwd+实例.ora 
页: [1]
查看完整版本: oracle Listener failed to start. See the error message(s) above