Home » RDBMS Server » Backup & Recovery » IMP Error IMP-00058: ORACLE error 1034 encountered
IMP Error IMP-00058: ORACLE error 1034 encountered [message #423704] Sat, 26 September 2009 23:06 Go to next message
casttree
Messages: 83
Registered: August 2008
Member
When I tried to

create user db_test identified by db_test;
GRANT UNLIMITED TABLESPACE TO db_test;
grant dba to db_test;

connect db_test/db_test
!imp db_test/db_test file = test.dmp full=yes commit=yes buffer= 1000000 log=/home/imp_test.log;
select test from dual; 



In imp_test.log, there is the error.
Quote:

IMP-00058: 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
IMP-00005: all allowable logon attempts failed
IMP-00000: Import terminated unsuccessfully


From some posts, looks like it is caused by the oracle DB is not up, but I can get the result for the sql before and after the imp , so I am guessing it may just some configuration issue.


Also if I run the above SQL in my local host, it works fine. The error I got is only from a test DB. which also let me think it is caused by different DB configuration.


Is there some part I should check ? or any suggestions for this issue.

Thanks,

[Updated on: Sat, 26 September 2009 23:10]

Report message to a moderator

Re: IMP Error IMP-00058: ORACLE error 1034 encountered [message #423705 is a reply to message #423704] Sat, 26 September 2009 23:36 Go to previous messageGo to next message
BlackSwan
Messages: 25039
Registered: January 2009
Location: SoCal
Senior Member
>From some posts, looks like it is caused by the oracle DB is not up,
For some DB.

>but I can get the result for the sql before and after the imp , so I am guessing it may just some configuration issue.
For other DB

>Also if I run the above SQL in my local host, it works fine.
For a DB
>The error I got is only from a test DB. which also let me think it is caused by different DB configuration.
For other DB

>Is there some part I should check ? or any suggestions for this issue.

Check environment.

Post Guidelines clearly state to specify OS name & version & Oracle DB version; which you ignore.

Enjoy your mystery.



Re: IMP Error IMP-00058: ORACLE error 1034 encountered [message #423720 is a reply to message #423704] Sun, 27 September 2009 05:33 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
You have not posted how you are connecting to the sql session
to create the user or what constitutes your LOCAL HOST.

But
Quote:
connect db_test/db_test
!imp db_test/db_test

will connect to the LOCAL HOST or the local database.
If there are two different databases in local machine,
use a tns entry or ORACLE_SID to identify the database to connect to.
Quoting BlackSwan
Quote:

Post Guidelines clearly state to specify OS name & version & Oracle DB version

please try to give complete information to get a complete suggestion.
Re: IMP Error IMP-00058: ORACLE error 1034 encountered [message #423736 is a reply to message #423704] Sun, 27 September 2009 12:46 Go to previous messageGo to next message
casttree
Messages: 83
Registered: August 2008
Member
the connection string is below:

connect SYS/xxxxx@(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=dadvfl0785.test.com)(PORT=11323)))(CONNECT_DATA=(SID=t1l0785))) AS SYSDBA ;
create user db_test identified by db_test;
GRANT UNLIMITED TABLESPACE TO db_test;
grant dba to db_test;

connect db_test/db_test@(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=dadvfl0785.test.com)(PORT=11323)))(CONNECT_DATA=(SID=t1l0785))) ;
!imp db_test/db_test file = test.dmp full=yes commit=yes buffer= 1000000 log=/home/imp_test.log;
select 3 from dual; 


