Shared Memory Realm Does not Exist [message #68882] |
Mon, 03 January 2005 01:57 |
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 |
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 |
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 |
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 |
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 |
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 |
|
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 #446357 is a reply to message #68882] |
Sun, 07 March 2010 23:44 |
|
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 #446366 is a reply to message #68882] |
Mon, 08 March 2010 00:02 |
|
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 |
|
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.
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 #446378 is a reply to message #446374] |
Mon, 08 March 2010 00:58 |
|
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 |
|
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 #446400 is a reply to message #446394] |
Mon, 08 March 2010 02:13 |
|
Michel Cadot
Messages: 68728 Registered: March 2007 Location: Saint-Maur, France, https...
|
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 |
|
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 :
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 17095 times)
[Updated on: Mon, 08 March 2010 02:23] Report message to a moderator
|
|
|