IP为192.168.2.219的机器上安装了一个Oracle10g服务器
本机安装了Oracle客户端,通过Oracle Net Manager测试连接成功,但是使用SqlPlus连接服务器时报ORA-12154无法解析指定标识符错误,我接触Oracle新手。
请大家请教,在线等待中......sqlnet.ora文件:
# sqlnet.ora Network Configuration File: C:\oracle\product\10.2.0\client_1\network\admin\sqlnet.ora
# Generated by Oracle configuration tools.# This file is actually generated by netca. But if customers choose to
# install "Software Only", this file wont exist and without the native
# authentication, they will not be able to connect to the database on NT.SQLNET.AUTHENTICATION_SERVICES= (NTS)NAMES.DIRECTORY_PATH= (TNSNAMES,ONAMES,HOSTNAME)
//tnsnames.ora文件
# tnsnames.ora Network Configuration File: C:\oracle\product\10.2.0\client_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.TESTING =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.2.219)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = testing)
)
)
本机安装了Oracle客户端,通过Oracle Net Manager测试连接成功,但是使用SqlPlus连接服务器时报ORA-12154无法解析指定标识符错误,我接触Oracle新手。
请大家请教,在线等待中......sqlnet.ora文件:
# sqlnet.ora Network Configuration File: C:\oracle\product\10.2.0\client_1\network\admin\sqlnet.ora
# Generated by Oracle configuration tools.# This file is actually generated by netca. But if customers choose to
# install "Software Only", this file wont exist and without the native
# authentication, they will not be able to connect to the database on NT.SQLNET.AUTHENTICATION_SERVICES= (NTS)NAMES.DIRECTORY_PATH= (TNSNAMES,ONAMES,HOSTNAME)
//tnsnames.ora文件
# tnsnames.ora Network Configuration File: C:\oracle\product\10.2.0\client_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.TESTING =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.2.219)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = testing)
)
)
先指定下ORACLE_SID 看看.
c:>tnsping testingC:>set ORACLE_SID=testing
C:>sqlplus /nolog
------------------------------------------------------------------------------
Blog: http://blog.csdn.net/tianlesoftware
网上资源: http://tianlesoftware.download.csdn.net
相关视频:http://blog.csdn.net/tianlesoftware/archive/2009/11/27/4886500.aspx
DBA1 群:62697716(满); DBA2 群:62697977
c:>tnsping testing
HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\HOME0
ORACLE_SID
ORACLE_HOME
键值
sqlplus scott/tiger@testing(前提是scott用户解锁)
你的sqlplus是怎么用的?给我们看看,是什么错。
新的问题又来了,PL/SQL连接不上数据库报ORA-12154无法解析指定标识符错误
有可能是 杀毒软件比如卡巴斯基等,就经常会将oracle的监听连接服务给屏蔽掉。
有可能是 杀毒软件比如卡巴斯基等,就经常会将oracle的监听连接服务给屏蔽掉。