I think the SQL is connecting to same DB, and the test sql "select 3 from dual; works fine.
Re: IMP Error IMP-00058: ORACLE error 1034 encountered [message #423738 is a reply to message #423736] Sun, 27 September 2009 12:54 Go to previous messageGo to next message
BlackSwan
Messages: 25039
Registered: January 2009
Location: SoCal
Senior Member
Enjoy your mystery.

You ignore my request.
I ignore you plea for answers.
Re: IMP Error IMP-00058: ORACLE error 1034 encountered [message #423740 is a reply to message #423736] Sun, 27 September 2009 13:08 Go to previous messageGo to next message
Michel Cadot
Messages: 64111
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
I think the SQL is connecting to same DB,

Good but now be sure of that.

And answer BlackSwan's questions. Third time we asked you.

Regards
Michel
Re: IMP Error IMP-00058: ORACLE error 1034 encountered [message #423750 is a reply to message #423704] Sun, 27 September 2009 17:43 Go to previous messageGo to next message
casttree
Messages: 83
Registered: August 2008
Member
sorry, for OS version and Oracle version are listed below:

OS version (by uname -a) is
Linux 2.6.9-78.0.0.0.1.ELxenU #1 SMP Fri Jul 25 15:04:57 EDT 2008 i686 i686 i386 GNU/Linux

Oracle version is 10.2.0.4


Re: IMP Error IMP-00058: ORACLE error 1034 encountered [message #423751 is a reply to message #423750] Sun, 27 September 2009 17:56 Go to previous messageGo to next message
BlackSwan
Messages: 25039
Registered: January 2009
Location: SoCal
Senior Member
casttree wrote on Sun, 27 September 2009 15:43
sorry, for OS version and Oracle version are listed below:

OS version (by uname -a) is
Linux 2.6.9-78.0.0.0.1.ELxenU #1 SMP Fri Jul 25 15:04:57 EDT 2008 i686 i686 i386 GNU/Linux

Oracle version is 10.2.0.4




>Also if I run the above SQL in my local host, it works fine. The error I got is only from a test DB. which also let me think it is caused by different DB configuration.

For which system is above response for "local host" or "test DB" system?

What SIDs exist on each of the systems involved?
Re: IMP Error IMP-00058: ORACLE error 1034 encountered [message #423758 is a reply to message #423704] Sun, 27 September 2009 21:56 Go to previous messageGo to next message
casttree
Messages: 83
Registered: August 2008
Member
The above is environment for both my local host and the test DB. I can't login test DB, through I can add some test code and get the log file when the test is finished.

But now I am not sure what kind of test code I can add to debug the issue.

Below are the log from test DB
Quote:

Connected.
SQL> SET SERVEROUTPUT ON
SQL> SET AUTOPRINT ON
SQL> create user dwh_test identified by dwh_test ;

User created.

SQL> GRANT UNLIMITED TABLESPACE TO dwh_test ;

Grant succeeded.

SQL> grant dba to dwh_test ;

Grant succeeded.


SQL> connect dwh_test/dwh_test@(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=dadvfl0015.test.com)(PORT=11323)))(CONNECT_DATA=(SID=t1l001 5))) ;
Connected.
SQL> select 3 from dual ;

3
----------
3

SQL> ! imp dwh_test/dwh_test file = lu_period_293.dmp full=yes commit=yes buffer= 1000000 log=imp_lu_perid_293.log ;

SQL> select sid from gv$session where USERNAME = 'DWH_TEST' ;


SID
----------
54



And below are from imp_lu_perid_293.log

Quote:

IMP-00058: 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
IMP-00005: all allowable logon attempts failed
IMP-00000: Import terminated unsuccessfully




Re: IMP Error IMP-00058: ORACLE error 1034 encountered [message #423760 is a reply to message #423758] Sun, 27 September 2009 22:24 Go to previous messageGo to next message
BlackSwan
Messages: 25039
Registered: January 2009
Location: SoCal
Senior Member
run the test to reproduce error as posted in the file below

>And below are from imp_lu_perid_293.log

change directory into the folder which contains imp_lu_perid_293.log

CUT the lines below

date
env | sort
ls -l imp_lu_perid_293.log
uname -a
touch capture.log
ls -l capture.log
date

PASTE the lines above into a terminal/command window

CUT commands & results and PASTE everything back here


What SIDs exist on each of the systems involved?
What SIDs exist on each of the systems involved?
What SIDs exist on each of the systems involved?
What SIDs exist on each of the systems involved?
Re: IMP Error IMP-00058: ORACLE error 1034 encountered [message #423764 is a reply to message #423704] Sun, 27 September 2009 23:18 Go to previous messageGo to next message
casttree
Messages: 83
Registered: August 2008
Member
I may not be able to provide all information for env due to corporation policy. If some variable for env are needed, I may try to get it.

And the test DB is removed after testing and I only can get the saved log.

For SID, it is generted differently each time and specified in connect string.

the log has been removed, so ls -l imp_lu_perid_293.log shows error as below

ls -l imp_lu_perid_293.log
ls: imp_lu_perid_293.log: No such file or directory
$ uname -a
Linux dadvkb0256 2.6.9-78.0.13.2.1.ELxenU #1 SMP Fri Mar 13 21:40:56 EDT 2009 i686 i686 i386 GNU/Linux

[Updated on: Sun, 27 September 2009 23:19]

Report message to a moderator

Re: IMP Error IMP-00058: ORACLE error 1034 encountered [message #423765 is a reply to message #423764] Sun, 27 September 2009 23:23 Go to previous messageGo to next message
BlackSwan
Messages: 25039
Registered: January 2009
Location: SoCal
Senior Member
Enjoy your mystery.

You ignore my request.
I ignore you plea for answers.
Re: IMP Error IMP-00058: ORACLE error 1034 encountered [message #423800 is a reply to message #423736] Mon, 28 September 2009 06:35 Go to previous message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Quote:
I think the SQL is connecting to same DB, and the test sql "select 3 from dual; works fine.

No.
Quote:
connect db_test/db_test@(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=dadvfl0785.test.com)(PORT=11323)))(CONNECT_DATA=(SID=t1l0785))) ;
!imp db_test/db_test file = test.dmp full=yes commit=yes buffer= 1000000 log=/home/imp_test.log;

In the first line you are connecting to a database hosted in
HOST=dadvfl0785.test.com
In second line (invoking imp), you are trying to connect to a local database. You are missing the connect string.
!imp db_test/db_test@youAreMissingThisConnectString
Previous Topic: how to free tablespace after delete data from database
Next Topic: Database got shutdown due to shortest storage in OS
Goto Forum:
  


Current Time: Mon Dec 05 21:21:24 CST 2016

Total time taken to generate the page: 0.11406 seconds