ORA-27101: shared memory realm does not exist

[viniciusandrade]

I intore Oracle 10g Xe on Windows & 64 bits. The installation occurred normally, but I can not enter http://127.0.0.1:8080/apex. and when I try to enter SQLPlus with the user SYSTEM appears:

Error:
ORA-01034: Oracle Not Available
ORA-27101: Shared Memory Realm Does Not Exists

If I try to enter with 'SQLPlus / Sysdba' appears:

Error:
ORA-01031: Insufficient privileges.

Does anyone know how to solve this?

[stcoutinho]

Vinicius,

Oracle XE was developed for 32-bit platform, but still seems to be able to run it at 64 bits.

Your instance Xe Parace These downloaded.

See if you can manually initialize the XE instance.

01) Open an MS-DOS window;
02) Call SQL * Plus: SQLPLUS <ENTER>
03) In the SQL * Plus session, run the command below:
SQL> / SYSDBA <ENTER>
04) When executing the above command, the message should appear:
"Connected to an idle instance".
05) Positive case, run the command below:
SQL> Startup <Enter>
06) The instance should be started without problems, as in the example below:

Select all

ORACLE instance started. 
Total System Global Area 1553305600 bytes 
Fixed Size	 2213656 bytes 
Variable Size	 1241516264 bytes 
Database Buffers	 301989888 bytes 
Redo Buffers	 7585792 bytes 
Database mounted. 
Database opened.

07) If initialization occurs without problems, exit SQL * plus with the command below:
SQL> Exit <Enter>
08) See if the listener is in the air . In the MS-DOS session, run the command:
lsnrctl status <enter>
09) The above command should return something like this:

Select all

LSNRCTL for 32-bit Windows: Version 10.2.0.1.0 - Production on 22-AGO-2011 18:29:41 
Copyright (c) 1991, 2005, Oracle.  All rights reserved. 
Estabelecendo conexÒo com (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC_FOR_XE))) 
STATUS do LISTENER 
------------------------ 
Apelido                   LISTENER 
VersÒo                    TNSLSNR for 32-bit Windows: Version 10.2.0.1.0 - Production 
Data Inicial              10-AGO-2011 18:50:55 
Funcionamento         11 dias 23 hr. 38 min. 55 seg 
NÝvel de Anßlise     off 
Seguranþa              ON: Local OS Authentication 
SNMP                      OFF 
Serviþo Default           XE 
Arq. ParÔm. Listn.    d:\oracle\xe\app\oracle\product\10.2.0\server\network\admin\listener.ora 
Arq. Log Listener    d:\oracle\xe\app\oracle\product\10.2.0\server\network\log\listener.log 
Resumo de Atendimento... 
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC_FOR_XEipc))) 
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=WTLSABR03649520.telefonica.br)(PORT=1521))) 
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=8080))(Presentation=HTTP)(Session=RAW)) 
Resumo de Serviþos... 
O serviþo "CLRExtProc" tem 1 instÔncia(s). 
  InstÔncia "CLRExtProc", status UNKNOWN, tem 1 handler(s) para este serviþo... 
O serviþo "PLSExtProc" tem 1 instÔncia(s). 
  InstÔncia "PLSExtProc", status UNKNOWN, tem 1 handler(s) para este serviþo... 
O serviþo "XEXDB" tem 1 instÔncia(s). 
  InstÔncia "xe", status READY, tem 1 handler(s) para este serviþo... 
O serviþo "XE_XPT" tem 1 instÔncia(s). 
  InstÔncia "xe", status READY, tem 1 handler(s) para este serviþo... 
O serviþo "xe" tem 1 instÔncia(s). 
  InstÔncia "xe", status READY, tem 1 handler(s) para este serviþo... 
O comando foi executado com Ûxito

10) Really return something like "TNS-12541: TNS: There is no listener", run the command below:
LSNRCTL START <ENTER>
11) You can check if the listener startup is OK, typing Again the command:
LSNRCTL Start <Enter>
12) With the seat in the air and Listener OK, try again access the Oracle XE page.

Inform me after the results of this action plan.

Hugs,

Sergio Coutinho

