Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I have a problem with Oracle XE 11g on Windows 7 64. I know that a lot of people have the same problem but I did'nt find a solution for my case.

In sqlnet.ora: with SQLNET.AUTHENTICATION_SERVICES = (NTS) I have

ORA-12638: Credential retrieval failed

with SQLNET.AUTHENTICATION_SERVICES = (NTS) I have

ORA-01031: insufficient privileges

echo %ORACLE_HOME% returns:

D:\Projets\tools\com\oracle\xe\app\oracle\product\11.2.0\server\app\oracle\product\11.2.0\server 

echo %ORACLE_SID% returns:

XE

My tnsnames.ora:

XE =
(DESCRIPTION =
  (ADDRESS = (PROTOCOL = TCP)(HOST = ITEM-60808.dhcp.mtrl.fr.sopra)(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) 
  ) 
) 

My listeners.ora:

SID_LIST_LISTENER =
 (SID_LIST =
   (SID_DESC =
     (SID_NAME = PLSExtProc)
     (ORACLE_HOME =     d:\Projets\tools\com\oracle\xe\app\oracle\product\11.2.0\server\app\oracle\product\11.2.0\server)
     (PROGRAM = extproc)
   )
 (SID_DESC =
  (SID_NAME = CLRExtProc)
  (ORACLE_HOME = d:\Projets\tools\com\oracle\xe\app\oracle\product\11.2.0\server\app\oracle\product\11.2.0\server)
  (PROGRAM = extproc)
 )
)

LISTENER =
 (DESCRIPTION_LIST =
   (DESCRIPTION =
    (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
    (ADDRESS = (PROTOCOL = TCP)(HOST = ITEM-60808.dhcp.mtrl.fr.sopra)(PORT = 1521))
   )
  )

 DEFAULT_SERVICE_LISTENER = (XE)

lsnrctl status returns:

LSNRCTL for 32-bit Windows: Version 11.2.0.2.0 - Production on 24-JUIN -2013 15:23:44

Copyright (c) 1991, 2010, Oracle.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
TNS-12541: TNS:no listener
 TNS-12560: TNS:protocol adapter error
  TNS-00511: No listener
   32-bit Windows Error: 2: No such file or directory
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=ITEM-60808.dhcp.mtrl.fr.sopra)    (PORT=1521)))
TNS-12541: TNS:no listener
 TNS-12560: TNS:protocol adapter error
  TNS-00511: No listener
   32-bit Windows Error: 61: Unknown error

OracleJobSchudelerXE, OracleServiceXE and OracleXEClrAgent are launched but OracleXETNSListener doesn't want to start...

Does anybody have the solution?

share|improve this question
add comment

migrated from stackoverflow.com Jun 25 '13 at 11:20

This question came from our site for professional and enthusiast programmers.

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.