配置好你的监听器。
通过oracle network assistant
还有就是直接修改你的listener.ora文件
这是一个例子
# LISTENER.ORA Network Configuration File: c:\Oracle\Ora81\network\admin\listener.ora
# Generated by Oracle configuration tools.LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = bachelor)(PORT = 1521))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
)
)SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = c:\Oracle\Ora81)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = afis)
(ORACLE_HOME = c:\Oracle\Ora81)
(SID_NAME = afis)
)
)#以上需要注意的有
host = 你的主机名或ip
GLOBAL_DBNAME =你的数据库的名字
ORACLE_HOME = 你的数据库的安装路径即oraclehome
SID_NAME = 你的数据库的事例的sid号
通过oracle network assistant
还有就是直接修改你的listener.ora文件
这是一个例子
# LISTENER.ORA Network Configuration File: c:\Oracle\Ora81\network\admin\listener.ora
# Generated by Oracle configuration tools.LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = bachelor)(PORT = 1521))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
)
)SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = c:\Oracle\Ora81)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = afis)
(ORACLE_HOME = c:\Oracle\Ora81)
(SID_NAME = afis)
)
)#以上需要注意的有
host = 你的主机名或ip
GLOBAL_DBNAME =你的数据库的名字
ORACLE_HOME = 你的数据库的安装路径即oraclehome
SID_NAME = 你的数据库的事例的sid号
good luck!!
good luck!!