Home » RDBMS Server » Server Administration » ora-01034 ORACLE not available (merged)
ora-01034 ORACLE not available (merged) [message #326499] Wed, 11 June 2008 15:40 Go to next message
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: database not starting [message #326501 is a reply to message #326499] Wed, 11 June 2008 15:45 Go to previous messageGo to next message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
>i cannot find my initsid.ora initialisation parameter file
It should be in your backups.

>what should i do to start the database...........
Make a new initsid.ora file.

>please plzzzzzz help me..........
http://www.orafaq.com/forum/t/88153/0/
Please read & follow posting guidelines as stated in URL above
Re: ora-01034 ORACLE not available [message #326542 is a reply to message #326499] Wed, 11 June 2008 23:21 Go to previous messageGo to next message
Michel Cadot
Messages: 64153
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
i cannot find my initsid.ora initialisation parameter file


So create one.

Read and follow OraFAQ Forum Guide

Regards
Michel
help with oracle [message #326824 is a reply to message #326499] Thu, 12 June 2008 14:46 Go to previous messageGo to next message
deepan_g
Messages: 12
Registered: May 2008
Junior Member
hi,
i was getting the oracle not found (ora-01034)
shared memory realm does not exist (ora-27101)
so i installed the oracle again

i was given a practical to create spfile from pfile
so i first shutdown the database with immediate option, then i connected as sysdba

ie sql> connect /as sysdba
connected to an idle instance.
sql>create spfile from pfile;

after entering the above statement i get two errors
ORA-01078: failure in processing system parameters LRM-00109: could not open parameter file 'E:\ORACLE......'

and now if i try to connect to database i get ora-01034 and ora-27101

why does this happen? and is there any solution for this or will i hav to install it again....
please help.
Re: help with oracle [message #326826 is a reply to message #326824] Thu, 12 June 2008 14:59 Go to previous messageGo to next message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
>why does this happen?
because most likely you did not read & follow the Installation Guide.


>and is there any solution for this
Yes

>or will i hav to install it again....
Only if you are a glutton for punishment.

It appears you are running on Windoze. Which version?
What do you think is the SID of your database?

change directory to $ORACLE_HOME/dbs
List all the files in this directory & post the results back here

http://www.orafaq.com/forum/t/88153/0/
Please read & follow posting guidelines as stated in URL above
Re: help with oracle [message #326829 is a reply to message #326826] Thu, 12 June 2008 15:17 Go to previous messageGo to next message
deepan_g
Messages: 12
Registered: May 2008
Junior Member
hi,
thanks for replying.
yes im using windows xp
oracle release 9.2.0.1.0
the sid for my database is "deep".

im new to oracle so can u please tell me how to change the directory to $ORACLE_HOME/dbs in windows.

there is only one file in e:\oracle\dbs named initdw (it is ora file).
please help
thankyou you very much for helping me in advance.
Re: help with oracle [message #326830 is a reply to message #326826] Thu, 12 June 2008 15:20 Go to previous messageGo to next message
deepan_g
Messages: 12
Registered: May 2008
Junior Member
hi,
thanks for replying.
yes im using windows xp
oracle release 9.2.0.1.0
the sid for my database is "deep".

im new to oracle so can u please tell me how to change the directory to $ORACLE_HOME/dbs in windows.

there is only one file in e:\oracle\dbs named initdw (it is ora file).
please help
thankyou you very much for helping me in advance.

my spfile name is "init.ora.51320080547" and is stored in "E;\oracle\admin\deep\pfile"
Re: help with oracle [message #326832 is a reply to message #326824] Thu, 12 June 2008 15:28 Go to previous messageGo to next message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
>my spfile name is "init.ora.51320080547" and is stored in "E;\oracle\admin\deep\pfile"

I am NOT saying you are wrong, but I am surprised by that file name.

Why do you think it is your spfile?

$ copy E:\oracle\admin\deep\pfile\init.ora.51320080547 e:\oracle\dbs\spfiledeep.ora


sqlplus
/ as sysdba
startup

& what happens?

For what it is worth V9 is no longer supported.
I suggest you work with either V10 or v11.
Re: help with oracle [message #326834 is a reply to message #326832] Thu, 12 June 2008 15:51 Go to previous messageGo to next message
deepan_g
Messages: 12
Registered: May 2008
Junior Member
hi,
thankyou for replying...

i have copied the file to dbs directory then

i tried what u said but it is asking for username and password
after i enter the password im getting errors

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


actually im doing the oca course.im doing it from oracle university.here v9 is available so hav to work wid v9.


thanks for replying
Re: help with oracle [message #326884 is a reply to message #326824] Thu, 12 June 2008 23:40 Go to previous messageGo to next message
Michel Cadot
Messages: 64153
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Don't repeat your question, if you have nex information update the previous topic don't create a new one each day.
http://www.orafaq.com/forum/m/326499/102589/#msg_326499

Regards
Michel

[Updated on: Thu, 12 June 2008 23:40]

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 messageGo to next message
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 #326920 is a reply to message #326916] Fri, 13 June 2008 01:57 Go to previous messageGo to next message
deepan_g
Messages: 12
Registered: May 2008
Junior Member
hi,
thanks for replying....
i hav written the following instructions as u said,but its giving error....

Microsoft Windows XP [Version 5.1.2600]
(C) Copyright 1985-2001 Microsoft Corp.

C:\Documents and Settings\Administrator>cd \

C:\>set oracle_sid=deep

C:\>sqlplus "/ as sysdba"

SQL*Plus: Release 9.2.0.1.0 - Production on Fri Jun 13 12:17:11 2008

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

ERROR:
ORA-01031: insufficient privileges

Enter user-name:


im not getting impatient,its just that my oracle exam is next week.
what should i do...
please help.
thanks


Re: help with oracle [message #326923 is a reply to message #326920] Fri, 13 June 2008 02:13 Go to previous messageGo to next message
abs_amit
Messages: 59
Registered: January 2006
Location: delhi
Member
sqlplus "sys/password as sysdba"

give the password and then try to login
Re: help with oracle [message #326930 is a reply to message #326920] Fri, 13 June 2008 02:25 Go to previous messageGo to next message
Michel Cadot
Messages: 64153
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
There are many and many topics in many forums without speaking about Metalink about this error and you didn't find any answer?

Regards
Michel
Re: help with oracle [message #326934 is a reply to message #326923] Fri, 13 June 2008 02:30 Go to previous messageGo to next message
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 #326947 is a reply to message #326934] Fri, 13 June 2008 02:57 Go to previous messageGo to next message
Michel Cadot
Messages: 64153
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Michel Cadot wrote on Thu, 12 June 2008 06:21
Quote:
i cannot find my initsid.ora initialisation parameter file


So create one.

Regards
Michel


Re: help with oracle [message #326957 is a reply to message #326934] Fri, 13 June 2008 03:37 Go to previous messageGo to next message
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
Re: help with oracle [message #326967 is a reply to message #326957] Fri, 13 June 2008 04:28 Go to previous messageGo to next message
deepan_g
Messages: 12
Registered: May 2008
Junior Member
hi,
i have a problem with loading data into a database lesson.
i want to load using the load wizard using oracle enterprise manager console
ie database -> schema -> [schema name] -> tables
expand the table into which you will load data.
select Data Management -> load from right-mouse menu
it gives error "application can only be launched when the application is connected to the oracle management server (OMS)".

can we connect to oracle management server on a standalone computer?
if yes
how do we connect to OMS?


please help..
thankyou for helping me
Re: ora-01034 ORACLE not available (merged) [message #326968 is a reply to message #326499] Fri, 13 June 2008 04:30 Go to previous messageGo to next message
abs_amit
Messages: 59
Registered: January 2006
Location: delhi
Member
please come with one by one.
let us know first the earlier issue is resolved or not ?


Re: ora-01034 ORACLE not available (merged) [message #326988 is a reply to message #326968] Fri, 13 June 2008 05:23 Go to previous message
deepan_g
Messages: 12
Registered: May 2008
Junior Member
hi amit,
yes my previous problem is solved...
thankyou very much for solving my problem
it really helped me.


thankyou
deepan
Previous Topic: 11i
Next Topic: User Creation
Goto Forum:
  


Current Time: Sun Dec 11 02:26:13 CST 2016

Total time taken to generate the page: 0.10735 seconds