oracle 配置监听-白红宇

LISTENER =

(DESCRIPTION_LIST =

(DESCRIPTION =

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

(ADDRESS = (PROTOCOL = TCP)(HOST = raccontroller.cc)(PORT = 1521))

)

SID_LIST_LISTENER =

(SID_LIST =

(SID_DESC =

(GLOBAL_DBNAME = orcl.raccontroller.cc)

(SID_NAME = orcl)

(ORACLE_HOME = /ruiy/ocr/DBSoftware/app/oracle/product/11.2.0/dbhome_1)

)

ADR_BASE_LISTENER = /ruiy/ocr/DBSoftware/app/oracle

2，Instance "ruiy", status UNKNOWN, has 1 handler(s) for this service...

就是你的/ruiy/ocr/DBSoftware/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora中建的监听,没在tnsnames.ora中加

listener.ora文件Example

LISTENER =  (DESCRIPTION_LIST =    (DESCRIPTION =      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))      (ADDRESS = (PROTOCOL = TCP)(HOST = raccontroller.cc)(PORT = 1521))    )  )SID_LIST_LISTENER =  (SID_LIST =    (SID_DESC =      (GLOBAL_DBNAME = orcl.raccontroller.cc)      (SID_NAME = orcl)      (ORACLE_HOME = /ruiy/ocr/DBSoftware/app/oracle/product/11.2.0/dbhome_1)    )   (SID_DESC =      (GLOBAL_DBNAME = ruiy.raccontroller.cc)      (SID_NAME = ruiy)      (ORACLE_HOME = /ruiy/ocr/DBSoftware/app/oracle/product/11.2.0/dbhome_1)    )  )ADR_BASE_LISTENER = /ruiy/ocr/DBSoftware/app/oracle

View Code

tnsnames.ora文件Example

ORCL =  (DESCRIPTION =    (ADDRESS = (PROTOCOL = TCP)(HOST = raccontroller.cc)(PORT = 1521))    (CONNECT_DATA =      (SERVER = DEDICATED)      (SERVICE_NAME = orcl.raccontroller.cc)    )  )RUIY =  (DESCRIPTION =    (ADDRESS = (PROTOCOL = TCP)(HOST = raccontroller.cc)(PORT = 1521))    (CONNECT_DATA =      (SERVER = DEDICATED)      (SERVICE_NAME = ruiy.raccontroller.cc)    )  )

View Code

global_dbname

sid_name

service_name

instance_name