测试成功了的话,说明没什么问题
试试
修改oracle\ora816\network\ADMIN\tnsnames.ora
如:host项改成数据库服务器的ip地址,service_name为数据库名称
ORAL =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = Sun)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = oral)
)
)
试试
修改oracle\ora816\network\ADMIN\tnsnames.ora
如:host项改成数据库服务器的ip地址,service_name为数据库名称
ORAL =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = Sun)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = oral)
)
)
解决方案 »
- 不显示删除回复显示所有回复显示星级回复显示得分回复 安装oracle11g时出现 先决条件检查全部失败 求高人指点
- [紧急求助]!!紧急数据恢复,拜托大家了!!
- 不解,你的库会是这样么?
- jobs脚本中'TRUNC(SYSDATE+1)的意思是什么?
- sql复制数据
- oracle按时到出表
- 从oracle数据库中select出结果的问题
- 新手提问. 下面的语句中请问怎么用 EXIST 来替换IN ?
- 关于在.NET中ORACLE数据库连接及时释放的问题(急!)
- 虾米提问:删除用户时的cascade?
- 索引会自动invalid?大家帮忙分析一下原因
- 急,在线等!如何从oracle数据库中导出数据到.txt文件中
是否通,把你的TNSNAMES.ORA文件里,连接串的配置信息帖出来
应该没有问题的。
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.2.125)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = oral)
)
)
则试试:
conn system/manager@oraltest 是否有什么错误信息.把你的操作过程及tnsname.ora都帖出来看看.
试试
tnsping 通过就行了
>>tnsping 通过,并不代表就能连接上数据库
信息如下:
ERROR:
ORA-12154: TNS: 无法处理服务名谢谢各位大侠
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.156)(PORT = 1521))
)
(CONNECT_DATA =
(SID = SZDB)
(SERVER = DEDICATED)
)
)
ORA-12154: TNS:could not resolve service name
First open the tnsnames.ora file and check the settings
eg-
CHECK1 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST =CHECK2)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = CHECK3)
)
)
IN THE ABOVE GIVEN SCRIPT
CHECK1---> Data Source Name u r Connecting from the front end
CHECK2---> Server name to which u r connecting
CHECK3---> Service name/SID of the Data base u r connecting
* - c:\> ping CHECK2 (Host ip or name)
if you cannot ping that means the client server network problem. Else* - c:\> telnet CHECK2:1521
if you cannot connect to port ,network problem . Else* - c:\> TNSPING CHECK1if still the same error
check SQLNET.ORA
Commect other settings and keep only following line and TNSPING.
SQLNET.AUTHENTICATION_SERVICES= (NTS)If not NTS change to NONE and TNSPING.If Still not working check whether a Spyware running on your PC.
Run spyware detection tool.Do you have multiple Oracle installations on your machines like Oracle client and Developer ?
If so you'll have to set up the tnsnames.ora on both HOMES.
Or else setup the registry.
Add string value TNS_ADMIN to \HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE
Set the values of TNS_ADMIN to the folder where the tnsnames.ora you set up resides.
Eg. C:\oracle\ora92\admin
启了吗?
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.156)(PORT = 1521))
)
(CONNECT_DATA =
(SID = SZDB)
(SERVER = DEDICATED)
)
)SQLPLUS连接用的是MYNAME,而不是SZDB