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

admin

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

& g2 l4 L4 s+ O: k  L检查监听程序的配置文件内容
  t$ F  w) v+ Lcat /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
# \( \+ |& F: |* h+ @+ C# listener.ora Network Configuration File: /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
* v/ {' w; G; i! g( E# Generated by Oracle configuration tools.
+ u) d, T1 a. z5 H" U& F
LISTENER =
( K- }, B8 ]/ B8 ?8 Z* l  (DESCRIPTION_LIST =
    (DESCRIPTION =
' t* _1 i* d" o2 F      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
      (ADDRESS = (PROTOCOL = TCP)(PORT = 1521))
) V, b6 G" a$ }' F" [    )
& V. g5 R8 c! ?2 t8 n  )
1 c* D. W  C6 R* l2 l+ S
9 [* z1 s+ N' JADR_BASE_LISTENER = /u01/app/oracle


% T. w# J8 f2 r检查监听日志：
[oracle@oracle alert]$ cd /u01/app/oracle/product/11.2.0/dbhome_1/network/log/
[oracle@oracle log]$ ls
[oracle@oracle log]$
) Q0 `: A& ]8 C( @/ G

没日志，尴尬了

8 o- Q/ L9 L3 w: K0 f

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

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

0 D9 \5 P5 J7 j6 ICopyright (c) 1991, 2009, Oracle.  All rights reserved.

( _. u5 n# ~5 \: f9 y5 ], SStarting /u01/app/oracle/product/11.2.0/dbhome_1/bin/tnslsnr: please wait...
* L. t3 O3 F4 j3 o
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
+ @) g  h1 u. v( VLog 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)))
& E% c+ a) O- p% h
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
% F) w/ J1 }$ A7 _6 m  M- E9 l3 USTATUS of the LISTENER
  _, W; f+ @  Q5 b- {" Z------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 11.2.0.1.0 - Production
+ l2 ?) ^( |! _2 Q7 C3 Y# PStart Date                13-OCT-2018 12:08:42
) O: D7 N& F  s/ {- t7 VUptime                    0 days 0 hr. 0 min. 2 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
+ U. \; A. L! x; T1 u/ A. LListener Parameter File   /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
) R2 U% ]& K* F+ d  [6 h) }" xListener Log File         /u01/app/oracle/diag/tnslsnr/oracle/listener/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
$ L! F2 r. C! v! o, k# Q  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=oracle.domain.com)(PORT=1521)))
The listener supports no services
The command completed successfully

admin

vim .bash_profile
% r, w% a! x* G4 z6 j^[[B^[[B^[[B[oracle@oracle ~]$ vim .bash_profile
+ M/ p# j) @& H6 h/ o
ORACLE_BASE=/u01/app/oracle
% a0 ~0 Y  B8 K2 H. Z* V; IORACLE_HOME=$ORACLE_BASE/product/11.2.0/dbhome_1
" j: l- H7 `% U& ?ORACLE_HOME_LISTNER=$ORACLE_BASE/product/11.2.0/dbhome_1
ORACLE_SID=clouddb
- X9 H; R2 v+ q1 l6 zPATH=$ORACLE_HOME/bin:$PATH
2 L, M  Z) J" @8 w  I  hexport ORACLE_BASE ORACLE_HOME ORACLE_HOME_LISTNER ORACLE_SID PATH
ORACLE_TERM=xterm
' T0 z6 l  o6 c, Nexport ORACLE_TERM
. J( R+ k! k* OTNS_ADMIN=$ORACLE_HOME/network/admin
export TNS_ADMIN
% X( D0 t: ]" f, u' b+ P" U#set the user languages
#NLS_LANG="SIMPLIFIED CHINESE_CHINA".GBK
  H/ O  @2 E, g9 T* |; y. G#LC_CTYPE=zh_CN.GBK
) A2 F& X2 Z6 y) w6 W! k4 N#LC_ALL=zh_CN.UTF8
6 Q" \% e3 {8 _( O$ a+ K. G  x9 X#LANG=zh_CN.GBK
# ~" G1 D# J% u- V2 nLD_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
* `; ^. G; U; eumask 022

admin

添加文件
; ^5 I+ D- U) n执行添加加密的建立password文件
/ x2 I3 v' h8 a- @/ f) A
; u8 H  A4 _# k5 _% l( A[oracle@dd ~]$orapwd file=/app/oracle/product/10.2.0/dbs/orapwprice.ora password=111111 entries=10 force=y
& p( r! L9 I8 s& C& }7 \因为是linux所以文件明是orapw+实例.ora
2 E/ }+ M2 x: J4 b1 K0 ]window是pwd+实例.ora 
: w% i# N7 m+ I