This discussion is archived
13 Replies Latest reply: Oct 15, 2012 3:51 PM by orafad RSS

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

968167 Newbie
Currently Being Moderated
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 Oracle ACE
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Oracle ACE
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Oracle ACE
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Oracle ACE
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Oracle ACE
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Oracle ACE
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    thank you !!!

    it works now
  • 13. Re: Cant connect to http://127.0.0.1:8080/apex/f?p=4950
    orafad Oracle ACE
    Currently Being Moderated
    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

Legend

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