Exp-00056 Oracle Error 12514 Encountered
connectdescriptor Posted on April 2, 2008 by aiiriigz exp 00056 oracle error 12154 encountered C:Documents and SettingsAdministrator>sqlplus system/manager@hysit SQL*Plus: Release exp 00056 oracle error 1017 encountered 10.2.0.1.0 - Production on 星期三 4月 2 11:35:04 2008 Copyright (c) exp 00056 oracle error 1034 encountered 1982, 2005, Oracle. All rights reserved. ERROR:ORA-12514: TNS:listener does not currently know of service requested in connect descriptor 修改 listener.oraSID_LIST_LISTENER = (SID_LIST = (SID_DESC = (SID_NAME = PLSExtProc) (ORACLE_HOME = /u01/app/ora10g/product/10.2.0) (PROGRAM = extproc) ) ) 修改为如下: SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (SID_NAME = PLSExtProc) (ORACLE_HOME = /u01/app/ora10g/product/10.2.0) (PROGRAM = extproc) ) (SID_DESC = (GLOBAL_DBNAME = ora9) (ORACLE_HOME = /u01/app/ora10g/product/10.2.0) (SID_NAME = ora9) ) ) 另外一个问题解决: SQL> startupORA-00119: invalid specification for system parameter LOCAL_LISTENERORA-00132: syntax error or unresolved network name ‘LISTENER_ORA9'SQL> startup mountORA-00119: invalid specification for system parameter LOCAL_LISTENERORA-00132: syntax error or unresolved network name ‘LISTENER_ORA9'SQL> startup nomountORA-00119: invalid specification for system parameter LOCAL_LISTENERORA-00132: syntax error or unresolved network name ‘LISTENER_ORA9' SQL> ![ora10g@testg ~]$ cd /u01/app/ora10g/product/10.2.0/dbs/[ora10g@testg dbs]$ lshc_ora9.dat initdw.ora lkORA9 spfileora9.orahc_test10g.dat init.ora orapwora9 [ora10g@testg dbs]$ strings spfileora9.ora > initora9.ora 编辑,去掉 local_listener 这行 [ora10g@testg dbs]$ vi initora9.ora *.local_listener='LISTENER_ORA9′ [ora10g@testg dbs]$ pwd/u01/app/ora10g/product/10.2.0/dbs[ora10g@testg dbs]$ lshc_ora9.dat initdw.ora initora9.ora orapwora9hc_te
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 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 https://aiiriigz.wordpress.com/2008/04/02/sqlplusora-12514-tnslistener-does-not-currently-know-of-service-requested-in-connect-descriptor/ 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 to the top How to create an oracle dump(.dmp) file using Toad? up vote 1 down vote favorite 1 We can export the entire database schema(skeleton) along with its data in one .dmp file using oracles "exp" tool. But how do http://dba.stackexchange.com/questions/72845/how-to-create-an-oracle-dump-dmp-file-using-toad I do it using Toad only. I can't use this C:\Users\kaunds_oliver>exp PORTAL_xxx/xxx@asdb file=E:\\Oliver\\userexpo rt.dmp log=E:\\Oliver\\userexport.log As there is no entry in the TNSNAMES.ora for the remote server ="asdb" Also, I tried doing this ASDB = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP) (HOST = 172.27.xx.xx) (PORT = 1530)) ) (CONNECT_DATA = (SERVICE_NAME = asdb)) ) But I don't have the privileges to edit anything in C Drive i.e. the TNSNAMES.ora file How do I create a dump file using specifically "Toad" tool of a database that I am connected to remotely? sql oracle share|improve this question asked Jul 31 '14 at 9:40 Oliver 108115 migrated from stackoverflow.com Jul 31 '14 at 11:52 This question came from our site for professional and enthusiast programmers. You can use dbms_datapump from any SQL client –a_horse_with_no_name Jul 31 '14 at 12:45 add a comment| 2 Answers 2 active oldest votes up vote 1 down vote accepted Not directly answering the question as I don't use Toad, but you can use exp without a tnsnames.ora by using the 'easy connect' syntax for the connection string, at least in recent versions: exp PORTAL_xxx/xxx@//172.27
Post your question and get tips & solutions from a community of 418,548 IT Pros & Developers. It's quick & easy. EXP-00056 ORACLE error 12154 encountered P: https://bytes.com/topic/oracle/answers/925029-exp-00056-oracle-error-12154-encountered 61 osman7king I have tried to export a database, but i got the following http://blog.itpub.net/26844646/viewspace-1093755/ message: EXP-00056 ORACLE error 12154 encountered ORA-12154: TNS could not resolve the connect identifier specified but i can access the database successfully and the TNS is correct. Thanks Nov 26 '11 #1 Post Reply Share this Question 3 Replies Expert 100+ P: 699 rski Show the command you use to export database. Nov oracle error 26 '11 #2 reply P: 61 osman7king dear rski.. I have fixed the problem. there was a '@' charactre in the password of my database, and after I change the password and remove that character from it, the problem has been fixed and the export operation has been done successfully. THANKS. Nov 29 '11 #3 reply P: 1 Andrewpaul Dear osman7king, Oracle 12154 error means TNS 00056 oracle error could not resolve the connect identifier specified. A connection to a database or other service was requested using a connect identifier, and the connect identifier specified could not be resolved into a connect descriptor using one of the naming methods configured. You can try below instruction There was a '@' character in the password of your database, and after you change the password and remove that character from it, the problem has been fixed and the export operation has been done successfully. For more solution visit, Feb 15 '12 #4 reply Message Cancel Changes Post your reply Join Now >> Sign in to post your reply or Sign up for a free account. Similar topics regular exp using exp() inside many nested for loops causing Memory overflow finding underflow/overflow threshold for exp(x) exp exp function help! Opening for IBM/DB2 Content Manager with 2yrs of Exp In Chennai Help needed with reg exp please reg exp help math.exp(complex) reg exp question: removing class and style from html Browse more Oracle Database Questions on Bytes Question stats viewed: 7545 replies: 3 date asked: Nov 26 '11 Follow this discussion BYTES.COM 2016 Formerly "TheScripts.com" from 2005-2008 About Bytes
首页 | 博文目录 | 关于我 caisanpx 博客访问: 384856 博文数量: 169 用 户 组: 普通用户 注册时间: 2012-04-12 15:01 个人简介 暂无介绍 文章分类 全部博文(169) goldgate(2) rac(1) dataguard(6) backup&recovery(2) Oracle开发(10) ORACLE(5) TroubleSho(1) LINUX(7) ORACLE基础(97) oracle读书笔记(2) 转载(15) 未分配的博文(22) 文章存档 2016年(16) 2016年10月(1) 2016年03月(1) 2016年02月(8) 2016年01月(6) 2015年(12) 2015年12月(5) 2015年11月(2) 2015年10月(1) 2015年02月(3) 2015年01月(1) 2014年(65) 2014年10月(3) 2014年09月(5) 2014年07月(1) 2014年06月(4) 2014年05月(6) 2014年04月(16) 2014年03月(21) 2014年02月(3) 2014年01月(6) 2013年(49) 2013年12月(13) 2013年11月(17) 2013年10月(13) 2013年08月(1) 2013年03月(3) 2013年02月(2) 2012年(27) 2012年12月(4) 2012年11月(22) 2012年04月(1) 我的朋友 最近访客 fengsong 烟花丶易 Y一沉不 palosky datapeng Allen_21 yejinhe1 zxx2403 aaaaaaaa 微信关注 IT168企业级官微 微信号:IT168qiye 系统架构师大会 微信号:SACC2013 订阅 推荐博文 ·Oracle系统表 smon_scn_time ... ·MySQL--异常的客户端连接... ·MySQL Profile在5.7的简单测... ·Oracle恢复流程图 ·dbms_resource_manager.calib... 热词专题 友情链接 ·tianlesoftware ·realkid4 ·tahiti ·oracle-base ·Maclean ·Roger ·d.b.c.a ·Fenng ·PL/SQLChallenge ·asktom EXP-00056: ORACLE error 12514 encountered解决方法 2014-02-26 21:46:49 分类: Oracle
[oracle@cj emp_imp]$ exp scott/tiger@cj01 tables=scott.dept, file='/db/ora11g/test/emp_imp/dept.dmp', log='/db/ora11g/test/emp_imp/dept.log'; Export: Release 11.2.0.1.0 - Production on Wed Feb 26 21:41:22 2014 Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved. EXP-00056: ORACLE error 12514 encountered ORA-12514: TNS:listener does not currently know of service requested in connect descriptor EXP-00000: Export terminated unsuccessfully 使用转义字符进行转换 [oracle@cj emp_imp]$ exp scott/\"tiger@cj01\" tables=scott.dept, file='/db/ora11g/test/emp_imp/dept.dmp', log='/db/ora11g/test/emp_imp/dept.log'; Export: Release 11.2.0.1.0 - Production on Wed Feb 26 21:44:18 2014 Copyright (c) 1982, 2009, Oracle and/or its affili