Results 1 to 8 of 8
  1. #1
    Join Date
    Oct 2011
    Posts
    18

    Unanswered: Oracle Express instance blocked

    Hi, I just downloaded Oracle 11g Express Edition and installed it on my Windows 7 64-bit PC. Went through the same process to do the installation which went by mostly fine.
    Step-by-step Install of Oracle 11g XE

    But when I tried to run the Get Started thingy, it started my browser looking for the following address but wasn't able to load any pages.
    http://127.0.0.1:8080/apex/f?p=4950

    So looking at the following article I did the update on my host file and re-installed it but still failed.
    Install Oracle 11gR2 on Windows

    I searched around and found the lsnrctl command to use and produced the following output. What does "Instance "xe", status BLOCKED" mean? In fact before I did the host file change, it would say it's UNKNOWN like the other two.

    Also what are CLRExtProc and PLSExtProc for anyway?

    Code:
    C:\Users\Michael>lsnrctl stat
    
    LSNRCTL for 64-bit Windows: Version 11.2.0.2.0 - Production on 06-AUG-2014 02:28:06
    
    Copyright (c) 1991, 2014, Oracle.  All rights reserved.
    
    Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
    STATUS of the LISTENER
    ------------------------
    Alias                     LISTENER
    Version                   TNSLSNR for 64-bit Windows: Version 11.2.0.2.0 - Production
    Start Date                06-AUG-2014 02:21:23
    Uptime                    0 days 0 hr. 6 min. 43 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\Michael-Desktop\listener\alert\log.xml
    Listening Endpoints Summary...
      (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1ipc)))
      (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=Michael-Desktop)(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 BLOCKED, has 1 handler(s) for this service...
    The command completed successfully

  2. #2
    Join Date
    Oct 2011
    Posts
    18
    Just an update on this. I have disabled Windows UAC as instructed on the blog, un-installed Oracle Express, rebooted, and re-installed Oracle Express. When I tried to use the Get Started thing, it's still giving me an error.

    But when I issued the lsnrctl command again it's indicating both XEXDB and xe are in READY states!

    So question:
    1) What are the differences between CLRExtProc, PLSExtProc, XE, and XEXDB?
    2) Why all of a sudden there is an extra XEXDB?
    3) Why is it such a pain to install the database where by I must setup the host file for localhost and disable UAC? Am I supposed to run without UAC for the rest of time?
    4) For some reasons I'm able to connect to XE via SQL Developer when I specify SID = XE or Service Name = XE. But for XEXDB it only works when I specify Service Name = XEXDB. If I specify SID = XEXDB it'd say the TNSListener doesn't currently know of SID given in connect descriptor. Why the two have different setup?
    5) For some reasons I'm unable to run the grant statement after creating the user chris when following the tutorial below in SQL Developer. I'm able to do the same however from SQL Plus.
    http://docs.oracle.com/cd/E17781_01/...c.htm#XEGSG111

    Code:
    C:\Users\Michael>lsnrctl stat
    
    LSNRCTL for 64-bit Windows: Version 11.2.0.2.0 - Production on 07-AUG-2014 00:41:39
    
    Copyright (c) 1991, 2014, Oracle.  All rights reserved.
    
    Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
    STATUS of the LISTENER
    ------------------------
    Alias                     LISTENER
    Version                   TNSLSNR for 64-bit Windows: Version 11.2.0.2.0 - Production
    Start Date                07-AUG-2014 00:27:39
    Uptime                    0 days 0 hr. 14 min. 0 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\Michael-Desktop\listener\alert\log.xml
    Listening Endpoints Summary...
      (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1ipc)))
      (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=Michael-Desktop)(PORT=1521)))
      (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=Michael-Desktop)(PORT=8080))(Presentation=HTTP)(Session=RAW))
    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 "XEXDB" has 1 instance(s).
      Instance "xe", status READY, 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
    Last edited by grob115; 08-06-14 at 14:21.

  3. #3
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    consider that listener.ora file is NOT required to start or use Oracle listener.
    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.

  4. #4
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    So: Get Started link opens your browser with the following address:

    http://127.0.0.1:8080/apex/f?p=4950

    but the page ... what? Remains empty? Displays an error? If so, which one is it?

    As you can connect to the database, do the following and copy/paste the whole session over here:
    Code:
    SQLPLUS /NOLOG
    CONNECT SYS AS SYSDBA
    
    SELECT DBMS_XDB.GETHTTPPORT FROM DUAL;
    What did this SELECT return? If the result was 0 (zero), it means that server is disabled so you have to enable it by issuing
    Code:
    EXEC DBMS_XDB.SETHTTPPORT(8080);
    at the SQL*Plus prompt.

    Any improvement?
    Last edited by Littlefoot; 08-07-14 at 04:52.

  5. #5
    Join Date
    Oct 2011
    Posts
    18
    Hi there thanks for the replies. I'm not sure what I did but I'm able to see the web page now. I did try to execute that command and it's returning port 8080.

    One thing I'm not understanding is when the following asks for the password, it accepts both "system" and the password I specified during the install process. Any clues? Is this a bug?
    Code:
    SQL> connect as sysdba
    Enter user-name: system
    Enter password:
    Connected.

  6. #6
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    to make a long story short, I expect DB will accept any string for the password
    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.

  7. #7
    Join Date
    Oct 2011
    Posts
    18
    Quote Originally Posted by anacedent View Post
    to make a long story short, I expect DB will accept any string for the password
    This doesn't make sense. How can this be the case? Besides, what is the purpose of asking for that password for user SYS and SYSTEM during installation?

  8. #8
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    When you are logged onto the Operating System and a member of a specific OS group (ORA_DBA), then Oracle uses OS authentication to allow access "as sysdba".

    It essentially is a "backdoor" into the database which requires physical access to the DB Server.

    The actual password for SYS is required for anyone not in the ORA_DBA group.
    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.

Posting Permissions

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