Chinaunix

标题: 数据库导出时遇到的奇怪问题 [打印本页]

作者: 402550990 时间: 2013-05-30 12:04
标题: 数据库导出时遇到的奇怪问题
最近执行数据库导出时遇到一个很奇怪的问题，请各位大虾帮忙看看
[oracle@node1 admin]$ exp test/test123@orcl file=/data/111.dmp full=y

Export: Release 10.2.0.5.0 - Production on Thu May 30 11:54:14 2013

Copyright (c) 1982, 2007, Oracle.  All rights reserved.

EXP-00056: ORACLE error 12154 encountered
ORA-12154: TNS:could not resolve the connect identifier specified
EXP-00000: Export terminated unsuccessfully
通过sqlplus / as sysdba登上数据库查看状态是OPEN，其它的也都正常，数据库监听也是正常的，通过PLSQL用test用户登陆也都OK
[oracle@guangxi1 admin]$ tnsping node1

TNS Ping Utility for Linux: Version 10.2.0.5.0 - Production on 30-MAY-2013 11:56:59

Copyright (c) 1997,  2010, Oracle.  All rights reserved.

Used parameter files:

Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.200.65)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl)))
OK (10 msec)
TNSPING显示OK

[oracle@guangxi1 admin]$ sqlplus test/test123@orcl

SQL*Plus: Release 10.2.0.5.0 - Production on Thu May 30 11:58:15 2013

Copyright (c) 1982, 2010, Oracle.  All Rights Reserved.

ERROR:
ORA-12154: TNS:could not resolve the connect identifier specified

Enter user-name: test
Enter password:

Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> select instance_name,status from v$instance;

INSTANCE_NAME
------------------------------------------------
STATUS
------------------------------------
orcl
OPEN

SQL>
很奇怪，直接sqlplus test/test123@orcl登陆不了数据库，在输入用户名密码后又可以登陆，用户名和密码还是原来的test/test123，这种情况是哪里配置有问题呢？

欢迎光临 Chinaunix (http://bbs.chinaunix.net/)