This discussion is archived
7 Replies Latest reply: Nov 27, 2012 1:29 PM by lxiscas RSS

Please help me to use get started URL

lxiscas Newbie
Currently Being Moderated
Hi, guys:

I am sorry for the post. The problem may sound familiar to you, but I have been lost for one week. I am required to install Oracle XE 11g on Windows 7 64 bits OS. and I tried many times and searched on this forum, but I still cannot use get started URL. Here is my situation:

#1 I cannot run get started, I get information as:
Unable to connect
Firefox can't establish a connection to the server at 127.0.0.1:8080.


#2 I checked the services of Windows.
There are these services related to XE:

OracleJobSchedulerXE disabled
OracleMTSRecoveryService manual
OracleServiceXE started automatic
OracleXEClrAgent manual
OracleXETNSListener automatic

SO only OracleServiceXE is started. I tried to start OracleXETNSListener service, but it failed, and reported: the Oracle OracleXETNSListener service started and then stopped, some service stop automatically if they are not in use by other services or programs.

#3 I can run start database and and it reported: OracleXETNSListener is starting. and I can run sqlplus and log in as system as sysdba.

#4 I also run lsnrctl stat on command and I got this result:

lsnrctl for 32- bit windows: version 11.2.0.2.0- production on 27-NOV-2012
connecting to (DESXRIPTION=(ADDRESS=(PROTOCOL=TCP)(KEY=EXTPROC)))
TNS12541: TNS: no listenerTNSTNS-12560: TNS: protocol adapter error
TNS-00511: no listener
32-bit windows Error: 61: Unknown error
connecting to (DESXRIPTION=(ADDRESS=(PROTOCOL=IPC)(HOST=LSGPCDELL790-2)(PORT=1521)))
TNS12541: TNS: no listenerTNSTNS-12560: TNS: protocol adapter error
TNS-00511: no listener
32-bit windows Error: 61: Unknown error

Could anyone help me on this problem? what should I start?

Thanks for your help!

Sam

Edited by: lxiscas on Nov 27, 2012 8:50 AM

Edited by: lxiscas on Nov 27, 2012 8:51 AM
  • 1. Re: Please help me to use get started URL
    clcarter Expert
    Currently Being Moderated
    OracleXETNSListener service started and then stopped
    Got to figure out why the listener won't stay running, with no listener the Apex web pages won't be available. Try a `lsnrctl start`, connect to the database with the system user, `alter system register;` and check the `lsnrctl status` and `lsnrctl services` output again. If the listener crashes might have some hints in the listener log, filename shows up in the `... status` output.

    I'm not positive about windows x64 but 64 bit XE for Windows has not yet been released- might have to wait for that version.

    And may help to completely wipe the listener.ora file, i.e. stop the listener, move [.../network/admin/]listener.ora to listener.ora.bk and try another `lsnrctl start`. Every database install has a default listener at the default port 1521 named "listener", a non existent listener.ora file could eliminate a configuration glitch with that file.
  • 2. Re: Please help me to use get started URL
    lxiscas Newbie
    Currently Being Moderated
    Hi, pal:

    Thanks for your suggestion!. I tried your way. I cannot start listener with command as lsnrctl start, it reported as "failed to start service, error 0", so I change the name of listener.ora as listener.bk.ora, but I got the same problem... any further suggestion?

    Sam
  • 3. Re: Please help me to use get started URL
    clcarter Expert
    Currently Being Moderated
    See if there are any more error messages in the listener.log.

    Verify your windows user is in the local Administrators and ORA_DBA groups, I think a Start/Run/lusrmgr.msc shortcut still works on Win7. But if that was a problem for the installing user the services probably would not have gotten created.

    Only two of those services matter for XE, the ...ServiceXE is the database and ...XEtnslistener one.
  • 4. Re: Please help me to use get started URL
    lxiscas Newbie
    Currently Being Moderated
    Hi:

    my account is windows administrator, but I do not know how to verify my windows user belongs to ORA_DBA group, I log in to sqlplus with SYSTEM though. Windows did not find lusrmgr shortcut.

    Thanks.

    Sam
  • 5. Re: Please help me to use get started URL
    orafad Oracle ACE
    Currently Being Moderated
    lxiscas wrote:
    I cannot start listener with command as lsnrctl start, it reported as "failed to start service, error 0", so I change the name of listener.ora as listener.bk.ora, but I got the same problem...
    Please post a full copy-paste of command line session, from a elevated command prompt (Run as administrator):
    C:\>lsnrctl start
    Also post results from:

    C:\>sc qc OracleXETNSListener

    C:\>net localgroup ora_dba
  • 6. Re: Please help me to use get started URL
    lxiscas Newbie
    Currently Being Moderated
    Hi:

    I run as administrator:

    Microsoft Windows [Version 6.1.7601]
    Copyright (c) 2009 Microsoft Corporation. All rights reserved.

    C:\Windows\system32>cd\

    C:\>sc qc OracleXETNSListener
    [SC] QueryServiceConfig SUCCESS

    SERVICE_NAME: OracleXETNSListener
    TYPE : 10 WIN32_OWN_PROCESS
    START_TYPE : 2 AUTO_START
    ERROR_CONTROL : 0 IGNORE
    BINARY_PATH_NAME : C:\oraclexe\app\oracle\product\11.2.0\server\BIN\tn
    slsnr.exe
    LOAD_ORDER_GROUP :
    TAG : 0
    DISPLAY_NAME : OracleXETNSListener
    DEPENDENCIES :
    SERVICE_START_NAME : LocalSystem

    C:\>net localgroup ora_dba
    Alias name ora_dba
    Comment Oracle DBA Group

    Members

    -------------------------------------------------------------------------------
    NT AUTHORITY\SYSTEM
    Sam
    The command completed successfully.


    C:\>lsnrctl start

    LSNRCTL for 32-bit Windows: Version 11.2.0.2.0 - Production on 27-NOV-2012 15:25
    :15

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

    Starting tnslsnr: please wait...

    Failed to start service, error 0.
    TNS-12560: TNS:protocol adapter error

    C:\>
  • 7. Re: Please help me to use get started URL
    orafad Oracle ACE
    Currently Being Moderated
    Did you perhaps uninstall and reinstall XE in the process?

    Either way, reboot Windows and see if service is started.

Legend

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