Home » RDBMS Server » Server Administration » ORA-01034: ORACLE not available and ORA-27101
ORA-01034: ORACLE not available and ORA-27101 [message #303190] Thu, 28 February 2008 05:04 Go to next message
sarava20
Messages: 11
Registered: February 2008
Junior Member
Hi all,

Please help me..


I have installed Oracle 8i SERVER edition(can be acting as server as well client i guess ) .
All the instalation got over.
I have created two SID in tnsnames.ora using net 8 assistant.
one SID is connecting to remote Database ie 10g and one is connecting to same DB which i installed my local.

after installation its connecting to two server (10 g (remote machine) and 8i(local machine)) using thr SQLplus and SQL navigator.

after some time its getting connect to only remote Database ie 10g alone.Its not connecting to my local server i.e 8i server which i installed on my local.

Its giving the Error in Sqlplus and even in sql navigator
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
========================================
snippet of tnsnames.ora

for remote DB 10g :-
DMAXIMO1.GROUP.ROOT.AD =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 172.30.128.16)(PORT = 1791))
)
(CONNECT_DATA =
(SERVICE_NAME = dmaximo1)
)
)

local machine 8i:-
ORCL.GROUP.ROOT.AD =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = NTB1421)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = orcl.group.root.ad)
)
)

can anybody help me to resolve this problem?
If i reinstalled entire oracle product in my local machine its working fine after installation .after few more mins its not working...
Listners are running properly.


plese help me to resolve this problem...


