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 ?

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.