Page 1 of 1

Shared memory realm not available

Posted: Fri May 25, 2007 8:33 am
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

Posted: Fri May 25, 2007 9:19 am
by ahmadbilal
If you are on windows then start oracle services ...


or in run type svrmgrl
connect internal/oracle
startup force

Posted: Mon May 28, 2007 7:07 am
by Rauf
Thanks Boss (Ahmad Bilal).


Regards
Rauf Anjum

Posted: Tue May 29, 2007 2:46 am
by Rauf
Ahmed Bilal sb

My problem is solved but Please tell me what is svrmgrl.

Posted: Fri Jun 01, 2007 10:37 am
by Santhosh
svrmgrl stands for Server Manager. Inorder to start the database you are connecting through this tool and starting the database

Posted: Sat Jun 02, 2007 3:11 pm
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?