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

admin

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

3 `1 @5 z4 e* v5 C检查监听程序的配置文件内容
1 A/ m1 Q' x" |/ s3 ]% Xcat /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.
/ L! ^3 w5 z! N6 I: W7 f- e
LISTENER =
  v5 g0 z/ m1 G& i  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
      (ADDRESS = (PROTOCOL = TCP)(PORT = 1521))
    )
( h6 v) ?: @9 B/ T  )
- [9 ~- x& B2 |; ^3 x2 x' ]
ADR_BASE_LISTENER = /u01/app/oracle


4 r1 G) V# [9 G- T/ G! f5 Q检查监听日志：
[oracle@oracle alert]$ cd /u01/app/oracle/product/11.2.0/dbhome_1/network/log/
  e# e2 v% M  K: S0 T[oracle@oracle log]$ ls
[oracle@oracle log]$
$ `4 D, Z$ l9 D
3 k! M- m: x% P! E: f5 c
没日志，尴尬了

' r4 _% e  x, M; `% D2 E

查看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

$ lsnrctl start
2 `. \$ I& {$ q  v5 A. F
9 P) B1 N4 _( sLSNRCTL for Linux: Version 11.2.0.1.0 - Production on 13-OCT-2018 12:08:38

" z' j4 P( X' D+ X- `Copyright (c) 1991, 2009, Oracle.  All rights reserved.
9 }+ d; }% @4 a
Starting /u01/app/oracle/product/11.2.0/dbhome_1/bin/tnslsnr: please wait...
" e- F, k8 c2 n7 c8 K5 ~  `
TNSLSNR for Linux: Version 11.2.0.1.0 - Production
6 r, K- w( l; B) [5 TSystem 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
& _* Q3 `+ F! |% H0 eListening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
+ x: ^0 n- H8 _7 v9 C2 f% o1 VListening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=oracle.domain.com)(PORT=1521)))
. b7 g2 w( M. I# j; l* _
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
- S- M' E( N/ S/ j& R1 P. \! bSTATUS of the LISTENER
1 B7 r9 n' d: h6 o/ ~1 t7 F# }% f) F( F------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 11.2.0.1.0 - Production
: A6 O" J  h, `* g2 [% N, S0 vStart Date                13-OCT-2018 12:08:42
) \$ |) P! c; ^; {* k1 zUptime                    0 days 0 hr. 0 min. 2 sec
9 V4 o" v4 z- v/ W5 h" OTrace Level               off
- c8 @! U+ r3 P( D5 OSecurity                  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
9 E9 i5 m0 D& |% S$ I! yListening Endpoints Summary...
& h( T' U! a6 v$ A6 d  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=oracle.domain.com)(PORT=1521)))
% N$ g( Y' s2 GThe listener supports no services
The command completed successfully

admin

vim .bash_profile
) @* D7 h+ @$ p' y^[[B^[[B^[[B[oracle@oracle ~]$ vim .bash_profile
7 }' {6 c$ B7 q
) Q$ v, m$ X, u9 d1 S: VORACLE_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
; N  x- F, }7 a3 q& j: {3 O7 ^( W#LC_CTYPE=zh_CN.GBK
#LC_ALL=zh_CN.UTF8
9 P- [4 e+ C% ^7 _#LANG=zh_CN.GBK
: q5 k# t+ d( s- S! @( b& l. CLD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib
CLASSPATH=$ORACLE_HOME/jdk/jre:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib
! s9 G2 V8 t" rexport NLS_LANG LC_CTYPE LC_ALL LANG LD_LIBRARY_PATH CLASSPATH
2 y: D% d% B* J; [7 B0 I) H. Wumask 022

admin

添加文件
执行添加加密的建立password文件
3 |* t! l, z! J. Q. e
- u) R% P+ Q9 ]2 p5 c  b9 h[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 
9 U3 V# ~" y0 N# b; H