Welcome Guest ( Log In | Register )


 
 
 
 
 
 

 
 
Oracle 

Performance Tuning Reference poster
 
Oracle training in Linux 

commands
 
Oracle training Weblogic Book
 
Easy Oracle Jumpstart
 
Oracle training & performance tuning books
 
Burleson Consulting Remote DB Administration
 
 
 
Reply to this topicStart new topic
> ORA-01034: ORACLE not available ORA-27101: shared memory realm does not exist
surendar
post Apr 7 2012, 05:43 AM
Post #1


Newbie
*

Group: Members
Posts: 1
Joined: 7-April 12
From: Hyderabad, AP, India
Member No.: 47,049



ERROR:
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist

connected as- / as sysdba
Connected to an idle instance.

SQL> startup
ORA-01261: Parameter db_recovery_file_dest destination string cannot be translated
ORA-01263: Name given for file destination directory is invalid
OSD-04018: Unable to access the specified directory or device.
O/S-Error: (OS 2) The system cannot find the file specified.
SQL>

ORACLE_HOME is - E:\oracle\product\10.2.0\db_2
ORACLE_SID is - orcl11


I'm using Oracle 10.2.0 in windows 7.When i installed oralce it worked properly for 1 week, now throwing an error ora-01034 and ora-27101.
Could you please suggest options for me how to fix this issue ?

I just perform CRUD Operations with database as a java dev by connecting via MYEclipse, but it is not at all allowing me to connect.
Can you help ? sad.gif
Go to the top of the page
 
+Quote Post
burleson
post Apr 7 2012, 07:14 AM
Post #2


Advanced Member
***

Group: Members
Posts: 11,542
Joined: 26-January 04
Member No.: 13



Hi Surendar,


>> talled oralce it worked properly for 1 week, now throwing an error ora-01034 and ora-27101.

Well. something changed! This is the message you get when Oracle is shut down. . . .


See here\, try starting the Oracle and the listener service from Windows:

http://www.dba-oracle.com/t_start_oracle_w...ws_services.htm


Also, what value do you have for db_recovery_file_dest?

db_recovery_file_dest
- ORACLE_BASE/flash_recovery_area.


--------------------
Hope this helps. . .

Donald K. Burleson
Oracle Press author
Author of Oracle Tuning: The Definitive Reference
Go to the top of the page
 
+Quote Post

Reply to this topicStart new topic
1 User(s) are reading this topic (1 Guests and 0 Anonymous Users)
0 Members:

 

Lo-Fi Version Time is now: 1st October 2014 - 01:13 PM