|
|
[oracle@adrep ~]$ lsnrctl start
$ B7 E3 U8 X. U5 R% f4 o8 E! q. G8 A
: h4 `* F8 u9 U C
LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 14-SEP-2013 10:11:38" w/ n) f- }; J0 b! B; D1 y
$ p8 A' k9 L/ ^# a8 X& `
) \% r5 s8 k4 @) \% W1 GCopyright (c) 1991, 2011, Oracle. All rights reserved.( I# }( i4 _' h
8 C) F2 x4 G9 c- Z0 l8 G9 b6 x0 n/ k' x0 ~
Starting /u01/app/oracle/product/11.2.0/dbhome_1/bin/tnslsnr: please wait...
3 q) K8 Y" `9 D1 G) V3 k3 z8 t2 a- O- X7 [1 B7 G9 K: j& q. R
% R& v& z/ T/ ]! F
TNSLSNR for Linux: Version 11.2.0.3.0 - Production3 ?+ y/ P8 e8 k5 n& H
System parameter file is /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
) x# @4 |/ x0 [. g7 d8 p& \/ PLog messages written to /u01/app/oracle/diag/tnslsnr/adrep/listener/alert/log.xml
; O5 z! P1 Y; k9 o2 @; sListening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=adrep)(PORT=1521)))& I# }9 B* D0 {$ ?$ W0 i, }/ r
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))5 ]1 P# j; ]2 w. ~, C0 B& I/ p
: A% ]/ F) p: |8 [
8 Z0 A" s0 _& Z) [6 l& ~Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=adrep)(PORT=1521)))- H! |' _+ b5 K l! r
STATUS of the LISTENER6 a+ b' D G) E" U4 T' m
------------------------# w4 w# n$ G' q2 Y" j
Alias LISTENER
7 P) v2 m' f9 k7 d# A% G# ZVersion TNSLSNR for Linux: Version 11.2.0.3.0 - Production
# M; k; z7 n$ p! Q1 y( ^& xStart Date 14-SEP-2013 10:11:38
- p5 j4 b. G% tUptime 0 days 0 hr. 0 min. 0 sec
$ r1 d7 Y# v- U6 }7 |+ XTrace Level off
- R9 ^* E) U2 G% h. U1 wSecurity ON: Local OS Authentication: h% A! ?) ]& v3 e. J6 N2 C
SNMP OFF/ E/ D$ @, l4 H% z: {
Listener Parameter File /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora" i7 M/ y& l+ C. h( _
Listener Log File /u01/app/oracle/diag/tnslsnr/adrep/listener/alert/log.xml
2 o' `& A+ o. T0 A. N2 e; i7 u6 YListening Endpoints Summary...
4 A# H) {% A6 g0 g+ P! G (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=adrep)(PORT=1521)))0 w, u, F9 b* V0 Z: B
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))) R# O/ N7 }8 v7 Z$ j) z; k% D' E
The listener supports no services; _; j* ?3 c# s5 d
The command completed successfully
; q, a$ r, p, Q6 ]6 e4 W3 b由于这台主机之前做的是stream实验，修改了一下hostname，之前的监听和服务名也用netca重新配置过了，但是启动监听一致是这个状态，动态监听注册不上
% D4 o8 A! `5 I5 J1 d
/ r9 I! L/ F' c3 z P3 r本地登录到Oracle实例，手动注册实例也无果，问题依旧! x& {- B. ~! U( t' Q% \
L5 ^% x+ `( D: u- a- ?5 l& k$ C2 KSQL> alter system register;
9 C. T" k! q3 w* _8 m* V0 s/ V1 |8 D) F8 C
% Q3 _7 P7 x- e) h4 JSystem altered.
0 D. S2 ?$ [" F( f- O D$ N
. y$ a2 w& W4 q7 u2 E+ U* d, M& {1 G4 ^& z1 E3 N- l
SQL> ! q7 h& p4 s, `
[oracle@adrep ~]$ lsnrctl status
( t" x) Q0 K. }4 F0 L+ }, I
+ @- L& n+ v, [4 { A% H' o. T8 v& l* }$ ?+ A" ]
LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 14-SEP-2013 10:13:030 x% t# R3 F( r8 J; Q7 |0 E, m
1 a0 s9 _, f: P; R- m! R
" e( Z. D# s oCopyright (c) 1991, 2011, Oracle. All rights reserved.
2 x: ~, _% V+ q2 c' D, y" X; w- R6 t" S( c: }0 N
. c% T3 D; e' l
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=adrep)(PORT=1521)))
2 |/ {0 k1 d. ]+ j2 J" w% Q c4 }STATUS of the LISTENER
$ |6 I8 u* ^: a3 _------------------------4 A! v/ Y- T9 I; D' u: |
Alias LISTENER
; l! Q8 }) E2 i9 y6 f. W) I3 \Version TNSLSNR for Linux: Version 11.2.0.3.0 - Production
& u4 j# O, R+ p' dStart Date 14-SEP-2013 10:11:38
" z$ w T! z3 ~( _Uptime 0 days 0 hr. 1 min. 25 sec
3 [+ T, Z4 [! q, ~' UTrace Level off4 b+ E. k( [6 f1 @. l, x
Security ON: Local OS Authentication7 p" ?4 U4 b9 k, T5 |1 w. i
SNMP OFF. _3 j" A; m4 v5 a3 I5 ] D
Listener Parameter File /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
, W7 I/ W* E# O/ L) L6 ]Listener Log File /u01/app/oracle/diag/tnslsnr/adrep/listener/alert/log.xml
b, a- [6 f/ B- L2 @# {/ m0 qListening Endpoints Summary...
# {! Z2 D+ H' K9 h: P/ ~5 I (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=adrep)(PORT=1521)))+ c H( ~" r, G6 N9 ]
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
- C2 ], y. Y. X2 v* M0 `/ E$ qThe listener supports no services
- s+ B, S$ K0 Y. B( x l `* q/ KThe command completed successfully. ]' a2 b* p$ M3 O4 @ e' m |! c$ F
: `) w: o# I# E8 \. Q7 k" E. M3 f( z( s
[oracle@adrep ~]$ lsnrctl reload
: V2 E2 k! }1 G" C: S. X1 t1 w4 d Listener Log File /u01/app/
; T9 j1 m3 @ v% z! }
N6 `1 m3 c) d6 C4 s8 ~6 A4 \) S3 M
LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 14-SEP-2013 10:16:13
! q% O. ?+ r X( R: A% W* m
' ^/ e' h+ u3 I+ h
0 c+ f/ ~* e) ?0 G9 x0 ACopyright (c) 1991, 2011, Oracle. All rights reserved./ l: e4 j D0 C% M& @
! @! `! [9 f3 a4 v3 B" _3 W
+ _8 F6 n: E( \Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=adrep)(PORT=1521)))& M( N0 S7 a6 P* y, [( `5 g
The command completed successfully$ N" A( V1 f$ C! H" ]/ n) y
[oracle@adrep ~]$ lsnrctl status
# X4 C; F+ D7 o" `6 s
+ _$ N! g- `/ M7 F0 m* V, h- ?' f$ {
7 p$ |) |5 U5 Q! uLSNRCTL for Linux: Version 11.2.0.3.0 - Production on 14-SEP-2013 10:13:186 v; y7 j9 ^8 h2 y# Y
9 \' u$ l9 E1 E/ k' g9 l+ V: V) ~% h5 X: [
Copyright (c) 1991, 2011, Oracle. All rights reserved.
& X9 p) K/ n( w2 p' Y% x- u% x1 K6 t; ]2 y- t8 O. L! b
; V; r7 |2 C E5 _9 A/ {, {7 U
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=adrep)(PORT=1521))): B" ]' Q" ~* l! L' i
STATUS of the LISTENER
+ t$ A9 W' b2 g2 Y) M------------------------: _6 ~" L' N1 W& Q, |" S G0 A9 L( Y
Alias LISTENER
/ q/ a, d3 h$ e+ Z2 HVersion TNSLSNR for Linux: Version 11.2.0.3.0 - Production2 i$ D+ m% t2 a
Start Date 14-SEP-2013 10:11:38
% }. A: g) ]: nUptime 0 days 0 hr. 1 min. 40 sec5 |! ?/ H$ Z. B a$ u3 u) _% w# I
Trace Level off
& f- h" m& b" Z8 s' TSecurity ON: Local OS Authentication
5 `- D* W# K% k# iSNMP OFF
5 r8 X: i( {$ n8 A# u5 S+ WListener Parameter File /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora: \6 B* W" F; @5 H' Z
Listener Log File /u01/app/oracle/diag/tnslsnr/adrep/listener/alert/log.xml" j6 F# {" H$ [% ~
Listening Endpoints Summary.... }$ ^7 q; @% X2 Y! ^
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=adrep)(PORT=1521)))
7 `! f: H2 y* I( m (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
4 p; R" h( Y% O4 x$ v! bThe listener supports no services+ N" e1 b t2 i% P
The command completed successfully6 z3 b7 E5 @* P j0 r% l* E
[oracle@adrep ~]$ lsnrctl stop
Y \& G4 y0 U3 h2 m: H
6 w# C2 a+ M% v+ B9 U( X$ o
4 ]/ m1 F& ^3 ?, s- d: G6 B
+ F+ J# H, B/ T4 MLSNRCTL for Linux: Version 11.2.0.3.0 - Production on 14-SEP-2013 10:17:03
& ^' l8 T8 j6 o! _- K2 }7 J
; r7 M) |1 n& I- y' ~2 N& U/ Z* X1 b
Copyright (c) 1991, 2011, Oracle. All rights reserved. y) O# }3 l0 K" }& g
9 c$ E5 q8 T1 @9 ~4 h
# B1 l) @% ?# z) \Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=adrep)(PORT=1521)))( G% m5 g1 _' [5 W
The command completed successfully
4 l0 p/ }( T9 x2 O( L
% l) B. A: q7 k. Q: C- M[oracle@adrep ~]$ lsnrctl start
5 ]) I) a8 H1 {! a. s- `' c, q5 d( \8 u3 h. e
/ y- B& R& m& C( a
LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 14-SEP-2013 10:18:53
3 T2 b5 G" g4 T2 L1 ~ n) J+ Z
- E6 w5 u5 x% J: n4 L& S4 U$ F- i$ b& O5 H) t( W4 `
Copyright (c) 1991, 2011, Oracle. All rights reserved.# a/ X& g& s, i7 o* h$ z
6 s3 [& @5 Y1 Y5 w+ A% {# k
; i6 ?1 `8 o4 C5 g$ fStarting /u01/app/oracle/product/11.2.0/dbhome_1/bin/tnslsnr: please wait...
. ^3 s7 p$ a! i; |# F( x# w9 Z* Y; s3 x2 }
: E, } y& R" c7 L
TNSLSNR for Linux: Version 11.2.0.3.0 - Production
3 Z/ w! O- d8 \) R- X: R5 NSystem parameter file is /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora4 E1 J7 w! v" p9 j$ Y: U( O+ i
Log messages written to /u01/app/oracle/diag/tnslsnr/adrep/listener/alert/log.xml8 P; P& g! f. @) J) o- D9 E/ Q6 r/ L
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=adrep)(PORT=1521))) `1 S' c, B0 `& b6 S. Y3 K* ^
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
2 [' j, _9 b( @. T2 G1 w) P3 v
/ U1 J* d& e) v- ]6 d6 e/ c: d' ]+ @+ F: Y1 F0 @' X% x+ m$ a
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=adrep)(PORT=1521)))
5 c1 k& W9 c: u: ]. c: I/ oSTATUS of the LISTENER
2 [! u3 j' Z$ \# J4 p! C------------------------ \5 T0 U7 y5 ?0 a6 x1 o( A
Alias LISTENER* b9 Q/ x& Y) D- P7 [4 H0 b
Version TNSLSNR for Linux: Version 11.2.0.3.0 - Production
1 {% j6 d+ T) ^3 @0 }5 cStart Date 14-SEP-2013 10:18:53
0 `6 i! E- }9 Y3 L: M) DUptime 0 days 0 hr. 0 min. 0 sec
' ?6 Z1 Q2 C4 k2 qTrace Level off
+ z' x2 E' I3 k3 ^! DSecurity ON: Local OS Authentication
% g. |' v$ C9 f3 H( {: r& nSNMP OFF. d- i+ U2 u# i6 g
Listener Parameter File /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora0 x, K! ^0 P9 a# ?2 i) }+ `
Listener Log File /u01/app/oracle/diag/tnslsnr/adrep/listener/alert/log.xml
, t, b* q1 s5 D$ P2 S5 K4 N; z1 M/ VListening Endpoints Summary...
" U- E' D" i6 H2 l (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=adrep)(PORT=1521)))2 B. c0 K) q4 G1 ~% q2 [' b( X
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
o8 k" p5 g7 P0 q4 ~" [! h* vThe listener supports no services4 R7 f$ f: J1 f) h
The command completed successfully
+ |. l, ~0 C" r- |, M& x# p3 q[oracle@adrep ~]$
0 e& X( H/ G& N4 i2 t" `0 j% }' k& w3 Y9 b- _. e
于是考虑通过mgr配置静态监听，但是让我郁闷的是，总是提示需要输入一个合法的SID
- o' I, g0 X$ F8 C R0 p ]
( ~( U7 n- E* v e4 d$ G' A& ?) W1 a4 W/ C0 u% ~/ x
4 o2 ` w: \0 ^$ T) N" F
这个SID绝对是strmtarget没错的，global name即service name也确实是target，这个可以由以下参数获得佐证
4 e$ Y. o8 @+ y- b
2 q+ i3 |( E; ^9 xSQL> show parameter name
: l+ d4 n* P' B! D
, K6 a6 ~1 K9 \ a$ j$ u, O
- v7 {% c. n; h4 S! O7 cNAME TYPE VALUE5 {: h5 V% H" O" x% N' Q) k
------------------------------------ ----------- ------------------------------! v1 t8 |6 H4 D: P0 u6 j- }
db_file_name_convert string
( d$ j. v- S& e2 `+ a( kdb_name string strmtarg
5 Q+ G" A6 ~" w7 G" Z0 ~db_unique_name string strmtarget4 j0 b; T x) x3 W2 \; X
global_names boolean TRUE
' ~ z' q' J8 Ainstance_name string strmtarget) I* T" f7 a }
lock_name_space string+ v( `1 o/ X9 g1 O8 c2 L1 }/ Z
log_file_name_convert string
- f" K5 e/ y7 h; x* r" j. uprocessor_group_name string& ^% N1 j4 T2 g6 ]
service_names string target
! \: `0 g. s3 ^) b% Q9 r+ Z( O) c9 L8 [0 Y
也可以通过v$instance视图查到SID是正确的, V8 Y" t! C. y e
8 z2 q; W6 U; r/ B0 z
SQL> select instance_name from v$instance;: ~' @$ _; B$ Y+ o* `) s# B
$ D6 I1 g' j! Z$ e) }$ I
INSTANCE_NAME4 e! b2 P4 l( v9 N N
----------------
! _7 Q; s9 B/ C7 x! Q! f' M$ ostrmtarget
0 x9 V, K5 Q, `6 i
8 p' Z+ v7 l% R难道就没有办法设置静态监听了吗？NO，这里还有一种方法就是手动修改listener.ora文件，添加以下几行内容
( F$ R( b/ l* E3 I: r9 l$ l7 W9 D6 c- k: o5 g9 ~0 Q. f
SID_LIST_LISTENER = $ k4 @9 U' r; b' _9 \
(SID_LIST =
) |9 O0 n- M* c7 } (SID_DESC = $ |* v m. m: _& I% z
(GLOBAL_DBNAME = target)6 c2 x8 L, l$ N, N: c
(SID_NAME = strmtarget)% W4 p$ x% C9 F" f5 }
); D; w& D$ i- { ^. d
)
. K; j& w! Q8 J7 F- ` M1 m. z& j7 a9 \) g/ g
其作用就是配置一个实例静态监听，只不过用这里跳过了图形化界面修改而已，如果是用netmgr成功修改了实例的静态监听，也是会生成以上几行代码的
3 u2 Y/ o* ^9 |0 j( y: |1 x6 n6 g$ b3 g5 y4 c5 E- S) K3 o
这里可以先把listener.ora用xftp工具拷贝出来，修改完再拷贝回相同位置即可
; D" e9 x4 {' _4 G
/ a% m9 H+ p" ]# E! R. X; [' x这里只需要重新加载一次监听就可以注册上实例了 n1 f v4 a5 w
) e. k4 F, T$ `4 i[oracle@adrep ~]$ lsnrctl reload
4 N* ~* X9 z7 [0 P# Z$ u2 |
7 A* }4 u9 \- v1 K2 I' g8 D
- u% C) F5 t; B5 p. XLSNRCTL for Linux: Version 11.2.0.3.0 - Production on 14-SEP-2013 10:32:06
6 h# F1 I6 e9 u& l
4 o! @$ ~* x! T! S/ l2 j$ Y+ ]% _( C. H% ^# n( ]
Copyright (c) 1991, 2011, Oracle. All rights reserved.
9 m6 u( n ^2 o: y4 H S: b3 i1 b8 e2 t
# V! z- B" u8 S u
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=adrep)(PORT=1521)))( @2 X" f6 l5 h$ X% A7 q6 G& r" C' c
The command completed successfully
8 [$ y( \& _( K[oracle@adrep ~]$ lsnrctl status
9 S6 @+ i$ d" Z0 e8 W: K: M% p1 {0 ]9 ~$ i5 ]! V
" ?' n: Y1 y& J
LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 14-SEP-2013 10:32:14
; s9 _! ^; b8 ]' ?# F' @* Y3 o; [3 ?4 d" T7 @
9 E7 j$ C( N7 c8 }9 N( kCopyright (c) 1991, 2011, Oracle. All rights reserved.' b0 u9 s' Q) C# C% k( V
) f; I$ N, D; u0 @0 @. J" E: a. m
& O0 [: G8 K( B' m; |; S6 G, i# X- P( @Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=adrep)(PORT=1521)))
`9 ~# D5 X& O+ o5 o3 u4 KSTATUS of the LISTENER( f5 t [& G; |9 |
------------------------4 r8 Q/ D& P5 I. `& J* K
Alias LISTENER
& f. z/ D6 o) O* d6 P3 hVersion TNSLSNR for Linux: Version 11.2.0.3.0 - Production6 k4 [& V# K# |( o7 C: w2 J& E' b6 X
Start Date 14-SEP-2013 10:18:53' |' v9 I7 t" y* L" [4 V$ E: P5 y
Uptime 0 days 0 hr. 13 min. 21 sec0 T- q) p' g9 g! \6 o
Trace Level off( H; g2 N9 i4 n1 G
Security ON: Local OS Authentication9 ?6 T, H; ?; q$ E4 Y
SNMP OFF
$ h' k0 i9 _4 I- }& h7 iListener Parameter File /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
/ \) \0 @9 a) O8 v. iListener Log File /u01/app/oracle/diag/tnslsnr/adrep/listener/alert/log.xml
0 Q$ R1 t8 a# t+ D/ Y$ [+ GListening Endpoints Summary...1 n/ I7 E" V$ Q: F. `7 H
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=adrep)(PORT=1521)))6 V2 A1 r Y4 Z0 k$ S
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))& G; h" a" L) c+ ~& O) e$ P
Services Summary...
4 A, M6 s- i$ L F9 b: o# AService "target" has 1 instance(s).! d5 E! a1 A1 L$ j0 i; c- b, ?
Instance "strmtarget", status UNKNOWN, has 1 handler(s) for this service...+ X3 [" N/ o, x3 g( B$ R
The command completed successfully
7 o; d+ ?5 [8 F1 ^) H+ b; ?" d7 e[oracle@adrep ~]$ 7 I0 M0 x* O. C/ g' i
3 H9 B- b$ g( \2 K% j+ j
这里target实例通过以上方法，成功地把实例注册上了，注意"UNKNOWN"就表示是静态注册的，如果是"READY"则表示是动态注册的' G) m% D+ F0 n
5 z7 v5 J4 k2 A, g注意：动态和静态监听可以共存，如：
4 n+ F7 [1 u8 e; O5 K; j" t/ Z3 b8 a8 E4 y
[oracle@zlm ~]$ lsnrctl status
/ ]4 z l+ T) O$ u
. \% t( ?1 A: n& @- P: D1 O; ]9 h0 S7 m6 @' i
LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 14-SEP-2013 09:52:237 i3 Y4 K$ Y0 e* d! b
0 c' J( ?3 E7 Z j" E2 r
4 Q" l+ E1 |. f* D$ b$ m8 G# C' ]Copyright (c) 1991, 2011, Oracle. All rights reserved./ t% m, C! w! W* L9 b6 j7 N+ k
; q# h9 Q6 D6 ?' }1 r
& `- B" M* z" f2 g
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=zlm)(PORT=1521)))9 F( O5 z1 y* y7 q+ ^3 [' u; _ K" H
STATUS of the LISTENER; ]( L' i6 X" p- [. O* O& l
------------------------. C& }/ S3 t! B+ a' k
Alias LISTENER
5 y4 z; [ s2 vVersion TNSLSNR for Linux: Version 11.2.0.3.0 - Production
$ x6 K( T9 O6 G+ O+ l8 A: ^Start Date 14-SEP-2013 09:15:04# v' M( E2 m& Y' I/ p( U- b/ a# z
Uptime 0 days 0 hr. 37 min. 19 sec
0 j4 O7 m' S( vTrace Level off1 t+ A. z. j; i5 ^5 q8 T+ c
Security ON: Local OS Authentication5 ?3 U6 u' G% T. d. d
SNMP OFF% @' T( X# m D' C5 Y
Listener Parameter File /u01/app/oracle/product/11.2.0/db_1/network/admin/listener.ora
1 E# J4 z2 z' v4 j4 {Listener Log File /u01/app/oracle/diag/tnslsnr/zlm/listener/alert/log.xml
3 J; Y {8 F4 o0 g+ _. b5 p! NListening Endpoints Summary...
* _3 E" G" ?) e, Z+ c; }: e (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=zlm)(PORT=1521))) |, j: A" n3 P5 Y, c
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521))); `% w) K. T' O% T- B
Services Summary...
4 W. U) t* S# t; u0 M+ p% [Service "zlm11g" has 2 instance(s).
/ f& e# G: z% X' g7 Y; O9 P4 Z+ ] Instance "zlm11g", status UNKNOWN, has 1 handler(s) for this service.... k/ G. ~7 Q& n' \% M( n
Instance "zlm11g", status READY, has 1 handler(s) for this service...* P5 i5 M/ U$ k5 c0 F1 B' |
Service "zlm11gXDB" has 1 instance(s).- e' i- O3 J, L& l0 E
Instance "zlm11g", status READY, has 1 handler(s) for this service...) \, e9 G- j4 X' K1 t" {
The command completed successfully
5 \+ Q+ ^2 t. t; n1 W[oracle@zlm ~]$' i' t \! ]7 V4 i7 V ?! v, m( a' O
) u( x1 }7 [. y以上是我在zlm主机上的监听状态，可以发现，同时配置了动态和静态的监听3 a3 `5 j: v) A% r0 L l3 W2 \
; ^6 U8 z7 @4 V
总结：以上利用了手动修改配置静态监听的方法成功注册了Oracle实例，动态监听往往需要等实例启动后，过一段时间才会注册上，而静态监听则可以马上注册。而且一旦实例重启会造成动态监听暂时无效，有些版本的bug甚至会导致动态监听的注册就再也起不来了。所以我对于监听的观点是，尽量配置静态监听，这样就可以避免很多由监听带来的问题，诸如我们经常会碰到的几个ora error：ora-12541、ora-12514、ora-12154等，尤其是在RAC和DG中，一个监听的问题，往往会带来很大的麻烦，尤其需要引起大家的注意。' V0 A: a' O6 M* i8 [# h* K
|
|
发表于 2018-10-13 13:26:56