# listener.ora Network Configuration File: G:\oracle\product\10.2.0\db_1\network\admin\listener.ora
# Generated by Oracle configuration tools.
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = G:\oracle\product\10.2.0\db_1)
(PROGRAM = extproc)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = GHOST-PC)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCPS)(HOST = GHOST-PC)(PORT = 2484))
)
)
这是listener.ora代码。
# tnsnames.ora Network Configuration File: G:\oracle\product\10.2.0\db_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.
orcl =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = GHOST-PC)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
ntrs =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.7.61.241)(PORT = 1521))
)
(CONNECT_DATA =
(SID = efss)
(SERVICE_NAME = ntrs)
)
)
这是tnsnames.ora代码
我要访问的是ntrs的数据库,可就是一值报错,数据库不是在本机,需要同过IP去连接的!但就是一直访问不了,求高手帮助!
那个oracle home我不知道
是填写那个ip 还是本机的oracle home?还是服务器上的??
服务器上的 ORACLE_HOME 地址
是啊,其他人都要通过这个ip去连接,他们就能上了
追答你看一下这个OracleOraDb10g_home1TNSListener服务启动了吗
追问已启动!
追答你能ping通oracle服务器的10.7.61.241这个地址吗
追问已ping通
追答你看一下ntrs =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.7.61.241)(PORT = 1521))
)
(CONNECT_DATA =
(SID = efss)
(SERVICE_NAME = ntrs)
)
)
这个与其他人的有什么不一样,如果不相同改为相同,在看一下登陆密码,权限正不正确,再连接试试
解决oracle中初学者常见问题ORA-12514远程连接数据库出错
你说的这个我在win7上操作过,不过我在xp点这个的时候系统毫无反应..........