This discussion is archived
12 Replies Latest reply: Dec 6, 2012 11:26 AM by n_shah18 RSS

XE listner home page not starting

n_shah18 Newbie
Currently Being Moderated
windows 7 ,64 bit i am trying to install XE

step i followed till now


I have Windows 7 x64 and a got the problem about the KEY_XE.reg not fount. I have tried a lot of configurations I have finally solved.

We need do some thinks:

1. Start the installer ‘Setup.exe’. Wait till ask about the path;
2. Do not press next. Open with Windows Explorer the folder like this:
C:\Users\<your user name>\AppData\Local\Temp{60712028-B7B0-4EC3-9C28-663111EC954A}
3. There will be a file “OracleMTSRecoveryService.reg”. Make a copy and rename the copy to KEY_REG.reg;
4. Go to the installer and go ahead with the installation.

You will not see any error about the KEY_XE.reg not found.


further issue is this
C:\oraclexe\app\oracle\product\11.2.0\server\bin>lsnrctl status

LSNRCTL for 32-bit Windows: Version 11.2.0.2.0 - Production on 04-DEC-2012 14:29:38

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=LSGPCDELL790-1)(PORT=1521)))
TNS-12541: TNS:no listener
 TNS-12560: TNS:protocol adapter error
  TNS-00511: No listener
   32-bit Windows Error: 61: Unknown error

C:\oraclexe\app\oracle\product\11.2.0\server\bin> 
services OracleServiceXE (would start) and OracleXETNSListener (wont start)

Edited by: Hunk09 on Dec 4, 2012 12:33 PM

Edited by: Hunk09 on Dec 4, 2012 12:40 PM

