oracle 的监听配置怎么解决,客户端怎么配置监听

SQL code# listener.ora

SID_LIST_LISTENER =

(SID_LIST =

(SID_DESC =

(GLOBAL_DBNAME = YONGDB.yongyy.com)

(SID_NAME = YONGDB)

)

)

LISTENER =

(DESCRIPTION_LIST =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))

(ADDRESS = (PROTOCOL = TCP)(HOST =yongyy.com)(PORT = 1521))

)

)

ADR_BASE_LISTENER = /yongyy/u01/app/oracle

#------------------------------------------

tnsnames.ora

YONGDB =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP)(HOST = yongyy.com)(PORT = 1521))

(CONNECT_DATA =

(SERVER = DEDICATED)

(SERVICE_NAME = YONGDB.yongyy.com)

)

)

#-------------------------------

# sqlnet.ora

NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)

ADR_BASE = /yongyy/u01/app/oracle

-----------------------------------------------------

客户端的配置:

[color=#FF0000]listener.ora[/color]

LISTENER =

(DESCRIPTION_LIST =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.24.128)(PORT = 1521)) --本来是 YONGYY-PC :是客户端的主机名

)

)

ADR_BASE_LISTENER = D:\Oracle

YONGDB =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.24.128)(PORT = 1521)) -- 服务器的IP

(CONNECT_DATA =

(SERVER = DEDICATED)

(SERVICE_NAME = YONGDB)

)

)

[color=#FF0000]sqlnet.ora[/color]

SQLNET.AUTHENTICATION_SERVICES= (NTS)

NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)

[color=#FF0000]tnsnames[/color]

YONGDB =

(DESCRIPTION =

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

(CONNECT_DATA =

(SERVER = DEDICATED)

(SERVICE_NAME = YONGDB)

)

)