ORA-12514: TNS: Listener Does Not Currently Know of Service.

[Abcd]

I am receiving this message when you try to connect with Oracle XE with PL / SQL 10. Using Windows 10, version 1703.

Everything was working OK until Oracle services began not to Start. erro 0xc00007b. After several attempts to solve the problem, I reinstalled Oracle. The OracleXE service rose but the error 0xc00007b continued in the listener service, are reinstalled again and finally the listener and oracle startaram services, but now I have this problem:

Select all

ORA-12514: TNS: Listener does not currently know of service requested in connect descriptor

I rode lsnrctl status and gave this:

Listener status

Select all

Apelido                   LISTENER 
VersÒo                    TNSLSNR for 64-bit Windows: Version 11.2.0.2.0 - Production 
Data Inicial              16-JAN-2018 21:11:54 
Funcionamento         0 dias 0 hr. 15 min. 26 seg 
NÝvel de Anßlise     off 
Seguranþa              ON: Local OS Authentication 
SNMP                      OFF 
Serviþo Default           XE 
Arq. ParÔm. Listn.    C:\oraclexe\app\oracle\product\11.2.0\server\network\ADMIN\listener.ora 
Arq. Log Listener    C:\oraclexe\app\oracle\diag\tnslsnr\LAPTOP-712G31EO\listener\alert\log.xml 
Resumo de Atendimento... 
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1ipc))) 
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=LAPTOP-712G31EO)(PORT=1521))) 
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 comando foi executado com Ûxito.

TNS NAMES is with the SERVICE XE:

Select all

XE = 
  (DESCRIPTION = 
    (ADDRESS = (PROTOCOL = TCP)(HOST = LAPTOP-712G31EO)(PORT = 1521)) 
    (CONNECT_DATA = 
      (SERVER = DEDICATED) 
      (SERVICE_NAME = XE) 
    ) 
  ) 
 
EXTPROC_CONNECTION_DATA = 
  (DESCRIPTION = 
    (ADDRESS_LIST = 
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1)) 
    ) 
    (CONNECT_DATA = 
      (SID = PLSExtProc) 
      (PRESENTATION = RO) 
    ) 
  ) 
 
ORACLR_CONNECTION_DATA =  
  (DESCRIPTION =  
    (ADDRESS_LIST =  
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))  
    )  
    (CONNECT_DATA =  
      (SID = CLRExtProc)  
      (PRESENTATION = RO)  
    )  
  ) 

Listener.ora:

Select all

SID_LIST_LISTENER = 
  (SID_LIST = 
    (SID_DESC = 
      (SID_NAME = PLSExtProc) 
      (ORACLE_HOME = C:\oraclexe\app\oracle\product\11.2.0\server) 
      (PROGRAM = extproc) 
    ) 
    (SID_DESC = 
      (SID_NAME = CLRExtProc) 
      (ORACLE_HOME = C:\oraclexe\app\oracle\product\11.2.0\server) 
      (PROGRAM = extproc) 
    ) 
  ) 
 
LISTENER = 
  (DESCRIPTION_LIST = 
    (DESCRIPTION = 
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1)) 
      (ADDRESS = (PROTOCOL = TCP)(HOST = LAPTOP-712G31EO)(PORT = 1521)) 
    ) 
  ) 
 
DEFAULT_SERVICE_LISTENER = (XE)

I have already stopped and Startei the servic of the OracleLex, unsuccessfully.

Does anyone know what might be missing?

Thanks.

[Abcd]

The problem described above has been resolved by inserting a new SID_DESC into the SID_LIST to the bank service.

But now another error appeared:

Select all

ORA-01034: ORACLE not available 
ORA-27101: shared memory realm does not exist 
Process ID:0 
Session ID: 0 Serial number: 0

The OracleXe service is running

[adrianoturbo]

Brother has taken a look at the Windows services?