exp error

[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

[julian]

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.

[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

[julian]

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?

[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

[julian]

Often this error comes when the ORACLE_SID is not properly set.

[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.

[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)?