Exp-00056 Oracle Error 12170 Encountered
Contents |
EXP-00056 encountered ORACLE error 12170 ORA-12170 TNS: connection timeout Thank you, please help us to see the masters exp 00056 oracle error 12154 encountered Reply: tnsping oracle Reply: cited a floor suiziguo reply: tnsping oracle Experts
Exp 00056 Oracle Error 1017 Encountered
can say more specific? Reply: cited a floor suiziguo reply: tnsping oracle After the first SSH login server TNSPING
Exp 00056 Oracle Error 1034 Encountered
5 times no problem ah OK (10 msec) OK (0 msec) OK (0 msec) OK (0 msec) OK (20 msec) Reply: sqlplus oa1/123 @ oracle can be properly connected? Reply: references, 4th Floor suiziguo reply: sqlplus oa1/123 @ oracle can be properly connected? Yes ah sqlplus oa1/123 @ oracle can enter> command line input Reply: exp and sqlplus should be able to connect to the server using sqlnet Would be a firewall issue? Reply: reference to the 6th floor tangren reply: exp and sqlplus should be able to connect to the server using sqlnet Would be a firewall issue? Firewall is not ah no problem Before backing off Reply: Are you permission to home is not it? Reply: Monitor disconnected .. ssh or connect it? Can I see ssh connections effectively SSH connection timeout solutions http://blog.csdn.net/tianlesoftware/archive/2010 / 01/24/5250247.aspx -------------------------------------------------- ---------------------------- Blog : http://blog.csdn.net/tianlesoftware online resources : http://tianlesoftware.download.csdn.net related videos : http://blog.csdn. net/tianlesoftware/archive/2009/11/27/4886500.aspx Q Q group: 62697716 Reply: On a server with several oracle? Reply: reference to the 8th floor crazylaa reply: Are you not a privilege for the home? Pwd privileged ah and has a Reply: reference to the 10th floor nihaozhangchao reply: on server equipped with several oracle ?Only an oracle Reply: [Quote = reference to the 9th floor tianlesoftware reply:] Monitor disconnected .. ssh or connect it? Can I see ssh connections effectively SSH connection timeout solutions http://blog.csdn.net/tianlesoftware/archive/2010/01/24/5250247.aspx -------------------------------------------------- ---------------------------- SSH has been connected ah sqlplus oa1/123 @ oracle properly connected Reply: You can also ask the itpub before, tried the method in which he mentions no ORA-12170: TNS: Connect timeout occurred Cause: The server shut down because connection establishment or communication with a clie
log in tour help Tour Start here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company Business Learn more about hiring developers or posting ads with us Database Administrators Questions Tags Users Badges Unanswered Ask Question _ Database Administrators Stack Exchange is http://oracle.veryoo.com/2014/02/ssh-remote-exp-export-database-error.html a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute: Sign up Here's how it works: Anybody can ask a question Anybody can answer The best answers are voted up and rise http://dba.stackexchange.com/questions/118698/sql-oracle-export-error to the top SQL Oracle export error up vote 1 down vote favorite I'm trying to export a database content to a dump file, so I'm doing the following: [root@serverId TEST]# ps -ef|grep pmon|grep -v grep oracle 25371 1 0 Sep29 ? 00:02:22 ora_pmon_SIDPA [root@serverId TEST]# echo $ORACLE_HOME /home/oracle/product/10.2.0 [root@serverId TEST]# echo $ORACLE_SID SIDPA [root@serverId TEST]# echo $PATH /home/oracle/product/10.2.0/bin:/home/oracle/product/10.2.0//bin::/usr/kerberos/sbin:/usr/kerberos/bin:/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/usr/local/cca/CCA_SRV:/root/bin [root@serverId TEST]# exp userId@//serverId:1521/SIDPA FILE=dumpuserId.dmp LOG=dumpuserId.LOG OWNER=userId Export: Release 10.2.0.3.0 - Production on Wed Oct 21 09:10:56 2015 Copyright (c) 1982, 2005, Oracle. All rights reserved. Password: EXP-00056: ORACLE error 12154 encountered ORA-12154: TNS:could not resolve the connect identifier specified EXP-00000: Export terminated unsuccessfully [root@serverId TEST]# As you can see I already set the env vars $ORACLE_HOME and $ORACLE_SID as far as I understand correctly. I also set the PATH, so I think it should work but unfortunately, I does not. Any comments about what to try will be welcomed. Thanks
exp onlinecrm/ks@mydb file=/home/oracle/dbbackup/onlinecrm_09-05.dmp Export: Release 10.2.0.4.0 - Production on 星期一 9月 5 15:28:20 http://m.blog.chinaunix.net/uid-26805356-id-3357727.html 2011 Copyright (c) 1982, 2007, Oracle. All rights reserved. EXP-00056: ORACLE error 12154 encounteredORA-12154: TNS:could not resolve the connect identifier specifiedEXP-00000: Export terminated unsuccessfully [oracle@kuaishang ~]$ exp onlinecrm/ks@mydb file=/home/oracle/dbbackup/onlinecrm_09-05.dmp Export: oracle error 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 encounteredORA-12170: TNS:Connect timeout occurredEXP-00000: Export terminated unsuccessfully [oracle@client1 00056 oracle error 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 onlinecrm/ks@mydb 和tnsnames.ora的SERVICE_NAME = orcl10g不同名,找不到才造成tns "Connect timeout occurred" ;所以把备份语句exp onlinecrm/ks@mydb file=/home/oracle/dbbackup/onlinecrm_09-05.dmp 改成exp onlinecrm/ks@orcl10g file=/home/oracle/dbbackup/onlinecrm_09-05.dmp就可以 上一篇:ifconfig修改IP 下一篇:10种启动故障解决方法(转) ITPUB博客 | ITPUB论坛 | chinaunix论坛 北京皓辰网域网络信息技术有限公司. 版权所有