This discussion is archived
1 2 Previous Next 29 Replies Latest reply: Jun 10, 2013 10:47 AM by clcarter Go to original post RSS
  • 15. Re: Newbie on running Oracle 11g - Windows cannot find http:something
    orafad Oracle ACE
    Currently Being Moderated
    zack_falcon wrote:
    Of note is that I've already inserted the following:
    127.0.0.1 arnold-pc
    Please reverse that change.
    Comment out the line (add a # in front of it), then reboot laptop.

    Check if lsnrctl stat output is different, after rebooting.


    You don't have any other services installed that uses port 8080?

    It was stated earlier that this was a company laptop.
    Is it connected to office network and was it while you installed XE? Are you using a domin login? (set | findstr "USER SERV")
  • 16. Re: Newbie on running Oracle 11g - Windows cannot find http:something
    966080 Newbie
    Currently Being Moderated
    Change has been reversed. Restarted the laptop and waited awhile before doing the lsnrctl stat command.

    Here's the results. I can't see any differences.

    C:\Windows\System32>lsnrctl stat

    LSNRCTL for 32-bit Windows: Version 11.2.0.2.0 - Production on 11-OCT-2012 09:34
    :13

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

    Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
    STATUS of the LISTENER
    ------------------------
    Alias LISTENER
    Version TNSLSNR for 32-bit Windows: Version 11.2.0.2.0 - Produ
    ction
    Start Date 11-OCT-2012 09:29:35
    Uptime 0 days 0 hr. 4 min. 41 sec
    Trace Level off
    Security ON: Local OS Authentication
    SNMP OFF
    Listener Log File C:\oraclexe\app\oracle\diag\tnslsnr\arnold-PC\listener
    \alert\log.xml
    Listening Endpoints Summary...
    (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=arnold-PC)(PORT=1521)))
    Services Summary...
    Service "xe" has 1 instance(s).
    Instance "xe", status READY, has 1 handler(s) for this service...
    The command completed successfully

    As for checking if the port 8080 is used, how do I do that?

    I used telnet localhost 8080. Returned a "Could not open connection to the host on port 8080: Connection failed."

    The company structure (as far as I know) is rather simple. Everything's connected to a server, which acts only as a file repository. Each laptop can be modified and used as the user pleases (within reason, of course). Kinda like how most multi-computer setups at home are. No domain login, or anything.

    Here's the results of the set | findstr "USER SERV" command.

    C:\Windows\System32>set | findstr "USER SERV"
    ALLUSERSPROFILE=C:\ProgramData
    LOGONSERVER=\\ARNOLD-PC
    USERDOMAIN=arnold-PC
    USERNAME=IDS
    USERPROFILE=C:\Users\IDS


    I tried running the "Getting Started with Oracle" again, but it still shows me the "Oops! Google Chrome could not connect to 127.0.0.1:8080" message.

    Thanks for the help.

    -Zack_Falcon
  • 17. Re: Newbie on running Oracle 11g - Windows cannot find http:something
    orafad Oracle ACE
    Currently Being Moderated
    At this point, a reinstall might be the best way forward.

    But, either way, let's look at some XDB (built in HTTP server) details first.

    Run the following, from sqlplus:
    select dbms_xdb.gethttpport from dual;
    
    set serveroutput on
    set long 20000
    set pages 0
    
    
    declare
      host  varchar2(100);
      port  number;
      proto number;
    begin
      DBMS_XDB.GETLISTENERENDPOINT (DBMS_XDB.XDB_ENDPOINT_HTTP,
                     host,port,proto);
    
      dbms_output.put_line('Endpoint info (HTTP): Host='||host||' Port='||port||' (protocol='||proto||')');
    
    end;
    /
    
    spool My_XE_XDB_config.xml
    select DBMS_XDB.CFG_GET from dual;
    spool off
    Interesting bits from the last CFG_GET output is found in e.g. listener and port parts of http-config element.
    But you could spool to file and look for other potential relevant bits.
  • 18. Re: Newbie on running Oracle 11g - Windows cannot find http:something
    966080 Newbie
    Currently Being Moderated
    Most of the commands I entered in SQL yielded me a "SP2-0640: Not connected"

    I couldn't log on using sqlplus anyway. I get an

    "ORA-01033: ORACLE initialization or shutdon in progress"

    for some reason.

    So I used sql /nolog instead.

    I'm going to reinstall, which I hope fixes the problems. I just hope I don't run into these issues again.

    Thanks for the help anyway.

    -Zack_Falcon
  • 19. Re: Newbie on running Oracle 11g - Windows cannot find http:something
    orafad Oracle ACE
    Currently Being Moderated
    zack_falcon wrote:
    I couldn't log on using sqlplus anyway. I get an

    "ORA-01033: ORACLE initialization or shutdon in progress"
    This could possibly be related. In the fourth post of this thread, it seemed to be up.

    If you have not reinstalled already, try this sequence of commands:


    sqlplus / as sysdba

    SQL> shu immediate

    SQL> exit


    sqlplus / as sysdba

    SQL> startup

    Edited by: orafad on Oct 12, 2012 10:01 AM
  • 20. Re: Newbie on running Oracle 11g - Windows cannot find http:something
    966080 Newbie
    Currently Being Moderated
    Well, thankfully I haven't been able to uninstall yet. Here's the results of those commands:


    C:\Windows\System32>sqlplus / as sysdba

    SQL*Plus: Release 11.2.0.2.0 Production on Mon Oct 15 09:20:24 2012

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


    Connected to:
    Oracle Database 11g Express Edition Release 11.2.0.2.0 - Production

    SQL> shu immediate
    ORA-01109: database not open


    Database dismounted.
    ORACLE instance shut down.
    SQL> exit
    Disconnected from Oracle Database 11g Express Edition Release 11.2.0.2.0 - Produ
    ction

    C:\Windows\System32>sqlplus / as sysdba

    SQL*Plus: Release 11.2.0.2.0 Production on Mon Oct 15 09:32:03 2012

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

    Connected to an idle instance.

    SQL> startup
    ORACLE instance started.

    Total System Global Area 376635392 bytes
    Fixed Size 1383692 bytes
    Variable Size 234881780 bytes
    Database Buffers 134217728 bytes
    Redo Buffers 6152192 bytes
    Database mounted.
    ORA-01589: must use RESETLOGS or NORESETLOGS option for database open


    SQL> exit
    Disconnected from Oracle Database 11g Express Edition Release 11.2.0.2.0 - Produ
    ction

    C:\Windows\System32>

    Thanks.

    -Zack_Falcon
  • 21. Re: Newbie on running Oracle 11g - Windows cannot find http:something
    966080 Newbie
    Currently Being Moderated
    Well, I've reinstalled the database, to the instructions of my boss. Sad to say, opening the "Get Started with Oracle" shortcut still yields me an error message:

    "Google Chrome could not connect to 127.0.0.1:8080"

    Maybe I'm over-thinking things? Do I need to manually open the 8080 port, or something? Or perhaps Internet Explorer is required for the browser thing?
  • 22. Re: Newbie on running Oracle 11g - Windows cannot find http:something
    orafad Oracle ACE
    Currently Being Moderated
    Was the root cause, that caused installation or instance to fail in the first place, fixed or even identified?

    Before jumping away at trying to open a web app (Get Started), please re-verify the basic pieces.
    I.e. is the instance running, with database opened? Does the listener have database services registered?

    sqlplus / as sysdba

    (exit from sqlplus)

    lsnrctl stat

    Please post result of above commands. Also verify that log files in config\log\ dir are free of errors.
  • 23. Re: Newbie on running Oracle 11g - Windows cannot find http:something
    966080 Newbie
    Currently Being Moderated
    Here's the results of the commands

    sqlplus / as sysdba

    C:\Windows\System32>sqlplus / as sysdba

    SQL*Plus: Release 11.2.0.2.0 Production on Tue Oct 16 10:10:14 2012

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


    Connected to:
    Oracle Database 11g Express Edition Release 11.2.0.2.0 - Production

    SQL> exit
    Disconnected from Oracle Database 11g Express Edition Release 11.2.0.2.0 - Produ
    ction


    lsnrctl stat

    C:\Windows\System32>lsnrctl stat

    LSNRCTL for 32-bit Windows: Version 11.2.0.2.0 - Production on 16-OCT-2012 10:11
    :09

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

    Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
    STATUS of the LISTENER
    ------------------------
    Alias LISTENER
    Version TNSLSNR for 32-bit Windows: Version 11.2.0.2.0 - Produ
    ction
    Start Date 16-OCT-2012 09:24:22
    Uptime 0 days 0 hr. 46 min. 49 sec
    Trace Level off
    Security ON: Local OS Authentication
    SNMP OFF
    Default Service XE
    Listener Parameter File C:\oraclexe\app\oracle\product\11.2.0\server\network\a
    dmin\listener.ora
    Listener Log File C:\oraclexe\app\oracle\diag\tnslsnr\arnold-PC\listener
    \alert\log.xml
    Listening Endpoints Summary...
    (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1ipc)))
    (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=arnold-PC)(PORT=1521)))
    Services Summary...
    Service "CLRExtProc" has 1 instance(s).
    Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service...
    Service "PLSExtProc" has 1 instance(s).
    Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
    Service "xe" has 1 instance(s).
    Instance "xe", status READY, has 1 handler(s) for this service...
    The command completed successfully

    C:\Windows\System32>

    Thanks.

    -Zack_Falcon
  • 24. Re: Newbie on running Oracle 11g - Windows cannot find http:something
    orafad Oracle ACE
    Currently Being Moderated
    zack_falcon wrote:
    Listening Endpoints Summary...
    No sign of a PORT=8080 entry among endpoints. So Get Started can't work.

    Do you have any anti-virus/malware or firewalls that could interfere with or block registration?


    If you still not see required enpoint, scince database now is up and running (from the Connected to: .. above) --

    Try the "script" I posted above.
    Go through this thread from the top and re-verify previous facts/behaviour of the system.
  • 25. Re: Newbie on running Oracle 11g - Windows cannot find http:something
    966080 Newbie
    Currently Being Moderated
    I tried the script, but I can't get past the login.

    I'm pretty sure the username I can use is sys, and the password is whatever I put in during the installation.

    Will anything change if I use sqlplus / as sysdba instead?

    C:\Windows\System32>sqlplus

    SQL*Plus: Release 11.2.0.2.0 Production on Wed Oct 17 09:35:36 2012

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

    Enter user-name: sys
    Enter password:
    ERROR:
    ORA-01033: ORACLE initialization or shutdown in progress
    Process ID: 0
    Session ID: 0 Serial number: 0

    -Zack_Falcon
  • 26. Re: Newbie on running Oracle 11g - Windows cannot find http:something
    orafad Oracle ACE
    Currently Being Moderated
    zack_falcon wrote:

    C:\Windows\System32>sqlplus

    SQL*Plus: Release 11.2.0.2.0 Production on Wed Oct 17 09:35:36 2012

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

    Enter user-name: sys
    Enter password:
    ERROR:
    ORA-01033: ORACLE initialization or shutdown in progress
    Process ID: 0
    Session ID: 0 Serial number: 0
    In your previous post, right after re-install, it said:
    Connected to:
    Oracle Database 11g Express Edition Release 11.2.0.2.0 - Production
    What response do you see now from sqlplus / as sysdba?


    What happened in between, what have changed? (e.g. did you try any of the XE start menu items)

    That the instance does not keep running, as it seems from here, needs to be resolved.
  • 27. Re: Newbie on running Oracle 11g - Windows cannot find http:something
    1009096 Newbie
    Currently Being Moderated
    You need a listener on port 8080 to know it needs to do something, and your machine needs to know 127.0.0.1 is localhost!

    I had the same exact problem listed here, and went through all the steps, none of which solved the problem. I searched other forums for an answer as well. The guidance offered for setting the hosts file in
    C:\Windows\System32\drivers\etc\hosts was incorrect. The line to add should be
    127.0.0.1 localhost

    NOT
    127.0.0.1 localhost yourPCname or in Udo's example for Arnold
    127.0.0.1 localhost arnold-PC

    Once the host file was fixed, Get_Started worked without an issue.

    I would also like to suggest restarting your machine after you perform the install even though the install said everything is running. Minimally after a restart, the %HTTPPORT% environment variable will be in affect at that point so you will no longer need to edit the properties of Get_Started. Check your services (Start > Control Panel > System and Security > Administrative Tools > Services ) and make sure the two Oracle services -- OracleServiceXE, OracleXETNSListener -- are started. Check any security agent running on your machine to make sure the agent is not preventing Oracle programs from running (Cisco Security Agent kept on shutting down these services) until I 'trusted' the untrusted program. Make sure your firewall allows the ports too!

    orafad had it write when he noticed that 8080 was not listening. You should see
    Listening Endpoints Summary...
    (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1ipc)))
    (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=_yourPCname_)(PORT=1521)))

    (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=_yourPCname_)(PORT=8080))(
    Presentation=HTTP)(Session=RAW))
    Services Summary...

    when you execute lsnrctl stat (_yourPCname_ should have the name of your pc)

    And thank you, everyone, who takes the time out to answer these questions.
    Jim
  • 28. Re: Newbie on running Oracle 11g - Windows cannot find http:something
    998751 Newbie
    Currently Being Moderated

    oracle 11g installation refer this for windows 764 bit http://blog.mclaughlinsoftware.com/2011/09/13/oracle-11g-xe-install/

     

    Enter user-name: sys

    Enter password:

    ERROR:

    ORA-01033: ORACLE initialization or shutdown in progress

    Process ID: 0

    Session ID: 0 Serial number: 0


    In my case issue was user permission and windows event log services was not running up.


    Try to restart windows log event services ,if u get error 4201 follow this  http://answers.microsoft.com/en-us/windows/forum/windows_7-performance/cannot-start-windows-event-log-service-on-windows…

  • 29. Re: Newbie on running Oracle 11g - Windows cannot find http:something
    clcarter Expert
    Currently Being Moderated

    Verify the networking setup on the host.

     

    The listener needs a valid hostname it its configuration, or a valid IPv4 address. If the host network setup is not quite correct, apex will also be not quite correct, and  not exactly working. So take a look at the listener endpoints, in a command box:

     

    lsnrctl status

    ...

    endpoints...

    ...port=1521...

    ...port=8080...presentation=http ...

     

    If the port=8080 entry is missing from the endpoints, the apex web pages will not work. Usually its caused by a less than 100% correct network configuration on the host.

     

    One easy fix is stopping the listener and rename the listener.ora file, restart the listener, and try again.

1 2 Previous Next

Legend

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