Re: ORA-01034: ORACLE not available and ORA-27101 [message #303194 is a reply to message #303190] Thu, 28 February 2008 05:10 Go to previous messageGo to next message
NandKumar
Messages: 92
Registered: June 2007
Location: v$hyderabad
Member
ORA-1034

Quote:
01034, 00000, "ORACLE not available"
// *Cause: Oracle was not started up. Possible causes include the following:
// - The SGA requires more space than was allocated for it.
// - The operating-system variable pointing to the instance is
// improperly defined.
// *Action: Refer to accompanying messages for possible causes and correct
// the problem mentioned in the other messages.
// If Oracle has been initialized, then on some operating systems,
// verify that Oracle was linked correctly. See the platform
// specific Oracle documentation.


What is the OS where 8i is installed ?
Re: ORA-01034: ORACLE not available and ORA-27101 [message #303195 is a reply to message #303194] Thu, 28 February 2008 05:13 Go to previous messageGo to next message
sarava20
Messages: 11
Registered: February 2008
Junior Member

oracle installed at windows xp ...

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

where do i increase the memory ?
Re: ORA-01034: ORACLE not available and ORA-27101 [message #303196 is a reply to message #303195] Thu, 28 February 2008 05:16 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
It means your database is down.
Just start the database.
Search forum / google before posting.
Re: ORA-01034: ORACLE not available and ORA-27101 [message #303197 is a reply to message #303196] Thu, 28 February 2008 05:23 Go to previous messageGo to next message
sarava20
Messages: 11
Registered: February 2008
Junior Member
from run -->services.msc
i guess that my DB is up status

OracleServiceORCL ---- Started
OracleOraHome81TNSListner -- Started
OracleOraHome81PaginServer --
OracleOraHome81HTTPServer --Started
OracleOraHome81DataGatherer -- Started
OracleOraHome81ClientCache --
OracleOraHome81Agent --- Started

Can u pls tell me some more explanation?
Re: ORA-01034: ORACLE not available and ORA-27101 [message #303198 is a reply to message #303197] Thu, 28 February 2008 05:35 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
>> OracleServiceORCL ---- Started
It is just a service. still the database can be down.
Re: ORA-01034: ORACLE not available and ORA-27101 [message #303199 is a reply to message #303198] Thu, 28 February 2008 05:37 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
As said, the service may be up and alive and database may be down.
C:\> net start ORACLESERVICEMARC
The OracleServiceMARC service is starting.......
The OracleServiceMARC service was started successfully.

C:\>sqlplus /nolog

SQL*Plus: Release 10.2.0.1.0 - Production on Thu Feb 28 06:32:44 2008

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

SQL> connect /as sysdba
Connected.
SQL> shutdown abort
ORACLE instance shut down.
SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options

C:\>sqlplus scott/tiger

SQL*Plus: Release 10.2.0.1.0 - Production on Thu Feb 28 06:33:12 2008

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

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

C:\> net start ORACLESERVICEMARC
The requested service has already been started

[Updated on: Thu, 28 February 2008 05:37]

Report message to a moderator

Re: ORA-01034: ORACLE not available and ORA-27101 [message #303684 is a reply to message #303199] Sun, 02 March 2008 00:01 Go to previous messageGo to next message
sarava20
Messages: 11
Registered: February 2008
Junior Member

As you said this is service
OracleServiceORCL ---- Started
It is just a service. still the database can be down.


can u pls tell me that Still the service is started then how come database can be down ?

Since i tried this i m getting the following information

C:\> net start OracleServiceORCL
The requested service has already been started

SQL> connect /as sysdba
Connected to an idle instance

Can u help me to resolve this excpetion .?
oracle shared memory realm prooblem....


Thanks in advance



Re: ORA-01034: ORACLE not available and ORA-27101 [message #303685 is a reply to message #303684] Sun, 02 March 2008 00:15 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Just check oracle services type from MANUAL to AUTO in services windows.
Re: ORA-01034: ORACLE not available and ORA-27101 [message #303694 is a reply to message #303684] Sun, 02 March 2008 02:03 Go to previous messageGo to next message
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Database Platform Guide 10g Release 2 (10.2) for Microsoft Windows
Chapter 5 Administering a Database on Windows
Section Starting and Shutting Down a Database Using Services (but the whole chapter worth to be read).

Regads
Michel
Re: ORA-01034: ORACLE not available and ORA-27101 [message #303701 is a reply to message #303685] Sun, 02 March 2008 03:02 Go to previous messageGo to next message
sarava20
Messages: 11
Registered: February 2008
Junior Member
All services related to oracle is Auto only ....
Re: ORA-01034: ORACLE not available and ORA-27101 [message #303703 is a reply to message #303190] Sun, 02 March 2008 03:20 Go to previous messageGo to next message
varu123
Messages: 754
Registered: October 2007
Senior Member
Quote:
SQL> connect /as sysdba
Connected to an idle instance


SQL>startup
Re: ORA-01034: ORACLE not available and ORA-27101 [message #303704 is a reply to message #303701] Sun, 02 March 2008 03:25 Go to previous messageGo to next message
sarava20
Messages: 11
Registered: February 2008
Junior Member
When i say connect /as sysdba
I m getting the following message...

SQL> connect /as sysdba
Connected to an idle instance.
SQL>

Any clue?

but when i say
SQL> connect username/pwd@dmaximo1
Connected.
SQL>

Its not pining up local oracle 8i server.
All services are related to oracle is got up started stage only....
any one tell me ..how do i resolve this ?

SQL> connect scott/tiger@ORCL
ERROR:
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist


Warning: You are no longer connected to ORACLE.
SQL>

Re: ORA-01034: ORACLE not available and ORA-27101 [message #303705 is a reply to message #303190] Sun, 02 March 2008 03:30 Go to previous messageGo to next message
varu123
Messages: 754
Registered: October 2007
Senior Member
when you do
conn /as sysdba

the message "connected to idle instance" means your instance is down.
You need to start it with the command:
SQL> startup
Re: ORA-01034: ORACLE not available and ORA-27101 [message #303706 is a reply to message #303701] Sun, 02 March 2008 03:54 Go to previous messageGo to next message
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Don't try to guess, read the chapter I posted it is a prerequisite to work with Oracle on Windows.

Regards
Michel
Re: ORA-01034: ORACLE not available and ORA-27101 [message #303708 is a reply to message #303705] Sun, 02 March 2008 03:55 Go to previous messageGo to next message
sarava20
Messages: 11
Registered: February 2008
Junior Member
YES Buddy...
Thanks thank u very much....

i got this exception and resolved by using startup the instances....


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

C:>sqlplus /nolog
SQL> connect /as sysdba
Connected to an idle instance.
SQL> STARTUP PFILE=D:\oracle\admin\orcl\pfile\init.ora
ORACLE instance started.

Total System Global Area 237856796 bytes
Fixed Size 75804 bytes
Variable Size 80416768 bytes
Database Buffers 157286400 bytes
Redo Buffers 77824 bytes
Database mounted.
Database opened.
SQL>connect scott/tiger
connected
SQL>


Resolved the Error...
thank u very much


sarava20@gmail.com
Re: ORA-01034: ORACLE not available and ORA-27101 [message #303710 is a reply to message #303708] Sun, 02 March 2008 04:24 Go to previous messageGo to next message
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
There was no error, just your lack of knowledge.

Regards
Michel
icon1.gif  Re: ORA-01034: ORACLE not available and ORA-27101 [message #303716 is a reply to message #303710] Sun, 02 March 2008 05:28 Go to previous messageGo to next message
sarava20
Messages: 11
Registered: February 2008
Junior Member
I m a newbie..it might be lack of knowledge...
Everything is learning exp

Mad
Re: ORA-01034: ORACLE not available and ORA-27101 [message #303720 is a reply to message #303716] Sun, 02 March 2008 06:15 Go to previous message
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
This is why I posted a link and you should know the answer WITHOUT needed to post after if you read it.

Regards
Michel
Previous Topic: STARTUP UPGRADE results in error ORA-01157: cannot identify/lock data
Next Topic: Creating another database
Goto Forum:
  


Current Time: Thu Dec 05 20:15:51 CST 2024