Shared memory realm not available

In this forum you can share stuff related to Oracle 11g, 10g, 9i.
Post Reply
Rauf
Posts: 18
Joined: Sat May 12, 2007 2:00 am
Location: Pakistan

Shared memory realm not available

Post by Rauf »

Sir im facing the problem in my oracle 8i database when im going to logon to databace with any user (scott/tiger, system/manager etc) there come the error

Oracle not available
shared memory realm not available

Due to this error i cant run my database

Thanks and regurds
Rauf Anjum
ahmadbilal
Posts: 615
Joined: Mon Sep 18, 2006 1:32 am
Location: United Arab Emirates
Contact:

Post by ahmadbilal »

If you are on windows then start oracle services ...


or in run type svrmgrl
connect internal/oracle
startup force
Rauf
Posts: 18
Joined: Sat May 12, 2007 2:00 am
Location: Pakistan

Post by Rauf »

Thanks Boss (Ahmad Bilal).


Regards
Rauf Anjum
Rauf
Posts: 18
Joined: Sat May 12, 2007 2:00 am
Location: Pakistan

Post by Rauf »

Ahmed Bilal sb

My problem is solved but Please tell me what is svrmgrl.
Santhosh
Posts: 1
Joined: Fri Jun 01, 2007 10:17 am
Location: United Arab Emirates

Post by Santhosh »

svrmgrl stands for Server Manager. Inorder to start the database you are connecting through this tool and starting the database
ahmadbilal
Posts: 615
Joined: Mon Sep 18, 2006 1:32 am
Location: United Arab Emirates
Contact:

Post by ahmadbilal »

SVRMGRL and Connect Internal Desupport

The Server Manager utility (svrmgrl) is no longer available in 9i. Now, database administration is done via SQL*Plus or OEM. Also, connect internal is no longer available in Oracle9i. To perform administrative activities on the database (like shutdown or startup) you need to login using an account that is assigned SYSDBA privileges, using the as SYSDBA login syntax. Here is an example of logging into the SYS account as SYSDBA using SQL*Plus:

sqlplus ?sys/password as sysdba?
Post Reply

Who is online

Users browsing this forum: No registered users and 0 guests