| ORA-01034: ORACLE not available and ORA-27101 [message #303190] |
Thu, 28 February 2008 05:04  |
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  |
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 #303197 is a reply to message #303196] |
Thu, 28 February 2008 05:23 |
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 #303199 is a reply to message #303198] |
Thu, 28 February 2008 05:37 |
 |
Mahesh Rajendran
Messages: 10707
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 |
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 #303704 is a reply to message #303701] |
Sun, 02 March 2008 03:25 |
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 #303708 is a reply to message #303705] |
Sun, 02 March 2008 03:55 |
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
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
