1。在$ORACLE_HOME/network/admin/listener.ora 的SID_LIST_LISTENER 最后一个括号前面加
(SID_DESC =
(GLOBAL_DBNAME = oracle )
(ORACLE_HOME = /oracle/app/produtc/10.2.0/db_1)
(SID_NAME = crm45)
)
2。在$ORACLE_HOME/network/admin/tnsnames.ora
crm45 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.40.214)(PORT = 1521))
)
(CONNECT_DATA =
(SID = crm45)
)
)
*** 我的Oracle安装目录是:/oracle/app/produtc/10.2.0/db_1/ 如果你不是根据自己情况修改