找回密码
 注册
查看: 4541|回复: 3

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

[复制链接]

1

主题

0

回帖

12

积分

管理员

积分
12
QQ
发表于 2018-10-13 11:52:29 | 显示全部楼层 |阅读模式
Listener failed to start. See the error message(s) above/ d6 r3 G/ f/ I; M( j
2 b/ N" U1 e1 A  d
检查监听程序的配置文件内容
; I& }  I+ ?: W& W2 e  x$ `cat /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
1 t' c: M0 _# }% Q  o- M( |9 k# listener.ora Network Configuration File: /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora# T  _- `1 u6 f; n/ }- g( H
# Generated by Oracle configuration tools.
2 z! \3 a2 _( c1 x" [
( d) Q, b2 u* D+ }LISTENER =
& x) q% E" L, E  y( b8 \/ r1 N) p2 j  (DESCRIPTION_LIST =
: C: u! E) U5 }: b. @8 I3 A    (DESCRIPTION =" p, o: l$ y; A; S
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
9 e5 O' I0 ^1 C' v% q5 S      (ADDRESS = (PROTOCOL = TCP)(PORT = 1521))6 U+ C8 A  ~/ N2 `8 s
    )+ E% P1 r( F5 q
  )
5 @% U& ~0 N1 S. M4 }2 k
- F* M, }! ]9 E! E+ |ADR_BASE_LISTENER = /u01/app/oracle2 |- U  ^0 o  [! I" L% Z4 i6 v

% ]; Z+ N- v4 c0 N1 g4 _1 ]
- ]4 z# V/ L; J检查监听日志:4 n9 e& |- E9 B( N2 b% U! C/ F- V
[oracle@oracle alert]$ cd /u01/app/oracle/product/11.2.0/dbhome_1/network/log/. K# h1 h. F( I- V6 K- {
[oracle@oracle log]$ ls$ j/ Z% z" J1 m7 G& k4 l/ K8 D  y7 k
[oracle@oracle log]$
8 A# `0 ^" e; a' h2 d# M4 B6 \! x/ q/ K( _
% D# Z3 W  R5 w1 x; F" m! h" ?% }
没日志,尴尬了
* B1 p1 e0 h9 V" _. d! e
% Q5 K& o2 A- y4 \

查看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 让刚才修改的内容生效

1

主题

0

回帖

12

积分

管理员

积分
12
QQ
 楼主| 发表于 2018-10-13 12:11:31 | 显示全部楼层
$ lsnrctl start8 F- W3 w% v1 ]/ m- `" f" a8 x) c
1 A- [/ u, K+ u9 G  ^/ M
LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 13-OCT-2018 12:08:38
' p: Y  R. _: g4 O7 G( b% B0 a8 S4 F* P: q
Copyright (c) 1991, 2009, Oracle.  All rights reserved.
% G" L) A- ?6 J) c. r' h, A8 I- Q% [* a
Starting /u01/app/oracle/product/11.2.0/dbhome_1/bin/tnslsnr: please wait...
0 M1 t  B1 u6 y" R, A& j* g3 {& b; f  V8 P" {0 _$ {1 L' E
TNSLSNR for Linux: Version 11.2.0.1.0 - Production
, z8 s0 i- S8 i% }System parameter file is /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora, k8 p! y' B3 H" Q: u0 p& G
Log messages written to /u01/app/oracle/diag/tnslsnr/oracle/listener/alert/log.xml  e' W. f# ^3 L; \
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))1 @( I' m8 _. z8 r# I: ]
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=oracle.domain.com)(PORT=1521)))
% _8 o4 e# k) m% [
- ^2 m- C) k3 N$ C. KConnecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))1 G3 X) ?& q, p" F
STATUS of the LISTENER
& a; |; t1 K% K------------------------6 }/ }, u9 ]* [
Alias                     LISTENER
0 o/ G' w! i; WVersion                   TNSLSNR for Linux: Version 11.2.0.1.0 - Production6 ^! B2 y$ L8 Z3 f! x
Start Date                13-OCT-2018 12:08:42! Y0 P# c# i7 h
Uptime                    0 days 0 hr. 0 min. 2 sec: v7 [" k) Q8 M2 B
Trace Level               off" L9 I; R; g) G$ L  X+ k
Security                  ON: Local OS Authentication, J( @' D; t( {7 L8 O
SNMP                      OFF! M/ I3 B- _) X! g, A2 z& x
Listener Parameter File   /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora9 M8 Y3 u& f; S( d6 V( Y
Listener Log File         /u01/app/oracle/diag/tnslsnr/oracle/listener/alert/log.xml" n- H0 s# M; \2 K& G; V
Listening Endpoints Summary...! v8 J$ G- J! E1 k" ?
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))  o4 ^' ]5 W( z) \  a1 E
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=oracle.domain.com)(PORT=1521)))* J/ R" T- D3 V1 @& M% h
The listener supports no services
! m- W9 u8 I9 u. v; Y1 i$ IThe command completed successfully

1

主题

0

回帖

12

积分

管理员

积分
12
QQ
 楼主| 发表于 2018-10-13 12:18:01 | 显示全部楼层
vim .bash_profile $ o1 }7 K/ X( K- \
^[[B^[[B^[[B[oracle@oracle ~]$ vim .bash_profile
% ^9 M4 Q$ [' q; {. U1 t0 H9 Y. D: L+ H4 ~
ORACLE_BASE=/u01/app/oracle
: Z" C0 \# j: qORACLE_HOME=$ORACLE_BASE/product/11.2.0/dbhome_1
9 M# B& ^7 N, {+ jORACLE_HOME_LISTNER=$ORACLE_BASE/product/11.2.0/dbhome_10 g7 Y; B6 c, S* _
ORACLE_SID=clouddb0 H7 g3 b" w- C4 Q& a! L2 e
PATH=$ORACLE_HOME/bin:$PATH; Q: V  M1 K$ {7 {) S% E+ Y6 J- s9 p
export ORACLE_BASE ORACLE_HOME ORACLE_HOME_LISTNER ORACLE_SID PATH
, x' p: p3 ^0 z) [6 u6 M9 H2 iORACLE_TERM=xterm
  d2 V- E( c- c0 \export ORACLE_TERM! c! Q( R/ g9 G, z, {
TNS_ADMIN=$ORACLE_HOME/network/admin
0 M' u3 |# l8 Jexport TNS_ADMIN1 G7 H# y% u$ ^" G  F
#set the user languages" x: t3 c% v% `, ^
#NLS_LANG="SIMPLIFIED CHINESE_CHINA".GBK  R) ?' I$ s$ k0 l  n. n  ]
#LC_CTYPE=zh_CN.GBK
' o9 F8 L5 G* V7 _#LC_ALL=zh_CN.UTF8
8 e$ |3 g/ \+ M#LANG=zh_CN.GBK
$ p/ @5 V( b4 }1 S0 xLD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib
  @+ V. ?. Y  UCLASSPATH=$ORACLE_HOME/jdk/jre:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib
