|
|
[oracle@adrep ~]$ lsnrctl start
7 A! C& E8 W7 `6 B7 i: F4 i6 C& l+ Q5 W5 L: X) w6 H6 @. R
/ d% Z, @: r3 \. y+ s
LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 14-SEP-2013 10:11:38" Q- O5 e7 d( h. z: R5 a# w" R$ ]/ @
0 F# F: T) o& Y9 ]
$ x- |+ J! C7 \2 p( OCopyright (c) 1991, 2011, Oracle. All rights reserved.
; `/ l: ? u- ?; d
& R; j3 B1 W. ? W1 c% ]& d8 [
, N( J( C9 S- ZStarting /u01/app/oracle/product/11.2.0/dbhome_1/bin/tnslsnr: please wait...' O" d) @ _! c2 P3 A5 w7 l7 K, g
/ Y8 z% i+ {1 c# w+ T
' K4 O5 } K" a% N1 ]& z- Y6 k# HTNSLSNR for Linux: Version 11.2.0.3.0 - Production3 Y+ s% j t L# z6 n* p
System parameter file is /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora9 F# M/ x& s4 y) \
Log messages written to /u01/app/oracle/diag/tnslsnr/adrep/listener/alert/log.xml
4 p8 @; v" u! r0 K( X1 IListening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=adrep)(PORT=1521)))
+ L# \4 A( Z- P' v2 h$ f4 q# hListening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))/ a& t0 Q" k; i0 o d0 n0 K" }
4 l h: E- F0 \! ]7 u' N6 U
3 v: M X% l3 W/ x' s; r, WConnecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=adrep)(PORT=1521)))& q) w4 u1 H2 N. F- o0 y& T* j! j
STATUS of the LISTENER
" U3 u a5 d4 |* ]------------------------. J& U( O% b" c% Y- |5 A
Alias LISTENER+ v0 H9 |7 J* ?, _; g2 F- j
Version TNSLSNR for Linux: Version 11.2.0.3.0 - Production( b3 b# D5 i6 b9 T+ c3 u
Start Date 14-SEP-2013 10:11:38
+ k7 P, P$ T% M- p c0 q0 GUptime 0 days 0 hr. 0 min. 0 sec' ?0 N* {# t& ^* T* Z% Z+ ^
Trace Level off; g7 I4 `9 r7 \) k# A2 B. e
Security ON: Local OS Authentication( _, e9 Z& W w2 c) p9 O9 d3 ~7 X
SNMP OFF
# Z8 w3 W8 X, f0 ^0 tListener Parameter File /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora) Y, i0 m8 G! v
Listener Log File /u01/app/oracle/diag/tnslsnr/adrep/listener/alert/log.xml9 E& j) t+ K; D& ]* z
Listening Endpoints Summary...$ p. R- W E1 Q* O
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=adrep)(PORT=1521)))
$ A+ m; i( ]2 L$ R' p4 }3 z (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521))) Z. ?5 m% b3 [" b! [* B- E
The listener supports no services+ r2 q- D( I* t0 q! |3 B
The command completed successfully. L, w. b# F# e4 c2 N# i. u
由于这台主机之前做的是stream实验，修改了一下hostname，之前的监听和服务名也用netca重新配置过了，但是启动监听一致是这个状态，动态监听注册不上- T' p/ X/ y3 T% B; {0 G
- d7 F( g9 S Y& F* Z本地登录到Oracle实例，手动注册实例也无果，问题依旧: w& c: a, @9 z" t8 Y' K
4 p4 f4 T+ A( C& ~/ Y6 A( l3 J
SQL> alter system register;1 k, r9 _* a$ N/ w) N( X2 [6 a
7 o* K5 k9 C9 J
: \2 k& a& e7 ^4 W" d: N! r( kSystem altered.
) B+ h+ B* G+ }7 c* \
1 h" L. [ v7 l# M) E8 K+ a6 g+ M1 y
SQL> !: V% I! a% L- O$ \! T
[oracle@adrep ~]$ lsnrctl status
! x& R6 a9 R7 V4 n2 u F( D3 }8 I4 _1 \& @7 y/ K! P! M
0 H: R* Y% r, rLSNRCTL for Linux: Version 11.2.0.3.0 - Production on 14-SEP-2013 10:13:031 x, O R; r* T0 N5 k# t2 [
- q0 o9 E9 Y( C/ r
9 G0 Q U1 l! _' w) b4 c; c
Copyright (c) 1991, 2011, Oracle. All rights reserved.
4 F2 r0 u8 U7 c: a2 H
& k; S/ v8 n4 r/ [3 `6 o6 U& ]: V& W) r5 K3 t: w
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=adrep)(PORT=1521)))
/ o2 T. C! e. s4 Z1 d+ V/ B' ]STATUS of the LISTENER9 o" q( k* C; \' _1 U
------------------------+ n s( M! ~! e6 [3 ]
Alias LISTENER
6 e s5 _5 K, g* SVersion TNSLSNR for Linux: Version 11.2.0.3.0 - Production
K2 Y( y+ B' r2 L; }$ E' t( oStart Date 14-SEP-2013 10:11:380 M8 U& a+ z4 u. d8 B, [: \$ q
Uptime 0 days 0 hr. 1 min. 25 sec0 A& g0 Q ?8 E! Y
Trace Level off
/ |& C! v6 V) G3 cSecurity ON: Local OS Authentication2 f% `& ?: d% L6 N: J+ U
SNMP OFF4 U$ g6 R) x$ {( u. h0 t
Listener Parameter File /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
' A. U2 n" p7 Z5 _3 R$ ^Listener Log File /u01/app/oracle/diag/tnslsnr/adrep/listener/alert/log.xml
' | l c( x6 [, s8 [- a2 G+ k6 FListening Endpoints Summary...* z: s7 a& [+ P" ~, \* o
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=adrep)(PORT=1521)))
, r- s4 s* F7 n: e' c/ h (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
- T& \% B+ V1 N- Q2 K2 s: bThe listener supports no services! E6 A! [* ~! }1 @1 p
The command completed successfully
5 K/ s$ l/ ^) ?
6 v; q2 u( W4 w$ v( D* Z[oracle@adrep ~]$ lsnrctl reload' Z" x* W. b8 k
Listener Log File /u01/app/
; {, a" y; B% b( ?3 \8 Y
( `3 ^5 P3 l6 ] ?: \3 ^; i0 v! ]" o. f. J5 A! P
LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 14-SEP-2013 10:16:13
. g k2 ]: z1 G/ ~. o4 e# ]) ]
4 r2 f0 B# r. J5 V! x2 r9 y8 G+ Z3 F
Copyright (c) 1991, 2011, Oracle. All rights reserved.
" s$ ^3 {% z# R4 H- i9 n' _; @2 @& p3 Y. e4 G! O
( L/ Z7 k! e7 A+ B7 T0 E7 MConnecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=adrep)(PORT=1521)))5 Y- i( d7 p5 }6 ^
The command completed successfully$ U3 w3 \3 M, k' J9 m0 S
[oracle@adrep ~]$ lsnrctl status0 H( d0 Y% N8 E- Z
e. e4 n' e. b" a+ ]4 W X* s m+ c
" l1 L% y0 r& W1 {1 n. k' M m% ^
LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 14-SEP-2013 10:13:18# e% p9 Z5 k9 e5 G, e6 m
2 o+ _: [# {$ Z* V5 ~3 _/ a
& y, v; ^# U. G' H& z! k8 UCopyright (c) 1991, 2011, Oracle. All rights reserved.
8 {8 n+ }6 ]9 m& W% M6 I: F8 U8 L/ q9 I6 E6 Z
# z2 k3 @( `2 ?2 h8 NConnecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=adrep)(PORT=1521)))
t- v; [7 S9 X8 tSTATUS of the LISTENER
& j8 [$ U. ` a/ t! C+ u) D------------------------
5 E& K+ H' {' m# U* ZAlias LISTENER6 ~1 P! G0 W# H: Q
Version TNSLSNR for Linux: Version 11.2.0.3.0 - Production- ]2 C9 f, \, m6 q" O" N" X ^6 L: C
Start Date 14-SEP-2013 10:11:38. h/ }7 P& Q2 h
Uptime 0 days 0 hr. 1 min. 40 sec" ]" S2 c. C/ A+ D9 K
Trace Level off" x9 x7 y' f; Z% S: I
Security ON: Local OS Authentication
8 U+ m1 D, X9 @3 K& M+ x6 _SNMP OFF9 x, [1 u' d2 s6 L" K
Listener Parameter File /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora5 d2 m$ c' R; N* s* q; S
Listener Log File /u01/app/oracle/diag/tnslsnr/adrep/listener/alert/log.xml
) o7 @ f3 _0 uListening Endpoints Summary...3 T: V6 \+ k, b2 U; V
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=adrep)(PORT=1521)))8 V% a; z* J3 M1 t# U
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
$ C- [! f* C; fThe listener supports no services1 p# u$ {$ @ b
The command completed successfully* l, [0 b' A' A9 p5 w: p4 K
[oracle@adrep ~]$ lsnrctl stop: e* o" ]7 R1 \4 Q& N, Y
7 O& |; J! a; B& f9 F1 u1 n" ]7 Z( S- f
4 [7 i6 e+ c, y; r
LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 14-SEP-2013 10:17:03
9 V3 ^2 ]1 A% o' C
) W, g/ p4 Z* R b# V6 r9 W7 i0 B. \' g5 a
Copyright (c) 1991, 2011, Oracle. All rights reserved.; I A+ ~% \3 `6 }9 v2 v/ I
2 h2 O( m" z3 x
) I/ B+ q. g% K7 m
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=adrep)(PORT=1521)))
/ [+ z9 g0 d; z" e% L2 f! S; UThe command completed successfully, Q5 m/ g+ w$ E5 I+ o" q! S* c% }! X
% v( Y' Q# c! y& c[oracle@adrep ~]$ lsnrctl start" Q* h0 P$ S, ]
/ z% ?/ J3 Z6 e; G2 N
! p5 T- S/ W2 z/ Y7 b G1 _! JLSNRCTL for Linux: Version 11.2.0.3.0 - Production on 14-SEP-2013 10:18:53. T+ v% `8 d2 T) n9 C( @( D; p. B. h
4 @; j8 N1 n1 ^: w' ^2 E& s7 E/ c# p0 l, l7 a3 l
Copyright (c) 1991, 2011, Oracle. All rights reserved.
) R, J# Y1 ?+ c/ C( q. r, ]# t9 V# [+ }5 `" F
# }# U C; M" a* X4 p
Starting /u01/app/oracle/product/11.2.0/dbhome_1/bin/tnslsnr: please wait...
7 L) T6 f" n; E0 {; T8 a( I: B& @# |- V2 B( b! Q% z$ ~
7 J2 y! Y3 w$ n" a
TNSLSNR for Linux: Version 11.2.0.3.0 - Production
P2 _) w; y; K# @+ YSystem parameter file is /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
- |8 u+ o, t) ^2 {; H) o* Y# e6 a hLog messages written to /u01/app/oracle/diag/tnslsnr/adrep/listener/alert/log.xml) s- a$ Y. ?( f2 h5 A4 i
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=adrep)(PORT=1521)))+ [, K! `9 D4 L
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
0 m/ a/ n9 u! |: G- p% i0 p. p
1 q" f/ K+ H- j
V3 {, G1 {% j$ c+ Z5 bConnecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=adrep)(PORT=1521)))3 Y* l& O% p7 d1 p- d4 {& v
STATUS of the LISTENER9 [5 n3 d o2 x
------------------------& s! K9 K: C3 ]# t
Alias LISTENER
0 }$ ?0 K& T* k. v& tVersion TNSLSNR for Linux: Version 11.2.0.3.0 - Production
8 ?0 @$ \1 W' A" ^- k& `Start Date 14-SEP-2013 10:18:534 Y9 ?! ` k; q9 k' {7 P: Z
Uptime 0 days 0 hr. 0 min. 0 sec
* Y/ K2 O+ h0 ]- f) n% y% }Trace Level off
x$ I" } H; n" W' I3 S9 ySecurity ON: Local OS Authentication
4 j1 P* y( q+ WSNMP OFF6 S2 R4 c1 u" z" ^3 z( n
Listener Parameter File /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora8 }4 r2 F( r- Y$ W! T
Listener Log File /u01/app/oracle/diag/tnslsnr/adrep/listener/alert/log.xml( W" |& q9 n# b, V' U0 h7 R) R! t
Listening Endpoints Summary...2 V- O# g- s6 E$ C$ `% `
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=adrep)(PORT=1521)))2 h8 `! @& y8 K1 q
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
% M+ c! ]4 n1 ]' y# D$ GThe listener supports no services3 n+ [% N* H2 \ z9 O" x& _
The command completed successfully
5 C3 X( Q+ E: M- Z9 X[oracle@adrep ~]$
7 T& e6 v. X$ v5 P$ O$ F- B" @: ]7 H& Q
6 Y, b( |) M, G' W2 G" @0 `于是考虑通过mgr配置静态监听，但是让我郁闷的是，总是提示需要输入一个合法的SID# b, y$ `! @) _+ ^& j
$ S- l) r+ x. E, Y6 n' T( y5 l
* @! P/ y( e/ V9 V& y- I4 } ^- o+ r3 a; C
这个SID绝对是strmtarget没错的，global name即service name也确实是target，这个可以由以下参数获得佐证3 }7 U$ W3 {& h- f7 S& ]
5 X7 ^% l: G$ p" }4 G
SQL> show parameter name2 z* o& |% A: v1 g& a
+ U; Y6 M9 ^9 M; E4 V
C( A& S; A/ \7 p5 J
NAME TYPE VALUE) t" d9 D/ E) `) s: B: b
------------------------------------ ----------- ------------------------------
- w: ?7 R! ~& ~7 H8 t- odb_file_name_convert string
2 c/ n* x: ~& Bdb_name string strmtarg# I1 B8 X4 m' i2 X
db_unique_name string strmtarget
. J4 o4 _5 w4 Q M- |# eglobal_names boolean TRUE
' c/ c2 y% j, d: hinstance_name string strmtarget: L# l7 v) o2 O* T/ h3 I+ G
lock_name_space string
6 [8 Q6 [+ q; X3 a. U& zlog_file_name_convert string
0 q k( P: K! a* Nprocessor_group_name string9 }9 q1 Q5 S- `5 y4 ^
service_names string target
& z8 d3 Q* p( y' ^: r0 G: @7 l
( s6 r% O. q( z也可以通过v$instance视图查到SID是正确的
, A+ G# B( r) p6 a; m2 L( Y, f5 @& A
$ b, t5 g- W4 A# B' G' S* N! R: A' _SQL> select instance_name from v$instance;0 Z3 j) a" {% ?& O
) M' j. U5 ~, y9 V$ X( I8 p% ]
INSTANCE_NAME
8 B1 p6 b. b' G----------------
2 [9 a5 K+ M& i: b6 a( z; gstrmtarget8 v& C1 M) }: o+ Q8 `$ F
5 m% W W) @: \2 Q& x
难道就没有办法设置静态监听了吗？NO，这里还有一种方法就是手动修改listener.ora文件，添加以下几行内容
, e; S( Z: b, ]! j8 T
7 Y+ ^ k# p6 {( L& U9 DSID_LIST_LISTENER =
- L1 E9 o) }0 s' O6 l/ Y! p(SID_LIST = # M# Y4 Q0 H; k2 v; K) m' ?
(SID_DESC = & I3 F/ ~6 G& j$ t& S$ M7 g$ r1 A
(GLOBAL_DBNAME = target)' c6 S, `- m2 j, b) I
(SID_NAME = strmtarget)5 m- f4 _; f o
)9 j: n8 l; i0 A4 k4 j7 B
)
( O6 ^! h+ Y6 ?! l% v$ q8 I! _! _- T( m2 O
其作用就是配置一个实例静态监听，只不过用这里跳过了图形化界面修改而已，如果是用netmgr成功修改了实例的静态监听，也是会生成以上几行代码的
+ `; V- ^. Q: K( t; t6 L$ K# l% U3 N! ?% J+ x T4 n6 {
这里可以先把listener.ora用xftp工具拷贝出来，修改完再拷贝回相同位置即可
/ _3 ?- V& Z$ a: E0 H+ \4 j8 _9 r+ ^# }3 N
这里只需要重新加载一次监听就可以注册上实例了6 L* e6 Y/ J* n0 k0 q
3 l; G! m, R$ v6 e0 X+ u[oracle@adrep ~]$ lsnrctl reload
; f' _1 N# @, |, v
; y# g! c8 l& E/ U( [0 e( _& f
LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 14-SEP-2013 10:32:06 k8 m9 V8 E e4 v9 y( e
0 r+ h% O6 E. S, O6 C$ b
- J" L$ v% v# q, gCopyright (c) 1991, 2011, Oracle. All rights reserved.
/ o* @3 s; [2 ]/ a0 w$ g5 k7 Z
* L) `8 G: H9 L' |5 q6 ^0 B
' |/ e! {5 s( c; ]* r! z% H% bConnecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=adrep)(PORT=1521)))
5 O. Y6 C, K! B5 v9 C9 ]- z' wThe command completed successfully
$ g/ m, h( t1 \+ M5 T4 b[oracle@adrep ~]$ lsnrctl status0 v, b# j# v2 J0 J' W
+ v/ P8 G9 q L/ J7 ?/ W: p8 I' K
LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 14-SEP-2013 10:32:144 Z# |+ i) F- _2 S- V. A
$ Q d, H- k. {9 a! O' L9 C* R) d
. Q0 i% i8 s ]* g$ Q& @, Z4 [Copyright (c) 1991, 2011, Oracle. All rights reserved.6 }1 _! I" m/ c4 g7 b
( I* p5 F( J8 F& Q1 y/ N- w
2 o% F0 f8 B0 E! i9 z K
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=adrep)(PORT=1521)))
& @7 H1 E$ `3 Q# nSTATUS of the LISTENER d7 G4 \& [1 G! y& m
------------------------
! P4 c! x5 D Z- R% VAlias LISTENER( s9 O) P1 M+ r$ g' M
Version TNSLSNR for Linux: Version 11.2.0.3.0 - Production
X8 j# o2 S- Z1 V8 l8 nStart Date 14-SEP-2013 10:18:53
6 L7 O9 F4 D0 v6 q& vUptime 0 days 0 hr. 13 min. 21 sec
( S0 {$ p% q, u/ q1 jTrace Level off
I5 [3 E# O! VSecurity ON: Local OS Authentication. V2 m3 U9 k: a# K1 v* e
SNMP OFF \" L- c5 t6 m6 A! |( z: l: I
Listener Parameter File /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
: L4 T: b+ Y! eListener Log File /u01/app/oracle/diag/tnslsnr/adrep/listener/alert/log.xml
4 z8 a, @+ Y- \$ F0 I6 ?Listening Endpoints Summary...
/ r3 b! C7 w* s. A1 r3 i (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=adrep)(PORT=1521)))
. H( t1 ~6 ~" [( U+ [$ f: E (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
. X w8 W) H/ sServices Summary...
* I# M5 V$ J$ @" r* B; W6 _5 gService "target" has 1 instance(s).
9 A, \ Z4 j3 I1 e0 J/ o4 \1 Q6 w Instance "strmtarget", status UNKNOWN, has 1 handler(s) for this service...4 A4 I' z% b. K' y& G1 u
The command completed successfully
1 R" Q" ?! ^) H( S2 O- Y5 e[oracle@adrep ~]$
' o. Q& d. v* o" |$ B A6 ~! G9 [
+ M+ e4 n+ g/ k/ _' _这里target实例通过以上方法，成功地把实例注册上了，注意"UNKNOWN"就表示是静态注册的，如果是"READY"则表示是动态注册的
1 E& @! x' Q$ Q. L
5 [3 e/ O! v/ B; H. W% D注意：动态和静态监听可以共存，如：
. B9 `7 d, r) V* J: s- z. y6 Q& B% ~' K5 a) ]3 M* b5 f) Y
[oracle@zlm ~]$ lsnrctl status
2 q; e7 {& ^6 O
/ t4 W- v8 X* V4 V: m. y% e* V1 v6 z3 T$ [1 C! ?( e3 W: [& Y
LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 14-SEP-2013 09:52:23
9 o$ R- o9 H) ~8 v8 _. h1 m S- M- {4 h: {% O4 N" R: B" b
! t" R: Z3 h9 r& hCopyright (c) 1991, 2011, Oracle. All rights reserved.
: J& Y9 O% x) |' K, g! g+ Z/ e
( M5 S- t: s) p$ \8 A: ^. p/ x* y9 |. z: r: K( D3 R
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=zlm)(PORT=1521)))* ~; {) _3 w2 V( j
STATUS of the LISTENER
! H; C, K" H* N( H------------------------7 [/ G4 h f7 p) N
Alias LISTENER/ u' F9 w7 n/ v' z
Version TNSLSNR for Linux: Version 11.2.0.3.0 - Production7 `% b O3 r2 H( ]
Start Date 14-SEP-2013 09:15:04
( ~/ O: ?/ }6 f! W: G6 JUptime 0 days 0 hr. 37 min. 19 sec6 I9 x% X6 o' s p5 @, p, _" g
Trace Level off, r% ~" Z# E4 K
Security ON: Local OS Authentication
$ [* A4 i. t m OSNMP OFF8 p/ m- ?* r; E& @) p: F `
Listener Parameter File /u01/app/oracle/product/11.2.0/db_1/network/admin/listener.ora7 q9 _# @7 k; s- k- y
Listener Log File /u01/app/oracle/diag/tnslsnr/zlm/listener/alert/log.xml
$ z/ a( }) c# ~+ U3 aListening Endpoints Summary...7 F* z5 T/ N" j+ n7 i9 x& A% P
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=zlm)(PORT=1521)))
. ~( R# P: h- D( Z9 M) o (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))% C% x* ~4 F# \; K
Services Summary...
3 B" m- i+ U% J) [+ z% TService "zlm11g" has 2 instance(s).* C( b0 h6 P3 v7 O- y/ l& b ^
Instance "zlm11g", status UNKNOWN, has 1 handler(s) for this service...9 U( l* U4 Q, i; B+ u5 J2 }) |& o
Instance "zlm11g", status READY, has 1 handler(s) for this service...
5 W/ v0 l5 D8 ~: G% Y5 VService "zlm11gXDB" has 1 instance(s).9 F D- ~* F z& O
Instance "zlm11g", status READY, has 1 handler(s) for this service...# v! m. V4 t+ b# I2 a/ E
The command completed successfully9 K" F( `+ C% I/ b: j$ d4 a3 |
[oracle@zlm ~]$
4 V7 e. E+ Q2 K s0 C* A T
. @; D+ u: D# {3 B以上是我在zlm主机上的监听状态，可以发现，同时配置了动态和静态的监听. k/ h: a1 R4 y* Y! Q
& U1 X. X: q: ]! J. ^
总结：以上利用了手动修改配置静态监听的方法成功注册了Oracle实例，动态监听往往需要等实例启动后，过一段时间才会注册上，而静态监听则可以马上注册。而且一旦实例重启会造成动态监听暂时无效，有些版本的bug甚至会导致动态监听的注册就再也起不来了。所以我对于监听的观点是，尽量配置静态监听，这样就可以避免很多由监听带来的问题，诸如我们经常会碰到的几个ora error：ora-12541、ora-12514、ora-12154等，尤其是在RAC和DG中，一个监听的问题，往往会带来很大的麻烦，尤其需要引起大家的注意。
' v! H2 {/ T. e& ]1 n! e& _9 w |
|
发表于 2018-10-13 13:26:58