前段时间重装了oracle(服务器),现在将一个程序的数据(.dmp)导入数据库中后,
当登陆时,总是出现以下错误: ORA-12154: TNS:could not resolve the connect identifier specified。但sqlplus 和plsql均能登陆。
实在弄不明白是什么原因,请高手指教??
listener.ora文件内容如下:# listener.ora Network Configuration File: E:\ora\product\10.2.0\db_1\network\admin\listener.ora
# Generated by Oracle configuration tools.SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = E:\ora\product\10.2.0\db_1)
(PROGRAM = extproc)
)
)LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
(ADDRESS = (PROTOCOL = TCP)(HOST = liqian-5fy)(PORT = 1521))
)
)tnsnames.ora文件内容如下:
# tnsnames.ora Network Configuration File: E:\ora\product\10.2.0\db_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.
ORADB =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
(LOAD_BALANCE = yes)
)
(CONNECT_DATA =
(SID = oradb)
)
)EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
sqlnet.ora文件内容如下:
SQLNET.AUTHENTICATION_SERVICES= (NTS)NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)
当登陆时,总是出现以下错误: ORA-12154: TNS:could not resolve the connect identifier specified。但sqlplus 和plsql均能登陆。
实在弄不明白是什么原因,请高手指教??
listener.ora文件内容如下:# listener.ora Network Configuration File: E:\ora\product\10.2.0\db_1\network\admin\listener.ora
# Generated by Oracle configuration tools.SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = E:\ora\product\10.2.0\db_1)
(PROGRAM = extproc)
)
)LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
(ADDRESS = (PROTOCOL = TCP)(HOST = liqian-5fy)(PORT = 1521))
)
)tnsnames.ora文件内容如下:
# tnsnames.ora Network Configuration File: E:\ora\product\10.2.0\db_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.
ORADB =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
(LOAD_BALANCE = yes)
)
(CONNECT_DATA =
(SID = oradb)
)
)EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
sqlnet.ora文件内容如下:
SQLNET.AUTHENTICATION_SERVICES= (NTS)NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)
解决方案 »
- 急求教,access转oracle数据库的问题?
- SQL语句执行速度慢
- oracle 10.2.0.2的大BUG,怎样解决
- 求助:杀毒时把htpasswd.exe和startapache.exe文件给误删除,请问如何恢复?
- sql语句问题
- oracle 存储过程 怎么少用 if then
- 求SQL 找出时间最小的一行
- 初学者提问:如何创建数据库和表,如何添加记录?(Oracle 8i)(绝对给分)
- 请问WINDOW98环境下可以运行ORACLE吗?在哪里下载?多谢!
- 修改了机器名后oracle启动不了?
- execute immediate 执行的DML语句,可能包含子查询吗?
- 使用group by后怎么查询除分组字段外的字段?
当登陆时,总是出现以下错误: ORA-12154: TNS:could not resolve the connect identifier specified。但sqlplus 和plsql均能登陆。
不知道第一个登陆是什么意思?
sqlplus 和plsql用的是一样的TNS啊,能登陆又不能登陆
搞不懂,到底是可以登录还是不能登陆
高手,我的意思是sqlplusw plsql 用dba账户 如phyexam均可以登录,但是在应用程序中,输入应用程序中的管理员账户却无法登陆。错误提示如上所述啊