-
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
-
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.
Oracle Certified Master
Oracle Certified Professional 6i,8i,9i,10g,11g,12c
email: ocp_9i@yahoo.com
-
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
-
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?
Oracle Certified Master
Oracle Certified Professional 6i,8i,9i,10g,11g,12c
email: ocp_9i@yahoo.com
-
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
-
Often this error comes when the ORACLE_SID is not properly set.
Oracle Certified Master
Oracle Certified Professional 6i,8i,9i,10g,11g,12c
email: ocp_9i@yahoo.com
-
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.
-nagarjuna
-
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)?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|