|
|
[oracle@adrep ~]$ lsnrctl start2 k5 ?( x5 b* R* F# C% L( e/ f
% f2 H# V0 A h" @0 w5 x: e0 j$ v1 \
LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 14-SEP-2013 10:11:38
* |2 \2 Q k9 ^: `# o" d% g
1 L& k. G& O1 }1 F8 r. B* |6 u5 a
4 v0 h5 n1 S0 k4 y0 [* z+ X6 {Copyright (c) 1991, 2011, Oracle. All rights reserved. d9 Q$ f: U6 Y
+ U% m; t) M* P: Z* U; Q3 k# s4 L
0 P$ G. D3 T% i* Q5 X. z, N! ?
Starting /u01/app/oracle/product/11.2.0/dbhome_1/bin/tnslsnr: please wait...! s0 U5 [$ ]( L
2 |0 {7 ^. j% n: _8 z" u1 ^( J! N9 @( Q+ P) c6 q
TNSLSNR for Linux: Version 11.2.0.3.0 - Production1 H" [: o" S; N k3 E: ^
System parameter file is /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
8 d$ D$ p9 \' }% W' ULog messages written to /u01/app/oracle/diag/tnslsnr/adrep/listener/alert/log.xml! ^& [/ s1 U" Z! G' U( S2 ~
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=adrep)(PORT=1521)))3 `0 J4 r! S; h) q7 R; H0 m
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
$ i- d1 a ~' D' a$ ~
0 }# F, \% ?, E$ s3 K3 I v+ y, @+ P1 o# \* Q) K
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=adrep)(PORT=1521)))
8 c; y) W8 [. b* ISTATUS of the LISTENER: W, F8 G3 S+ U9 `2 S/ e
------------------------' x4 P8 m6 P. j1 b
Alias LISTENER( S( f$ d# w6 o ^
Version TNSLSNR for Linux: Version 11.2.0.3.0 - Production
% f9 d' D! q8 _5 }Start Date 14-SEP-2013 10:11:38
; f. D/ \3 h. KUptime 0 days 0 hr. 0 min. 0 sec. c `/ R( n8 b2 g( c
Trace Level off
- _1 r: X: \" ?* j' y q6 A8 T) tSecurity ON: Local OS Authentication; j- n% H) b& w4 ~
SNMP OFF& Z) k3 D( H4 ]# a6 f0 H6 b& C1 q
Listener Parameter File /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
+ B. R _$ C4 S; |9 L" A' j: TListener Log File /u01/app/oracle/diag/tnslsnr/adrep/listener/alert/log.xml0 L( S: T- \6 a' }
Listening Endpoints Summary...+ g- Q2 r% K; G( a
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=adrep)(PORT=1521)))5 |# ]3 ?5 J9 d. I
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))" n( E, @! Q0 w- P' Y* t. x
The listener supports no services1 V6 l2 x8 w8 R# T/ c
The command completed successfully
6 f) I0 r9 d5 |( P, L& Z* s" b由于这台主机之前做的是stream实验，修改了一下hostname，之前的监听和服务名也用netca重新配置过了，但是启动监听一致是这个状态，动态监听注册不上 O# ?- D4 K1 V& k# ^- N+ A/ ]
* A/ z0 E H' w0 z4 D6 [本地登录到Oracle实例，手动注册实例也无果，问题依旧
2 q) ?5 q7 e, U: D6 F2 _! T/ f+ j8 Q ]' {9 _5 D' U* a
SQL> alter system register;
y% E( a1 k1 J0 y8 h/ E {! R0 z; D1 ^$ C) y
0 Q* Q; m9 X. |4 Z N: r" KSystem altered.
: M$ ^2 z. A5 F6 Y
8 D: C& j& N( \3 M7 @" C0 m- T- s4 `4 F* {# M0 K- d$ f
SQL> !
5 N# Y# [5 i$ H3 `[oracle@adrep ~]$ lsnrctl status
7 x# ]5 ]. o1 A I0 I" \$ x: @! j& I$ W2 i6 p" n
C" W/ N u& D7 G; w; k4 ~1 ALSNRCTL for Linux: Version 11.2.0.3.0 - Production on 14-SEP-2013 10:13:03( J# N8 z: Q% V W$ K6 q# T! ]
8 J* g9 R" P& l3 B8 v
4 e/ w( Y: W, @# M% h
Copyright (c) 1991, 2011, Oracle. All rights reserved.
. i0 z* ?4 u R. b; w3 l6 S8 x5 j. U" b' t
& l( \7 |" K) T. H1 @Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=adrep)(PORT=1521))): j. Y* }7 h9 }8 z2 ]
STATUS of the LISTENER
# M. H! S$ L; Q. P* c- M------------------------
/ S$ |( N" p1 T0 w& FAlias LISTENER
# u' A: x7 K) [' WVersion TNSLSNR for Linux: Version 11.2.0.3.0 - Production7 Z8 k. s0 R1 J" j0 J- ]
Start Date 14-SEP-2013 10:11:38% Z8 q6 w; k* \. j$ ^
Uptime 0 days 0 hr. 1 min. 25 sec
" m" y/ h' ~) b. O- [* a% wTrace Level off
0 c: Z# ^& L$ a) k) z% RSecurity ON: Local OS Authentication5 n7 R- Y# E; Y, W0 H0 x
SNMP OFF# Y9 k8 f/ Y! O4 P
Listener Parameter File /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora. E+ V7 x7 t5 o3 W) \6 N
Listener Log File /u01/app/oracle/diag/tnslsnr/adrep/listener/alert/log.xml8 a# M% c7 c& d; c' ]2 j8 b
Listening Endpoints Summary..., T$ Z" ]* t/ [$ x" ^2 L) n, x
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=adrep)(PORT=1521)))
9 v/ K" L# U0 K& h& `" r/ f (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
# ?1 t1 |7 K. g& {2 pThe listener supports no services# A. {, Q/ L$ n- f* P
The command completed successfully: j d6 r1 C; H* u
) t5 N; D+ L- c( e8 X
[oracle@adrep ~]$ lsnrctl reload
' |/ R, A8 W: B$ Z- e0 ~! U; e9 L2 h Listener Log File /u01/app/
! n3 B# N% M9 t8 i5 D* D" j
% e& `6 F2 _# h$ Q/ j/ {5 C3 a: ~: o9 T1 r4 J( j- x
LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 14-SEP-2013 10:16:13
+ [% t' V, l: A6 q( c3 v- ^2 @
) [2 i' x' p9 @! n" P& I9 ~# w( h- V' b1 M' g) R" v$ m
Copyright (c) 1991, 2011, Oracle. All rights reserved.
. \3 _; k9 L6 _- l" K7 ?. T& ]
. I$ k1 J3 L) X4 c, }$ t# G6 C7 ?$ |, y0 g
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=adrep)(PORT=1521)))
% B [+ r- E O1 x9 E( G4 pThe command completed successfully6 \ R z. H* E# @# G
[oracle@adrep ~]$ lsnrctl status# F7 L/ x0 P$ `. D* w- C1 V
* q6 P/ L7 c0 [- q) T& ]# G4 k* C' k$ ^: m4 q. S
LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 14-SEP-2013 10:13:18
- ]! q% t% d% ]7 F- r8 O# {
/ X' W$ S/ b; J9 ^& x
, U/ H, z9 |: ^Copyright (c) 1991, 2011, Oracle. All rights reserved.
6 j# w& v5 r) o
, W' A; R y% w
! U- B& F* ~9 u7 A8 g! VConnecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=adrep)(PORT=1521)))
1 K9 W0 a& J7 x2 {- F) J2 ^5 {5 p6 zSTATUS of the LISTENER
9 z! a6 C8 r4 t# c$ |% a8 f------------------------7 G- [, X* b1 ~$ D# ?
Alias LISTENER
5 ?# T% p8 H' L3 {% DVersion TNSLSNR for Linux: Version 11.2.0.3.0 - Production
% f W2 }: i1 JStart Date 14-SEP-2013 10:11:38. I7 K5 G% v2 `8 Q% N- p" v
Uptime 0 days 0 hr. 1 min. 40 sec C$ W% c' F6 w- d) {% {5 v
Trace Level off9 t8 A5 E0 {) Z& Q! `' u8 g4 `
Security ON: Local OS Authentication6 R( @' w/ E+ L
SNMP OFF& {1 U5 e6 P% H7 {
Listener Parameter File /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
7 M! M- y/ e- n) ZListener Log File /u01/app/oracle/diag/tnslsnr/adrep/listener/alert/log.xml8 n) z9 Y! W8 x! i
Listening Endpoints Summary...! z, s, j+ e+ z4 D m5 G! @# |* t- T
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=adrep)(PORT=1521)))
$ }, x( R/ O4 | @% r, t (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
! X/ \- P' \" r# r4 ^The listener supports no services6 M% j/ [! g% }# s/ d/ D2 L) M
The command completed successfully
+ P/ n( i0 O1 J" b[oracle@adrep ~]$ lsnrctl stop: c2 U" t5 n7 Z% K
0 E V! V p6 x3 ?
S B: m, m! T5 B' ^7 T% s
]9 G, \$ _$ z" c/ rLSNRCTL for Linux: Version 11.2.0.3.0 - Production on 14-SEP-2013 10:17:03
8 z0 p8 h; M: l e9 c3 Z: d) c/ o" V3 a# t2 c: \ V
8 @) y" M5 Z2 q* n" U$ Y
Copyright (c) 1991, 2011, Oracle. All rights reserved.( q6 D% v( A0 O, F
! F2 ~: U4 P4 U; u* u" n
, v, y1 @* d4 n% f3 f# vConnecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=adrep)(PORT=1521)))( G# t! i' U" O4 N2 J' A
The command completed successfully' V9 J9 |& z2 V' p. N( A3 T; d, l5 \% M
5 }3 \7 ]4 S1 l$ J
[oracle@adrep ~]$ lsnrctl start, n0 p; P$ x. [* `2 L' p
5 E' R/ E# B7 k2 s% [" S
+ X4 Y; D5 t6 h' m n% _
LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 14-SEP-2013 10:18:53: L; `4 @; Z3 X( Y/ a1 |0 C: t/ |0 \
( }8 ]& h4 v8 y* b; p. R
" r# U" V/ @; W2 E% LCopyright (c) 1991, 2011, Oracle. All rights reserved.
4 r2 Q$ w/ ]/ u# V0 p" ?5 z9 x l$ D. l4 r) Z' i+ i
3 K7 x* m; L* @. @+ ]Starting /u01/app/oracle/product/11.2.0/dbhome_1/bin/tnslsnr: please wait...! J3 t; L; x7 L2 q# ~
* L5 ^( x, D N5 f
* A' a& W8 T" CTNSLSNR for Linux: Version 11.2.0.3.0 - Production( @+ q2 @+ X7 k6 E$ P) A, t5 I5 h! }
System parameter file is /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
: K1 r4 |! S* dLog messages written to /u01/app/oracle/diag/tnslsnr/adrep/listener/alert/log.xml
5 j# p6 s/ _1 A; cListening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=adrep)(PORT=1521)))
# Z3 F$ {+ J" ? n6 TListening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
( q1 |& O1 ?4 G( k R8 q# S$ r
9 b, i) A0 _0 g/ J! L) u8 w7 u% {: k8 s$ O# q3 F, i* t7 u# m: b% F
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=adrep)(PORT=1521)))
7 Y8 r6 B$ }/ L0 Q, ]STATUS of the LISTENER
, I; m3 j+ [6 x9 I( P------------------------
: _- @5 ?1 ?8 L7 q' o" u" XAlias LISTENER' {, N9 {7 q! l
Version TNSLSNR for Linux: Version 11.2.0.3.0 - Production
5 X; f4 H9 k( W W G4 G( ^5 L% KStart Date 14-SEP-2013 10:18:537 I! g" a4 B: C2 E& W# M: K I
Uptime 0 days 0 hr. 0 min. 0 sec
3 s* F1 b) |; _' p& bTrace Level off
2 Z! ?& D" ~+ a2 g' xSecurity ON: Local OS Authentication# }( O! _3 C" ^. A/ ?3 g! f0 w
SNMP OFF
5 C& F4 i( p! X5 `9 `Listener Parameter File /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora3 \# f# `3 m* k! X" B' Q# ~
Listener Log File /u01/app/oracle/diag/tnslsnr/adrep/listener/alert/log.xml
2 Z, y# g$ J% B) [Listening Endpoints Summary...
9 w+ v) I4 v3 S (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=adrep)(PORT=1521)))9 W* M6 {8 x [
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521))): F2 Q, x( o3 N0 l. L5 u. ]7 L( @
The listener supports no services. g' y" _8 u$ s/ o2 O
The command completed successfully$ ]" s: g& I6 \2 `$ U- g6 h
[oracle@adrep ~]$ & G; x5 |* {4 c% o) f# V
9 w% t6 f! t7 d/ _% s( @8 M于是考虑通过mgr配置静态监听，但是让我郁闷的是，总是提示需要输入一个合法的SID; U" v7 u% p& m! R% j
- o, V* z9 c# u2 N2 N' q4 o/ l- Y
+ a# p/ o" _/ @: c3 f/ M. n3 u1 H这个SID绝对是strmtarget没错的，global name即service name也确实是target，这个可以由以下参数获得佐证* S. H+ q4 V! B
& C" X; x: d0 u$ g1 q# R6 A
SQL> show parameter name# ?& ^" [3 m$ D9 ?8 q1 j& ] W
; P( A5 _+ z l7 ^0 H6 p( Y
. H( R8 y b- `, `9 e% D4 x, T6 W; uNAME TYPE VALUE
. I8 _& |8 o5 X4 v; C3 g; C------------------------------------ ----------- ------------------------------- E" U0 o9 ?5 q0 c( `" G3 i
db_file_name_convert string
) z% @: \3 R7 n) [; m/ d. g( Odb_name string strmtarg
, D, d: ]6 \$ E X+ _+ t0 qdb_unique_name string strmtarget# e* q# \3 Q# b% I; d
global_names boolean TRUE
- q# {4 W" ]4 Z$ s& E$ b- Cinstance_name string strmtarget, |3 ]3 ]; b* T# S, _# T# O& H
lock_name_space string2 R6 s, B0 m4 u3 D- u
log_file_name_convert string
2 U& ]9 O! r; l& `( lprocessor_group_name string/ l/ P1 \8 T; }+ R
service_names string target: o. d* t) s1 y; @
8 M0 K- g2 `+ C3 A2 k' T也可以通过v$instance视图查到SID是正确的
" e7 [& I9 x n Z; D5 H: @, n
$ m p% R+ L0 G' jSQL> select instance_name from v$instance; X" G ?% X/ r
" W- M! k3 ]' A6 k4 B3 U6 c4 [2 QINSTANCE_NAME
$ [7 S- k" d- R; Z$ w6 q! ~1 Q----------------
: Q+ C" U; e1 _+ k) Kstrmtarget
1 t1 z1 a' a+ q( G1 d& ~7 L9 E
4 z: `6 R9 s6 H, l; }0 }难道就没有办法设置静态监听了吗？NO，这里还有一种方法就是手动修改listener.ora文件，添加以下几行内容
! H# u) N7 _# @1 M% R9 H6 p
- T: w- Q& c1 @" i2 Z# TSID_LIST_LISTENER = % h( C' r1 S5 z) b
(SID_LIST =
+ I$ a" Q" }2 b4 _5 @ (SID_DESC = - m3 y. Y% m# x& }7 Q9 @, A
(GLOBAL_DBNAME = target)& u/ b( g& ^$ }0 n9 k( Z! j
(SID_NAME = strmtarget)5 r. I" J2 x6 F! v& Q- f
)
$ i% K# Z4 K+ n; D)
+ W) H2 @- l0 z' ]5 J" `# x% {; F" b# n- {' {5 l
其作用就是配置一个实例静态监听，只不过用这里跳过了图形化界面修改而已，如果是用netmgr成功修改了实例的静态监听，也是会生成以上几行代码的
9 Z) I& X/ Y9 m |) y8 c6 \& @3 I1 v0 }5 i
这里可以先把listener.ora用xftp工具拷贝出来，修改完再拷贝回相同位置即可. V- v5 }# L7 ?1 @- a9 u
& ~1 _) \3 g9 v这里只需要重新加载一次监听就可以注册上实例了
: J: W% |+ w j
9 H( [7 l' L. I[oracle@adrep ~]$ lsnrctl reload$ G* C/ d; n; `' U2 M( d5 u
0 [+ H |9 _* [5 g' w; m6 T+ _1 e$ q$ W; `" e% x/ G3 N
LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 14-SEP-2013 10:32:06; K* ?' D8 U% \
/ p& A# S0 Y, t4 N7 G
6 q/ [ \# e8 DCopyright (c) 1991, 2011, Oracle. All rights reserved.( I0 g% T1 l& r
. c' ^. y8 q1 T; g2 h1 x
5 H: Z7 v- d, e% bConnecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=adrep)(PORT=1521)))
1 u2 N* l ~4 ?. zThe command completed successfully, I, _2 k* _2 q; V. c
[oracle@adrep ~]$ lsnrctl status# F* |* Y6 r7 p+ G- L( P
5 _% F; m y: W/ u( o5 M0 Y6 @2 r3 ]* n
LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 14-SEP-2013 10:32:14) f& @) P/ \: P. T% ^3 |% q3 W
% f n$ t6 K1 E* ]0 r0 f! [( p! ?8 K( _
& N: P# m1 c& a( Y- a* e6 e* r
Copyright (c) 1991, 2011, Oracle. All rights reserved.( ]- d! o& F4 G& q G
: R* U/ U8 |8 O2 Q
1 M2 i/ C/ `# K" l/ D8 @9 ~( [
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=adrep)(PORT=1521)))
7 {- B0 l4 c. w' j2 k8 aSTATUS of the LISTENER
& t# z# o( q# \$ _/ ]7 O4 T------------------------
3 A' W+ K" q; E2 M, s3 nAlias LISTENER, \4 {$ C' e0 K( D8 F4 z0 B
Version TNSLSNR for Linux: Version 11.2.0.3.0 - Production
! m$ y6 Q+ k% F! GStart Date 14-SEP-2013 10:18:53' p1 R& ]; n$ `( l" [
Uptime 0 days 0 hr. 13 min. 21 sec1 D9 t7 y% n$ X# }6 ]$ u; C. r
Trace Level off3 ^1 Z; N9 C1 U2 Y+ D
Security ON: Local OS Authentication
* V+ q* Y+ s; XSNMP OFF
$ u; y: {; }" j# F {7 CListener Parameter File /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora. x# o8 }( J3 A0 L
Listener Log File /u01/app/oracle/diag/tnslsnr/adrep/listener/alert/log.xml
2 F$ }, \4 r0 f+ v1 t# \Listening Endpoints Summary...- s2 c7 C6 f2 P/ r5 e
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=adrep)(PORT=1521)))
% T: v0 x# M2 I; a, ~6 o( ~ (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
S7 Z" y9 v7 Z6 H9 h5 |7 |Services Summary...
& ]5 `! r" k3 l) |7 X' F \2 W& t0 ?Service "target" has 1 instance(s).. o# F C+ n# C- n/ p% n! U
Instance "strmtarget", status UNKNOWN, has 1 handler(s) for this service...7 ?4 p! C( f1 A: ^
The command completed successfully
" c" r0 K# T/ y0 A$ p2 o[oracle@adrep ~]$ # [1 ?! r& J3 `' ]$ R6 E K
- M) |+ `; H8 w; c! |
这里target实例通过以上方法，成功地把实例注册上了，注意"UNKNOWN"就表示是静态注册的，如果是"READY"则表示是动态注册的
/ x4 E- @: ^4 g" I. G
* Y! Z: N/ J" w! u注意：动态和静态监听可以共存，如：
( E( m5 t& o9 @3 Y9 w4 S8 z$ Q- r! l
[oracle@zlm ~]$ lsnrctl status
8 {4 z! I1 y+ Q" Z' P* T) e/ X
8 u: K E$ X( Q/ P' a# b
; L/ I$ }8 o% g9 A& _9 @& _4 [LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 14-SEP-2013 09:52:23
- ]5 P% m+ f4 C3 f' Y$ f6 ^ X( E9 d( a2 R% a
$ @, N$ e" d$ @2 u" P5 O9 LCopyright (c) 1991, 2011, Oracle. All rights reserved.
R/ j8 b' J. X- U# d6 u8 j0 G: ^# x1 A+ S9 y
/ V- Y( d+ H) X
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=zlm)(PORT=1521))), o0 e' A* D* {
STATUS of the LISTENER
5 s0 S, X# B" |1 j( o------------------------+ V/ S, g# E: }+ f- P! k u
Alias LISTENER1 z1 @0 R+ y( W2 ?/ n: I5 b2 d
Version TNSLSNR for Linux: Version 11.2.0.3.0 - Production
, b! j# N2 W7 }- KStart Date 14-SEP-2013 09:15:04
( p2 x( w4 H3 \% [" \. ?Uptime 0 days 0 hr. 37 min. 19 sec, X7 x1 O& p6 L2 e5 e
Trace Level off u& E/ E! Q- w4 t
Security ON: Local OS Authentication; Q$ K- D) r$ x6 e$ z8 g6 p
SNMP OFF
& y* N6 Z- d3 J% Y8 Z! qListener Parameter File /u01/app/oracle/product/11.2.0/db_1/network/admin/listener.ora- T7 A4 ^) `- q6 D( w1 S0 @
Listener Log File /u01/app/oracle/diag/tnslsnr/zlm/listener/alert/log.xml4 @! O: M4 o4 Z$ l
Listening Endpoints Summary.... v% g& n, `* M5 d }
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=zlm)(PORT=1521)))
3 l$ m6 ^0 D: |* R5 t9 X (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521))). N( {6 n1 x3 T& k; \
Services Summary...) [1 W( u: L8 e k
Service "zlm11g" has 2 instance(s).
6 V/ q" ~! q) h Instance "zlm11g", status UNKNOWN, has 1 handler(s) for this service...
, T9 Z1 D8 Q2 k+ ?- _6 U. f- P Instance "zlm11g", status READY, has 1 handler(s) for this service.../ R7 k3 f: _ O6 U
Service "zlm11gXDB" has 1 instance(s).
\! f: g6 v! \5 I# J Instance "zlm11g", status READY, has 1 handler(s) for this service...2 ?0 s1 N$ s5 w4 f* [. U$ z. Q( |
The command completed successfully2 Z' R( Z9 D+ l# d F% C3 z
[oracle@zlm ~]$
h0 Z$ d" w3 b+ J: g" e; k8 B
* p# O1 c1 c! |) x9 ~* |( B; |8 I以上是我在zlm主机上的监听状态，可以发现，同时配置了动态和静态的监听$ K& @+ K) h, \" P6 C6 `- B9 y
9 z3 y$ q! u; J' e! n9 ^2 o总结：以上利用了手动修改配置静态监听的方法成功注册了Oracle实例，动态监听往往需要等实例启动后，过一段时间才会注册上，而静态监听则可以马上注册。而且一旦实例重启会造成动态监听暂时无效，有些版本的bug甚至会导致动态监听的注册就再也起不来了。所以我对于监听的观点是，尽量配置静态监听，这样就可以避免很多由监听带来的问题，诸如我们经常会碰到的几个ora error：ora-12541、ora-12514、ora-12154等，尤其是在RAC和DG中，一个监听的问题，往往会带来很大的麻烦，尤其需要引起大家的注意。
, L5 v( Q/ V" P' O$ H o* l |
|
发表于 2018-10-13 13:26:58