Re: Oracle Enterprise 10gR2 can't be installed on Windows XP/2003

From: Thomas <thomas.zuehlke_at_googlemail.com>
Date: Sun, 12 Aug 2007 11:03:22 -0700
Message-ID: <1186941802.558707.46390@l70g2000hse.googlegroups.com>

Thanks for reply!
> If you would have done so, you would have found a plethora of
> posters,who,like you, couldn't be bothered to read the documentation,
> so yet posted this error again, *AND* have been responded.
You are right, the ORA-12154 error is a frequently posted error and there are many hints for it. But my problem is, that this error occurs during the installation process. I think its not a good idea to change the tnsnames.ora file during the installation. But i have tryed it (please see below).

> Your problem is your listener.ora and tnsnames.ora don't match.
> There is an init.ora parameter called service_name.
> If you type lsnrctl services in a dos box, you'll see which service
> the listener supports. THAT servicename needs to go in tnsnames.ora.
I have tryed your advices. I have deleted Enterprise Database and started the installation again. As the error occurs, i have checked the init.ora file, there is no entry with the name "service_name". I have checked the LSNRCTL with "services": LSNRCTL> services
Anmeldung bei (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1))) Services bersicht...
Dienst "PLSExtProc" hat 1 Instance(s).
  Instance "PLSExtProc", Status UNKNOWN, hat 1 Handler f³r diesen Dienst...

    Handler:

      "DEDICATED" eingerichtet:0 abgewiesen:0
         LOCAL SERVER

Dienst "orcl" hat 1 Instance(s).
  Instance "orcl", Status READY, hat 1 Handler f³r diesen Dienst...     Handler:

      "DEDICATED" festgelegt:0 abgelehnt:0 Status:ready
         LOCAL SERVER

Dienst "orclXDB" hat 1 Instance(s).
  Instance "orcl", Status READY, hat 1 Handler f³r diesen Dienst...     Handler:
      "D000" eingerichtet:0 abgewiesen:0 aktuell:0 max:1002 Status:ready

         DISPATCHER <machine: WINXPCORPWORK, pid: 932>
         (ADDRESS=(PROTOCOL=tcp)(HOST=winxpcorpwork)(PORT=1039))

Dienst "orcl_XPT" hat 1 Instance(s).
  Instance "orcl", Status READY, hat 1 Handler f³r diesen Dienst...     Handler:

      "DEDICATED" festgelegt:0 abgelehnt:0 Status:ready
         LOCAL SERVER

(sorry, but output is in german)
The Service "PLSExtProc" has the status UNKNOWN, I think this the problem?

The listener.ora file contains:
SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =

      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = C:\oracle\product\10.2.0\db)
      (PROGRAM = extproc)

    )
  )
LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =

      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
      (ADDRESS = (PROTOCOL = TCP)(HOST = winxpcorpwork)(PORT = 1521))

    )
  )

And the tnsnames.ora contains:
EXTPROC_CONNECTION_DATA =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))     )
    (CONNECT_DATA =

      (SID = PLSExtProc)
      (PRESENTATION = RO)

    )
  )

I have changed a line in tnsnames.ora from "(ADDRESS = (PROTOCOL = IPC) (KEY = EXTPROC1))" to "(ADDRESS = (PROTOCOL = IPC)(KEY = PLSExtProc))" but i get another error. Then i have changed the line from "EXTPROC_CONNECTION_DATA =" to "EXTPROC1_CONNECTION_DATA =" and the installation doesn't continue for 2 hourse and i have canceled the "Oracle Database Configuration Assistant" again. Therefore i think the actual configuration is okay, but do i need an entry for the ORCL service?
Thanks a lot!
Thomas Received on Sun Aug 12 2007 - 13:03:22 CDT