13 Replies Latest reply: Oct 15, 2012 5:51 PM by orafad RSS

    Cant connect to http://127.0.0.1:8080/apex/f?p=4950

    968167
      Sorry guys for posting such Thread. I searched in forum , tried everything I read but still cant fix it. Please help.


      I am trying to install Oracle Database 11g Express Edition and APEX. First I got an error cause I needed .Net Framework over v3.5 , so I uninstalled Oracle, upgraded Framework and installed it again..

      I am trying to open http://127.0.0.1:8080/apex/f?p=4950 but it says "Unable to connect"

      In services I have started OracleMTSRecoveryService, OracleServiceXE, OracleXEClrAgent and OracleXETNListener.

      I can run SQL Command line but havent set username and password , so I cant do anything there.

      Could anyone help me please ?

      regards
        • 1. Re: Cant connect to http://127.0.0.1:8080/apex/f?p=4950
          orafad
          To verify the ground work first, try the following and post complete (copy-paste) output of command session:

          lsnrctl stat

          sqlplus / as sysdba
          • 2. Re: Cant connect to http://127.0.0.1:8080/apex/f?p=4950
            968167
            im not sure what is my username.. the default should be sys or system, right ? I am using the password, that I used for the installation :



            C:\Documents and Settings\Admin>lsnrctl stat

            LSNRCTL for 32-bit Windows: Version 11.2.0.2.0 - Production on 13-╬╩╥. -2012 23:
            02:10

            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 13-╬╩╥. -2012 21:45:20
            Uptime 0 days 1 hr. 16 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\asus-pc\listener\a
            lert\log.xml
            Listening Endpoints Summary...
            (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1ipc)))
            (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=asus-pc)(PORT=1521)))
            Services Summary...
            Service "CLRExtProc" has 1 instance(s).
            Instance "CLRExtProc", status UNKNOWN, has 3 handler(s) for this service...
            Service "PLSExtProc" has 1 instance(s).
            Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
            The command completed successfully

            C:\Documents and Settings\Admin>sqlplus / as sysdba

            SQL*Plus: Release 11.2.0.2.0 Production on ╤с ╬ъЄ. 13 23:02:21 2012

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

            ERROR:
            ORA-12560: TNS:protocol adapter error


            Enter user-name: system
            Enter password:
            ERROR:
            ORA-12560: TNS:protocol adapter error


            Enter user-name: sys
            Enter password:
            ERROR:
            ORA-12560: TNS:protocol adapter error


            SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus
            • 3. Re: Cant connect to http://127.0.0.1:8080/apex/f?p=4950
              orafad
              965164 wrote:

              C:\Documents and Settings\Admin>sqlplus / as sysdba

              SQL*Plus: Release 11.2.0.2.0 Production on ╤с ╬ъЄ. 13 23:02:21 2012

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

              ERROR:
              ORA-12560: TNS:protocol adapter error
              On Win platforms, this usually indicates that OracleService<sid> is not started.

              As elevated admin, open a command window and issue:

              net start oracleservicexe


              If start via service succeeds, verify database service registration via lsnrctl stat. Look at endpoints and services summaries.
              • 4. Re: Cant connect to http://127.0.0.1:8080/apex/f?p=4950
                968167
                Thanks for your help but still cant open http://127.0.0.1:8080/apex/f?p=4950



                C:\Documents and Settings\Admin>net start oracleservicexe
                The OracleServiceXE service is starting.....
                The OracleServiceXE service was started successfully.


                C:\Documents and Settings\Admin>lsnrctl stat

                LSNRCTL for 32-bit Windows: Version 11.2.0.2.0 - Production on 14-╬╩╥. -2012 18:09:45 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 - Production Start Date 14-╬╩╥. -2012 09:01:18 Uptime 0 days 9 hr. 8 min. 38 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\admin\listener.ora Listener Log File C:\oraclexe\app\oracle\diag\tnslsnr\asus-pc\listener\alert\log.xml Listening Endpoints Summary... (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1ipc))) (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=asus-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...
                The command completed successfully
                • 5. Re: Cant connect to http://127.0.0.1:8080/apex/f?p=4950
                  orafad
                  Basic building blocks first, then worry about the web application (Getting Started page).


                  After win service was "started successfully", did you try another sysdba connection?

                  sqlplus / as sysdba


                  I'm having a hard time reading that lsnrctl output posted above, but it seems database instance was not able to register its services.

                  Stop listener (OracleXETNSListener).
                  Rename listener.ora, the one mentioned as Listener Parameter file, to, say, listener.ora_moved.
                  Start listener.
                  Wait at least one minute.
                  Post another copy-paste of lsnrctl stat command.
                  • 6. Re: Cant connect to http://127.0.0.1:8080/apex/f?p=4950
                    968167
                    C:\Documents and Settings\Admin>lsnrctl stat

                    LSNRCTL for 32-bit Windows: Version 11.2.0.2.0 - Production on 14-╬╩╥. -2012 21:
                    36:07

                    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 14-╬╩╥. -2012 21:34:26
                    Uptime 0 days 0 hr. 1 min. 42 sec
                    Trace Level off
                    Security ON: Local OS Authentication
                    SNMP OFF
                    Listener Log File C:\oraclexe\app\oracle\diag\tnslsnr\asus-pc\listener\a
                    lert\log.xml
                    Listening Endpoints Summary...
                    (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=asus-pc)(PORT=1521)))
                    The listener supports no services
                    The command completed successfully


                    When I tried sqlplus / as sysdba , after win service was "started successfully",

                    C:\Documents and Settings\Admin>sqlplus / as sysdba

                    SQL*Plus: Release 11.2.0.2.0 Production on ═ф ╬ъЄ. 14 21:33:12 2012

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

                    ERROR:
                    ORA-28056: Writing audit records to Windows Event Log failed
                    OSD-00512: Message 512 not found; product=RDBMS; facility=SOSD
                    O/S-Error: (OS 1502) The event log file is full.
                    ORA-28056: Writing audit records to Windows Event Log failed
                    OSD-00512: Message 512 not found; product=RDBMS; facility=SOSD
                    O/S-Error: (OS 1502) The event log file is full.


                    Enter user-name: sys
                    Enter password:
                    ERROR:
                    ORA-01034: ORACLE not available
                    ORA-27101: shared memory realm does not exist
                    Process ID: 0
                    Session ID: 0 Serial number: 0
                    • 7. Re: Cant connect to http://127.0.0.1:8080/apex/f?p=4950
                      orafad
                      965164 wrote:
                      ORA-28056: Writing audit records to Windows Event Log failed
                      O/S-Error: (OS 1502) The event log file is full.
                      Make sure there is room in relevant event log (.g. remove unwanted entries), then re-try starting the database instance.

                      Is some of the previous cases/threads where event log full error was discovered, it was found having caused a failed install.
                      So maybe a re-install of XE is in order after tidying up the Windows event log (you could check log files at <oracle home dir>\config\log\ for clues).
                      • 8. Re: Cant connect to http://127.0.0.1:8080/apex/f?p=4950
                        968167
                        cleared the log in Event Viewer

                        re-installed...and still cant get into Getting Started


                        C:\Documents and Settings\Admin>sqlplus / as sysdba

                        SQL*Plus: Release 11.2.0.2.0 Production on ═ф ╬ъЄ. 14 22:44:11 2012

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

                        ERROR:
                        ORA-28056: Writing audit records to Windows Event Log failed
                        ORA-28056: Writing audit records to Windows Event Log failed


                        Enter user-name: sys
                        Enter password:
                        ERROR:
                        ORA-01089: immediate shutdown in progress - no operations are permitted
                        Process ID: 0
                        Session ID: 0 Serial number: 0
                        • 9. Re: Cant connect to http://127.0.0.1:8080/apex/f?p=4950
                          orafad
                          965164 wrote:
                          cleared the log in Event Viewer
                          Which one? (there is at least three or four Windows logs)

                          Maybe you could clear them all just to be sure.

                          ORA-28056: Writing audit records to Windows Event Log failed
                          It seems there is still some issue with Event log.


                          What errors, if any, do you have in log files in config\log? (xe.bat.log, clone*.log, etc.)
                          • 10. Re: Cant connect to http://127.0.0.1:8080/apex/f?p=4950
                            968167
                            Didnt know they were 4.. I had cleared only the System log, after clearing the rest of them

                            C:\Documents and Settings\Admin>sqlplus / as sysdba

                            SQL*Plus: Release 11.2.0.2.0 Production on ╧э ╬ъЄ. 15 00:07:07 2012

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

                            Connected.
                            SQL>


                            doesnt require to write username/password


                            Xe.bat.log just that - Instance created.

                            Clonedbcreation. log :

                            SQL> Create controlfile reuse set database "XE"
                            2 MAXINSTANCES 8
                            3 MAXLOGHISTORY 1
                            4 MAXLOGFILES 16
                            5 MAXLOGMEMBERS 3
                            6 MAXDATAFILES 100
                            7 Datafile
                            8 'C:\oraclexe\app\oracle\oradata\XE\system.dbf',
                            9 'C:\oraclexe\app\oracle\oradata\XE\undotbs1.dbf',
                            10 'C:\oraclexe\app\oracle\oradata\XE\sysaux.dbf',
                            11 'C:\oraclexe\app\oracle\oradata\XE\users.dbf'
                            12 LOGFILE
                            13 GROUP 1 SIZE 51200K,
                            14 GROUP 2 SIZE 51200K,
                            15 RESETLOGS;
                            SP2-0640: Not connected
                            SQL> exec dbms_backup_restore.zerodbid(0);
                            SP2-0640: Not connected
                            SP2-0641: "EXECUTE" requires connection to server
                            SQL> shutdown immediate;
                            SP2-0640: Not connected
                            Database closed.
                            SP2-0640: Not connected
                            Database dismounted.
                            ORA-28056: Writing audit records to Windows Event Log failed
                            OSD-227211992: Message 227211992 not found; product=RDBMS; facility=SOSD

                            O/S-Error: (OS 1502) The event log file is full.
                            SQL> startup nomount pfile="C:\oraclexe\app\oracle\product\11.2.0\server\config\scripts\initXETemp.ora";
                            ORA-01081: cannot start already-running ORACLE - shut it down first
                            SQL> Create controlfile reuse set database "XE"
                            2 MAXINSTANCES 8
                            3 MAXLOGHISTORY 1
                            4 MAXLOGFILES 16
                            5 MAXLOGMEMBERS 3
                            6 MAXDATAFILES 100
                            7 Datafile
                            8 'C:\oraclexe\app\oracle\oradata\XE\system.dbf',
                            9 'C:\oraclexe\app\oracle\oradata\XE\undotbs1.dbf',
                            10 'C:\oraclexe\app\oracle\oradata\XE\sysaux.dbf',
                            11 'C:\oraclexe\app\oracle\oradata\XE\users.dbf'
                            12 LOGFILE
                            13 GROUP 1 SIZE 51200K,
                            14 GROUP 2 SIZE 51200K,
                            15 RESETLOGS;
                            SP2-0640: Not connected
                            SQL> alter system enable restricted session;
                            SP2-0640: Not connected
                            SQL> alter database "XE" open resetlogs;
                            SP2-0640: Not connected
                            SQL> alter database rename global_name to "XE";
                            SP2-0640: Not connected
                            SQL> alter system switch logfile;
                            SP2-0640: Not connected
                            SQL> alter system checkpoint;
                            SP2-0640: Not connected
                            SQL> alter database drop logfile group 3;
                            SP2-0640: Not connected
                            SQL> ALTER TABLESPACE TEMP ADD TEMPFILE 'C:\oraclexe\app\oracle\oradata\XE\temp.dbf' SIZE 20480K REUSE AUTOEXTEND ON NEXT 640K MAXSIZE UNLIMITED;
                            SP2-0640: Not connected
                            SQL> select tablespace_name from dba_tablespaces where tablespace_name='USERS';
                            SP2-0640: Not connected
                            SQL> select sid, program, serial#, username from v$session;
                            SP2-0640: Not connected
                            SQL> alter user sys identified by "&&sysPassword";
                            SP2-0640: Not connected
                            SQL> alter user system identified by "&&systemPassword";
                            SP2-0640: Not connected
                            SQL> alter system disable restricted session;
                            SP2-0640: Not connected
                            SQL> @C:\oraclexe\app\oracle\product\11.2.0\server\config\scripts\postScripts.sql
                            SQL> connect "SYS"/"&&sysPassword" as SYSDBA
                            ERROR:
                            ORA-28056: Writing audit records to Windows Event Log failed
                            OSD-227267640: Message 227267640 not found; product=RDBMS; facility=SOSD
                            O/S-Error: (OS 1502) The event log file is full.
                            ORA-28056: Writing audit records to Windows Event Log failed
                            OSD-227267640: Message 227267640 not found; product=RDBMS; facility=SOSD
                            O/S-Error: (OS 1502) The event log file is full.


                            SQL> set echo on
                            SQL> spool C:\oraclexe\app\oracle\product\11.2.0\server\config\log\postScripts.log



                            CloneRmanRestore.log :

                            SQL> startup nomount pfile="C:\oraclexe\app\oracle\product\11.2.0\server\config\scripts\init.ora";
                            ORA-28056: Writing audit records to Windows Event Log failed
                            OSD-120533328: Message 120533328 not found; product=RDBMS; facility=SOSD

                            O/S-Error: (OS 1502) The event log file is full.
                            SQL> @C:\oraclexe\app\oracle\product\11.2.0\server\config\scripts\rmanRestoreDatafiles.sql;
                            SQL> set echo off;
                            SP2-0640: Not connected
                            SP2-0640: Not connected
                            SP2-0640: Not connected
                            ERROR:
                            ORA-28056: Writing audit records to Windows Event Log failed
                            OSD-246073752: Message 246073752 not found; product=RDBMS; facility=SOSD
                            O/S-Error: (OS 1502) The event log file is full.
                            ORA-01075: you are currently logged on


                            SQL> spool C:\oraclexe\app\oracle\product\11.2.0\server\config\log\cloneDBCreation.log
                            • 11. Re: Cant connect to http://127.0.0.1:8080/apex/f?p=4950
                              orafad
                              965164 wrote:
                              Didnt know they were 4.. I had cleared only the System log, after clearing the rest of them
                              SQL> Create controlfile reuse set database "XE"
                              ...
                              ORA-28056: Writing audit records to Windows Event Log failed
                              O/S-Error: (OS 1502) The event log file is full.
                              Perhaps another re-install could succeed now that all logs are cleared. Third time's a charm...
                              • 12. Re: Cant connect to http://127.0.0.1:8080/apex/f?p=4950
                                968167
                                thank you !!!

                                it works now
                                • 13. Re: Cant connect to http://127.0.0.1:8080/apex/f?p=4950
                                  orafad
                                  Great!

                                  Now you could install Oracle SQL Developer (currently v3.2) and start messin around ;)

                                  http://www.oracle.com/technetwork/developer-tools/sql-developer/overview/index.html

                                  And maybe even plan for an upgrade to just released APEX 4.2!

                                  Docs:
                                  http://tahiti.oracle.com/

                                  Edited by: orafad on Oct 16, 2012 12:50 AM