|
|
[oracle@adrep ~]$ lsnrctl start
3 P1 y; t" j# C) X8 y* Q2 O' ^: h7 m- R; L# f% R
3 @8 [4 ^4 Q: e$ LLSNRCTL for Linux: Version 11.2.0.3.0 - Production on 14-SEP-2013 10:11:38
2 R+ F$ d2 g& E
8 v" v1 I0 O3 |& t: _2 j/ W
5 Z# e" T: q/ z% I$ [$ g8 DCopyright (c) 1991, 2011, Oracle. All rights reserved.8 L8 b5 {' t8 O( L8 m7 }
3 l9 U, X# b* }
- ~8 D% G9 c6 K9 R# H& y8 {/ N. `Starting /u01/app/oracle/product/11.2.0/dbhome_1/bin/tnslsnr: please wait...
9 |* `, g5 T8 J7 T2 M; b
9 F3 V( F+ i: J+ h! i @
. v* f- l$ y) t7 j. C' O( h$ NTNSLSNR for Linux: Version 11.2.0.3.0 - Production
4 i& {( R# k' KSystem parameter file is /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
7 x3 p2 B: I8 `# YLog messages written to /u01/app/oracle/diag/tnslsnr/adrep/listener/alert/log.xml
& A! ]6 q9 E# nListening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=adrep)(PORT=1521)))
. x6 i: K8 p5 ^! h0 j; \; rListening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
3 H: W9 b- [: E I- b# O& L9 m6 J: j5 P' L
- X# e# b8 D# b% G5 V5 t4 c* L0 ~
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=adrep)(PORT=1521)))8 k2 I( P. f$ o& b% N9 Q
STATUS of the LISTENER
5 E. B7 Y# y- M4 N& E, q------------------------( }: W+ p1 `( _2 F, `& g# }) H, g
Alias LISTENER
5 }2 [! p' W/ A! wVersion TNSLSNR for Linux: Version 11.2.0.3.0 - Production
9 p- Q, U. T0 v) b4 n1 g1 M/ ?# z) WStart Date 14-SEP-2013 10:11:38. f- H5 g* M0 ]2 S# e% `9 X. A( d% X
Uptime 0 days 0 hr. 0 min. 0 sec; S9 o; y- s' }5 r9 r
Trace Level off y* p. s8 N5 A ^& C: D
Security ON: Local OS Authentication
' H0 ?8 ?( B: _; V: xSNMP OFF
! x6 [6 j! ~# F- L! ~Listener Parameter File /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
+ @. Q+ p& b" g- T Z, Z/ l. PListener Log File /u01/app/oracle/diag/tnslsnr/adrep/listener/alert/log.xml+ f' i9 ]! V! W P0 ]% c# J
Listening Endpoints Summary...
- q3 t4 d# Q' q: ? (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=adrep)(PORT=1521)))
- J4 Q8 E9 x+ M1 H& a6 [" y4 Q (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))- ?6 O2 w% v( Y4 q/ J+ {
The listener supports no services
; Z8 K2 @/ o! n; GThe command completed successfully
) \# V8 K; S( p% `# m由于这台主机之前做的是stream实验，修改了一下hostname，之前的监听和服务名也用netca重新配置过了，但是启动监听一致是这个状态，动态监听注册不上* I% f0 b0 \$ U2 q% H, d
) Y. P/ a$ Y+ a6 j: [# T, w: L本地登录到Oracle实例，手动注册实例也无果，问题依旧
; v2 L6 N6 i, w1 d$ [& G( ]& t9 I. z( o6 Z2 B7 f
SQL> alter system register;
8 D' W7 \3 D& g# S" a/ J- Z( K, f: _: p$ ?. h( X6 m
2 N* [! o4 W; c( D( @( q" h7 ASystem altered.
0 {/ F) Q# a _3 ], [) h0 ]- d" k% a0 q
' j0 ~) F- w; t2 USQL> !
( U+ u; x0 C) J* J0 ?; G[oracle@adrep ~]$ lsnrctl status
5 f! P N" i; X! u3 m: C$ U0 m) m% r9 \2 s, D1 n( x
+ `) m: |9 g8 v# H, _- |4 Q
LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 14-SEP-2013 10:13:03- Y( H: T0 w( ^' L6 K* x6 O& s
2 M( |9 l- ?% H: I+ n! M6 w7 p
# S$ {3 d" ^% ?' F* U) oCopyright (c) 1991, 2011, Oracle. All rights reserved." F' H! E- ?+ e& P' B. W0 h4 d
4 [+ |$ L$ E. x& \2 F; {/ V
% t/ s) j! x9 QConnecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=adrep)(PORT=1521)))' Y* H1 }1 ~* K: [) h1 P- X! h, M' F9 }. @
STATUS of the LISTENER
0 @5 O% O) s+ Q6 h! ]( w! Y2 n------------------------4 u9 ?: M) ]+ i; m- t' `' I$ N
Alias LISTENER
: A& ~6 X. d3 S, n+ [* @3 nVersion TNSLSNR for Linux: Version 11.2.0.3.0 - Production. e9 v' u9 u& E* O! E
Start Date 14-SEP-2013 10:11:389 v* p B4 s/ a9 Y4 h
Uptime 0 days 0 hr. 1 min. 25 sec: x* |- b, {$ M. p2 [5 ?
Trace Level off
; ?* d( |0 d7 ]# y [( ~Security ON: Local OS Authentication
9 z! ~& C e: I2 h4 LSNMP OFF3 T. n/ x& M6 L- M- R3 c
Listener Parameter File /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora- Z( |' b' u9 j, Z; k( A# Z/ R
Listener Log File /u01/app/oracle/diag/tnslsnr/adrep/listener/alert/log.xml8 _$ |) B. \2 x8 c' w) H7 G
Listening Endpoints Summary...$ S, j D1 d' B- K2 G
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=adrep)(PORT=1521)))' M# E! i" M& S0 Q' a& P
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))2 [5 ~$ x# F# F6 v5 i
The listener supports no services- u' y# e/ o7 O$ G
The command completed successfully
1 V$ y5 w9 ^' y% v; c& I0 w
3 N# I7 ^9 P. d! q$ y[oracle@adrep ~]$ lsnrctl reload
/ m7 x6 v0 l( C* i& V6 i/ } Listener Log File /u01/app/4 `: ~4 x5 W8 j) o3 G' O
4 T5 x1 q' p$ X2 v! V8 l, }5 X$ G' ]: \9 [6 M5 j
LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 14-SEP-2013 10:16:13$ Q. m" G8 g0 m0 ^- v2 A: B
: V' ^7 W' s1 p1 X& U# H
/ J w7 X+ p, T+ yCopyright (c) 1991, 2011, Oracle. All rights reserved.) `: q$ V" Y4 {4 u( e* _
) {. y7 J, i) o: X; ?" S# m$ F
# S: c2 K5 Y2 ]* p; x X% A8 T9 X
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=adrep)(PORT=1521)))
4 |" M- @% e4 d* o6 }The command completed successfully0 a3 T5 o4 o: ?4 B, o; R
[oracle@adrep ~]$ lsnrctl status
! C( n9 J8 @# r
# U- u, f3 {$ {
) D# p/ s! O* Y$ D v9 R6 TLSNRCTL for Linux: Version 11.2.0.3.0 - Production on 14-SEP-2013 10:13:18
0 B" d! B: r8 Z6 n- G1 ~- n0 F3 M; }8 U* i N. G" l
! A/ q" @2 C' N- SCopyright (c) 1991, 2011, Oracle. All rights reserved.
0 x: W4 D2 S9 d/ h1 [- U( u) B- P
1 u/ d9 g3 K8 C: O2 A9 {' iConnecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=adrep)(PORT=1521)))7 u# D6 P3 Z7 `5 H1 l2 M6 l: Q
STATUS of the LISTENER
- J0 J9 p( L* E# ~! K------------------------
, y9 r5 ~/ j! qAlias LISTENER
3 Y( A, \4 s& F j$ _* sVersion TNSLSNR for Linux: Version 11.2.0.3.0 - Production. i% D7 |0 s9 y% {! f j' C
Start Date 14-SEP-2013 10:11:38# c" m% O. E9 \
Uptime 0 days 0 hr. 1 min. 40 sec
& ^* |% k' r( rTrace Level off
8 H- D4 r- K( |/ I$ ^2 }Security ON: Local OS Authentication
3 ?+ M8 S# d4 XSNMP OFF Q/ B. c0 D* F, k# b( y7 K
Listener Parameter File /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
- p/ u: d: E9 u& H! v4 q( ^Listener Log File /u01/app/oracle/diag/tnslsnr/adrep/listener/alert/log.xml/ C3 e8 L/ t1 C: Q6 c9 M, Q
Listening Endpoints Summary...+ N' c) d7 L# D5 e% d
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=adrep)(PORT=1521)))
( U+ W4 k9 c. R% n% j/ A- O8 Z (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))+ m/ \8 ~; S! N2 M
The listener supports no services
! i& Y) w& j3 g2 _ q/ [6 HThe command completed successfully
0 u1 x" \+ {: o# i+ S" [ B1 q[oracle@adrep ~]$ lsnrctl stop' K; |& ~, E' l9 M# u
~+ ]) a7 n# M" H3 {2 _! z0 C4 H! `" [ x R& o7 b
& m, T% Y0 ~* t% t" o: l, b/ f
LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 14-SEP-2013 10:17:03/ `8 `8 L0 u: A, ]0 W& v. z( X
, C0 L% R w" ]6 i
2 M; F% d( G1 d$ p- @Copyright (c) 1991, 2011, Oracle. All rights reserved.
9 _' \* J, j% b% j/ ?% L G
- [) a o' i3 N o6 E( O+ ]8 Y! h" i* S0 l- ~: d8 E: A
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=adrep)(PORT=1521)))
. s6 J' F) M" m1 ?: b; pThe command completed successfully
" G- \* q% I0 ~8 Q: k6 Q; N" q: w% v8 T% D1 I& h: s- e
[oracle@adrep ~]$ lsnrctl start: j* d8 H6 t# D+ Z& L: t
# H5 n6 Y3 t! }& @/ _5 a5 n7 B' |2 J9 g% q, p/ B
LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 14-SEP-2013 10:18:539 N4 Q+ u/ C: A9 O0 H) i) W9 s
' Y' R) O% k, J5 ?! O
. m% w4 W! ]3 v9 Q( L3 CCopyright (c) 1991, 2011, Oracle. All rights reserved.9 c5 g0 ?# [. b. W2 F
4 S# V, }5 n3 Y' M' c: |; }
5 k7 G2 O8 z5 p% J) U, cStarting /u01/app/oracle/product/11.2.0/dbhome_1/bin/tnslsnr: please wait...
* H2 `& A3 G# k. _ O0 L0 Q# ]$ } M$ w2 Y& ^, Z& B
' O2 X, o- D4 `: F7 n
TNSLSNR for Linux: Version 11.2.0.3.0 - Production
: f# o6 j6 S: P/ dSystem parameter file is /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora. D7 P9 N* s; Y+ A0 f" d
Log messages written to /u01/app/oracle/diag/tnslsnr/adrep/listener/alert/log.xml: T! L$ O) D4 c9 ` n D v
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=adrep)(PORT=1521)))5 Q# l5 T" Z. N! m: N5 |
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
& t" j( @5 X0 l3 O! |& u4 z5 p7 G/ K$ S8 |$ m @4 y4 {
. h8 D7 O0 ]6 u; z
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=adrep)(PORT=1521)))
5 b, X/ a2 L$ r4 pSTATUS of the LISTENER
# `" e4 D( k1 A. v9 V1 T------------------------# \* n* h4 n; s3 P% P% X6 D' {
Alias LISTENER' ~8 `: n' L* }
Version TNSLSNR for Linux: Version 11.2.0.3.0 - Production8 @# [3 N0 p Y6 d5 h8 \0 p5 d
Start Date 14-SEP-2013 10:18:538 e9 U: \ M0 V. g1 x$ L+ i4 x
Uptime 0 days 0 hr. 0 min. 0 sec
9 I2 z+ B2 K! {- J# XTrace Level off3 t3 a+ |: Z; T) E
Security ON: Local OS Authentication; p/ K1 O# m" U1 z7 }6 v
SNMP OFF
8 ~& O1 X8 X0 ^( }# fListener Parameter File /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
3 P, A5 D, L/ o, r0 |) H: sListener Log File /u01/app/oracle/diag/tnslsnr/adrep/listener/alert/log.xml3 Z* [4 h! u4 C3 x
Listening Endpoints Summary...
( y ?/ n5 N" ?" `; |- A0 B2 U2 h (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=adrep)(PORT=1521)))) R" y! P3 a- S8 Y1 }
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))% B. ~. F$ S5 ]% ~; K4 D7 O
The listener supports no services
4 N& b6 U) c# `1 L8 i, W% _The command completed successfully
3 s+ k$ d4 w2 ]) W# W7 t7 ?[oracle@adrep ~]$
' W) O. X) h# `* R S% w p3 I5 l
8 Y h2 e! a, i7 D4 u于是考虑通过mgr配置静态监听，但是让我郁闷的是，总是提示需要输入一个合法的SID
7 Z7 u3 z3 {. Y! |- p7 n4 _
! k6 N! S5 v4 }/ ~$ s/ N
$ O4 O; P& V5 {# w' v- {" A) m( l! k5 V3 R* f
这个SID绝对是strmtarget没错的，global name即service name也确实是target，这个可以由以下参数获得佐证
/ H# x) d& K) \; ~1 |8 X5 y+ Z8 [( u$ c# X8 |2 s9 \" T
SQL> show parameter name
, F3 ]& L6 ~1 n% ~/ B5 |( ^
3 d$ H3 B. v% `2 {6 A6 T6 J/ q( b @' F/ k& w/ h& y
NAME TYPE VALUE
# P/ t. n" s9 S& b, x------------------------------------ ----------- ------------------------------4 W, o( y0 l' q% M4 q
db_file_name_convert string
2 W! k5 J% o& ^- Y; mdb_name string strmtarg
+ ?5 }# X6 S0 fdb_unique_name string strmtarget
" B5 M4 I+ M9 U2 gglobal_names boolean TRUE
1 q& L Y% I. ]2 V; jinstance_name string strmtarget
! {: h% B; W m4 ?6 ~# Ilock_name_space string+ X+ M9 p1 q# }$ Q9 F! }
log_file_name_convert string
9 H% u4 M8 e4 W$ Sprocessor_group_name string; T l0 @2 S6 l
service_names string target
+ `* S% w. n. H
' w! o/ U8 q B' F0 `0 ^! C4 a也可以通过v$instance视图查到SID是正确的
! W1 H# j0 I6 q7 T, r) ^5 J9 ]! X6 @- ?3 s% j7 _; U/ T0 O
SQL> select instance_name from v$instance;
, k7 L4 P# i! Y: G+ F$ ~6 R* l8 h$ V
INSTANCE_NAME5 L! I0 X! a+ f8 E# `6 X# `0 A
----------------
- X5 G3 B3 c2 Fstrmtarget4 W0 c! W! Y6 k7 O+ k3 x
: K" v& U5 L7 T% Y# Z! }) g9 F: S
难道就没有办法设置静态监听了吗？NO，这里还有一种方法就是手动修改listener.ora文件，添加以下几行内容
8 N, u/ i* `6 k" Y* z4 h' o* i4 b+ z
SID_LIST_LISTENER =
" N6 M& @7 d8 t* T' ^(SID_LIST = $ \7 H3 f' y% |4 Y
(SID_DESC = $ G( T, u) ~/ _. U0 \1 v q
(GLOBAL_DBNAME = target)$ T) }9 I" g5 X
(SID_NAME = strmtarget)# w+ i$ G3 J% \: ]8 h# i
)- O0 K& u0 o- _! [( R5 C( X
)( F2 l6 n1 _9 K& q
7 g9 L+ d e/ J* r1 v% |/ x5 U; b9 r/ T其作用就是配置一个实例静态监听，只不过用这里跳过了图形化界面修改而已，如果是用netmgr成功修改了实例的静态监听，也是会生成以上几行代码的$ C: F/ [$ L) A: u2 v
6 Q/ M6 l+ ^9 M( B2 Z
这里可以先把listener.ora用xftp工具拷贝出来，修改完再拷贝回相同位置即可0 [5 j9 w! W* M- U5 d+ u: u
& B' b% Q9 q8 [2 L$ Y+ a
这里只需要重新加载一次监听就可以注册上实例了! [2 r& |# a' }
% q* e2 ^' V: ]6 s
[oracle@adrep ~]$ lsnrctl reload
0 n! B( C) c/ \. j" G: X( c
# T2 a4 ]7 }5 E# d# y0 X# |
& [) X9 [4 @( w! L! DLSNRCTL for Linux: Version 11.2.0.3.0 - Production on 14-SEP-2013 10:32:06
7 Y) T* b, U* |3 u0 T1 K) ^
9 I1 {. V3 T1 K9 U1 ~7 j5 q
& ?* p( V) y# L3 C( B, RCopyright (c) 1991, 2011, Oracle. All rights reserved.
3 H" Y! R4 _8 R$ i6 M
7 N2 ^1 a/ f$ L' g( _3 t! R4 j2 V; }: q
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=adrep)(PORT=1521)))
( J( J1 e' F- R8 l& [# s) nThe command completed successfully: Q( W. m% v5 i1 d3 ?
[oracle@adrep ~]$ lsnrctl status( K8 l+ z9 [7 r* B) q9 _. p4 K
8 f( H! e# E: I- S0 P6 T
, K! v+ l' `, P: R- `3 ?) Q; BLSNRCTL for Linux: Version 11.2.0.3.0 - Production on 14-SEP-2013 10:32:14# B W+ M! G! Q5 M, c1 U
7 [4 ]2 ^! ^9 H8 z: |
' H% g" g, W. m8 q% z# cCopyright (c) 1991, 2011, Oracle. All rights reserved.
2 Z* ]( v1 {6 Q0 S& }
6 o( K( _# ?6 l! \; E8 D3 v& ?& j+ D/ [! _0 m; W" h
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=adrep)(PORT=1521)))
* ]# a4 G8 i: QSTATUS of the LISTENER. f' |/ s& F! ^+ p+ e# f. N: I
------------------------: k. i. Z: B1 v
Alias LISTENER1 V! R0 `; ?% W8 V8 L
Version TNSLSNR for Linux: Version 11.2.0.3.0 - Production
5 y9 x6 d3 L9 r' S8 i) UStart Date 14-SEP-2013 10:18:537 L/ i/ l" a) q8 o7 {# ?& O
Uptime 0 days 0 hr. 13 min. 21 sec S2 x- d( G( P$ `, f8 o# a5 V
Trace Level off
/ {8 j. ~% I; L1 g8 u; {Security ON: Local OS Authentication, a$ ]" n4 I6 o0 g. B8 h
SNMP OFF
8 L# y( C0 I. N* |Listener Parameter File /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora+ N+ \* Y, W; D6 U- M
Listener Log File /u01/app/oracle/diag/tnslsnr/adrep/listener/alert/log.xml
- f3 [* c4 m; E3 i I; [) h* I9 ]/ Z' aListening Endpoints Summary...! U; K2 [9 {: R
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=adrep)(PORT=1521)))
: j/ {8 `5 E* | (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
' j$ W! C Y0 z8 ~/ B; zServices Summary... {6 K A6 f0 a" i" _9 j
Service "target" has 1 instance(s).% |+ @9 N1 A& v8 F
Instance "strmtarget", status UNKNOWN, has 1 handler(s) for this service...' B" F' u4 `5 {: q5 c; _2 C
The command completed successfully6 ~- S$ d( S/ O% B. h
[oracle@adrep ~]$ , Z8 S6 K, X; }7 x$ M+ p8 h
% o9 Y- U6 h2 i8 D8 \这里target实例通过以上方法，成功地把实例注册上了，注意"UNKNOWN"就表示是静态注册的，如果是"READY"则表示是动态注册的
3 r7 \8 ^* G: ^* s$ w& m) m" N3 u* ]) A
注意：动态和静态监听可以共存，如：
$ j/ X6 V' o4 U, F3 ^; i5 `" K; s- ^6 {4 E- o
[oracle@zlm ~]$ lsnrctl status
0 j& s: x; D$ X
6 K' f: w/ T5 Y9 p! [( l
: h' H- H( w# B/ W! w# d7 Y* WLSNRCTL for Linux: Version 11.2.0.3.0 - Production on 14-SEP-2013 09:52:23# q; `7 d' i3 b6 u' ]* f
9 z3 d J* i& Z: Z/ e& R0 F
% K( v+ u( |: _' b
Copyright (c) 1991, 2011, Oracle. All rights reserved.
+ a0 S; b. g6 D& h& a( n$ ?1 `' h7 ^8 F8 S% ^+ q3 m/ @. [5 O5 e
% A& c) J6 K$ h+ i
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=zlm)(PORT=1521)))
3 k- Y- k: r& {9 V! oSTATUS of the LISTENER& H# M& z$ Z3 G, i
------------------------2 A+ G/ [% ]( T/ P4 X9 E, H
Alias LISTENER, K% H' ~ X/ H7 Q# r& Y5 r
Version TNSLSNR for Linux: Version 11.2.0.3.0 - Production3 a- o) Y2 ^& e) a o# b6 e
Start Date 14-SEP-2013 09:15:04
; p5 [/ ^- u9 r- D2 Z5 G; TUptime 0 days 0 hr. 37 min. 19 sec
* M# ^' x4 j9 FTrace Level off
( u6 W& d- a) q& R- N# @5 E: zSecurity ON: Local OS Authentication6 W4 P. t/ a. t% C
SNMP OFF
2 t: [. N# u3 i; s! gListener Parameter File /u01/app/oracle/product/11.2.0/db_1/network/admin/listener.ora
) f; [- s% h* q- W1 J5 `Listener Log File /u01/app/oracle/diag/tnslsnr/zlm/listener/alert/log.xml+ Q6 \6 u/ K9 o4 i9 E. u+ g' O
Listening Endpoints Summary...
) U! V$ @. w8 P; m7 h (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=zlm)(PORT=1521)))
6 _+ z* O( V4 Z2 {" d (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))- v2 u, @) ?1 v+ h4 Z' I
Services Summary...7 h7 v& `- C+ L& H4 i$ }: M; s2 I
Service "zlm11g" has 2 instance(s).
7 W% U, F t- B% S% F' ] Instance "zlm11g", status UNKNOWN, has 1 handler(s) for this service.... `$ Y ]6 h; ~/ _' v; p; P
Instance "zlm11g", status READY, has 1 handler(s) for this service...
; }3 j! T, a' Y' C# G6 E+ NService "zlm11gXDB" has 1 instance(s).
* W; j* S7 l9 k Instance "zlm11g", status READY, has 1 handler(s) for this service...
* J* O2 b6 Z9 MThe command completed successfully
+ X6 K, Z2 w4 F! N2 Q9 ][oracle@zlm ~]$
% s3 z1 n, ^7 j! k4 l1 @' @4 p q% ^9 p- P( N. Y- q% w% A
以上是我在zlm主机上的监听状态，可以发现，同时配置了动态和静态的监听
( [' w' Q' Q) j( s8 \8 O0 }4 O/ b: I7 Y3 @/ Y1 x
总结：以上利用了手动修改配置静态监听的方法成功注册了Oracle实例，动态监听往往需要等实例启动后，过一段时间才会注册上，而静态监听则可以马上注册。而且一旦实例重启会造成动态监听暂时无效，有些版本的bug甚至会导致动态监听的注册就再也起不来了。所以我对于监听的观点是，尽量配置静态监听，这样就可以避免很多由监听带来的问题，诸如我们经常会碰到的几个ora error：ora-12541、ora-12514、ora-12154等，尤其是在RAC和DG中，一个监听的问题，往往会带来很大的麻烦，尤其需要引起大家的注意。, F% N# w7 ]; P6 e. Q% Q
|
|
发表于 2018-10-13 13:26:58