建立本地网络服务名,保证能够连通,建议主机名用IP地址,然后用这个本地网络服务名连接Oracle数据库另外注意两台机子能否Ping通
解决方案 »
- 时间重叠统计
- oracle 如何书写批处理将原有用户及表空间删除,重新创建表空间和用户,高分急求!!!!!!!!!!!!!!!!!!!!!!
- 为什么这个语句在SQL下能执行,而写到FUNCTIONS里就编译不能通过呢?
- 郁闷最近改进了一下藏拙分词,词库有400万词汇!5000字的文章完全切分居然需要 接近1秒钟的时间!
- [求助]oracle9i 的按小时统计的问题
- 我今天面试的SQL题目,欢迎刚毕业的同学来试一试!!!
- 在线等待!
- http服务器打不开,OMS缺少内容
- rh8+oracle9i,安装后出现ORA-12560:协议适配器错误!急急急!
- oracle
- 如何更改表中列名?
- 创建完资料库后启动不了management server服务?出现错误997:重叠的I/O操作进行中,怎么办?
Data Source=OAServer_insect;User ID=system;Password=manager;tns该怎么设置呢?
如:C:\Oracle\Ora81\network\admin\tnsnames.ora
找到tnsnames.ora手工修改一下就行了!!!!!
ORA817 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = IBMF80)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = ora817)
)
)IORA817 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 134.67.9.22)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = ora817)
)
)
OASERVER_INSECT =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = insect)(PORT = 1521))
)
(CONNECT_DATA =
(SID = OAserver)
(SERVER = DEDICATED)
)
)