exp error

Printable View

10-05-2002, 08:02 AM
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
10-05-2002, 08:21 AM
julian

Quote:

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.
10-05-2002, 09:32 AM
steeve123

The oracle_sid is set
my oracle version is:

Oracle9i Release 9.0.1.0.0 - Production
PL/SQL Release 9.0.1.0.0 - Production
CORE 9.0.1.0.0 Production
TNS for Compaq Tru64 UNIX: Version 9.0.1.0.0 - Production
NLSRTL Version 9.0.1.0.0 - Production
10-05-2002, 09:40 AM
julian

Quote:

Originally posted by steeve123
The oracle_sid is set
my oracle version is:

Oracle9i Release 9.0.1.0.0 - Production
PL/SQL Release 9.0.1.0.0 - Production
CORE 9.0.1.0.0 Production
TNS for Compaq Tru64 UNIX: Version 9.0.1.0.0 - Production
NLSRTL Version 9.0.1.0.0 - Production

Check the privileges to the Oracle executible in the bin directory. Is the DB up?
10-05-2002, 09:40 AM
laxman

Hi ,

Generally u will "ORA-01034: ORACLE not available "
error when ur database is not up and running..

ORA-27101: shared memory realm does not exist
For this check the shared memory viz kernel parameters

First up the database normally and
then export..

Laxman
10-06-2002, 04:28 AM
julian

Often this error comes when the ORACLE_SID is not properly set.
10-07-2002, 12:43 AM
nagarjuna

I got such an error few times when I try to bounce the database using sqlplus. But, it worked fine with svrmgrl. Donno about 9i.
10-07-2002, 10:38 AM
jgmagnus

would help if you provide your command-line or your parameter file for the export ...

this JUST happened, or happens all the time (many days)?