Re: ORA-27101: shared memory realm does not exist

From: Mathijs <blabla_at_bla.hu>
Date: 01 Nov 2006 14:34:35 GMT
Message-ID: <Xns986E9E85AE5D9holleknolle23@194.134.69.69>

01 nov 2006, (Charles Hooper):

Thanks for your effort to help me. I did everything you asked me to do, but no oddities (except that I can't use Oracle), all seems to be okay (as I said, it's an out-of-the-box installation where I tried to stick with the defaults as much as possible and didnt edit any files manually... And I did manage to use the database twice).

Cheers,
M.

> The path should include the Oracle home bin folder, which might be:
> F:\ORACLEXE\APP\ORACLE\PRODUCT\10.2.0\db_1\bin

Check:

	C:\>path
	PATH=F:\oraclexe\app\oracle\product\10.2.0\server\bin;F:\WINDOWS
\system32;
	...

> Then, make certain that the spfile is in the expected location:
> C:\> DIR F:\ORACLEXE\APP\ORACLE\PRODUCT\10.2.0\SERVER\DBS\SPFILEXE.ORA
Check:

	F:\oraclexe\app\oracle\product\10.2.0\server\dbs>dir
	 Directory of F:\oraclexe\app\oracle\product\10.2.0\server\dbs

	11-10-2006  13:33    <DIR>          .
	11-10-2006  13:33    <DIR>          ..
	30-10-2006  11:35             2.560 SPFILEXE.ORA
	               1 File(s)          2.560 bytes
	               2 Dir(s)   6.033.031.168 bytes free

> Check the registry to make certain that the correct values are
> entered.
> The values will likely be located near:
> HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\
Check (I think... How can I know what the right values are?):

	[HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\KEY_XE]
		"StmtCacheSize"="0"
		"NLS_LANG"="DUTCH_THE NETHERLANDS.WE8MSWIN1252"
		"ORACLE_HOME_NAME"="XE"
		"ORACLE_BASE"="F:\\oraclexe\\"
		"VERSION"="10.2.0.1.0"
		"ORACLE_HOME_KEY"="SOFTWARE\\ORACLE\\KEY_XE"
		"ORAMTS_CP_TRACE_LEVEL"="0"
		"Type"=dword:00000057
		"ORACLE_SID"="XE"
		"ORACLE_HOME"="F:\\oraclexe\\app\\oracle\\product\\10.2.0
\\server"
		"ORAMTS_CP_TRACE_DIR"="F:\\oraclexe\\app\\oracle\\product
\\10.2.0\\server\\oramts\\trace"
		"StatementCacheSize"="0"
		"OLEDB"="F:\\oraclexe\\app\\oracle\\product\\10.2.0\\server
\\oledb\\mesg"
		"ORA_XE_AUTOSTART"=TRUE
		"ORA_XE_SHUTDOWN"=TRUE
		"ORA_XE_SHUTDOWNTYPE"=immedeate
		"ORA_XE_SHUTDOWN_TIMEOUT"=90

> Verify that the Oracle related services are set to Automatic startup
> and that their status is Started.

Check:

	OracleServiceXE - started, automatic startup
	OracleXETNSListener - started, automatic startup

	OracleXEClrAgent - Stopped, manual startup
	OracleXETNSListenerCLRExtProc, manual startup
	OracleXETNSListenerEXTPROC_FOR_XE, manual startup

>
> Try to connect to Oracle as the SYS user, from a command prompt:
> C:\> SQLPLUS /NOLOG
> SQL> CONNECT SYS/MY_SECRET_PASSWORD_at_XE AS SYSDBA
> SQL> STARTUP
          C:\>SQLPLUS /NOLOG

	SQL> CONNECT SYS/MY_SECRET_PASSWORD_at_XE AS SYSDBA
	ERROR:
	ORA-12514: TNS:listener does not currently know of service requested 

in connect descriptor

Note that "SQL> CONNECT /" gave the following error:

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

> If the XE database instance fails to start, take a look inside the
> spfile, again from a command prompt:
> C:\> TYPE
> F:\ORACLEXE\APP\ORACLE\PRODUCT\10.2.0\SERVER\DBS\SPFILEXE.ORA
> Look through the output, are the values specified in the spfile
> the same as what you posted as listed in the alert file?

Checked. All the values are the same.

	F:\oraclexe\app\oracle\product\10.2.0\server\dbs>type SPFILEXE.ORA
	                        ?    ?                                               
?
	Z?  ·l?$
	
	
	
	
        	                        xe.__db_cache_size=226492416
	xe.__java_pool_size=4194304
	xe.__large_pool_size=12582912
	xe.__shared_pool_size=100663296
	xe.__streams_pool_size=0
	*.audit_file_dest='F:\oraclexe\app\oracle\admin\XE\adump'
	*.background_dump_dest='F:\oraclexe\app\oracle\admin\XE\bdump'
	*.compatible='10.2.0.1.0'
	*.control_files='F:\oraclexe\oradata\XE\control.dbf'
	*.core_dump_dest='F:\oraclexe\app\oracle\admin\XE\cdump'
	*.db_name='XE'
	*.DB_RECOVERY_FILE_DEST_SIZE=10G
	*.DB_RECOVERY_FILE_DEST='F:\oraclexe\app\oracle\flash_recovery_area'
	*.dispatchers='(PROTOCOL=TCP) (SERVICE=XEXDB)'
	*.job_queue_processes=4
	*.open_cursors=300
	*.os_authent_prefix=''
	*.pga_aggregate_target=110M
	*.remote_login_passwordfile='EXCLUSIVE'
	*.sessions=20
	*.sga_target=330M
	*.shared_servers=4
	*.undo_management='AUTO'
	*.undo_tablespace='UNDO'
	*.user_dump_dest='F:\oraclexe\app\oracle\admin\XE\udump'

Euh.. now what? Received on Wed Nov 01 2006 - 08:34:35 CST