前段时间重装了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)
解决方案 »
- ORACLE dbf文件提示损坏,怎么恢复数据
- Oracle9i从一个表向另外一个表导入数据时报ORA-00600错误
- 在线等。。oracle链接数的问题
- oracle insert into
- recover database?
- 那位大侠会用pl/sql develop,请问怎样让查询出来的结果显示在一行上呢?
- 关于移动审计表sys.aud$到其它表空间的问题?
- 新人报道,请各位兄弟姐妹多多照顾
- 怎样 SELECT 所有包含小写字母的列?求最简便方法!
- 如何删除数据文件,急!
- execute immediate 执行的DML语句,可能包含子查询吗?
- 使用group by后怎么查询除分组字段外的字段?
当登陆时,总是出现以下错误: ORA-12154: TNS:could not resolve the connect identifier specified。但sqlplus 和plsql均能登陆。
不知道第一个登陆是什么意思?
sqlplus 和plsql用的是一样的TNS啊,能登陆又不能登陆
搞不懂,到底是可以登录还是不能登陆
高手,我的意思是sqlplusw plsql 用dba账户 如phyexam均可以登录,但是在应用程序中,输入应用程序中的管理员账户却无法登陆。错误提示如上所述啊