ORACLE修改侦听端口

首先 lsnrctl stop

更改listener.ora文件

# LISTENER.ORA Network Configuration File: D:oracleora92 etworkadminlistener.oraITPUB个人空间Nq ~;IJF*O8{
# Generated by Oracle configuration tools.

LISTENER =ITPUB个人空间k Z0i$z,OBH"O7O6SL
  (DESCRIPTION_LIST =
:h#S @i.j!ZH0    (DESCRIPTION =ITPUB个人空间
[kt,cU9L [`'`
      (ADDRESS_LIST =
#M1V6n1z!C @ ePA2p0        (ADDRESS = (PROTOCOL = TCP)(HOST = d10063)(PORT = 1523))ITPUB个人空间0YZHP.aN3P} o
      )
(A0C(a&Tc3`0      (ADDRESS_LIST =
&c1d!E(^!B+O&G4K0        (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
If0w5P R)|1}0      )ITPUB个人空间w/s1l"aTV
Bw
    )
qW?q4A8eo])m0  )

SID_LIST_LISTENER =
h
^#k0` W%l$l*o-Wa0  (SID_LIST =

j*kMnF0    (SID_DESC =ITPUB个人空间X+z!`1U}
      (SID_NAME = PLSExtProc)ITPUB个人空间4oR;LoQz
      (ORACLE_HOME = D:oracleora92)ITPUB个人空间W/yi?SN6d
      (PROGRAM = extproc)ITPUB个人空间i(TYq$qI
    )ITPUB个人空间$[5lm2H+h#DT?H$
    (SID_DESC =ITPUB个人空间?t`o9DX^+dR%?
      (GLOBAL_DBNAME = gsid)ITPUB个人空间 qj*n(j0W
      (ORACLE_HOME = D:oracleora92)ITPUB个人空间zuv&aiSU*x
      (SID_NAME = paul)
3E^/Y ~)O)Zem
Q`0    )
"L;w e)j%F
V#|0    (SID_DESC =
K:ov1h!H(@0      (GLOBAL_DBNAME = paul)ITPUB个人空间l2_:ub5SsX2Q
      (ORACLE_HOME = D:oracleora92)ITPUB个人空间
S%E+w5H!|t
      (SID_NAME = paul)ITPUB个人空间4Q-@]h?`!w
    )ITPUB个人空间 e'o#OG%@P N%O_)Ww
    (SID_DESC =
,@7Qn4I6W4yM0      (GLOBAL_DBNAME = test)ITPUB个人空间yEO)wd
b
      (ORACLE_HOME = D:oracleora92)
Q.GD-` {@C$]4~0      (SID_NAME = test)
*nm:g"o"x1E'}C/f6U0    )
w2gL,Pv:e0    (SID_DESC =
en.Pc_0      (GLOBAL_DBNAME = copy)
j }e!H#|5o0      (ORACLE_HOME = D:oracleora92)ITPUB个人空间$~Cog!WZ
      (SID_NAME = copy)
4n4jj1l0^ G5zJ `~0    )ITPUB个人空间!w'UR`4i;]0|?
    (SID_DESC =
YLx'h VJ0      (GLOBAL_DBNAME = pubtest)
J6Q:l
B;AI0R0      (ORACLE_HOME = D:oracleora92)ITPUB个人空间!F3t_m'AF8d X
      (SID_NAME = pubtest)ITPUB个人空间o&w"Bn RF
    )ITPUB个人空间q5M_F)G!q io&F"z
  )

 

tnsnames.ora 文件

PUBTEST1523 =ITPUB个人空间6]V"V.xI
B ^0dl
  (DESCRIPTION =ITPUB个人空间}x X(iB x*Xj;u
    (ADDRESS_LIST =ITPUB个人空间 wn-t zza5[T
      (ADDRESS = (PROTOCOL = TCP)(HOST = d10063)(PORT = 1523))ITPUB个人空间c-i I#x_-b?O.z1o Y1k
    )ITPUB个人空间Du't|sx
    (CONNECT_DATA =
|C~&a$Y+Zl-B|0      (SERVER = DEDICATED)ITPUB个人空间 Q9gFT3AS
      (SERVICE_NAME = pubtest)
$vE)PV;bm9T+q0    )
B4U H Xnh0  ) 

 

然后再lsnrctl start