IMP Error IMP-00058: ORACLE error 1034 encountered [message #423704] |
Sat, 26 September 2009 23:06 |
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 #423736 is a reply to message #423704] |
Sun, 27 September 2009 12:46 |
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 #423758 is a reply to message #423704] |
Sun, 27 September 2009 21:56 |
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 #423764 is a reply to message #423704] |
Sun, 27 September 2009 23:18 |
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 #423800 is a reply to message #423736] |
Mon, 28 September 2009 06:35 |
|
Mahesh Rajendran
Messages: 10708 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
|
|
|