Chinaunix首页 | 论坛 | 博客
  • 博客访问: 420051
  • 博文数量: 61
  • 博客积分: 507
  • 博客等级: 下士
  • 技术积分: 1185
  • 用 户 组: 普通用户
  • 注册时间: 2012-03-20 00:19
文章分类

全部博文(61)

文章存档

2014年(13)

2013年(21)

2012年(27)

分类: Oracle

2012-09-24 14:57:56

[oracle@client1 dbbackup]$ exp file=/home/oracle/dbbackup/onlinecrm_09-05.dmp
Export: Release 10.2.0.4.0 - Production on 星期一 9月 5 15:28:20 2011
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
[oracle@kuaishang ~]$ exp onlinecrm/ks@mydb file=/home/oracle/dbbackup/onlinecrm_09-05.dmp
Export: Release 10.2.0.1.0 - Production on Mon Sep 5 15:53:44 2011
Copyright (c) 1982, 2005, Oracle. All rights reserved.

EXP-00056: ORACLE error 12170 encountered
ORA-12170: TNS:Connect timeout occurred
EXP-00000: Export terminated unsuccessfully
[oracle@client1 admin]$ tnsping mydb tnsping也不通
TNS Ping Utility for Linux: Version 10.2.0.4.0 - Production on 05-9月 -2011 17:54:38
Copyright (c) 1997, 2007, Oracle. All rights reserved.
Used parameter files:
/usr/local/oracle/db_1/network/admin/sqlnet.ora
TNS-03505: Failed to resolve name
先确定安装目录下是有这两个文件
[oracle@client1 db_1]$ find /usr/local/oracle/db_1/ -name tnsnames.ora
/usr/local/oracle/db_1/network/admin/tnsnames.ora
[oracle@client1 db_1]$ find /usr/local/oracle/db_1/ -name listener.ora
/usr/local/oracle/db_1/network/admin/listener.ora
如果有请再查看tnsnames.ora这文件
[oracle@ku ~]$ vi /usr/local/oracle/db_1/network/admin/tnsnames.ora
ORCL10G =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = kuaishang)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl10g)
)
)
发现在exp tnsnames.ora的SERVICE_NAME = orcl10g不同名,找不到才造成tns "Connect timeout occurred"
;所以把备份语句exp file=/home/oracle/dbbackup/onlinecrm_09-05.dmp
改成exp onlinecrm/ks@orcl10g file=/home/oracle/dbbackup/onlinecrm_09-05.dmp就可以
阅读(10241) | 评论(0) | 转发(0) |
给主人留下些什么吧!~~