Home » Developer & Programmer » Precompilers, OCI & OCCI » ERROR:ORA-01034: ORACLE not available & ORA-27101: shared memory realm does not exist
ERROR:ORA-01034: ORACLE not available & ORA-27101: shared memory realm does not exist [message #238893] Sun, 20 May 2007 19:56 Go to next message
henryJack85
Messages: 5
Registered: May 2007
Location: Malaysia
Junior Member
Hi,

I try to install input all the SQL script (install.ora inside have "CREATE Table".... "Insert data") into my database "my_db",
User name : user
Password:passwd

How to solve this problem....

[root@gridlab95 data]# sqlplus user/passwd @install.ora >& results.ora

Output:
------------------------------------------------------------------------------------------------------------------------------------- ----------------------------------------
SQL*Plus: Release 10.2.0.1.0 - Production on Mon May 21 08:24:56 2007

Copyright (c) 1982, 2005, Oracle. All rights reserved.

ERROR:
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux Error: 2: No such file or directory


Enter user-name:
------------------------------------------------------------------------------------------------------------------------------------- ---------------------------------------

If this is cause by my username and password not match. Is there any password recovery in Oracle? I comfirm that the user name is correct...


Thank you...

-HenryJack
Re: ERROR:ORA-01034: ORACLE not available & ORA-27101: shared memory realm does not exist [message #238951 is a reply to message #238893] Mon, 21 May 2007 01:15 Go to previous message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
This error isn't result of invalid password, but the fact that your database isn't up. Startup the database and try again.
Previous Topic: /usr/bin/ld: cannot find -lclntsh
Next Topic: Free Download Pro*C for SUN
Goto Forum:
  


Current Time: Thu Mar 28 16:43:10 CDT 2024