Home » RDBMS Server » Enterprise Manager » Shared Memory Realm Does not Exist
Shared Memory Realm Does not Exist [message #68882] Mon, 03 January 2005 01:57 Go to next message
Naveed Shahzad Memon
Messages: 2
Registered: January 2005
Junior Member
I'm using Oracle 8i Enterprise Edition.
When i try to connect my database using Internal user, i m getting messege "Shared Memory Realm Does Not Exist" Please help me solving my problem. Thanks
Re: Shared Memory Realm Does not Exist [message #68883 is a reply to message #68882] Mon, 03 January 2005 03:18 Go to previous messageGo to next message
khawar
Messages: 4
Registered: September 2004
Junior Member
ASA,
It says that your database is not start yet, your should configure to start database autmaticlly through windows services(go to Run->services.msc->oracleservice(your database name) right click and select automatic) or you can start your database manaully by logging to your database as
click
Run->sqlplus and log on as
sys/change_on_install as sysdba
write command-> startup
Best wishes
Re: Shared Memory Realm Does not Exist [message #68892 is a reply to message #68882] Sun, 16 January 2005 05:12 Go to previous messageGo to next message
Manoj
Messages: 101
Registered: August 2000
Senior Member
when i installed oracle 9i .. if i want to conn. pl/sql.. i am getting an error..
ora-01034: oracle not available
ora-27101: shared memory realm does not exit

Even i tried to install again .. i got the same think
Please let me know about this error..

thanks
manoj
Re: Shared Memory Realm Does not Exist [message #113538 is a reply to message #68892] Mon, 04 April 2005 08:34 Go to previous messageGo to next message
anilgupt
Messages: 1
Registered: April 2005
Junior Member
This generally happens, if your database is not properlly mounted. For mouning your database, follow following steps:
1) Open DOS propmt
2) write SVRMGRL and enter
3) Connect with internal user, Connect internal
4) write Startup. This will mount your database propelly.

