1、服务名称配置(本地,客户端)
2、在要登陆的哪个数据库所在的机器上查看lsnrctl
2、在要登陆的哪个数据库所在的机器上查看lsnrctl
解决方案 »
- ORACLE11G 在win7上安装后提示错误
- oracle中,如何把数字型日期,转成汉字的。
- select...for update有关oracle行锁的问题
- Does anyone know if it is possible to supply multiple queries and tables to exp - so that the result is a single export file ?
- 创建数据表问题,initial
- Oracle8i EXP导出的警告信息,如何修正?
- 关于写文件异常 谢谢
- 导数据-菜鸟问题-操作成功马上给分
- 如何写实现这样功能的sql语句
- 请问:schema和object之间的关系.
- to :LGQDUCKY(飘) 关于你给的那个存储过程,我还是不会用啊。。。
- 请问多表关联中能不能使用外连接????
打开tnsnames.ora文件添加如下代码后保存DB的称呼 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = ip)(PORT = 1521))
)
(CONNECT_DATA =
(SID = 数据库名)
(SERVER = DEDICATED)
)
)
lsnrctl start 在服务端执行
打开tnsnames.ora文件添加如下代码后保存DB的称呼 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 数据库IP)(PORT = 1521))
)
(CONNECT_DATA =
(SID = 数据库名)
(SERVER = DEDICATED)
)
)
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.14)(PORT = 1521))
)
(CONNECT_DATA = (SID = lgy)(SERVER = DEDICATED))
)
没问题呀,还是出错:“无法处理服务名”
如果是9i的话,改为(service_name = 数据库名字)试试看