Results 1 to 6 of 6
  1. #1
    Join Date
    Apr 2013
    Posts
    5

    Unanswered: Unable to access Oracle Database Express Edtion homepage after instalation

    Hello,

    I've installed Oracle Database Express Edtion in a machine running windows vista, the application was successfully installed but when I try to access http://127.0.0.1:8080/apex, the webpage is not available.

    When I try to connect to sqlplus with sysadmin I get the error: ORA-12638: Credential retrieval failed.

    tnsping to localhost using IP or machine name returns OK.

    Bellow there are the results of commands lsnrctl status and lsnrctl service.

    Anyone could help?
    Thank you

    -> Resut of executing command: lsnrctl status

    LSNRCTL for 32-bit Windows: Version 10.2.0.1.0 - Production on 03-ABR-2013 01:10
    :29

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

    Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC_F OR_XE)))
    STATUS of the LISTENER
    ------------------------
    Alias LISTENER
    Version TNSLSNR for 32-bit Windows: Version 10.2.0.1.0 - Produ
    ction
    Start Date 02-ABR-2013 23:24:01
    Uptime 0 days 1 hr. 46 min. 28 sec
    Trace Level off
    Security ON: Local OS Authentication
    SNMP OFF
    Default Service XE
    Listener Parameter File C:\oraclexe\app\oracle\product\10.2.0\server\netwo rk\a
    dmin\listener.ora
    Listener Log File C:\oraclexe\app\oracle\product\10.2.0\server\netwo rk\l
    og\listener.log
    Listening Endpoints Summary...
    (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\ pipe\EXTPROC_FOR_XEipc)))
    (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=SONIAPC. faleixo.local)(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

    -> Result of executing the command: lsnrctl service

    LSNRCTL for 32-bit Windows: Version 10.2.0.1.0 - Production on 03-ABR-2013 01:13
    :57

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

    Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC_F OR_XE)))
    Services Summary...
    Service "CLRExtProc" has 1 instance(s).
    Instance "CLRExtProc", status UNKNOWN, has 3 handler(s) for this service...
    Handler(s):
    "DEDICATED" established:0 refused:0
    LOCAL SERVER
    "ORACLE SERVER" established:0 refused:0 current:0 max:25 state:ready
    CLRExtProc
    (ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\NTN_13E8 _C7B15878.ORA))
    "ORACLE SERVER" established:0 refused:0 current:0 max:25 state:ready
    CLRExtProc
    (ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\NTN_13E8 _C7B15878.ORA))
    Service "PLSExtProc" has 1 instance(s).
    Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
    Handler(s):
    "DEDICATED" established:0 refused:0
    LOCAL SERVER
    The command completed successfully

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    I have never seen anything like you posted above; which includes "LOCAL SERVER".

    I have never seen a SERVICE_NAME that is enclosed in double quote marks & includes a space character like "ORACLE SERVER"

    open Command Window & do as below

    lsnrctl stop
    cd C:\oraclexe\app\oracle\product\10.2.0\server\netwo rk\admin\
    ren listener.ora listener.ora.sav
    lsnrctl start
    # wait 60+ seconds before proceeding
    lsnrctl status
    lsnrctl service

    COPY the results from above then PASTE all back here
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    Apr 2013
    Posts
    5
    Thank you for your reply. I am a rooky in this area and my only experience with oracle is using oracle express edition.

    I was not able to execute lsnrctl stop in command line because I got the error:
    TNS-01190: The user is not authorized to execute the requested listener command.

    However I was able to stop/start the service OracleXETNSListener in services window. I think this is the same?

    Bellow there is the result of the commands after rename the listener to listener.ora.sav

    C:\>lsnrctl status

    LSNRCTL for 32-bit Windows: Version 10.2.0.1.0 - Production on 04-ABR-2013 23:09
    :43

    Copyright (c) 1991, 2005, 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 10.2.0.1.0 - Produ
    ction
    Start Date 04-ABR-2013 22:53:06
    Uptime 0 days 0 hr. 16 min. 37 sec
    Trace Level off
    Security ON: Local OS Authentication
    SNMP OFF
    Listener Log File C:\oraclexe\app\oracle\product\10.2.0\server\netwo rk\l
    og\listener.log
    Listening Endpoints Summary...
    (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=SONIAPC. faleixo.local)(PORT=1521)))
    The listener supports no services
    The command completed successfully

    C:\> lsnrctl service

    LSNRCTL for 32-bit Windows: Version 10.2.0.1.0 - Production on 04-ABR-2013 23:09
    :57

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

    Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
    The listener supports no services
    The command completed successfully

    Any help?

  4. #4
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >The listener supports no services
    Most common reason for the line above is because the database is down & needs to be started.

    open Command Window & do EXACTLTY as below

    sqlplus
    / as sysdba
    startup
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  5. #5
    Join Date
    Apr 2013
    Posts
    5
    Thanks again for your reply, the problem is that I cannot connect to sqlplus...
    I executed the commands exactly as you indicated and tried to connect sqlplus using the system credentials I have defined when installing oracle application express.
    See details bellow:

    C:\>sqlplus / as sysdba

    SQL*Plus: Release 10.2.0.1.0 - Production on Sex Abr 5 01:03:40 2013

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

    ERROR:
    ORA-12638: Credential retrieval failed


    Enter user-name: system
    Enter password:
    ERROR:
    ORA-12638: Credential retrieval failed


    Enter user-name: system
    Enter password:
    ERROR:
    ORA-12638: Credential retrieval failed


    SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus

  6. #6
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    you need to be logged on to the Operating System as the same OS user who own Oracle software files before invoking sqlplus.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •