Shulou(Shulou.com)06/01 Report--

-- oracle 11g Murray-

SID_LIST_LISTENER =

(SID_LIST =

(SID_DESC =

(SID_NAME = nms)

(ORACLE_HOME = / u01/oracle/product/10.2.0/db_1/)

(PROGRAM = extproc)

)

)

LISTENER =

(DESCRIPTION_LIST =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP) (HOST = TJ-NMS-DB) (PORT = 1523))

(ADDRESS = (PROTOCOL = IPC) (KEY = EXTPROC1523))

)

)

ADR_BASE_LISTENER = / u01/oracle

You need to change the local_listener parameter when using a non-default port

SQL > alter system set local_listener= "(address= (protocol=tcp) (host=192.168.0.100) (port=1523))"

-- oracle 10g Murray-

SID_LIST_LISTENER =

(SID_LIST =

(SID_DESC =

(GLOBAL_DBNAME = ydwg)

(ORACLE_HOME = / oracle/oracle10/product/10.2.0/db_1)

(SID_NAME = ydwg)

)

)

LISTENER =

(DESCRIPTION_LIST =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.100.151) (PORT = 1521))

)

)

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.