Re: ORA-12514 with 10g Install

scout1024_at_gmail.com wrote:

>
> listener.ora looks like :
> --------------------------------
> SID_LIST_LISTENER =
> (SID_LIST =
> (SID_DESC =
> (SID_NAME = PLSExtProc)
> (ORACLE_HOME = C:\oraclexe\app\oracle\product\10.2.0\server)
> (PROGRAM = extproc)
> )
> (SID_DESC =
> (SID_NAME = CLRExtProc)
> (ORACLE_HOME = C:\oraclexe\app\oracle\product\10.2.0\server)
> (PROGRAM = extproc)
> )
> )
>
>
> LISTENER =
> (DESCRIPTION_LIST =
> (DESCRIPTION =
> (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC_FOR_XE))
> (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
> )
> )
>

Change it to:

SID_LIST_LISTENER =
   (SID_LIST =

     (SID_DESC =
       (SID_NAME = PLSExtProc)
       (ORACLE_HOME = C:\oraclexe\app\oracle\product\10.2.0\server)
       (PROGRAM = extproc)
     )
     (SID_DESC =
       (SID_NAME = XE)
       (ORACLE_HOME = C:\oraclexe\app\oracle\product\10.2.0\server)
     )

LISTENER =
   (DESCRIPTION_LIST =

     (DESCRIPTION =
       (ADDRESS = (PROTOCOL = IPC)(KEY = XE))
       (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
     )

DEFAULT_SERVICE_LISTENER = (XE)
>
> sqlnet.ORA has:
> ------------------------
> SQLNET.AUTHENTICATION_SERVICES = (NTS)
>
> tnsname.ora has:
> ------------------------

Change that to:

XE =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))     (CONNECT_DATA =

      (SERVER = DEDICATED)
      (SID = XE)

-- 
Regards,
Frank van Bortel

Top-posting is one way to shut me up...