|
|
[oracle@adrep ~]$ lsnrctl start
% G4 F1 a' P* n2 s
/ Z9 M! { q. ^* H
( \; y& Y$ X' u( }/ ?0 `" bLSNRCTL for Linux: Version 11.2.0.3.0 - Production on 14-SEP-2013 10:11:38
3 K# k9 f' C) N# }
7 a4 g( B2 y/ R0 v
f3 O8 R! _( N1 BCopyright (c) 1991, 2011, Oracle. All rights reserved.
3 f5 x2 R2 U4 ~6 F- S7 N/ g! q7 F2 o; ^0 \. d9 W/ L
$ B* W) y, r- v( z' uStarting /u01/app/oracle/product/11.2.0/dbhome_1/bin/tnslsnr: please wait...+ _1 x l1 _2 k' o, V0 a$ d9 ^" P0 [
d% ` e: L& u: Y# w# o E4 V1 ^* i) V& }% ?
TNSLSNR for Linux: Version 11.2.0.3.0 - Production
- ]6 }$ o: ]& U* O* {) FSystem parameter file is /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora( |+ @ f. ~# l1 c: V# |0 l3 [) i
Log messages written to /u01/app/oracle/diag/tnslsnr/adrep/listener/alert/log.xml* @! k, O' U) A N1 B
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=adrep)(PORT=1521)))7 \" a- o6 Q. C; l2 J
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))* p4 B/ R+ l! G5 X1 ?
6 g/ `; Q. Z' U3 x( z
- @# g* N/ H6 u3 x4 i0 \0 m. pConnecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=adrep)(PORT=1521)))
( G4 z+ y# _6 d+ OSTATUS of the LISTENER& m& r* A9 a) ?) |2 W0 ^
------------------------
: [) B! `! C( {Alias LISTENER
D Y) F9 |( K9 T( vVersion TNSLSNR for Linux: Version 11.2.0.3.0 - Production8 q' L$ m5 `% E. j6 B4 F
Start Date 14-SEP-2013 10:11:38* ]' C n' n. C/ B, _3 y# t. O* ]
Uptime 0 days 0 hr. 0 min. 0 sec
! b" u4 u" ]5 i3 LTrace Level off. V4 X! r" l9 S8 h3 V+ u( _
Security ON: Local OS Authentication
- f. I' P0 c* ~0 oSNMP OFF
0 U8 n1 B% Y5 _$ m* PListener Parameter File /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
. _1 l8 I. Z4 F) YListener Log File /u01/app/oracle/diag/tnslsnr/adrep/listener/alert/log.xml. e0 V$ r% n! \* ~
Listening Endpoints Summary...4 U! q2 l: Y5 {# m: ^* N
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=adrep)(PORT=1521)))9 A9 P$ o" v, J3 |
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))( p" _6 U2 H- y* F
The listener supports no services7 d1 q2 M8 }: R5 v* v- o% R
The command completed successfully
; ^) E8 _* o* k) s由于这台主机之前做的是stream实验，修改了一下hostname，之前的监听和服务名也用netca重新配置过了，但是启动监听一致是这个状态，动态监听注册不上) { }: M9 E! Y4 q- g
4 a6 i& W% g$ b( T' M S本地登录到Oracle实例，手动注册实例也无果，问题依旧
. ~, w% u) V: \. N1 D. z. Q8 i
6 Y `5 i* P" Z: {SQL> alter system register;' i; n' W# E% }5 }: ]4 F
( P# ^! T [3 _: p$ Q w* p( f
' J' U3 ]- G" h% A5 H& U% gSystem altered.
/ |. H( Q( m- R
) Y/ Q1 I! G) g9 O2 W$ }8 S3 K7 h) {
0 L5 b, m6 U: M6 pSQL> !3 f9 U8 s* z. g$ v4 ?. ^
[oracle@adrep ~]$ lsnrctl status0 K6 Y/ S# x0 p5 l4 X. q
3 y: ^: _7 g1 \( L% e; q1 {3 e, g6 r4 J) {5 m/ o1 r
LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 14-SEP-2013 10:13:03
% Q- ?+ u1 _, y. p! ?; j" k5 }/ y) c+ ], j
. A: W+ S/ M9 s" Y! r7 HCopyright (c) 1991, 2011, Oracle. All rights reserved.
8 w6 v( C L+ @. C
. M/ ?( a8 e% ~, {- E& z X& l; b! m2 `
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=adrep)(PORT=1521)))
9 t6 W, H* D5 D _STATUS of the LISTENER
+ G' R1 K+ q$ h3 p------------------------
+ k( `- s- D. d, D1 J# \7 r, |Alias LISTENER' a7 |( i. \4 S
Version TNSLSNR for Linux: Version 11.2.0.3.0 - Production
0 Q {5 q1 l3 p4 ?; Z0 iStart Date 14-SEP-2013 10:11:38
" `0 {- ?! G1 }1 C5 c( S' N0 |2 RUptime 0 days 0 hr. 1 min. 25 sec
* j8 A# \. d, |) zTrace Level off
& V* r- R$ ~1 ~( l1 ]7 q; i: vSecurity ON: Local OS Authentication
# U6 w" K+ o* S; V, oSNMP OFF# L6 t- }* G9 f) f# Z/ d! D. n
Listener Parameter File /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora, V# {1 ]/ \% y' a0 P- X
Listener Log File /u01/app/oracle/diag/tnslsnr/adrep/listener/alert/log.xml& w- x p; n0 J1 d% a) \+ `, g& T' u
Listening Endpoints Summary...
4 e; w0 p- N+ ~ w (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=adrep)(PORT=1521))): X; @- Y2 G) ]3 \
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))& ?! l/ v6 Y7 ?" M% p- s3 z
The listener supports no services
# T U1 S& y+ }; \" N8 i4 J/ NThe command completed successfully# P2 B, b& Y2 \
/ }( O2 H9 }+ W4 C
[oracle@adrep ~]$ lsnrctl reload
% T% B) G0 B6 Z) y$ {/ `* V Listener Log File /u01/app/5 P8 P( ~3 Q: J8 R
# `5 J$ \9 r7 h. b. T0 C: n3 M, w
; v' V/ n5 ~. J5 DLSNRCTL for Linux: Version 11.2.0.3.0 - Production on 14-SEP-2013 10:16:131 E" F1 E+ _6 z3 M c' o
' {5 f! `8 V' l. ]$ j8 D* n0 _. E0 O$ n2 U* x* _7 w4 s. {
Copyright (c) 1991, 2011, Oracle. All rights reserved.
/ [6 z" z. T6 N6 K5 ]4 s2 W+ H1 L6 U8 X. u2 m- A/ G
2 O8 `( V) O/ F/ V4 `1 ^
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=adrep)(PORT=1521)))' M( z5 z/ Q. C7 k. Y+ l
The command completed successfully
1 ~4 d1 s& n0 E4 q2 j[oracle@adrep ~]$ lsnrctl status* J9 q& x% N* t* q
3 {# @+ c1 u* G- M/ s r" K& a* x7 r/ P
LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 14-SEP-2013 10:13:18# d- W7 p; _: v5 r
8 t$ |- q0 m8 r4 L) L6 `3 G5 U( D) ^, b( C% z1 A
Copyright (c) 1991, 2011, Oracle. All rights reserved./ @' Y: U8 k5 M. W
: W* J; ]& j4 [, f5 \0 Y
D5 F5 `: M; q. f6 Z5 J
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=adrep)(PORT=1521)))1 m% R; S; @- @" \5 m' L9 o
STATUS of the LISTENER8 T) F$ Y" z- f0 }2 B
------------------------
$ R3 o2 V5 M* hAlias LISTENER, t! s- G. y8 G: I
Version TNSLSNR for Linux: Version 11.2.0.3.0 - Production
5 N( l8 [& m0 Q/ M0 vStart Date 14-SEP-2013 10:11:38
% |; I g3 ]7 f: Z( T- l$ jUptime 0 days 0 hr. 1 min. 40 sec( a8 A$ U% K! E' \
Trace Level off
1 }: r9 ], ?2 d/ V5 xSecurity ON: Local OS Authentication0 V# Q# D8 d+ m/ o. M# j
SNMP OFF
( Z, u. `6 U0 v; A# M: EListener Parameter File /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora9 g0 p6 H" j, x3 r. M
Listener Log File /u01/app/oracle/diag/tnslsnr/adrep/listener/alert/log.xml
( j6 E5 D- g$ \3 H6 x& aListening Endpoints Summary...# B- g s1 H) W+ A7 Q+ P; v7 ]+ r0 Y
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=adrep)(PORT=1521)))0 ^) @) J6 d& b2 {) s
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
; o# S: X& ?3 E' l1 k* k6 k6 T' `The listener supports no services t8 i* g7 t! d
The command completed successfully5 _& ^7 |7 o+ J" F% M( a
[oracle@adrep ~]$ lsnrctl stop
6 Q! }6 g3 e: N$ C8 p4 s, m5 q* O' x) j
# d6 G/ G- M/ n+ t3 N' U' P4 O7 @2 ?
LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 14-SEP-2013 10:17:035 P5 N( }# w; ?& x) Q: {) h
# b8 \! _9 s1 f1 ~: c
$ o$ @. u: l1 [( V# B! A. yCopyright (c) 1991, 2011, Oracle. All rights reserved.
' J* ?2 Z7 b# m6 j: R, h6 O8 z) P8 t( M5 N* J, ]) \) o
# |' t3 n9 G6 d* X+ g8 `Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=adrep)(PORT=1521))): {( v9 Y% o0 G4 u! m6 w/ {( K# r
The command completed successfully
8 E) y: q' R. Y! ?; l6 F: i1 p& b9 o) E
[oracle@adrep ~]$ lsnrctl start; o! ]# b5 i8 |/ z2 B
5 w' y+ w; l/ x
+ B: z) M2 L' U% B
LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 14-SEP-2013 10:18:53# k8 v" V7 @" V0 |9 Y2 I8 O8 u+ i
' x) E0 [6 e2 K, L# G/ x, S5 H6 @ ^3 |
Copyright (c) 1991, 2011, Oracle. All rights reserved.
. f- f& M' c' w8 p9 y7 c3 d+ x& p ^! o0 w! u4 [0 ^
8 s0 o. R4 `1 Q9 ]- [Starting /u01/app/oracle/product/11.2.0/dbhome_1/bin/tnslsnr: please wait...: V; S& m& q8 }* t
/ l- H! {( F, G4 l: `9 m3 L6 _) z
) G+ W. ~5 H# \7 o! _. rTNSLSNR for Linux: Version 11.2.0.3.0 - Production+ Z: p ?5 F f; H) D8 h5 z8 t
System parameter file is /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
% O! ?- a( h, v6 C- }/ C8 e9 N; Y/ ~Log messages written to /u01/app/oracle/diag/tnslsnr/adrep/listener/alert/log.xml
! n0 k- @7 A0 ?1 a3 G# uListening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=adrep)(PORT=1521)))3 q: i' N8 ~3 O+ ?; n Y
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))7 c. L; d+ W0 P% M4 x
4 e9 y. D! V% g
, I' g8 G2 E; t% H, sConnecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=adrep)(PORT=1521)))
, j. Q6 S( I' c9 ZSTATUS of the LISTENER5 Y( @7 m: Q* V& P. S1 m
------------------------" L& j6 ?; _$ K; ~
Alias LISTENER
: U! _. Y! C; y, Y& n5 T/ @, bVersion TNSLSNR for Linux: Version 11.2.0.3.0 - Production
( @* B% V1 I; MStart Date 14-SEP-2013 10:18:535 H# s2 ~0 h, `
Uptime 0 days 0 hr. 0 min. 0 sec6 }% F) V- ]" j) d4 L& T$ Q! E& T
Trace Level off5 B8 Q r' g' r- L/ N/ K4 S& ~
Security ON: Local OS Authentication
2 K7 T( q; q, z1 W1 F) ?, _% ? _SNMP OFF
a: p8 n8 _# k1 d0 X% kListener Parameter File /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora0 M3 D2 I" |$ f9 j
Listener Log File /u01/app/oracle/diag/tnslsnr/adrep/listener/alert/log.xml
! [/ L+ ?: [# N5 K7 L/ q4 R% BListening Endpoints Summary...
% O: ?& W. m) `# D8 T; X' u (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=adrep)(PORT=1521))). Q q7 @4 l1 H0 ~( Y4 ~$ \" k* F
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))6 G* \4 N0 B, W: w, Z8 L! A+ S
The listener supports no services# A; i/ S' L H, l+ \
The command completed successfully* f4 M9 n9 ]5 Z: G" g% R
[oracle@adrep ~]$ $ Y0 P+ L* b- G6 W
6 E" ^* S( a# |9 {
于是考虑通过mgr配置静态监听，但是让我郁闷的是，总是提示需要输入一个合法的SID$ @" B- e) X# T R% u7 ~' o4 B
+ {, T4 D2 T- v, m% F8 q/ J; W# } ]4 L$ l1 \" o1 h. _3 G
) C$ t# o- M# Q! c" t. |
这个SID绝对是strmtarget没错的，global name即service name也确实是target，这个可以由以下参数获得佐证9 _5 b) V) e! {" J7 T) D4 Z
9 v7 S( e, ~/ l0 e% _8 P' GSQL> show parameter name
3 R+ R9 u# o# M9 R! A
4 C4 X) g- t& Y! k; N5 H6 F" w( o" ~
( _$ L- Q4 X* w6 m, m5 Z! FNAME TYPE VALUE
, z2 R( ~' v/ _$ r! P------------------------------------ ----------- ------------------------------% a; I1 m, d! A7 a0 B
db_file_name_convert string
3 N, l0 x) {4 v$ ~5 J3 j( W- Gdb_name string strmtarg8 g+ _4 |; w# k
db_unique_name string strmtarget
* t6 w2 k) h6 ]+ `" w- h2 K+ \2 xglobal_names boolean TRUE
8 w; h4 Q) p, ~9 hinstance_name string strmtarget
5 T# \- j2 A, Y/ L- s! v. V1 _* B2 Xlock_name_space string+ `# L5 G1 E/ I! l0 `
log_file_name_convert string
: R" K$ d* Q' `% ?& e7 r6 d/ p, cprocessor_group_name string4 f1 u$ Z0 b% f2 f# G
service_names string target
3 h. ~+ c! d7 } O2 W/ I. s: T0 U8 x1 Q7 D. P1 P9 A
也可以通过v$instance视图查到SID是正确的( J6 t6 w7 K n4 ~
2 R! O3 A1 w% g! v ?7 c' ^
SQL> select instance_name from v$instance;. e/ D( }; w2 B% _- ^, f3 |
Q: S" o$ J- n7 g a% l9 l
INSTANCE_NAME
; Y" f! _2 _. K) M) r; ?----------------0 q: p" y) e+ d2 q! `% U
strmtarget0 b- |9 G- ?1 W
# Z- h% n' O$ z" J
难道就没有办法设置静态监听了吗？NO，这里还有一种方法就是手动修改listener.ora文件，添加以下几行内容
$ q4 p0 ~" B) V0 `3 X; A; z. M* }! Y# a- v9 m. y. a7 A
SID_LIST_LISTENER =
" X* j! X; Q- n2 A' J2 H% L(SID_LIST = ! a1 l7 p h% V7 `
(SID_DESC = / u+ G, U; s+ j3 U& }/ S* v/ G* r
(GLOBAL_DBNAME = target)$ m( K% b3 c& V& u
(SID_NAME = strmtarget)8 k* Q; {0 H$ w
)
7 n& a: w# A$ q0 ~% S( J)- P/ \& @1 O3 d
. n# i; j4 g2 v+ E% G2 b5 Y) r: U: U
其作用就是配置一个实例静态监听，只不过用这里跳过了图形化界面修改而已，如果是用netmgr成功修改了实例的静态监听，也是会生成以上几行代码的
5 |5 A- m3 z: V. ]$ ]& Y1 Q
6 C4 Z6 @" @0 H# ^3 V$ y# `1 |这里可以先把listener.ora用xftp工具拷贝出来，修改完再拷贝回相同位置即可) P* [. o! i; U1 s; K9 ]
8 j, l; F; k8 H' u: _2 h' D' I
这里只需要重新加载一次监听就可以注册上实例了: Y5 u7 P9 h! E* K
d) `6 r g/ Z0 R0 r3 c- L
[oracle@adrep ~]$ lsnrctl reload* x( A" e* Y; i
, Z+ V' l9 r! l b7 E
& N2 t# L% Q) Q& k5 OLSNRCTL for Linux: Version 11.2.0.3.0 - Production on 14-SEP-2013 10:32:06
3 F6 L/ V! Y7 f3 G- x3 x" H) k; a/ [$ w+ u6 \
4 V' b3 v) N+ a; Y- oCopyright (c) 1991, 2011, Oracle. All rights reserved.
% V" g) e4 C! p, X! [) E; p3 g6 C; o
& r4 x9 u, u `! S( A' |Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=adrep)(PORT=1521)))
- P0 w" m% n1 Z/ N" \& }The command completed successfully
# h6 W3 G( ?& Y# @% z' Q& n c[oracle@adrep ~]$ lsnrctl status
8 ], j+ F' e7 X& Q) t8 T% [ h8 Z+ t. }' S2 c/ m" p% _
$ M4 \. ?. o) S" x vLSNRCTL for Linux: Version 11.2.0.3.0 - Production on 14-SEP-2013 10:32:14
& {7 L, o( E' S$ V! k5 a
2 o& Q1 j. y) g, z$ w. S& k0 x5 k
Copyright (c) 1991, 2011, Oracle. All rights reserved.- e0 x; A3 v$ s: o3 L+ M' q
* D7 [. T5 O8 v' a9 Z6 G0 M4 h0 _9 J2 a* [ B e" g
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=adrep)(PORT=1521)))
/ F1 q' Y$ d: ?/ WSTATUS of the LISTENER
' h% A2 y7 l: I1 k' K7 i+ o------------------------
X) H- e2 Q. I6 vAlias LISTENER; C9 ? a: s; B$ J& t' @
Version TNSLSNR for Linux: Version 11.2.0.3.0 - Production
5 Z2 ?7 i l6 n; ?+ D5 [- FStart Date 14-SEP-2013 10:18:53
. u! {0 w& @( C* \# pUptime 0 days 0 hr. 13 min. 21 sec/ Y7 w& Q% |+ j# t& h1 r3 v
Trace Level off; L0 c- _& Q L3 n5 k
Security ON: Local OS Authentication. q, P) {, f# g: _+ F" x
SNMP OFF
; o: [& I, j0 c8 y: mListener Parameter File /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
& }7 F( O8 `' iListener Log File /u01/app/oracle/diag/tnslsnr/adrep/listener/alert/log.xml
W, S4 p; `/ f3 G& eListening Endpoints Summary...9 r1 H: f' X6 P! s. k% g: ]
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=adrep)(PORT=1521)))' u5 F& o: c8 k3 h) |
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521))) [ i1 B4 K; E1 C8 P: K
Services Summary...( k5 ^9 d/ b/ U
Service "target" has 1 instance(s).
" b6 f5 z# h/ ~; A/ `9 R- E Instance "strmtarget", status UNKNOWN, has 1 handler(s) for this service...% s2 x2 L# I# E$ L$ K' j/ W+ K' T
The command completed successfully% h9 L& W8 e- @% ]
[oracle@adrep ~]$ 0 [; L! j2 n& ]
/ o1 R# C* c$ g: ~这里target实例通过以上方法，成功地把实例注册上了，注意"UNKNOWN"就表示是静态注册的，如果是"READY"则表示是动态注册的
7 }3 W5 s: Z/ e# ^
3 \+ N: m/ j% ]4 m& ~" c注意：动态和静态监听可以共存，如：0 Z k" J: k) r# m
( }4 V8 r9 z% t" p5 j. m- Q
[oracle@zlm ~]$ lsnrctl status- O O7 m' R5 d9 x+ L; a4 J
9 k+ C1 O/ \% {
- d! h/ T j+ E) O( q) v8 Y+ k
LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 14-SEP-2013 09:52:23$ |5 j7 B. j% }# R/ {5 D }
- r9 h* s+ h+ `- }: Y, u3 L F% m
* [1 z8 }" Q4 h% s4 f% b, Z& bCopyright (c) 1991, 2011, Oracle. All rights reserved.
' M' k5 ?! e4 l7 E
8 @# y. \& C3 i/ b" s" c% t8 B
& J- O3 G2 Q- ~& q1 z7 qConnecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=zlm)(PORT=1521)))1 i8 Y$ U7 U* ?* N
STATUS of the LISTENER, K' I# [+ t \6 [4 @
------------------------( E) g2 V5 g. k/ d- N8 d* B
Alias LISTENER
1 v" G/ {8 P- }3 y) |Version TNSLSNR for Linux: Version 11.2.0.3.0 - Production [/ f, I+ ?& f. A) s6 r, F6 h
Start Date 14-SEP-2013 09:15:04! p7 d, E1 i" R9 Y# \. H
Uptime 0 days 0 hr. 37 min. 19 sec4 P' y8 m& Y9 _, x$ d$ d+ S
Trace Level off
" x( z/ i8 _0 u c+ J9 aSecurity ON: Local OS Authentication' }9 ~ @1 S$ [8 G a8 g
SNMP OFF
x1 b8 j9 U) z+ gListener Parameter File /u01/app/oracle/product/11.2.0/db_1/network/admin/listener.ora4 r. X8 a9 B+ ~& r; W' r, m
Listener Log File /u01/app/oracle/diag/tnslsnr/zlm/listener/alert/log.xml
6 B% _ ?! Z5 t; y+ hListening Endpoints Summary...
2 @5 G! X. x! Z, m& A& [4 d (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=zlm)(PORT=1521)))* o( P i9 _% u/ W
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))8 B- S; q4 A* A1 t$ m
Services Summary...( [5 Z% g" w9 ?+ Q/ D D' q' x' x
Service "zlm11g" has 2 instance(s).0 W4 i* r% {' [( l+ s' W
Instance "zlm11g", status UNKNOWN, has 1 handler(s) for this service...
) b( ^, t! S) o+ v5 y3 ~ Instance "zlm11g", status READY, has 1 handler(s) for this service...
+ A/ m1 @, m JService "zlm11gXDB" has 1 instance(s).$ Z' G( M5 J, ?+ Q \+ C3 V( M
Instance "zlm11g", status READY, has 1 handler(s) for this service...: h; s0 `- o. ^3 l% D7 J
The command completed successfully
' x, y4 W" U# C! q; N2 Y) } T[oracle@zlm ~]$% j: V: \- ]5 U8 \: y) V: a
% \ L" U. e' J: a$ K& V以上是我在zlm主机上的监听状态，可以发现，同时配置了动态和静态的监听; A, W, r6 @0 d4 P8 |, k5 B# M' S
" ]! |9 m+ [+ I I% E( s: }总结：以上利用了手动修改配置静态监听的方法成功注册了Oracle实例，动态监听往往需要等实例启动后，过一段时间才会注册上，而静态监听则可以马上注册。而且一旦实例重启会造成动态监听暂时无效，有些版本的bug甚至会导致动态监听的注册就再也起不来了。所以我对于监听的观点是，尽量配置静态监听，这样就可以避免很多由监听带来的问题，诸如我们经常会碰到的几个ora error：ora-12541、ora-12514、ora-12154等，尤其是在RAC和DG中，一个监听的问题，往往会带来很大的麻烦，尤其需要引起大家的注意。! n/ N3 r7 Q; T+ i: e0 T
|
|
发表于 2018-10-13 13:26:56