Configuring localhost for Oracle XE on Windows 7

vincencollins — Mon, 02 May 2011 02:57:45 +0000

While at a client the installation of Oracle XE set the host to my computer name which included a sub-domain that would not resolving because I was on the client network. This was causing an ORA-12545 error (Connect failed because target host or object does not exist) which was resolved by change the host name to 127.0.0.1 in C:\oraclexe\app\oracle\product\11.2.0\server\network\ADMIN\listener.ora and C:\oraclexe\app\oracle\product\11.2.0\server\network\ADMIN\tnsnames.ora

Next I encountered an ORA-12514 error (listener does not currently know of service requested in connect descriptor) that took me awhile to figure out. I finally found the answer in this thread. Turns out the XE service needs to be registered by adding the following SID_DESC to the SID_LIST in C:\oraclexe\app\oracle\product\11.2.0\server\network\ADMIN\listener.ora

(SID_DESC =
      (SID_NAME = XE)
      (ORACLE_HOME = C:\oraclexe\app\oracle\product\11.2.0\server)
    )

Here is the complete C:\oraclexe\app\oracle\product\11.2.0\server\network\ADMIN\listener.ora file.

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)
    )
    (SID_DESC =
      (SID_NAME = XE)
      (ORACLE_HOME = C:\oraclexe\app\oracle\product\11.2.0\server)
    )
  )
 
LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
      (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
    )
  )
 
DEFAULT_SERVICE_LISTENER = (XE)

Happy Coding!
Vincen Collins

Hello world!

vincencollins — Wed, 23 Feb 2011 15:51:11 +0000

Welcome to WordPress. This is your first post. Edit or delete it, then start blogging!