本地oracle 链接远程oracle
远程:
listener.ora:
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = E:\oracle\product\10.2.0\db_1)
(PROGRAM = extproc)
)
)LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 218.24.24.55)(PORT = 1521))
)
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
)
tnsnames.ora
JIAOJIAO =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 218.24.24.55)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = SHARED)
(SERVICE_NAME = jiaojiao)
)
)EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(Key = EXTPROC0))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(SERVER = SHARED)
(PRESENTATION = RO)
)
)
本地机器:listener.oraSID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = E:\oracle\product\10.2.0\db_1)
(PROGRAM = extproc)
)
)LISTENER =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 218.24.24.55)(PORT = 1521))
)
tnsnames.ora
JIAOJIAO =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 218.24.94.35)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = SHARED)
(SERVICE_NAME = jiaojiao)
)
)EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)然后我链接sql plus
无监听程序 然后我启动监听
TNS-12545:因目标主机或对象不存在,连接失败
TNS-12560:TNS:协议适配器错误
TNS-00515:因目标主机活对象不存在,连接失败
32-bit windows error:49:unknown error
远程:
listener.ora:
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = E:\oracle\product\10.2.0\db_1)
(PROGRAM = extproc)
)
)LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 218.24.24.55)(PORT = 1521))
)
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
)
tnsnames.ora
JIAOJIAO =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 218.24.24.55)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = SHARED)
(SERVICE_NAME = jiaojiao)
)
)EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(Key = EXTPROC0))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(SERVER = SHARED)
(PRESENTATION = RO)
)
)
本地机器:listener.oraSID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = E:\oracle\product\10.2.0\db_1)
(PROGRAM = extproc)
)
)LISTENER =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 218.24.24.55)(PORT = 1521))
)
tnsnames.ora
JIAOJIAO =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 218.24.94.35)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = SHARED)
(SERVICE_NAME = jiaojiao)
)
)EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)然后我链接sql plus
无监听程序 然后我启动监听
TNS-12545:因目标主机或对象不存在,连接失败
TNS-12560:TNS:协议适配器错误
TNS-00515:因目标主机活对象不存在,连接失败
32-bit windows error:49:unknown error
lsnrctl start--启动监听
如题啊 有错误的
可以看看 HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\HOME0 里有没有一个叫 oracle_sid 的项?
如果没有创建一个,赋值即可。
远程的你你可以这样试着连下:
sqlplus 用户/密码@218.24.24.55/JIAOJIAO,
JIAOJIAO =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 218.24.94.35)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = SHARED)
(SERVICE_NAME = jiaojiao)
)
)
host 改成218.24.24.55如果你想连接到本机的数据库,那把你本机的监听IP改一下。
Oracle 数据库监听配置
http://blog.csdn.net/tianlesoftware/archive/2009/11/25/4861572.aspx
------------------------------------------------------------------------------
Blog: http://blog.csdn.net/tianlesoftware
网上资源: http://tianlesoftware.download.csdn.net
相关视频:http://blog.csdn.net/tianlesoftware/archive/2009/11/27/4886500.aspx
Q Q 群:62697716
高手能告诉我下 远程oracle的(listener.ora和tnsnames.ora )文件怎么配置吗 我那样配置正确吗
通的话就是本机的配置文件有问题。
不推荐知直接改文件,使用netca这种向导比较好
218.24.24.55 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 218.24.24.55)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = SHARED)
(SERVICE_NAME = jiaojiao)
)
) 2.确保在218.24.24.55上的远程数据库和监听已启动,然后在命令行输入
c:>tnsping 218.24.24.55
如果返回多少毫秒表示连接成功
服务器的 lsnrctl start 后
出现 因目标主机或对象不存在,链接失败
服务名中的主机名也是218.24.**.** 但是我启动 LISTENER1 这个监听名的时候 还是提示
TNS-12545:因目标主机或对象不存在,连接失败
高手指教