我用本机访问服务器上的数据库可以访问,访问本机创建的数据库报错。本机是113,不能访问113的库,其他都可以访问
找了很多办法都没有用。以下是我的配置文件,求高人指点listner.ora
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = icare
(ORACLE_HOME = E:\oracle\product\10.2.0\db_1)
(SID_NAME = icare)
)
(SID_DESC =
(GLOBAL_DBNAME = icare_gX)
(ORACLE_HOME = E:\oracle\product\10.2.0\db_1)
(SID_NAME = icare_gx)
)
(SID_DESC =
(GLOBAL_DBNAME = BAK
(ORACLE_HOME = E:\oracle\product\10.2.0\db_1)
(SID_NAME = BAK)
)
(SID_DESC =
(GLOBAL_DBNAME = jsjs
(ORACLE_HOME = E:\oracle\product\10.2.0\db_1)
(SID_NAME = jsjs)
)
)LISTENER =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.113)(PORT = 1521))
)tnsnames.ora
BAK=
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.113)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = BAK)
)
)ORCL =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.101)(PORT = 1521))
)
(CONNECT_DATA =
(SID = orcl)
)
)icare =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.101)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = icare)
)
)
找了很多办法都没有用。以下是我的配置文件,求高人指点listner.ora
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = icare
(ORACLE_HOME = E:\oracle\product\10.2.0\db_1)
(SID_NAME = icare)
)
(SID_DESC =
(GLOBAL_DBNAME = icare_gX)
(ORACLE_HOME = E:\oracle\product\10.2.0\db_1)
(SID_NAME = icare_gx)
)
(SID_DESC =
(GLOBAL_DBNAME = BAK
(ORACLE_HOME = E:\oracle\product\10.2.0\db_1)
(SID_NAME = BAK)
)
(SID_DESC =
(GLOBAL_DBNAME = jsjs
(ORACLE_HOME = E:\oracle\product\10.2.0\db_1)
(SID_NAME = jsjs)
)
)LISTENER =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.113)(PORT = 1521))
)tnsnames.ora
BAK=
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.113)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = BAK)
)
)ORCL =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.101)(PORT = 1521))
)
(CONNECT_DATA =
(SID = orcl)
)
)icare =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.101)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = icare)
)
)
OracleDBConsoleBAK.
OracleOraDb10g_home1TNSListener.
OracleServiceBAK
这三个服务就可以了
重建一下tns试试
(SERVER = DEDICATED)
(SERVICE_NAME = BAK)
)
(CONNECT_DATA =
(SID = orcl)
)注意上面两段代码的区别,别把sid当SERVICE_NAME用哦