|
|
[oracle@adrep ~]$ lsnrctl start2 F+ J1 e( C8 R) A3 U3 a# w
/ s6 ]- @/ v2 T7 n
2 E9 J( Z& m0 s% D* J5 S A
LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 14-SEP-2013 10:11:38& O* s+ j* w; X8 w0 o8 _1 y
/ z, a* P F1 S4 V9 j w; b6 T. A% A- `& P" u# z
Copyright (c) 1991, 2011, Oracle. All rights reserved.
$ ]5 w q9 ~1 C+ M
: k% u2 u$ Y: x0 j9 x. B {
% h7 v+ h4 A7 j k2 iStarting /u01/app/oracle/product/11.2.0/dbhome_1/bin/tnslsnr: please wait...- z6 r7 v% `9 U8 j/ {6 t% f
( ~4 b E8 @3 ~; G- f
/ { x2 e8 B# J* rTNSLSNR for Linux: Version 11.2.0.3.0 - Production
4 J% {) Y0 K+ I& a9 b }System parameter file is /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora1 U8 v: m f5 g# {5 D
Log messages written to /u01/app/oracle/diag/tnslsnr/adrep/listener/alert/log.xml
3 B! A3 I. {# B' aListening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=adrep)(PORT=1521)))6 `$ m+ J2 o% f S
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
3 B1 E0 E2 {; O( B( ^. i; V+ n, z
% p7 S$ H4 L) a0 h" ~: P6 J% b
: L7 ]- B0 w9 w: pConnecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=adrep)(PORT=1521)))
* e$ h' _7 ~: S" G# p; P, _STATUS of the LISTENER, r: Z) W1 \5 ]
------------------------' s' V- O7 ]# v/ {5 @
Alias LISTENER3 N; f" r: P3 D! ]' L7 M9 D* K
Version TNSLSNR for Linux: Version 11.2.0.3.0 - Production% t. I* D6 r! } ^8 N* ~; M4 h
Start Date 14-SEP-2013 10:11:38
6 @) }$ o% B% i6 L8 s* tUptime 0 days 0 hr. 0 min. 0 sec4 w( k6 G* J+ V" _7 C
Trace Level off
0 `0 ~) N& i9 s0 DSecurity ON: Local OS Authentication! n$ h! K. Q5 Q/ w
SNMP OFF8 F& m1 F( E; \) b3 U. g
Listener Parameter File /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora" n' \3 J* w a' ` W3 Z: V$ j4 \
Listener Log File /u01/app/oracle/diag/tnslsnr/adrep/listener/alert/log.xml
8 p" P+ D5 u; y$ u! YListening Endpoints Summary..., N; {: M0 I, t! D
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=adrep)(PORT=1521)))& b9 {9 k" |6 [9 t
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
& R' |1 ?* Q) S3 w( O GThe listener supports no services
( L" Q/ c, |3 q8 NThe command completed successfully
! z- a) r* I! `/ q) Y. p2 U# a由于这台主机之前做的是stream实验，修改了一下hostname，之前的监听和服务名也用netca重新配置过了，但是启动监听一致是这个状态，动态监听注册不上
& b+ Y$ B6 O5 u8 K8 S; r/ `+ k( ^1 H
本地登录到Oracle实例，手动注册实例也无果，问题依旧
" B$ j) d Y! d% A# T2 o- E* F7 q7 W: B. y0 a% W
SQL> alter system register;
' y$ h6 k% Y. X6 H: }& v8 k: s' v/ o8 d0 K- G E/ q* O
! R! n# ~& L8 y0 W1 Z) I+ TSystem altered.- ^2 f W; X. f
$ w9 @# [1 p' m2 j
) z/ \, f7 |, z/ G+ p
SQL> !
% v& c, p6 \) B. }( ~[oracle@adrep ~]$ lsnrctl status
- \0 |8 M0 M9 u, [; q0 F+ h- Z" z% W3 Z6 j# {9 K( {( J) m
7 [% W) g3 I7 uLSNRCTL for Linux: Version 11.2.0.3.0 - Production on 14-SEP-2013 10:13:03
0 U0 o# @8 I1 U# c( ]3 \8 h
# g* N9 ]6 T/ @& w' n3 k$ M j" `% g4 Q8 ~( y8 B! v; x
Copyright (c) 1991, 2011, Oracle. All rights reserved. k/ o: e1 X: Z7 l! N
, Q7 k U+ l% h: }
. Z8 H9 {6 a; m5 z1 |! E
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=adrep)(PORT=1521)))/ B, m! T4 Z! w' H! j
STATUS of the LISTENER
& F+ @9 f ~: k3 [$ r------------------------* n2 M1 b* d8 }, J6 Q( ^
Alias LISTENER/ [, Z' n1 b1 K% y! j) _7 v2 Y
Version TNSLSNR for Linux: Version 11.2.0.3.0 - Production
9 b9 {% u2 `! _& l. t. f5 VStart Date 14-SEP-2013 10:11:38. @8 e% g; n @% b7 i, f8 A1 b
Uptime 0 days 0 hr. 1 min. 25 sec
& B; c- I! p9 MTrace Level off# o; k" K* ?: U; F8 q$ l
Security ON: Local OS Authentication
+ f5 _+ z$ E: I2 ?( O7 s% rSNMP OFF
9 R: t" J" G6 lListener Parameter File /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora0 `2 x2 T J$ V% c
Listener Log File /u01/app/oracle/diag/tnslsnr/adrep/listener/alert/log.xml
- h; E8 i9 [8 @( z: s XListening Endpoints Summary...
# s) v7 L2 q( S) W/ j3 X (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=adrep)(PORT=1521)))5 f2 P8 I* c5 Z; o7 t3 b' s! j
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))* D1 Q1 L- F, b8 Y, _( u% y
The listener supports no services
: V' b, d- q" g8 k& UThe command completed successfully
) c7 l: \8 N; M h( d" V9 V/ F6 m8 G) g5 t; J
[oracle@adrep ~]$ lsnrctl reload) L4 V) q+ Z% U6 p# I l
Listener Log File /u01/app/
4 h6 g7 l, k! k7 L" L( q- A
3 _# r$ S3 b9 {% I3 a9 b+ A' V3 @# g; e, p# w
LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 14-SEP-2013 10:16:13: l! A0 ]* t: n0 D2 u
+ j9 E( S T4 p" Z3 w4 D8 Y q! C# S" W, _3 C
Copyright (c) 1991, 2011, Oracle. All rights reserved.( B+ T# f2 j4 S5 V3 {
) d* z/ h% |1 u. A2 \, h
3 H" E* V" F, s! mConnecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=adrep)(PORT=1521)))9 n$ k5 N1 t* |/ Z$ ]
The command completed successfully
: ^# Y% ~- T# Q5 e2 P[oracle@adrep ~]$ lsnrctl status& u5 w1 Y; K$ t# m1 o$ x
* j8 \4 S6 e9 E' ~4 r
; M- U1 G0 n# W, nLSNRCTL for Linux: Version 11.2.0.3.0 - Production on 14-SEP-2013 10:13:18
[. B) w @: a$ O4 p3 j# [
) M* T" m9 E t4 t6 F; y5 c5 C/ Y* R" C0 ?5 ~4 \/ n. Y& W
Copyright (c) 1991, 2011, Oracle. All rights reserved.
& K B% Q3 M) b7 \& j) e: W, g. K* h @1 J2 C3 x H
" i5 P M) u' u9 B; bConnecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=adrep)(PORT=1521)))2 i; K5 o$ X: W% V) B' d
STATUS of the LISTENER
, G) c7 V; U, n/ R. {( _ E------------------------
% I$ i2 o5 a zAlias LISTENER
1 z2 B* [: G$ }" j" WVersion TNSLSNR for Linux: Version 11.2.0.3.0 - Production4 H, A5 `( [" X1 O. l- E4 [
Start Date 14-SEP-2013 10:11:38$ n& G& T7 T7 P( N
Uptime 0 days 0 hr. 1 min. 40 sec
& d/ T3 @2 ~. j5 QTrace Level off
* {4 ^/ M5 V5 L! s/ m( A% L# OSecurity ON: Local OS Authentication& L8 b- Y4 L7 _# C7 y0 J
SNMP OFF8 c0 `- [- b& A) d
Listener Parameter File /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
3 s9 o; {9 s( u; b' hListener Log File /u01/app/oracle/diag/tnslsnr/adrep/listener/alert/log.xml1 ?& N6 A4 z/ G# Q/ i" H
Listening Endpoints Summary..." k5 m$ c" X ^
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=adrep)(PORT=1521))). {3 h5 p B$ n5 p
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
. u: e+ ]! f# x! Y& H; C4 e. QThe listener supports no services
1 N5 ~3 M7 M6 W" G0 Q: kThe command completed successfully, x/ a& j2 Z9 c
[oracle@adrep ~]$ lsnrctl stop0 t& g! y7 I& G; @
% U8 Y7 k5 q' K; S! @" z
$ ~9 a$ G+ I6 a; r& v1 {# Z* N
, a* |2 v/ o3 }9 ?/ q, F- M2 _/ _LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 14-SEP-2013 10:17:03
* G A1 n7 B+ Q4 s" g; R! g6 y5 F& ]+ ^2 k) Y2 r; t' k
6 z6 K9 o! ?1 h) R, R
Copyright (c) 1991, 2011, Oracle. All rights reserved.
! M0 V3 \4 l C# x
( E; B. r* H+ O, N* ^& h- P
. q* ]# t0 t/ X/ x9 ZConnecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=adrep)(PORT=1521)))
3 t" \8 q' N# w" r) A$ h+ S' zThe command completed successfully: @, [- V- `/ K' e7 Y
, ^, t! N! S& u9 A8 j# J
[oracle@adrep ~]$ lsnrctl start
( b3 ^8 O* z. }: A7 v# L& G/ V
7 |. }$ y! U- |% h) b q$ K3 p: p6 U3 {1 j" O5 h2 n+ l7 q3 z9 H
LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 14-SEP-2013 10:18:53
0 D( w1 x2 S5 l. z, }. H' N% _3 b. T$ t
; |. W+ N6 r. [6 i; f7 D1 ]
Copyright (c) 1991, 2011, Oracle. All rights reserved.
8 Y+ h7 t9 n$ B t( g; g5 _0 G0 o. @' W
3 P% |3 C" I `# p) s
Starting /u01/app/oracle/product/11.2.0/dbhome_1/bin/tnslsnr: please wait...
, i! [; R, x& A: u: O; s8 S* d/ L* B5 m( ?
& i) j0 Z+ |; G8 b, d) LTNSLSNR for Linux: Version 11.2.0.3.0 - Production
6 s: W; j' L Z( ]3 [System parameter file is /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
* d! B2 u& N& F- Y1 Y5 _! _Log messages written to /u01/app/oracle/diag/tnslsnr/adrep/listener/alert/log.xml
$ S0 ~9 ^& b# p/ O8 v( H; K, HListening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=adrep)(PORT=1521)))
1 T4 Y; F2 y/ `Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))+ N+ H; L! t" c- g* R
' N! s! @+ t3 x L2 a1 V
; e' c- H) O/ A& m7 G( `$ P6 x* C; eConnecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=adrep)(PORT=1521)))
$ M0 ]0 T; K U9 E, ~STATUS of the LISTENER% ~7 `' j6 f, b7 F/ p* s2 |
------------------------
, j2 ]& B% l# d4 l5 oAlias LISTENER; t/ g5 ^# `4 R+ G1 `) Q+ r
Version TNSLSNR for Linux: Version 11.2.0.3.0 - Production* w; F w! z- S
Start Date 14-SEP-2013 10:18:533 K8 C- r7 m' R$ j* R# \
Uptime 0 days 0 hr. 0 min. 0 sec
; `/ g$ q& \ Z) M( Q e0 u2 v% H. vTrace Level off& N4 l# G9 j7 b/ z0 B2 }5 _
Security ON: Local OS Authentication
' W# V# F: _ ], {/ |' KSNMP OFF. n; {) s! t* d6 @
Listener Parameter File /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
; n7 c$ u/ g6 ~- ZListener Log File /u01/app/oracle/diag/tnslsnr/adrep/listener/alert/log.xml4 _; \. J- M* b
Listening Endpoints Summary...
* T; I- t! V& W4 ] (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=adrep)(PORT=1521)))8 C" G" I" s' A$ e% V
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))$ C. z& o% h' @- X H
The listener supports no services
' Q3 b3 K; H+ s0 C8 a" U* ]The command completed successfully
- T# |+ w0 @# u8 i/ ^& y* l" Q[oracle@adrep ~]$ " Y2 n9 e0 ^* Q
! G1 h2 Q# o" [2 P, @
于是考虑通过mgr配置静态监听，但是让我郁闷的是，总是提示需要输入一个合法的SID
& S0 F1 I" v" i9 |7 t- X3 a i* n ]2 y" W- k; A
6 _8 M- \2 s, ^1 d0 X8 [7 X, G! z8 _) h5 Y+ y
这个SID绝对是strmtarget没错的，global name即service name也确实是target，这个可以由以下参数获得佐证
0 b" Y4 k3 j/ b9 u1 N8 f) v* w9 T( e; v% K! C2 o$ H0 k
SQL> show parameter name
) y# u& ]. g* i! W; }
) h5 S, j7 H$ a! S5 S" V, {
) I% E. O0 y' H; C# {$ \NAME TYPE VALUE9 A4 X5 @9 Z! N0 d' I8 h, N
------------------------------------ ----------- ------------------------------6 r5 y4 T. B/ p/ h: j/ L
db_file_name_convert string
7 O v% d1 x3 b- Gdb_name string strmtarg
6 h; h9 J( {& U" _' ddb_unique_name string strmtarget* n- f9 j+ p( _. h' w/ N- \3 l
global_names boolean TRUE
4 Y) j1 U* m8 d1 S, Ginstance_name string strmtarget
& i$ ~; B0 Q0 ]7 `+ y% Hlock_name_space string4 A9 `7 @' j$ j
log_file_name_convert string
- X$ s U+ K: qprocessor_group_name string
& j5 m/ j' I R* X+ w) y; O6 Fservice_names string target- q. F) c: H [3 }; L
$ u% K' u3 Y! F3 b( {也可以通过v$instance视图查到SID是正确的, K8 ]+ d+ i; A4 B8 o
& m( x3 F( t7 E: L2 s& |. l
SQL> select instance_name from v$instance;, f. X+ e( y! z* r1 w d
( h) S8 M) y: {3 c4 T8 Z+ C
INSTANCE_NAME Q+ X: H) Z9 _7 U7 F( m6 `( E
----------------: p0 ]" O* l9 F1 ~: E/ [
strmtarget
( ~9 ?! f. ^7 C2 U4 ^' z
, Y2 l* ~% |4 J0 M$ p难道就没有办法设置静态监听了吗？NO，这里还有一种方法就是手动修改listener.ora文件，添加以下几行内容/ x- j2 @& ~, ^
- L0 `7 m& m$ H$ J, o" K \% ~
SID_LIST_LISTENER = * f/ C5 z8 z, g7 b: \/ E0 I; u# M
(SID_LIST =
; N/ v& z' l3 ]* m (SID_DESC = 2 \% U" C4 @% t
(GLOBAL_DBNAME = target)/ L. [5 I9 h% ^# d8 e
(SID_NAME = strmtarget)
4 j9 w4 H! p/ c/ | )
" o z/ c7 }5 A)
0 Y' y' e! f. F; F& z6 e7 y
1 @* `3 u2 f6 Y0 n! K其作用就是配置一个实例静态监听，只不过用这里跳过了图形化界面修改而已，如果是用netmgr成功修改了实例的静态监听，也是会生成以上几行代码的" w4 _% X6 N# @/ R: u
" D$ Q0 Y# F$ Y7 }8 C8 P& E
这里可以先把listener.ora用xftp工具拷贝出来，修改完再拷贝回相同位置即可" L3 ~+ a: ^: j& n( _ `
! _9 p# p3 `+ t C3 b$ l: |
这里只需要重新加载一次监听就可以注册上实例了
5 v5 S# Z% N/ p6 N* i" \! H0 M/ B1 S% j$ E3 b
[oracle@adrep ~]$ lsnrctl reload2 Q) }! g/ g }& U5 b7 Y; \
( D/ b9 Q x3 c' {( U/ p$ j
3 ~5 z3 d- A: BLSNRCTL for Linux: Version 11.2.0.3.0 - Production on 14-SEP-2013 10:32:06: z$ m: k* v- q T0 l! _7 Y0 l
9 i# ]% R- [" l. p* p, z9 }: U9 o
3 ]5 O+ O* y' `1 H9 N XCopyright (c) 1991, 2011, Oracle. All rights reserved.
* J# t* T* P' r$ r+ {
5 G0 w5 x) M+ H) l1 F9 }4 U
: ^3 g$ p1 }* b9 W2 qConnecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=adrep)(PORT=1521)))
- `/ D- q6 k# ]" W s- Y$ t! i5 J% ~The command completed successfully& K L# W- Y& h9 C4 k, R
[oracle@adrep ~]$ lsnrctl status
" V9 \0 n ^+ b8 E( h; \& a* c& C. W$ g2 J' M
; l' p F! l+ o7 [
LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 14-SEP-2013 10:32:14# ~* G/ Y5 w1 [' B/ [1 r
0 I% p- M9 t2 t/ S7 X) h# @3 n! B2 F9 ^& C
Copyright (c) 1991, 2011, Oracle. All rights reserved.4 k- `/ e5 B/ |/ ]
2 y7 e8 ?/ U9 m+ \7 T; ~- `1 N; j' L0 p5 H) W& q
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=adrep)(PORT=1521)))$ p3 l$ _6 t- k+ j+ n
STATUS of the LISTENER+ j) A! k0 {+ h" ?6 v8 j
------------------------
5 j; a8 r0 x8 ?1 xAlias LISTENER ^% q c6 g" z+ k
Version TNSLSNR for Linux: Version 11.2.0.3.0 - Production
3 F! a, \' H Y" I" p( D6 FStart Date 14-SEP-2013 10:18:53" r# _, j6 x. b% Y
Uptime 0 days 0 hr. 13 min. 21 sec
, Q: o) B' {2 p5 U' N1 YTrace Level off
1 j0 D% `/ @& ^1 x6 kSecurity ON: Local OS Authentication
6 |7 j" i4 S6 S3 B! q; ySNMP OFF
- Z$ c9 C6 @7 q( RListener Parameter File /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
# ] f& B" B- Y; p8 LListener Log File /u01/app/oracle/diag/tnslsnr/adrep/listener/alert/log.xml
' _' m* s; @: a* U8 J7 q, z: ?" V# |Listening Endpoints Summary...
$ U$ S" y: M4 L3 c9 ]6 l (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=adrep)(PORT=1521)))
( k6 O4 {& z" A3 y7 V c (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))3 f$ |. R. q. n- Q# j
Services Summary...9 @$ ?1 L, s9 [, f# n4 O
Service "target" has 1 instance(s).
) I9 {/ i3 l+ `8 q) ~7 f2 V Instance "strmtarget", status UNKNOWN, has 1 handler(s) for this service...
+ Q5 ?/ [9 u& D( p H% i. ]; w- vThe command completed successfully
( ]# N* U1 x) G! ]# Q8 f9 {4 Q[oracle@adrep ~]$
5 t+ g9 l: P. p: P. @' @& m) x
$ w* |6 E" ]6 c8 A& h& n% m4 `这里target实例通过以上方法，成功地把实例注册上了，注意"UNKNOWN"就表示是静态注册的，如果是"READY"则表示是动态注册的, i& S' }2 S9 v( c
; C7 w) I2 e, k! H注意：动态和静态监听可以共存，如：% j2 t0 o' m5 i& S) _% d
4 N6 ]$ C9 r# R: z* `[oracle@zlm ~]$ lsnrctl status4 @ p: ~6 ?6 _/ |' ^
b8 Z+ }- |4 r9 a, o7 V+ E
6 B$ ^( T2 V3 r7 s' bLSNRCTL for Linux: Version 11.2.0.3.0 - Production on 14-SEP-2013 09:52:236 j9 p, L5 Y& L
: b( A% V1 B: n; u# ?& p& \
5 y2 B \+ c9 n" U9 d
Copyright (c) 1991, 2011, Oracle. All rights reserved.
+ N; i6 k) M1 @
, O0 a6 s5 T# y4 p/ z: A: r6 ]* N8 W! o
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=zlm)(PORT=1521))) [! E' b8 l3 o( ]
STATUS of the LISTENER5 ^3 e1 D5 I# j% q% i; c5 I( Z
------------------------4 q& q* `; Z! S* y
Alias LISTENER" w' m4 p* v) F& F. a6 i" j+ _, i
Version TNSLSNR for Linux: Version 11.2.0.3.0 - Production1 j" _. m. g% O' |+ ?7 ?& u1 F
Start Date 14-SEP-2013 09:15:04
8 @) U& Z7 z; A0 O- @; x' K# d, OUptime 0 days 0 hr. 37 min. 19 sec
: D4 E2 }) V I+ `Trace Level off
7 \- I6 s2 @6 @ W7 o" Y& SSecurity ON: Local OS Authentication& S4 \ R3 U% ^5 S4 f, r9 N
SNMP OFF
' H) `6 \- b$ Q1 cListener Parameter File /u01/app/oracle/product/11.2.0/db_1/network/admin/listener.ora' D4 Q- Y3 g( u" [% I
Listener Log File /u01/app/oracle/diag/tnslsnr/zlm/listener/alert/log.xml
; [% @: _; V# W1 r2 h) J- lListening Endpoints Summary...
9 H5 d, N$ {4 R (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=zlm)(PORT=1521)))7 N& K' T4 h, P7 r) g: @' |( J
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521))): |& c; e; Q, j# Z
Services Summary...3 o2 L0 S5 J) J1 ~: v
Service "zlm11g" has 2 instance(s).
4 d% B) \% Z% |5 [# X% O Instance "zlm11g", status UNKNOWN, has 1 handler(s) for this service...
$ Z8 b* x' \6 h' c) O/ L Instance "zlm11g", status READY, has 1 handler(s) for this service...; _' u+ a" X! ?& V* J: } z$ Y
Service "zlm11gXDB" has 1 instance(s).
3 j) r& s0 q' G. ~1 s$ y Instance "zlm11g", status READY, has 1 handler(s) for this service...
$ j6 P0 u8 w& m- z5 O* e% fThe command completed successfully2 D3 I& E. L2 L2 Z$ X. i! h8 L1 x
[oracle@zlm ~]$
6 y0 H( A5 d& p; M( e0 y! U
& S1 s4 P& j1 v/ a' X2 X以上是我在zlm主机上的监听状态，可以发现，同时配置了动态和静态的监听5 k3 o/ Z* `5 M5 j, J- U
8 s% W2 }& n7 E$ F" |
总结：以上利用了手动修改配置静态监听的方法成功注册了Oracle实例，动态监听往往需要等实例启动后，过一段时间才会注册上，而静态监听则可以马上注册。而且一旦实例重启会造成动态监听暂时无效，有些版本的bug甚至会导致动态监听的注册就再也起不来了。所以我对于监听的观点是，尽量配置静态监听，这样就可以避免很多由监听带来的问题，诸如我们经常会碰到的几个ora error：ora-12541、ora-12514、ora-12154等，尤其是在RAC和DG中，一个监听的问题，往往会带来很大的麻烦，尤其需要引起大家的注意。3 Z/ t6 Y& X; L. H( N
|
|
发表于 2018-10-13 13:26:56