OraFAQ Forum: Backup & Recovery

Home » RDBMS Server » Backup & Recovery » IMP-00058

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

IMP-00058 [message #111434]

Wed, 16 March 2005 06:52

reubenernest
Messages: 4
Registered: 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 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 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: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account 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: 4
Registered: 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)
when i do a ps -ef | grep pmon and smon i do see my instance up and running.
Is there anything else i can do?

I just found something disturbing. Under the /opt/oracle/admin ... i found the entire folder of the db instance missing. can oracle store this directory in any other location?. The db was created using the GUI some time ago.

[Updated on: Wed, 16 March 2005 23:21]

Report message to a moderator

Re: IMP-00058 [message #111878 is a reply to message #111434]

Mon, 21 March 2005 08:08

Uwe
Messages: 260
Registered: February 2003
Location: Zürich, Switzerland

Senior Member

But did you export the Oracle environment variables before starting import ?
Oracle needs to have them globally, not only settled with setenv or var=xxxx
I am not that familliar with csh or bash, but in ksh we always script with
export ORACLE_SID=mydb

regs

Report message to a moderator

Re: IMP-00058 [message #111923 is a reply to message #111878]

Mon, 21 March 2005 20:26

reubenernest
Messages: 4
Registered: March 2005
Location: Singapore

Junior Member

Thanks again. Yes all variable are already in the profile. I managed to fix imp problem, but now i have a new error.

EXP-00008: ORACLE error 4068 encountered
ORA-04068: existing state of packages has been discarded
ORA-04063: has errors
ORA-04063: package body "SYS.DBMS_AQADM_SYS" has errors
ORA-06508: PL/SQL: could not find program unit being called
ORA-06512: at "SYS.DBMS_AQ_IMPORT_INTERNAL", line 85
ORA-06512: at line 1
ORA-06512: at "SYS.DBMS_SYS_SQL", line 1118
ORA-06512: at "SYS.DBMS_SQL", line 316
ORA-06512: at "SYS.DBMS_EXPORT_EXTENSION", line 84
ORA-06512: at "SYS.DBMS_EXPORT_EXTENSION", line 135
ORA-06512: at line 1
EXP-00000: Export terminated unsuccessfully

Report message to a moderator