Edited by: Hunk09 on Dec 4, 2012 12:40 PM
  • 1. Re: XE listner home page not starting
    clcarter Expert
    Currently Being Moderated
    windows 7 ,64 bit
    Not sure if anyone has done a successful install on win-x64, I have no host to try it on. The x64 version for Windows is supposedly on the way, but not yet available.

    Try looking into the listener.log it should be in the ...oraclexe\app\oracle\diag\tnslsnr\<hostname>\listener\trace folder- any error messages might be helpful to help figure out why the listener won't start or stay running.
  • 2. Re: XE listner home page not starting
    n_shah18 Newbie
    Currently Being Moderated
    Thanks you for prompt reply.
    i understand that actual installation(64bit) is not available but many have install successfully , I am seeking help how did they do?


    regarding error in log file below
    Message 279 not found; No message file for product=NETWORK, facility=NL
    Message 509 not found; No message file for product=NETWORK, facility=NL
    Message 510 not found; No message file for product=NETWORK, facility=NL
    also

    C:\>set ORACLE_HOME
    oracle_home=C:\oraclexe\app\oracle\product\11.2.0\server
    
    C:\>set PATH
    Path=C:\oraclexe\app\oracle\product\11.2.0\server\bin
    PATHEXT=.COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.MSC
    
    C:\>set TNS_ADMIN
    Environment variable TNS_ADMIN not defined
    
    C:\>lsnrctl start
    
    LSNRCTL for 32-bit Windows: Version 11.2.0.2.0 - Production on 04-DEC-2012 15:20:21
    
    Copyright (c) 1991, 2010, Oracle.  All rights reserved.
    
    Starting tnslsnr: please wait...
    
    TNS-12560: TNS:protocol adapter error
     TNS-00530: Protocol adapter error
    
    
    C:\>
    thanks

    Edited by: Hunk09 on Dec 4, 2012 1:21 PM
  • 3. Re: XE listner home page not starting
    clcarter Expert
    Currently Being Moderated
    Should have an ORA-nnnn or TNS-nnnn error message instead of "message ... not found" something isn't right with the environment.

    Try setting ORACLE_HOME and add its bin folder to your PATH variable, and check that your user is in the local admins and ora_dba groups:
     
    set ORACLE_HOME=C:\oraclexe\app\oracle\product\11.2.0\server
    dir %ORACLE_HOME%
     ... just to make sure its right should be lots of folders
    set PATH=%ORACLE_HOME%\bin;%PATH%
    net localgroup administrators
     ...
    net localgroup ora_dba
     ...
    lsnrctl start
     ...
  • 4. Re: XE listner home page not starting
    n_shah18 Newbie
    Currently Being Moderated
    i followed the step again as mentioned
    C:\oraclexe>lsnrctl start
    
    LSNRCTL for 32-bit Windows: Version 11.2.0.2.0 - Production on 04-DEC-2012 15:36:02
    
    Copyright (c) 1991, 2010, Oracle.  All rights reserved.
    
    Starting tnslsnr: please wait...
    
    *TNS-12560: TNS:protocol adapter error*
     *TNS-00530: Protocol adapter error*
    thanks
  • 5. Re: XE listner home page not starting
    orafad Oracle ACE
    Currently Being Moderated
    Hunk09 wrote:
    C:\>set ORACLE_HOME
    oracle_home=C:\oraclexe\app\oracle\product\11.2.0\server
    On Windows, you should NOT need to set ORACLE_HOME as a environment variable. A working install has the setting in the Registry.

    Try:
    set oracle_home=
    sqlplus / as sysdba
    SQL> @.[%ORACLE_HOME%].
    SQL> host set ora


    >
    C:\>set PATH
    Path=C:\oraclexe\app\oracle\product\11.2.0\server\bin
    Is that the full PATH? Windows needs other dir paths as well.


    C:\>lsnrctl start

    LSNRCTL for 32-bit Windows: Version 11.2.0.2.0 - Production on 04-DEC-2012 15:20:21

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

    Starting tnslsnr: please wait...

    TNS-12560: TNS:protocol adapter error
    TNS-00530: Protocol adapter error
    You need to run lsnrctl start from a elevated command prompt (Run as administrator - even if logged in as a admin!).

    Edited by: orafad on Dec 4, 2012 11:07 PM
  • 6. Re: XE listner home page not starting
    n_shah18 Newbie
    Currently Being Moderated
    still the same

    i double check the path and ORACLE_HOME its the same as i stated before
    C:\>lsnrctl start
    
    LSNRCTL for 32-bit Windows: Version 11.2.0.2.0 - Production on 04-DEC-2012 15:57:43
    
    Copyright (c) 1991, 2010, Oracle.  All rights reserved.
    
    Message 1070 not found; No message file for product=NETWORK, facility=TNSTNS-12557: Message 12557 not found; No message file for product=NETWORK, facility=TNS
     TNS-12560: Message 12560 not found; No message file for product=NETWORK, facility=TNS
      TNS-00527: Message 527 not found; No message file for product=NETWORK, facility=TNS
  • 7. Re: XE listner home page not starting
    orafad Oracle ACE
    Currently Being Moderated
    That is not "still the same". Now you have "message ... not found" errors that you did not have above. Often caused by improperly set environment.

    Show what you have - re-run commands requested above and use copy-paste of command line sessions.

    Are you logged in as a local admin?

    net start OracleXETNSListener

    etc.
  • 8. Re: XE listner home page not starting
    n_shah18 Newbie
    Currently Being Moderated
    My bad for not running as ADmin

    Now i did
    C:\>set ORACLE_HOME
    Environment variable ORACLE_HOME not defined
    
    C:\>set ORACLE_HOME=C:\oraclexe\app\oracle\product\11.2.0\server
    
    C:\>set PATH=C:\oraclexe\app\oracle\product\11.2.0\server\bin;%PATH%
    
    C:\>lsnrctl start
    
    LSNRCTL for 32-bit Windows: Version 11.2.0.2.0 - Production on 04-DEC-2012 16:13
    :54
    
    Copyright (c) 1991, 2010, Oracle.  All rights reserved.
    
    Starting tnslsnr: please wait...
    
    Failed to start service, error 0.
    TNS-12560: TNS:protocol adapter error
    Edited by: Hunk09 on Dec 4, 2012 2:16 PM
  • 9. Re: XE listner home page not starting
    orafad Oracle ACE
    Currently Being Moderated
    Again, do NOT set ORACLE_HOME. If install was complete, it is set by Registry value.


    Remove environment variable ORACLE_HOME. Reboot the machine.

    Verify per below (Assuming correct PATH setting):

    set oracle_home -- should return "not defined"
    sqlplus / as sysdba
    SQL> @.[%oracle_home%]. -- says, as expected, unable to open but with the Home path, as found via PATH + Registry key values


    Then retry:

    c:\> lsnrctl start
  • 10. Re: XE listner home page not starting
    n_shah18 Newbie
    Currently Being Moderated
    Again, do NOT set ORACLE_HOME. If install was complete, it is set by Registry value.


    Remove environment variable ORACLE_HOME. Reboot the machine.
    DONE
    Verify per below (Assuming correct PATH setting):

    set oracle_home -- should return "not defined"
    true DONE
    sqlplus / as sysdba
    SQL> @.[%oracle_home%]. -- says, as expected, unable to open but with the Home path, as found via PATH + Registry key values
    * SP2-0310: unable to open file "C:\oraclexe\app\oracle\product\11.2.0\ *
    Then retry:

    c:\> lsnrctl start
    {code}

    C:\>lsnrctl start
    'lsnrctl' is not recognized as an internal or external command,
    operable program or batch file.

    C:\>

    {code}

    Edited by: Hunk09 on Dec 6, 2012 10:32 AM
  • 11. Re: XE listner home page not starting
    orafad Oracle ACE
    Currently Being Moderated
    Make sure PATH is set, with path to Oracle XE's bin folder prepended (the same as earlier).

    Please post full copy paste of command line sessions. The above is cut and missing pieces. We need to see exactly what you have on your screen.
  • 12. Re: XE listner home page not starting
    n_shah18 Newbie
    Currently Being Moderated
    Its started , was able to open home page.
    Microsoft Windows [Version 6.1.7601]
    Copyright (c) 2009 Microsoft Corporation.  All rights reserved.
    
    C:\Users\Neel>cd/
    
    C:\>set path
    Path=C:\Windows\System32
    PATHEXT=.COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.MSC
    
    C:\>set oracle_home
    Environment variable oracle_home not defined
    
    C:\>set path=C:\oraclexe\app\oracle\product\11.2.0\server\bin
    
    C:\>set path
    Path=C:\oraclexe\app\oracle\product\11.2.0\server\bin
    PATHEXT=.COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.MSC
    
    C:\>lsnrctl start
    
    LSNRCTL for 32-bit Windows: Version 11.2.0.2.0 - Production on 06-DEC-2012 13:24
    :02
    
    Copyright (c) 1991, 2010, Oracle.  All rights reserved.
    
    TNS-01106: Listener using listener name LISTENER has already been started
    
    C:\>
    THANK you SO SO much !

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points