Exp-00056 Oracle Error 1031 Encountered
Contents |
Failed If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link exp 00056 oracle error 12154 encountered above to proceed. To start viewing messages, select the forum that you want
Exp 00056 Oracle Error 1017 Encountered
to visit from the selection below. Results 1 to 5 of 5 Thread: Export Failed Tweet Thread Tools Show Printable
Exp 00056 Oracle Error 1034 Encountered
Version Email this Page… Subscribe to this Thread… Display Linear Mode Switch to Hybrid Mode Switch to Threaded Mode 08-13-2004,12:37 AM #1 CaoCao View Profile View Forum Posts Junior Member Join Date Sep 2003 Location China Posts 72 Export Failed OS: Windows 2000 Pro Oracle: 8.0.5.2.1 My company has many instances. Currently each instance is hosting one schema user which is access by an application. I thought of consolidating 2 or 3 instances into 1 instance. I want to know the pros and cons of running in 1 instance as compared to separate indivual instances. Tks. Errors: . exporting table JOB_GROUP EXP-00056: ORACLE error 1031 encountered ORA-01031: insufficient privileges . . exporting table JOB_SUB_GROUP EXP-00056: ORACLE error 1031 encountered ORA-01031: insufficient privileges . . exporting table KSEMP EXP-00056: ORACLE error 1031 encountered ORA-01031: insufficient privileges Reply With Quote 08-13-2004,04:16 AM #2 OracleDoc View Profile View Forum Posts The Doc is in! Join Date Sep 2003 Location over the hill and through the woods Posts 995 My company has many instances. Currently each instance is hosting one schema user which is access by an application. I thought of consolidating 2 or 3 instances into 1 instance. I want to know the pros and cons of running in 1 instance as compared to separate indivual instances. Tks. first of all... 1.Do all these instances run on one server? If not, do you have enough room and resources to fit all the extra data onto the one server. 2.The type of instances you have.. are they all realtivly the same? IE.. OLTP, warehouse, ect, ect.. Code: . exporting table JOB_GROUP EXP-00056: ORACLE error 1031 encountered ORA-01031: insufficient privileges . . exporting table JOB_SUB_GROUP EXP-00056: ORACLE error 1031 encountered ORA-01031: insufficient privileges . . exporting table KSEMP EXP-00056: ORACLE error 1031 encountered ORA-
CommunityOracle User Group CommunityTopliners CommunityOTN Speaker BureauJava CommunityError: You don't have JavaScript enabled. This tool uses JavaScript and much of it will not work correctly without it enabled. Please turn JavaScript back on and reload this page. Please enter a title. You can not post a blank message. Please type your message and try again. More discussions in General Database Discussions All PlacesDatabaseGeneral Database Discussions This discussion is archived 5 Replies Latest reply on Mar 25, 2010 4:22 AM by 739193 EXP-00008: ORACLE error 1031 encountered 739193 Mar 24, 2010 6:59 AM Hi All, I am getting these below errors during export.. Can you please anybody point out what went wrong?? .. .. .. .. http://www.dbasupport.com/forums/showthread.php?44193-Export-Failed . exporting refresh groups and children . exporting dimensions . exporting post-schema procedural objects and actions EXP-00008: ORACLE error 1031 encountered ORA-01031: insufficient privileges ORA-06512: at "SYS.DBMS_SCHED_MAIN_EXPORT", line 1598 ORA-06512: at "SYS.DBMS_SCHED_JOB_EXPORT", line 12 ORA-06512: at line 1 EXP-00085: The previous problem occurred when calling SYS.DBMS_SCHED_JOB_EXPORT.create_exp for object 107448 . exporting user history table . exporting default and system auditing options . exporting statistics Export terminated successfully with warnings. https://community.oracle.com/thread/1050075 Regards Arun I have the same question Show 0 Likes(0) 5805Views Tags: none (add) arunContent tagged with arun, dbaContent tagged with dba This content has been marked as final. Show 5 replies 1. Re: EXP-00008: ORACLE error 1031 encountered Rafi (Oracle DBA) Mar 24, 2010 7:04 AM (in response to 739193) Hi Arun, The link given below will help you solving this error.Can you please check the priveleges. http://asktom.oracle.com/pls/apex/f?p=100:11:0::::P11_QUESTION_ID:497621743228 Best regards, Rafi http://rafioracledba.blogspot.com/ Like Show 0 Likes(0) Actions 2. Re: EXP-00008: ORACLE error 1031 encountered 739193 Mar 24, 2010 7:08 AM (in response to Rafi (Oracle DBA)) seems the 1031 is the first thing to fix, please utilize support, you should have sufficient information for them to diagnose this pretty easily. So i should raise a SR with oracle? Like Show 0 Likes(0) Actions 3. Re: EXP-00008: ORACLE error 1031 encountered Anil Malkai Mar 24, 2010 7:10 AM (in response to 739193) try this note id 730067.1 for resolving ORA=1031 error. Hope that will help you. Anil Malkai Like Show 0 Likes(0) Actions 4. Re: EXP-00008: ORACLE error 1031 encountered 724798 Mar 24, 2010 7:34 AM (in response to 739193) Hi, please post the exp command which you are using. by which user y
parameters given are correct but still not able to connectBelow is the http://dbaforums.org/oracle/lofiversion/index.php?t19405.html error trace:EXP-00056: ORACLE error 12545 encountered ORA-12545: Connect failed because target host or object does not exist EXP-00000: Export terminated unsuccessfully What can http://grokbase.com/t/freelists.org/oracle-l/02btk74xp3/q-oracle-9i-remote-export-quot-insufficient-previlege-quot be the possible reasons? dave Mar 26 2010, 09:01 AM the error is quite clear, you need to ensure you are connecting to oracle error a database that exists and you have your tnsnames setup orrectly RHR Mar 26 2010, 11:31 AM It is difficult to diagnose the issue with any specificity based on the information you have included; however, as noted, the Oracle error is pretty clear.Perhaps you will find 00056 oracle error some useful information here:ORA-12545 Connection Failed Tips burleson Mar 26 2010, 01:03 PM Hi>> ORA-12545: Connect failed because target host or object does not exist [quute]ORA-12545: Connect failed because target host or object does not exist Cause: The address specified is not valid, or the program being connected to does not exist. Action: Ensure the ADDRESS parameters have been entered correctly; the most likely incorrect parameter is the node name. Ensure that the executable for the server exists (perhaps "oracle" is missing.) If the protocol is TCP/IP, edit the TNSNAMES.ORA file to change the host name to a numeric IP address and try again.[/quote]See here:http://www.dba-oracle.com/t_ora_12545_connect_failed.htm This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here. Invision Power Board © 2001-2016 Invision Power Services, Inc.
database test and tried to export form a 8icomputer to 9iR2 server. I got "ORA-01031: insufficient privileges".my export parfile on 8i server is:userid='sys/passwd1_at_db92 as sysdba'file=/tmp/exp_db8i_full.dmpbuffer=64000000compress=ngrants=yindexes=yrows=yfeedback=10000constraints=yconsistent=ylog=exp_db8i_full.logfull=yI got:Export: Release 8.1.7.2.0 - Production on Tue Nov 26 14:02:57 2002(c) Copyright 2000 Oracle Corporation. All rights reserved.EXP-00056: ORACLE error 1031 encounteredORA-01031: insufficient privilegesUsername:Does anyone know why??Thanks.The new MSN 8: smart spam protection and 2 months FREE*http://join.msn.com/?page=features/junkmail--Please see the official ORACLE-L FAQ: http://www.orafaq.com--Author: dist cashINET: mccdba_at_hotmail.comFat City Network Services -- 858-538-5051 http://www.fatcity.comSan Diego, California -- Mailing list and web hosting services---------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail messageto: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing). reply Tweet Search Discussions Search All Groups oracle-l 2 responses Oldest Nested John Thomas I think you need a password file on the 9i server to connect remotely with SYSDBA privilege. Go to $ORACLE_HOME/dbs and use orapwd. You may need to set an init.ora parameter along the lines of remote_password_exclusive or shared depending upon whether you want multiple users (or was it databases?) using the same file to log in remotely as well... Cheers, John Thomas In message, dist cash writes -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Thomas INET John Thomas at Nov 26, 2002 at 11:25 pm ⇧ I think you need a password file on the 9i server to connect remote