Regards,
+Anil
Re: Shared Memory Realm Does not Exist [message #116260 is a reply to message #113538] Mon, 18 April 2005 22:46 Go to previous messageGo to next message
vbplaya
Messages: 2
Registered: April 2005
Junior Member
I work on a UNIX system and had a similar problem. I found that when the server is restarted, the Oracle database begins in the ORACLE_HOME defined in my /var/opt/oracle/oratab file. My OS user environment had the ORACLE_HOME defined differently (I used a symbolic link). When I tried to get to the database using:

sqlplus "/ as sysdba"

I got the

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

message. I used the ps command to verify that my database was really up (it was). I changed my ORACLE_HOME environment variable and was able to get into the database.

I had to make sure that my ORACLE_HOME matched the ORACLE_HOME used to start and stop the database.

Hope this helps!
Re: Shared Memory Realm Does not Exist [message #118682 is a reply to message #116260] Fri, 06 May 2005 17:53 Go to previous messageGo to next message
vbplaya
Messages: 2
Registered: April 2005
Junior Member
I came across the following at the http://asktom.oracle.com site which explains why the ORACLE_HOME must be set properly:

"The SID is a site identifier. It plus the Oracle_home are hashed together in
Unix to create a unique key name for attaching an SGA. If your Oracle_sid or
Oracle_home is not set correctly, you'll get "oracle not available" since we
cannot attach to a shared memory segment that is identified by magic key. On
NT, we don't use shared memory but the SID is still important. We can have more
then 1 database on the same oracle home so we need a way to id them."
Re: Shared Memory Realm Does not Exist [message #446343 is a reply to message #68882] Sun, 07 March 2010 23:10 Go to previous messageGo to next message
itech
Messages: 173
Registered: May 2008
Location: Fsd, Pakistan
Senior Member

i always have to manually start up the database with the startup command, else i get the same error as described above (Shared Memory Realm Does not Exist)

in my services tab, the Listner & my Oracle service startup is set to automatic, still then it fails to start properly

Oracle : 8i
OS : 2003 Server
sid : itech8i
Re: Shared Memory Realm Does not Exist [message #446344 is a reply to message #446343] Sun, 07 March 2010 23:19 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Have a look at alert.log and post here the last 50 lines.

Regards
Michel
Re: Shared Memory Realm Does not Exist [message #446354 is a reply to message #446344] Sun, 07 March 2010 23:36 Go to previous messageGo to next message
itech
Messages: 173
Registered: May 2008
Location: Fsd, Pakistan
Senior Member

alerts log, found under Computer Management ?
Re: Shared Memory Realm Does not Exist [message #446357 is a reply to message #68882] Sun, 07 March 2010 23:44 Go to previous messageGo to next message
itech
Messages: 173
Registered: May 2008
Location: Fsd, Pakistan
Senior Member

found it !

Quote:

Mon Mar 08 10:06:23 2010
ORACLE V8.1.7.0.0 - Production vsnsta=0
vsnsql=e vsnxtr=3
Windows 2000 Version 5.2 Service Pack 2, v.2825, CPU type 586
Starting up ORACLE RDBMS Version: 8.1.7.0.0.
System parameters with non-default values:
processes = 150
shared_pool_size = 273126809
large_pool_size = 614400
java_pool_size = 32768
control_files = E:\Oracle8i\oradata\itech8i\control01.ctl, E:\Oracle8i\oradata\itech8i\control02.ctl, E:\Oracle8i\oradata\itech8i\control03.ctl
db_block_buffers = 100022
db_block_size = 8192
compatible = 8.1.0
log_buffer = 32768
log_checkpoint_interval = 10000
log_checkpoint_timeout = 1800
db_files = 1024
db_file_multiblock_read_count= 8
max_enabled_roles = 30
remote_login_passwordfile= EXCLUSIVE
global_names = TRUE
distributed_transactions = 10
instance_name = itech8i
service_names = itech8i
sort_area_size = 65536
sort_area_retained_size = 65536
db_name = itech8i
open_cursors = 300
ifile = E:\Oracle8i\admin\itech8i\pfile\init.ora
os_authent_prefix =
parallel_max_servers = 5
background_dump_dest = E:\Oracle8i\admin\itech8i\bdump
user_dump_dest = E:\Oracle8i\admin\itech8i\udump
max_dump_file_size = 10240
oracle_trace_collection_name=
PMON started with pid=2
DBW0 started with pid=3
LGWR started with pid=4
CKPT started with pid=5
SMON started with pid=6
RECO started with pid=7
Mon Mar 08 10:06:25 2010
alter database mount
Mon Mar 08 10:06:30 2010
Successful mount of redo thread 1, with mount id 1416069222.
Mon Mar 08 10:06:30 2010
Database mounted in Exclusive Mode.
Completed: alter database mount
Mon Mar 08 10:06:30 2010
alter database open
Beginning crash recovery of 1 threads
Mon Mar 08 10:06:31 2010
Thread recovery: start rolling forward thread 1
Recovery of Online Redo Log: Thread 1 Group 1 Seq 250 Reading mem 0
Mem# 0 errs 0: E:\ORACLE8I\ORADATA\ITECH8I\REDO01.LOG
Mon Mar 08 10:06:31 2010
Thread recovery: finish rolling forward thread 1
Thread recovery: 11 data blocks read, 6 data blocks written, 8 redo blocks read
Crash recovery completed successfully
Mon Mar 08 10:06:32 2010
Thread 1 advanced to log sequence 251
Thread 1 opened at log sequence 251
Current log# 2 seq# 251 mem# 0: E:\ORACLE8I\ORADATA\ITECH8I\REDO02.LOG
Successful open of redo thread 1.
Mon Mar 08 10:06:33 2010
SMON: enabling cache recovery
SMON: enabling tx recovery
Mon Mar 08 10:06:34 2010
Completed: alter database open
Re: Shared Memory Realm Does not Exist [message #446358 is a reply to message #446354] Sun, 07 March 2010 23:44 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
No Oracle alert.log, found at location given by background_dump_dest parameter.

Regards
Michel
Re: Shared Memory Realm Does not Exist [message #446360 is a reply to message #446358] Sun, 07 March 2010 23:50 Go to previous messageGo to next message
itech
Messages: 173
Registered: May 2008
Location: Fsd, Pakistan
Senior Member

psl see the message above http://www.orafaq.com/forum/mv/msg/24843/446357/124804/#msg_446357

[Updated on: Sun, 07 March 2010 23:53]

Report message to a moderator

Re: Shared Memory Realm Does not Exist [message #446363 is a reply to message #446360] Sun, 07 March 2010 23:52 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
This database/instance is up and running.
I think you didn't try to connect to this one.

Post your connection string, and client and server versions with 4 decimals.

Regards
Michel

[Updated on: Sun, 07 March 2010 23:53]

Report message to a moderator

Re: Shared Memory Realm Does not Exist [message #446366 is a reply to message #68882] Mon, 08 March 2010 00:02 Go to previous messageGo to next message
itech
Messages: 173
Registered: May 2008
Location: Fsd, Pakistan
Senior Member

i have only 1 data base instance my server.

when i installed the database, the universal installer was unable to create a database for me, then i manual created using database configuration assistant.

it worked without any error for couple of days, then started giving this error.

i have AD installed (but it was installed before the Oracle installation)

command was SQLPLUSW.EXE system/manager@itech8i

TNSnames.ora:
Quote:

# TNSNAMES.ORA Network Configuration File: E:\Oracle8i\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.

itech8i.itech.local =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = iserver)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = itech8i)
)
)




sqlnet.ora:
Quote:

# SQLNET.ORA Network Configuration File: E:\Oracle8i\network\admin\sqlnet.ora
# Generated by Oracle configuration tools.

NAMES.DEFAULT_DOMAIN = ITECH.LOCAL

SQLNET.AUTHENTICATION_SERVICES= (NTS)

NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME)




listener.ora :

Quote:

# LISTENER.ORA Network Configuration File: E:\Oracle8i\network\admin\listener.ora
# Generated by Oracle configuration tools.

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = iserver)(PORT = 1521))
)
)
)

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = E:\Oracle8i)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = itech8i)
(ORACLE_HOME = E:\Oracle8i)
(SID_NAME = itech8i)
)
)