[stcoutinho]

Vinicius,

I had forgotten about his comments on privilege problems with Sysdba.

If in the previous action plan this problem of privileges occur, do the following:

01) Search the sqlnet.ora file, which is usually located in
$ oracle_home / network / admin;
02 Open the sqlnet.ora file and see if this line exists:
# sqlnet.authentication_services = (NTS)
03) If this line exists, remove the "#" and save the file;
04) Open the MS-DOS window again (do not use the previous window);
05) Repeat the connection process of SQL * Plus as SYSDBA;
06) Make the action plan mentioned earlier.

As you are installing on a 64-bit Windows machine (I do not know if it would be XP, Vista or Windows 7), you may still come across problems.

In this case, post them here for the forum staff to be able to help you. And resort exactly the Windows version where this XE 10G is located.

Hugs,

Sergio Coutinho

[viniciusandrade]

Sergio, thank you very much for the answers.

Listener is already running normally.
About SQLNet.ora, had already edited him, but this line was not commented (#). What I did was change the (NTS) to (none) as I found in other forums ...
I'm trying to connect locally (no network) on the machine that I installed Oracle, which is a Windows 7 64 bits.
When I squeeze the layer '/ Sysdba' in SQLPlus appears:
SP2-0103: Nothing to run on the SQL buffer.

...

[stcoutinho]

Vincius,

I do not know if you are calling SQLPlus and only then typing "/ SYSDBA"

Try to run the entire command from the prompt of the Of the example below:

Select all

C:\> sqlplus / as sysdba      <enter>

Hugs,

Sergio Coutinho

[viniciusandrade]

Sergio,

When I run the command that passed me appears:

Error:
ORA-12638: credential recovery failure

[stcoutinho]

Vinicius,

Check that this change in SQLNET.ora you did is effective:

From:
SQLNET.AUTHENTICATION_SERVICES = (NTS)
For:
sqlnet.authentication_services = (none)

Repeat the command as described below:

Select all

set ORACLE_SID=[NOME_DO_SID_DA_SUA_INSTANCIA]  <enter> 
sqlplus / as sysdba                            <enter>

Hugs,

Sergio

[viniciusandrade]

Sergio,

SQLNET.ORA remains like this:

Select all

SQLNET.AUTHENTICATION_SERVICES = (NONE) 

I did what he said:

Select all

set ORACLE_SID= XE

When I try 'SqlPlus / Sysdba' appears:

Select all

ORA-12560: TNS:erro de adaptador de protocolo

The listener is like this:



and tsnames is like this:

Select all

XE = 
  (DESCRIPTION = 
    (ADDRESS = (PROTOCOL = TCP)(HOST = cedrojt-006.cedrofinances.com.br)(PORT = 1521)) 
    (CONNECT_DATA = 
      (SERVER = DEDICATED) 
      (SERVICE_NAME = XE) 
    ) 
  ) 
 
EXTPROC_CONNECTION_DATA = 
  (DESCRIPTION = 
    (ADDRESS_LIST = 
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC_FOR_XE)) 
    ) 
    (CONNECT_DATA = 
      (SID = PLSExtProc) 
      (PRESENTATION = RO) 
    ) 
  ) 
 
ORACLR_CONNECTION_DATA =  
  (DESCRIPTION =  
    (ADDRESS_LIST =  
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC_FOR_XE))  
    )  
    (CONNECT_DATA =  
      (SID = CLRExtProc)  
      (PRESENTATION = RO)  
    )  
  ) 

Remembering that I am running SQLPlus locally.

[stcoutinho]

Vinicius,
I will search more about the problems you are having in your environment.
I must update when you have a plan of action.
Hugs,
Sergio

[viniciusandrade]

Sergio,

Since I had not yet managed to run Oracle Xe on Windows 7 64bits, I decided to install Ubuntu in VirtualBox and run the XE on it.
On Linux is all normal, but when I try to open a section of SQLPlus in Windows to connect to the bank, look at what happens:

Select all

sqlplus system/senha@10.1.1.1:1521/xe 
Conectado a: 
Oracle Database 10g Express Edition Release 10 
SQL> conn usuario 
Informe a senha: 
ERROR: 
ORA-01034: ORACLE not available 
ORA-27101: shared memory realm does not exist

