OraFAQ Forum: Server Administration » ORA-01034: ORACLE not available

Home » RDBMS Server » Server Administration » ORA-01034: ORACLE not available (

) 1 Vote

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

ORA-01034: ORACLE not available [message #188482]

Fri, 18 August 2006 13:24

superoscarin@hotmail.com
Messages: 101
Registered: July 2006
Location: Mexico

Senior Member

Hi guys:

I´m getting the error:

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

I tried setting my oracle_sid and i still having the error. Then i do the follow

C:\infra\BIN>sqlplus "/as sysdba"

SQL*Plus: Release 10.1.0.3.0 - Production on Vie Ago 18 09:49:58 2006

Copyright (c) 1982, 2004, Oracle. All rights reserved.

Connected to an idle instance.

SQL> startup
ORA-02778: Name given for the log directory is invalid
SQL> startup c:\infra
SP2-0714: invalid combination of STARTUP options
SQL> startup c:\infra\database\SPFILEBDINFRA.ora
SP2-0714: invalid combination of STARTUP options.

I tried stopping and starting my listener and it doesn't work. Can anybody Help me??

Its very strange because i can start my services qith the console and don't gete me any arror.

I´m working with db 10gr1 in windows 2000

Thanks
Alex

Report message to a moderator

Re: ORA-01034: ORACLE not available [message #188485 is a reply to message #188482]

Fri, 18 August 2006 13:32

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

What part of "ORA-02778: Name given for the log directory is invalid" do you not understand?

Report message to a moderator

Re: ORA-01034: ORACLE not available [message #188487 is a reply to message #188485]

Fri, 18 August 2006 13:42

superoscarin@hotmail.com
Messages: 101
Registered: July 2006
Location: Mexico

Senior Member

Where can i find the log directory?

I´m reading these post s

http://www.experts-exchange.com/Databases/Oracle/Q_20844696.html

http://forums.oracle.com/forums/thread.jspa?messageID=1405846&#1405846

And believe me, if i understand it i don't ask you...

Thanks anacedent

[Updated on: Fri, 18 August 2006 13:44]

Report message to a moderator

Re: ORA-01034: ORACLE not available [message #188489 is a reply to message #188482]

Fri, 18 August 2006 13:47

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

select name from v$parameter where name like '%log%'
One of the specified "log" file destination is not correctly specified.

You might find additional clues in the alert_SID.log file

[Updated on: Fri, 18 August 2006 13:48] by Moderator

Report message to a moderator

Re: ORA-01034: ORACLE not available [message #188490 is a reply to message #188489]

Fri, 18 August 2006 14:03

superoscarin@hotmail.com
Messages: 101
Registered: July 2006
Location: Mexico

Senior Member

If i try to do:
select name from v$parameter where name like '%log%';

I have:
ORA-01034: ORACLE not available.

And what kind of clues are you talking about...

I don't know what happend because 2 months ago i don't have any problems and nobady toch this DB, i dont know if the database is down for 2 month result in this??

Alex

[Updated on: Fri, 18 August 2006 14:10]

Report message to a moderator

Re: ORA-01034: ORACLE not available [message #188494 is a reply to message #188482]

Fri, 18 August 2006 14:23

Yasir Hashmi
Messages: 304
Registered: April 2006

Senior Member

Did you check the services in the control panel?
Are they started?

Report message to a moderator

Re: ORA-01034: ORACLE not available [message #188497 is a reply to message #188494]

Fri, 18 August 2006 14:44

superoscarin@hotmail.com
Messages: 101
Registered: July 2006
Location: Mexico

Senior Member

yes they are

Report message to a moderator

Re: ORA-01034: ORACLE not available [message #188506 is a reply to message #188482]

Fri, 18 August 2006 16:29

Yasir Hashmi
Messages: 304
Registered: April 2006

Senior Member

whats your Sid and global database name?

Report message to a moderator

Re: ORA-01034: ORACLE not available [message #188507 is a reply to message #188506]

Fri, 18 August 2006 16:38

superoscarin@hotmail.com
Messages: 101
Registered: July 2006
Location: Mexico

Senior Member

Hi:

My sid is bdinfra and my global database name is bdinfra.interna.com

Greetings
Alex

Report message to a moderator

Re: ORA-01034: ORACLE not available [message #188513 is a reply to message #188482]

Sat, 19 August 2006 00:09

Yasir Hashmi
Messages: 304
Registered: April 2006

Senior Member

Make your SID and database name as one and reflect the changes in your appropriate directories and files and then try.

Report message to a moderator

Re: ORA-01034: ORACLE not available [message #188519 is a reply to message #188482]

Sat, 19 August 2006 00:30

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>SQL> startup
>ORA-02778: Name given for the log directory is invalid
One of the initSID.ora parameters is "pointing" to a non-existant folder.
Either the parameter value needs to be changed or the directory needs to be created.
It has NOTHING to do with SID or global name.

Report message to a moderator

Re: ORA-01034: ORACLE not available [message #188524 is a reply to message #188482]

Sat, 19 August 2006 01:02

Yasir Hashmi
Messages: 304
Registered: April 2006

Senior Member

Yes you are right ancedent. I am sorry i didn't notice this.
But this problem could only occur if the database is created manually.
Otherwise with OUI or DBCA could have been no errors.

Report message to a moderator

Re: ORA-01034: ORACLE not available [message #188525 is a reply to message #188482]

Sat, 19 August 2006 01:05

Yasir Hashmi
Messages: 304
Registered: April 2006

Senior Member

But what does this error actually means?
Since the services have started, SGA must be allocated and background processes must have started.
By shared memory it means the SGA or anything else?
and what is realm?

Report message to a moderator

Re: ORA-01034: ORACLE not available [message #188539 is a reply to message #188482]

Sat, 19 August 2006 03:24

Yasir Hashmi
Messages: 304
Registered: April 2006

Senior Member

Did you try to start the instance with pfile
SQL>startup pfile='pfile_location';

Report message to a moderator

Re: ORA-01034: ORACLE not available [message #188566 is a reply to message #188539]

Sat, 19 August 2006 16:19

jesuisantony
Messages: 166
Registered: July 2006
Location: Chennai

Senior Member

Can you please confirm if you have set the variable ORACLE_HOME ?

Report message to a moderator

Re: ORA-01034: ORACLE not available [message #188599 is a reply to message #188566]

Sun, 20 August 2006 12:21

superoscarin@hotmail.com
Messages: 101
Registered: July 2006
Location: Mexico

Senior Member

Yes i set my ORACLE_HOME and ORACLE_SID...

I tried to startup 'spfile_path':

because when i tried to create a pfile i have the follow message error:

First i tried to :
startup nomount
i have the follow message error...
SP2-0310 unable to open nomount.sql

After i should try to create the pfile but i can´t...

Can you give me the path for initSID.ora? i understand that it is when i'm connecting to other server (heterogeneous services). I only have a file init.ora in my PC.

In this case i´m working locally and in a infraestructura database of OAS.

What do you recommend me?

Thanks for your efforts.
Alex

Report message to a moderator

Re: ORA-01034: ORACLE not available [message #188603 is a reply to message #188482]

Sun, 20 August 2006 15:02

Yasir Hashmi
Messages: 304
Registered: April 2006

Senior Member

Whenever we start an instance of a database, oracle reads the initialization parameter file to start the instance.
You check your spfile(i hope you have it).Check the locations of initialization parameters and verify whether the locations exist or not.

Report message to a moderator

Re: ORA-01034: ORACLE not available [message #188604 is a reply to message #188599]

Sun, 20 August 2006 15:13

superoscarin@hotmail.com
Messages: 101
Registered: July 2006
Location: Mexico

Senior Member

I had to create the follow folders:

C:admin\bdinfra\bdump
C:admin\bdinfra\cdump
C:admin\bdinfra\udump

Now it works, thank you very much to all for your help.

I really apprecciate your help.
Your friend Alex.

Report message to a moderator

Re: ORA-01034: ORACLE not available [message #188605 is a reply to message #188482]

Sun, 20 August 2006 15:32

Yasir Hashmi
Messages: 304
Registered: April 2006

Senior Member

Yes you forgot the error.
anacedent rightly pointed:
One of the initSID.ora parameters is "pointing" to a non-existant folder.
Either the parameter value needs to be changed or the directory needs to be created

Report message to a moderator

Re: ORA-01034: ORACLE not available [message #189234 is a reply to message #188482]

Wed, 23 August 2006 14:33

jamesbond007
Messages: 2
Registered: August 2006

Junior Member

i man i have gone through you problems and i suggest you to do the following
go through to the dos prompt and execute oradim utility
and firstly delete the service and create new service and then check it it will work.
bye

Report message to a moderator

Re: ORA-01034: ORACLE not available [message #189261 is a reply to message #189234]

Wed, 23 August 2006 19:23

superoscarin@hotmail.com
Messages: 101
Registered: July 2006
Location: Mexico

Senior Member

what service are you talking about?

Report message to a moderator

Previous Topic:	Trace Issue
Next Topic:	Oracle database design patterns

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Apr 24 10:07:27 CDT 2024