Exp-00056 Oracle Error 1034
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
Exp 00056 Oracle Error 12154 Encountered
Project Hire for a Full Time Job Ways to Get Help Expand exp 00056 oracle error 1017 encountered Search Submit Close Search Login Join Today Products BackProducts Gigs Live Careers Vendor Services Groups Website Testing Store Headlines Experts Exchange > Questions > Oracle export error Want to Advertise Here? Solved Oracle export error Posted on 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_n
error 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 above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. Results 1 to 8 of 8 Thread: exp error Tweet Thread Tools Show Printable Version Email this Page… Subscribe to this Thread… Display Linear Mode Switch to Hybrid https://www.experts-exchange.com/questions/22604458/Oracle-export-error.html Mode Switch to Threaded Mode 10-05-2002,08:02 AM #1 steeve123 View Profile View Forum Posts Visit Homepage Senior Member Join Date Nov 2000 Posts 440 we created an instance on linux with a 9i database. We have imported are data and we connect and select the data. But if we want to export, here is the error. EXP-00056: http://www.dbasupport.com/forums/showthread.php?30130-exp-error ORACLE error 1034 encountered ORA-01034: ORACLE not available ORA-27101: shared memory realm does not exist Compaq Tru64 UNIX Error: 2: No such file or directory EXP-00005: all allowable logon attempts failed EXP-00000: Export terminated unsuccessfully Reply With Quote 10-05-2002,08:21 AM #2 julian View Profile View Forum Posts Senior Advisor Join Date Jun 2001 Location Helsinki. Finland Posts 3,938 Originally posted by steeve123 we created an instance on linux with a 9i database. We have imported are data and we connect and select the data. But if we want to export, here is the error. EXP-00056: ORACLE error 1034 encountered ORA-01034: ORACLE not available ORA-27101: shared memory realm does not exist Compaq Tru64 UNIX Error: 2: No such file or directory EXP-00005: all allowable logon attempts failed EXP-00000: Export terminated unsuccessfully Perhaps the database is down or more liekly the ORACLE_SID is not set. Oracle Certified Master Oracle Certified Professional 6i,8i,9i,10g,11g,12c email: ocp_9i@yahoo.com Reply With Quote 10-05-2002,09:32 AM #3 steeve123 View Profile View Forum Posts Visit Homepage Senior Member
the FAQ by clicking the link above. You may have to register before you can post: click the register http://www.dbforums.com/showthread.php?924674-Logon-via-EXP 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 http://oracle.ittoolbox.com/groups/technical-functional/oracle-db-l/exporting-different-database-users-with-nohup-command-2120568 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 #1 oracle error 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 Export: Release 00056 oracle error 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 Posts 1,137 Check the
Technology and Trends Enterprise Architecture and EAI ERP Hardware IT Management and Strategy Java Knowledge Management Linux Networking Oracle PeopleSoft Project and Portfolio Management SAP SCM Security Siebel Storage UNIX Visual Basic Web Design and Development Windows < Back CHOOSE A DISCUSSION GROUP Research Directory TOPICS Database Hardware Networking SAP Security Web Design MEMBERS Paul_Pedant DACREE MarkDeVries MacProTX Inside-ERP VoIP_News Inside-CRM I_am_the_dragon maxwellarnold Michael Meyers-Jouan TerryCurran Chris_Day Andrew.S.Baker Ramnath.Awate JoeTorre Locutus bracke Dennis Stevenson Craig Borysowich DukeGanote Richard PCMag mircea_luca iudithm Nikki Klein Clinton Jones knowscognosdoi AbhaiTripathi Iqbalyk bluesguyAZ59 COMPANIES Dell Software Panaya Inc. Oracle VAI View All Topics View All Members View All Companies Toolbox for IT Topics Oracle Groups Ask a New Question Oracle Database This group is where peers share technical expertise, solve problems, and discuss issues related to the use of Oracle Databases, including Oracle Grid. Home | Invite Peers | More Oracle Groups Your account is ready. You're now being signed in. Solve problems - It's Free Create your account in seconds E-mail address is taken If this is your account,sign in here Email address Username Between 5 and 30 characters. No spaces please The Profile Name is already in use Password Notify me of new activity in this group: Real Time Daily Never Keep me informed of the latest: White Papers Newsletter Jobs By clicking "Join Now", you agree to Toolbox for Technology terms of use, and have read and understand our privacy policy. exporting different database users with nohup command MOHAMMED ABDUL WAHAB asked May 20, 2008 | Replies (1) Dear All, i have tesing the different database users, so first i prepared the script in /usr/bin and then given permission to a script and run the script with nohup like this vi /usr/bin/mytest.sh export ORACLE_SID=DB01 export NLS_LANG=AMERICAN_AMERICA.AR8MSWIN1256 exp test/test . . .