See that it arrives to enter as system, but if I try to connect with 'user' it gives the same error. Strange that if I try to do it right:

Select all

sqlplus usuario/senha@10.1.1.1:1521/xe 
Conectado a: 
Oracle Database 10g Express Edition Release 10 
SQL>

Can it be any sqlplus problem? Because the bank on Linux is normal.

Embrace.

[stcoutinho]

Vinicius,

By Oracle Forums https://forums.oracle.com) Hi, it is possible to identify two possible causes for your problem:

a) Incorrect permission in the executable $ Oracle_home / bin / oracle :

On your blog http://sabdarsyed.blogspot.com/2009/01/ ... hared.html), DBA Sabdar Syed informs that this problem (shared memory) may be related to UNIX permissions problem in Oracle directory.
In short, you must assign the UNIX 6751 permission for the $ Oracle_Home / Bin / Oracle directory:

b) Environmental variables (oracle_home, oracle_sid, path)

Many forists mention that this problem occurs because the environment variables were not set correctly.

The Oracle XE manual (B25144-03), which can be obtained in [b http://www.oracle.com/pls/xe102/homepage[/b], nforming that you need to configure the bash-profile so that it automatically charges the variables Oracle Environment

Select all

$ cd $HOME 
$ cp $ORACLE_HOME/server/bin/oracle_env.sh .bash_profile

I suggest that you first run step a and see if the problem is resolved.

If it is not, run step B carefully. I suggest until you run a backup of "bash_profile".

Please update later this thread with the results obtained.

Hugs,

Sergio Coutinho

[viniciusandrade]

Good morning Sergio!

I made the two changes that passed me. But without success.
But now I'm already using the bank normally in Ubuntu, because I can already log in to it via SQLPlus and SQL Developer. When I connect to Windows SQLPlus directly on the user who want (SQLPLUS User / Password @ IP_UBUNTU: 1521 / XE), connect normally. The error only occurs when I am already connected and within the same section I try to connect with another user (SQL> CONN SYSTEM). There is a different error for Windows 7 64bits and for Windows XP 32bit:
Win 7:

Select all

ORA-27101: shared memory realm does not exist

Win XP:
1]]

TNSNAMES.ORA OF LINUX is like this:

Select all

XE = 
  (DESCRIPTION = 
    (ADDRESS = (PROTOCOL = TCP)(HOST = ubuntu)(PORT = 1521)) 
    (CONNECT_DATA = 
      (SERVER = DEDICATED) 
      (SERVICE_NAME = XE) 
    ) 
  ) 
 
EXTPROC_CONNECTION_DATA = 
  (DESCRIPTION = 
    (ADDRESS_LIST = 
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC_FOR_XE)) 
    ) 
    (CONNECT_DATA = 
      (SID = PLSExtProc) 
      (PRESENTATION = RO) 
    ) 
  )

[diegolenhardt]

There is no user with Grant Sysdba / System, or Export ..

I think it would be better to redo this installation huh, make an export and then it matters in a properly installed place,

It may be that I can solve it, but will it be trustworthy?

[stcoutinho]

HUMM,

About this user change error In the same session, the problem occurs both when you operate the Windows SQL * Plus and Ubuntu SQL * Plus? In both similar problems occur?

I do not know much about the synthesine of the connection string you use on your connections. Maybe it's outdating my part, but do you really need to tell all this after "@"? Why not simply try:

Select all

SQL> conn system/manager@XE

From what I said, you are able to work with the bank, despite this small inconvenience.

Would you still want to try out this problem completely, or the way it is, "já Give for the spending"?

Hugs,

Sergio Coutinho

[diegolenhardt]

How System will request the role that he wants

"/ Sysdba" or "System"
: D

[viniciusandrade]

Problems with Oracle XE in Windows 7 64bits continue, but I can already use the bank normally installed in Ubuntu.
I will continue searching and installing the bank in other machines that I have here.
Any news I find or even when I can solve the problem, I post here for everyone to consult.

Thank you all.