1 2 Previous Next 29 Replies Latest reply: Jun 10, 2013 12:47 PM by clcarter Go to original post RSS
      • 15. Re: Newbie on running Oracle 11g - Windows cannot find http:something
        orafad
        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
          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
            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
              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
                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
                  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
                    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
                      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
                        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
                          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
                            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
                              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
                                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

                                  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

                                    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