Home » RDBMS Server » Server Administration » ORA-01034: ORACLE not available  () 1 Vote
ORA-01034: ORACLE not available [message #188482] Fri, 18 August 2006 13:24 Go to next message
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
Re: ORA-01034: ORACLE not available [message #188485 is a reply to message #188482] Fri, 18 August 2006 13:32 Go to previous messageGo to next message
BlackSwan
Messages: 25033
Registered: January 2009
Location: SoCal
Senior Member
What part of "ORA-02778: Name given for the log directory is invalid" do you not understand?
Re: ORA-01034: ORACLE not available [message #188487 is a reply to message #188485] Fri, 18 August 2006 13:42 Go to previous messageGo to next message
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 Go to previous messageGo to next message
BlackSwan
Messages: 25033
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 Go to previous messageGo to next message
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 Go to previous messageGo to next message
Yasir Hashmi
Messages: 304
Registered: April 2006
Senior Member
Did you check the services in the control panel?
Are they started?
Re: ORA-01034: ORACLE not available [message #188497 is a reply to message #188494] Fri, 18 August 2006 14:44 Go to previous messageGo to next message
superoscarin@hotmail.com
Messages: 101
Registered: July 2006
Location: Mexico
Senior Member

yes they are
Re: ORA-01034: ORACLE not available [message #188506 is a reply to message #188482] Fri, 18 August 2006 16:29 Go to previous messageGo to next message
Yasir Hashmi
Messages: 304
Registered: April 2006
Senior Member
whats your Sid and global database name?
Re: ORA-01034: ORACLE not available [message #188507 is a reply to message #188506] Fri, 18 August 2006 16:38 Go to previous messageGo to next message
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
Re: ORA-01034: ORACLE not available [message #188513 is a reply to message #188482] Sat, 19 August 2006 00:09 Go to previous messageGo to next message
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.
Re: ORA-01034: ORACLE not available [message #188519 is a reply to message #188482] Sat, 19 August 2006 00:30 Go to previous messageGo to next message
BlackSwan
Messages: 25033
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.
Re: ORA-01034: ORACLE not available [message #188524 is a reply to message #188482] Sat, 19 August 2006 01:02 Go to previous messageGo to next message
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.

Re: ORA-01034: ORACLE not available [message #188525 is a reply to message #188482] Sat, 19 August 2006 01:05 Go to previous messageGo to next message
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?
Re: ORA-01034: ORACLE not available [message #188539 is a reply to message #188482] Sat, 19 August 2006 03:24 Go to previous messageGo to next message
Yasir Hashmi
Messages: 304
Registered: April 2006
Senior Member
Did you try to start the instance with pfile
SQL>startup pfile='pfile_location';
Re: ORA-01034: ORACLE not available [message #188566 is a reply to message #188539] Sat, 19 August 2006 16:19 Go to previous messageGo to next message
jesuisantony
Messages: 132
Registered: July 2006
Location: Chennai
Senior Member
Can you please confirm if you have set the variable ORACLE_HOME ?
Re: ORA-01034: ORACLE not available [message #188599 is a reply to message #188566] Sun, 20 August 2006 12:21 Go to previous messageGo to next message
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
Re: ORA-01034: ORACLE not available [message #188603 is a reply to message #188482] Sun, 20 August 2006 15:02 Go to previous messageGo to next message
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.
Re: ORA-01034: ORACLE not available [message #188604 is a reply to message #188599] Sun, 20 August 2006 15:13 Go to previous messageGo to next message
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.
Re: ORA-01034: ORACLE not available [message #188605 is a reply to message #188482] Sun, 20 August 2006 15:32 Go to previous messageGo to next message
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
Re: ORA-01034: ORACLE not available [message #189234 is a reply to message #188482] Wed, 23 August 2006 14:33 Go to previous messageGo to next message
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
Re: ORA-01034: ORACLE not available [message #189261 is a reply to message #189234] Wed, 23 August 2006 19:23 Go to previous message
superoscarin@hotmail.com
Messages: 101
Registered: July 2006
Location: Mexico
Senior Member

what service are you talking about?
Previous Topic: Trace Issue
Next Topic: Oracle database design patterns
Goto Forum:
  


Current Time: Sat Dec 03 03:46:47 CST 2016

Total time taken to generate the page: 0.13700 seconds