ora-01034 ORACLE not available (merged) [message #326499] |
Wed, 11 June 2008 15:40 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/124719.jpg) |
deepan_g
Messages: 12 Registered: May 2008
|
Junior Member |
|
|
hi guys,
when i try to start the database i get an error
ora-01034: ORACLE not available
ora-27101: shared memory realm does not exist.
ORA-01078: failure in processing system parameters LRM-00109: could not open parameter file 'E:\ORACLE\DATABASE\INITsid.ORA'.
i cannot find my initsid.ora initialisation parameter file
what should i do to start the database...........
please plzzzzzz help me..........
[Updated on: Wed, 11 June 2008 23:20] by Moderator Report message to a moderator
|
|
|
|
|
|
|
|
|
|
|
|
Re: help with oracle [message #326916 is a reply to message #326834] |
Fri, 13 June 2008 01:36 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
abs_amit
Messages: 59 Registered: January 2006 Location: delhi
|
Member |
|
|
Deepan,
First of all be patient and don’t think about reinstallation.
Let’s resolve it.
How you are connecting to the database? It shouldn't ask for the password.
Do this:
c:\> set oracle_sid=deep
c:\> sqlplus "/ as sysdba"
SQL> startup
Let us know what happens
[Updated on: Fri, 13 June 2008 01:36] Report message to a moderator
|
|
|
|
|
|
Re: help with oracle [message #326934 is a reply to message #326923] |
Fri, 13 June 2008 02:30 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/124719.jpg) |
deepan_g
Messages: 12 Registered: May 2008
|
Junior Member |
|
|
hi,
thankyou very much.
now i have connected to an idle instance...
now what to do?
can i start using the database?
can i create an spfile from a pfile by using
create spfile from pfile;
Because all this problems started when i executed this command.
thankyou very much it solved my problem...
it really helped me..
thanks.
after connected to an idle instance,i gave the startup instruction it is giving error
ie
SQL> startup
ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file 'E:\ORACLE\DATABASE\INITDEEP.ORA'
SQL>
[Updated on: Fri, 13 June 2008 02:35] Report message to a moderator
|
|
|
|
Re: help with oracle [message #326957 is a reply to message #326934] |
Fri, 13 June 2008 03:37 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
abs_amit
Messages: 59 Registered: January 2006 Location: delhi
|
Member |
|
|
please create spfile using below command:
SQL> create spfile from pfile='path of pfile';
and then try to start the instance.
it will start the instance if it is a valid spfile.
or you can try with below to validate the pfile.
SQL> startup pfile=<path of pfile>;
try this
Regards
Amit yadav
|
|
|
|
|
|