OraFAQ Forum: Server Administration » ora-01034 ORACLE not available (merged)

Home » RDBMS Server » Server Administration » ora-01034 ORACLE not available (merged)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ora-01034 ORACLE not available (merged) [message #326499]

Wed, 11 June 2008 15:40

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

BlackSwan
Messages: 26766
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

Report message to a moderator

Re: ora-01034 ORACLE not available [message #326542 is a reply to message #326499]

Wed, 11 June 2008 23:21

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

help with oracle [message #326824 is a reply to message #326499]

Thu, 12 June 2008 14:46

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.

Report message to a moderator

Re: help with oracle [message #326826 is a reply to message #326824]

Thu, 12 June 2008 14:59

BlackSwan
Messages: 26766
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

Report message to a moderator

Re: help with oracle [message #326829 is a reply to message #326826]

Thu, 12 June 2008 15:17

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.

Report message to a moderator

Re: help with oracle [message #326830 is a reply to message #326826]

Thu, 12 June 2008 15:20

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"

Report message to a moderator

Re: help with oracle [message #326832 is a reply to message #326824]

Thu, 12 June 2008 15:28

BlackSwan
Messages: 26766
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.

Report message to a moderator

Re: help with oracle [message #326834 is a reply to message #326832]

Thu, 12 June 2008 15:51

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

Report message to a moderator

Re: help with oracle [message #326884 is a reply to message #326824]

Thu, 12 June 2008 23:40

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

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

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

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

Report message to a moderator

Re: help with oracle [message #326923 is a reply to message #326920]

Fri, 13 June 2008 02:13

abs_amit
Messages: 59
Registered: January 2006
Location: delhi

Member

sqlplus "sys/password as sysdba"

give the password and then try to login

Report message to a moderator

Re: help with oracle [message #326930 is a reply to message #326920]

Fri, 13 June 2008 02:25

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Re: help with oracle [message #326934 is a reply to message #326923]

Fri, 13 June 2008 02:30

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

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Re: help with oracle [message #326957 is a reply to message #326934]

Fri, 13 June 2008 03:37

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

Report message to a moderator

Re: help with oracle [message #326967 is a reply to message #326957]

Fri, 13 June 2008 04:28

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

Report message to a moderator

Re: ora-01034 ORACLE not available (merged) [message #326968 is a reply to message #326499]

Fri, 13 June 2008 04:30

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 ?

Report message to a moderator

Re: ora-01034 ORACLE not available (merged) [message #326988 is a reply to message #326968]

Fri, 13 June 2008 05:23

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

Report message to a moderator

Previous Topic:	11i
Next Topic:	User Creation

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Dec 02 01:22:24 CST 2024