Exp-00056 Oracle Error 1034 Encountered
Contents |
for Help Receive Real-Time Help Create a Freelance Project Hire for a Full Time Job Ways to Get Help Ask a Question Ask for Help Receive Real-Time Help Create a Freelance Project Hire for a Full Time Job Ways to Get Help Expand ora 01034 oracle not available Search Submit Close Search Login Join Today Products BackProducts Gigs Live Careers Vendor Services Groups
Exp 00056 Oracle Error 12154 Encountered
Website Testing Store Headlines Experts Exchange > Questions > Oracle export error Want to Advertise Here? Solved Oracle export error Posted on exp 00056 oracle error 1017 encountered 2007-05-31 Oracle Database 1 Verified Solution 2 Comments 3,385 Views Last Modified: 2013-12-18 When I try to export the database, using exp, I get the following error: -bash-3.1$ exp Export: Release 10.2.0.1.0 - Production on Thu May 31 16:06:50 2007 Copyright (c) 1982, 2005, Oracle. All rights reserved. Username: ********** Password: EXP-00056: ORACLE error 1034 encountered ORA-01034: ORACLE not available ORA-27101: shared memory realm does not exist Linux Error: 2: No such file or directory EXP-00005: all allowable logon attempts failed EXP-00000: Export terminated unsuccessfully Could someone tell me how this can be solved. The export is done with the oracle user, and there is a production application that works with the database, so the database is up. If someone needs other details I will post them. 0 Question by:bogdan_etechnics Facebook Twitter LinkedIn Google LVL 8 Best Solution byYANN0S You can try: exp username/password@db_name where db_name is the service name (SID) of the instance you want to export from. Go to Solution 2 Comments LVL 8 Overall: Level 8 Oracle Database 7 Message Expert Comment by:gvsbnarayana2007-05-31 Hi, Are you able to connect to the database normally? What is the ORACLE_SID for the linix session ? Please check at linux prompt: echo $ORACLE_HOME does this result show the database name that you want to connect to? If yes, is the database started and able to connect to the database? HTH Regards, Badri. 0 LVL 8 Overall: Level 8 Oracle Database 8 Message Accepted Solution by:YANN0S2007-05-31 You can try: exp username/password@db_name where db_name is the service name (SID) of the instance you want to export from. 0 Write Comment First Name Please enter a first name Last Name Please enter a last name Email We will never share this with anyone. Comment Submit Your Comment By clicking you are agreeing to Experts Exchange's Terms of Use. Featured Post IT, Stop Being Called Into Every Meeting Promoted by Highfive Highfive is so simple that setting up every meeting room
Messages: 4Registered: March 2005 Location: Singapore Junior Member Hi, I am managing an Oracle 8.1.7 on a sun 2.6 platform. All the database instances i am unable to do an IMP funtion. Below is the error i get... IMP-00058: ORACLE error 1034 encountered ORA-01034: ORACLE not available ORA-27101: shared memory realm does not exist SVR4 Error: 2: No such file or directory IMP-00005: all allowable logon attempts failed IMP-00000: Import terminated unsuccessfully I tried to connect using https://www.experts-exchange.com/questions/22604458/Oracle-export-error.html svrmgrl. I am getting this error sgmcdb01% svrmgrl Oracle Server Manager Release 3.1.7.0.0 - Production Copyright (c) 1997, 1999, Oracle Corporation. All Rights Reserved. Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production With the Partitioning option JServer Release 8.1.7.0.0 - Production SVRMGR> connect internal Connected. SVRMGR> select * from global_name; select * from global_name * ORA-01034: ORACLE http://www.orafaq.com/forum/t/42358/2/ not available Can anybody help me fix the problem? Your help would be very much appreciated Report message to a moderator Re: IMP-00058 [message #111449 is a reply to message #111434] Wed, 16 March 2005 08:18 Mahesh Rajendran Messages: 10672Registered: March 2002 Location: oracleDocoVille Senior MemberAccount Moderator >> ORA-01034: ORACLE not available the problem is , the database you are trying to export /import is NOT up and available. or Your ENV is not properly set. You must be looking into WRONG instances. >>sgmcdb01% svrmgrl above command assumes you have set ORACLE_SID=something and by default tries to login into database/instance named SOMETHING. Report message to a moderator Re: IMP-00058 [message #111505 is a reply to message #111449] Wed, 16 March 2005 21:46 reubenernest Messages: 4Registered: March 2005 Location: Singapore Junior Member Thanks for the reply. But my database is up and running cos the clients can do their normal operations. I did set the environment correct setenv $ORACLE_SID (my_db) whe
the FAQ by clicking the link above. You may have to register before you can post: click the http://www.dbforums.com/showthread.php?924674-Logon-via-EXP register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. Results 1 to 7 of 7 Thread: Logon via EXP Tweet Thread Tools Show Printable Version Subscribe to this Thread… Search Thread Advanced Search Display Linear Mode Switch to Hybrid Mode Switch to Threaded Mode 09-22-03,09:29 oracle error #1 tanaka View Profile View Forum Posts Registered User Join Date Sep 2003 Location Chiang Mai Thailand Posts 14 Unanswered: Logon via EXP Hello I try to use EXP utility oracle 9.0.2 after I telnet to server and type to shell promt (oracle user) as followed [oracle@linux-serv EXP]$ exp system/**** file=/EXP/expdat.dmp compress=y System return me as followed 00056 oracle error Export: Release 9.2.0.1.0 - Production on Mon Sep 22 19:40:43 2003 Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved. EXP-00056: ORACLE error 1034 encountered ORA-01034: ORACLE not available ORA-27101: shared memory realm does not exist Linux Error: 2: No such file or directory EXP-00005: all allowable logon attempts failed EXP-00000: Export terminated unsuccessfully Evenif I use system user and system's password login to Oracle Enterprise Manager successful. I gave same password to exp parameter. But I can not log in to system. How can I fix this problem? I try to solve problem.By use oerr command. It told me as I did'nt start oracle instance. Evenif it still running..... I reconize something. I can connect as system in oracle enterprise manager (normal and as sysdba). But for sys use I connect as sysdba only. Guide me please. Thank you. Attached Thumbnails Kindly regards, Thana p. Chiangmai Thailand Yim_cm@hotmail.com Reply With Quote 09-22-03,09:39 #2 AlanP View Profile View Forum Posts Registered User Join Date Mar 2002 Location Reading, UK Post