我在机子用netmanager建立了连接,
tnsnames.ora文件如下:
# TNSNAMES.ORA Network Configuration File: C:\oracle\ora92\NETWORK\ADMIN\tnsnames.ora
# Generated by Oracle configuration tools.NC50 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = r51e)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = nc50)
)
)NC_DEV =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.16.40)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = ncdev)
)
)NC_TEST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.16.46)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = nctest)
)
)INST1_HTTP =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = r51e)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = SHARED)
(SERVICE_NAME = MODOSE)
(PRESENTATION = http://HRService)
)
)EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)listener.ora如下:
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = r51e)(PORT = 1521))
)
)
)SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = C:\oracle\ora92)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = nc50)
(ORACLE_HOME = C:\oracle\ora92)
(SID_NAME = nc50)
)
)
//用pl/sql都是可以连接访问的
//////////////////////////////////////////////////////////////////
跨库连接语句如下:
-- 建立数据库连接
create public database link
ncdev1 connect to ncdev identified by ncdev using 'ncdev';select * from bd_corp@ncdev1;
-- 删除数据库连接
DROP PUBLIC DATABASE LINK ncdev1;这个字符串用了两种'ncdev'和'nc_dev',都不行;///////////////////////////////////////////////
提示错误如下:ORA-12154: TNS: 无法解析指定的连接标识符
在网上找好多资料,还是没有搞好,请高手们指一点,谢谢.
tnsnames.ora文件如下:
# TNSNAMES.ORA Network Configuration File: C:\oracle\ora92\NETWORK\ADMIN\tnsnames.ora
# Generated by Oracle configuration tools.NC50 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = r51e)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = nc50)
)
)NC_DEV =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.16.40)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = ncdev)
)
)NC_TEST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.16.46)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = nctest)
)
)INST1_HTTP =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = r51e)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = SHARED)
(SERVICE_NAME = MODOSE)
(PRESENTATION = http://HRService)
)
)EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)listener.ora如下:
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = r51e)(PORT = 1521))
)
)
)SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = C:\oracle\ora92)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = nc50)
(ORACLE_HOME = C:\oracle\ora92)
(SID_NAME = nc50)
)
)
//用pl/sql都是可以连接访问的
//////////////////////////////////////////////////////////////////
跨库连接语句如下:
-- 建立数据库连接
create public database link
ncdev1 connect to ncdev identified by ncdev using 'ncdev';select * from bd_corp@ncdev1;
-- 删除数据库连接
DROP PUBLIC DATABASE LINK ncdev1;这个字符串用了两种'ncdev'和'nc_dev',都不行;///////////////////////////////////////////////
提示错误如下:ORA-12154: TNS: 无法解析指定的连接标识符
在网上找好多资料,还是没有搞好,请高手们指一点,谢谢.
解决方案 »
- PowerCenter8.1读取Oracle10g的数据到flat file中文出现乱码
- 排序:将一列1-10正序,11-20倒序,20-?正序,前两步已经解决,请高人指点。
- 表my_test 有字段keyid 多条记录 怎么查出数量最多的前10条
- 求plsql中功能同break,continue 的语句
- 我想一个JOB10秒中后执行怎么写
- 在oracle中如何实现,每到一个月的15号12时,就执行一个特定存储过程,如何做啊?
- ORACLE乱码问题,请高手解答。
- 获取当前日期的问题
- 大家帮忙呀,看这个语句怎么写呀,很简单呀!!!
- oracle数据库中数据怎么手工生成一个有固定格式的xml文件?
- oracle用dblink跨库查询ORA-12154: TNS: 无法解析指定的连接标识符
- 我只有em不可用,重新配置的时候端口号不知道该选哪个呢?
你在你自己的机器(客户端)建立的tnsname,服务器用不了
Looking for ugg boots? you can buy ugg boot online. Many choices, like ugg cardy, ugg classic cardy,ugg classic tall,ugg classic cardy boots, etc. You can certainly find your ideal one there. The ugg boots online mall wins many customs for its unique ugg boots uk and cardy ugg bootsYou can also find cheap ugg cardy boots there.Provide the authentic links of london jewelry, including links of london sweetie bracelet, links of london charms, Necklaces, Chains, Rings, Earrings at the lowest prices possible.Hello, I purchased a foreclosed home early 2009 and I recently have noticed a very strange odor from my sewage pump or sewage lineBuy and sell Screen Printing Machine from credible manufacturers and suppliers,If you are wondering if a biometric fingerprint door lock is worth the price, you may be surprised at how affordable they are becoming.
hi .come here ugg boots is very good .cheap ugg boots is u best choose, u will fined ugg classic tall and ugg classic short,UGG classic mini,UGG classic leopard
ugg boot ,UGG NEW all at my site.ugg women boots,ugg winter boot all ugg boots on sale
come on UGG DISCOUNT, ugg boots sale,we like UGG CLASSI BOOTS,UGG ON SALE