after manual startup,
Quote:

SQL*Plus: Release 8.1.7.0.0 - Production on Mon Mar 8 11:01:01 2010

(c) Copyright 2000 Oracle Corporation. All rights reserved.


Connected to:
Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production
With the Partitioning option
JServer Release 8.1.7.0.0 - Production

SQL>

Re: Shared Memory Realm Does not Exist [message #446368 is a reply to message #68882] Mon, 08 March 2010 00:14 Go to previous messageGo to next message
itech
Messages: 173
Registered: May 2008
Location: Fsd, Pakistan
Senior Member

now again, i restarted the system, and getting this error again when i try to connect via sqlplusw

Quote:

SQL*Plus: Release 8.1.7.0.0 - Production on Mon Mar 8 11:12:

(c) Copyright 2000 Oracle Corporation. All rights reserved.

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


Enter user-name: system@itech8i[/email][/email]
Enter password: *******
ERROR:
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist


Enter user-name:


the alert log is still shows the previous msges, now new lines!

Quote:

Mon Mar 08 10:06:25 2010
alter database mount
Mon Mar 08 10:06:30 2010
Successful mount of redo thread 1, with mount id 1416069222.
Mon Mar 08 10:06:30 2010
Database mounted in Exclusive Mode.
Completed: alter database mount
Mon Mar 08 10:06:30 2010
alter database open
Beginning crash recovery of 1 threads
Mon Mar 08 10:06:31 2010
Thread recovery: start rolling forward thread 1
Recovery of Online Redo Log: Thread 1 Group 1 Seq 250 Reading mem 0
Mem# 0 errs 0: E:\ORACLE8I\ORADATA\ITECH8I\REDO01.LOG
Mon Mar 08 10:06:31 2010
Thread recovery: finish rolling forward thread 1
Thread recovery: 11 data blocks read, 6 data blocks written, 8 redo blocks read
Crash recovery completed successfully
Mon Mar 08 10:06:32 2010
Thread 1 advanced to log sequence 251
Thread 1 opened at log sequence 251
Current log# 2 seq# 251 mem# 0: E:\ORACLE8I\ORADATA\ITECH8I\REDO02.LOG
Successful open of redo thread 1.
Mon Mar 08 10:06:33 2010
SMON: enabling cache recovery
SMON: enabling tx recovery
Mon Mar 08 10:06:34 2010
Completed: alter database open


i think this means, that database still not mounted automatically.

but the services mmc shows that oracle is started.

http://www.orafaq.com/forum/fa/7535/124804/

still havnt mounted manualy, what to do n check ?
awaiting reply.

[Updated on: Mon, 08 March 2010 00:23]

Report message to a moderator

Re: Shared Memory Realm Does not Exist [message #446374 is a reply to message #446366] Mon, 08 March 2010 00:41 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
the universal installer was unable to create a database for me

Why? Maybe the root of your current problem.

Quote:
i think this means, that database still not mounted automatically

If the database is open then it is mounted (previous step in startup).

Do you run SQL*Plus locally to the database?
What is your OS?
Any change in the OS (patch...) since the last time it works as expectly?

Regards
Michel
Re: Shared Memory Realm Does not Exist [message #446378 is a reply to message #446374] Mon, 08 March 2010 00:58 Go to previous messageGo to next message
itech
Messages: 173
Registered: May 2008
Location: Fsd, Pakistan
Senior Member

the universal installer gave error (what i remember) that must run the setup from administrator acc. like this. however i was Logged in as the Administrator Account, infact with administrator account. and after teh setup completed, i created the database manually in the same session.

Quote:

If the database is open then it is mounted (previous step in startup).


well if you check the alert log pasted later, it still shows the same lines as previous, no new lines added (after i rebooted the system). isn't it suppose to add new lines when ever the datase is started.(auto or manual)

and still i am getting the error, havnt yet started the db manualy (was waiting for your reply)

yes i am running sql locally,

OS : windows Server 2003 SP2
no change in OS since last it was working correctly!

just created users in AD, and joined pc's on domain.

[Updated on: Mon, 08 March 2010 01:01]

Report message to a moderator

Re: Shared Memory Realm Does not Exist [message #446381 is a reply to message #68882] Mon, 08 March 2010 01:07 Go to previous messageGo to next message
itech
Messages: 173
Registered: May 2008
Location: Fsd, Pakistan
Senior Member

and still, if i stop and restart the Service from MMC, the services is started without any error but when i try to login still gives the shared memory error.

and alert log laste time stamp is still Mon Mar 08 10:06:34 2010

.

one thing i noted, previously i do not require the TNS name to be specified when connecting localy via SQLPlusw, how ever when i now try to connect without specifying the TNS, it gives the TNS Protocol adapter error.

what can be the cause behind this ?
Re: Shared Memory Realm Does not Exist [message #446394 is a reply to message #68882] Mon, 08 March 2010 01:53 Go to previous messageGo to next message
itech
Messages: 173
Registered: May 2008
Location: Fsd, Pakistan
Senior Member

an interesting issue.

http://www.orafaq.com/forum/fa/7536/124804/

MMC shows that service is started, and dba studio shows that database is still down. even i restarted the service from MMC, the database status was still down.

why this could be?

how to see which database is installed, and which the MMC is showing ?

i have only one database (which failed to install by universal installer, then i created it manually. i gave the same SID name, that can be the issue, how to resolve this now ?)

thanking in anticipation.
  • Attachment: ora8i.PNG
    (Size: 64.38KB, Downloaded 16619 times)

[Updated on: Mon, 08 March 2010 01:54]

Report message to a moderator

Re: Shared Memory Realm Does not Exist [message #446400 is a reply to message #446394] Mon, 08 March 2010 02:13 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
MMC shows that service is started, and dba studio shows that database is still down. even i restarted the service from MMC, the database status was still down.

why this could be?

Because starting the service does NOT mean starting the database/instance.
There 4 steps in instance startup:
1/ Starting the service
2/ Starting the instance in nomount mode
3/ Mounting the database
4/ Opening the database
MMC only manage the first step unless your configuration parameters indicates to go further (HKLM\Software\Oracle\Homex\ORA_sid_AUTOSTART=TRUE, iirc)

Quote:
how to see which database is installed, and which the MMC is showing ?

I don't understand the question, didn't you point to database service in your picture?
One point, it seems to me that SID was limited to 4 characters in 8i on Windows (but Oracle8i is a very old version).

Quote:
which failed to install by universal installer, then i created it manually.

You still don't post the reason of this failure.

Regards
Michel
Re: Shared Memory Realm Does not Exist [message #446401 is a reply to message #68882] Mon, 08 March 2010 02:18 Go to previous message
itech
Messages: 173
Registered: May 2008
Location: Fsd, Pakistan
Senior Member

Quote:

You still don't post the reason of this failure.

well i posted earlier.
Quote:

the universal installer gave error (what i remember) that must run the setup from administrator acc. like this. however i was Logged in as the Administrator Account, infact with administrator account. and after teh setup completed, i created the database manually in the same session.


===
here is the registry view for oracle home :

http://www.orafaq.com/forum/fa/7537/124804/

here AutoStart is set to true,
then why the database didn't start automatically, how to track?

.
PS: Michel, hopefully not disturbing you alot!
2), this post made my count 100! hehe..
  • Attachment: reg_8i.PNG
    (Size: 48.40KB, Downloaded 16565 times)

[Updated on: Mon, 08 March 2010 02:23]

Report message to a moderator

Previous Topic: custom query on EMREP SCHEMA
Next Topic: How to see process in Oracle Enterprise Manager
Goto Forum:
  


Current Time: Thu Mar 28 03:44:49 CDT 2024