" [2 m6 A2 M) x+ P& j1 oexport NLS_LANG LC_CTYPE LC_ALL LANG LD_LIBRARY_PATH CLASSPATH  D8 L/ r# r# `
umask 022

1

主题

0

回帖

12

积分

管理员

积分
12
QQ
 楼主| 发表于 2018-10-13 12:34:57 | 显示全部楼层
添加文件' ?0 n2 V3 O' ~! J+ G  F
执行添加加密的建立password文件
% ]' I+ \6 u. _' T9 h1 D( g; ?8 k7 O8 Y* Z
[oracle@dd ~]$orapwd file=/app/oracle/product/10.2.0/dbs/orapwprice.ora password=111111 entries=10 force=y
  `5 K' U; |1 a因为是linux所以文件明是orapw+实例.ora
5 O! m; b; w% ^9 p* ?* Awindow是pwd+实例.ora 
6 ~. k' x) L; @  }
您需要登录后才可以回帖 登录 | 注册

本版积分规则

返回首页|Archiver|手机版|小黑屋|易陆发现技术论坛 ( 蜀ICP备2026014127号-1 )

GMT+8, 2026-6-12 00:11 , Processed in 0.041258 second(s), 21 queries .

Powered by Discuz! X5.0

© 2001-2026 Discuz! Team.

快速回复 返回顶部 返回列表