9 Replies Latest reply: Apr 11, 2013 4:52 AM by orafad RSS

    I Have Problem with Oracle Database 11g Express Edition

    992125
      Hi,
      I have a problem with Oracle Database 11g Express Edition. After installing it and whenever I click the "getting started" icon, I get the following error:
      Can't connect to 127.0.0.1:8080

      Note that the URL is: http://127.0.0.1:8080/apex/f?p=4950

      I have windows 7 Home Premium Service Pack 1
      The system type is 64-bit OS

      -------------------------------------
      The output of the command : lsnrctl stat
      is below
      ----------------------------------
      Microsoft Windows [Version 6.1.7601]
      Copyright (c) 2009 Microsoft Corporation. All rights reserved.

      C:\Users\AAA> lsnrctl stat

      LSNRCTL for 32-bit Windows: Version 11.2.0.2.0 - Production on 20-FEB-2013 01:54
      :12

      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 19-FEB-2013 14:42:32
      Uptime 0 days 11 hr. 11 min. 48 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\Abdulmajeed-PC2\li
      stener\alert\log.xml
      Listening Endpoints Summary...
      (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1ipc)))
      (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=Abdulmajeed-PC2)(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
      -------------------------

      Need help

      Thanks

      Edited by: 989122 on Feb 19, 2013 11:07 PM
        • 1. Re: I Have Problem with Oracle Database 11g Express Edition
          Udo
          Hi, and welcome to the OTN forums!

          First, please note that XE is not supported on any Windows 64bit release yet. So it is likely, that some parts of your installation didn't work as expected.
          The issue you encounter is very common and you'll find tons of posts with lots of useful hints.
          I recommend you to check your installation logs, the state of your firewall, and possibly the health of your database (though it seems the database is up).
          For the latter, please execute
          sqlplus / as sysdba
          -Udo
          • 2. Re: I Have Problem with Oracle Database 11g Express Edition
            992125
            I'm a student. So I have very basic info about DBs. It worked with some of my friends in class even though they have the same OS. I have checked many posts and that is how I come up with the command listen. But it is not working yet :(
            Here is the output of the command sqlplus / as sysdba

            -----------------------------------------------------
            C:\Users\AAA>sqlplus / as sysdba

            SQL*Plus: Release 11.2.0.2.0 Production on Wed Feb 20 02:59:32 2013

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

            ERROR:
            ORA-12560: TNS:protocol adapter error


            Enter user-name:
            --------------------------------------------------
            • 3. Re: I Have Problem with Oracle Database 11g Express Edition
              clcarter
              The ora-12560 indicates two possible problems.

              1) The Windows service for the database is not running.

              Run the services applet (Start/Run/services.msc) and make sure the OracleServiceXE service shows Running. There are four or five oracle entries, only the ...ServiceXE and ...XETNSListener ones are relevant in an XE install. For the Windows OS, services not running are a frequent cause of that particular error. Fairly certain services.msc works for win7 as it does for WinXP.

              Another symptom of the service not running ... you won't be able to connect to the database without using a sysdba connection, because the database instance is down.

              2) The registry settings for the client are not correct.

              If the registry settings are incorrect or absent, that is not an easy fix. Try the sqlplus in a command box started with the "run as Administrator" privilege and that might fix the registry problem, if there is one.

              Also verify your windows user is a member of the ORA_DBA group. Other errors, like a '... access denied' can occur with the connect / attempt, but you'll have to get past the -12560 error first. In the command box:
              net localgroups ora_dba
              ...
              user1
              user2 ...
              NT Authority\SYSTEM
              • 4. Re: I Have Problem with Oracle Database 11g Express Edition
                992125
                I checked the services and I found only one service that start with Oracle. It is OracleXETNSListener, and it is started!
                Does that mean that I have a problem with the installation?
                • 5. Re: I Have Problem with Oracle Database 11g Express Edition
                  clcarter
                  a problem with the installation?
                  Yes. It will require an uninstall, per the steps in the XE documentation, see http://docs.oracle.com/cd/E17781_01/install.112/e18803/toc.htm#CIHDDHJD

                  With win x64, as mentioned by others there is no XE installer for the 64 bit OS.

                  It might succeed by setting up an Administrator command box and running the installer from there. Note the Requirements section in the Windows install guide shows "System architecture Intel (x86)". So it might work, but the installer was not meant for x64.

                  And note the requirement for membership in the Administrators group in Windows, I think a Start/Run/lusrmgr.msc works for Win7 same as for XP to get to the local users and groups applet- check the admin group in the applet. Or try the net command, I'm not positive win7 works same-same or almost same as XP ...
                  net localgroup administrators
                  Administrators
                  <domain>\<user1>
                  <user2>
                  ...
                  • 6. Re: I Have Problem with Oracle Database 11g Express Edition
                    993029
                    Windows XP. I can't use UTL_FILE package. Statment "DECLARE descrip UTL_FILE.TYPE;" -> compile ->error:
                    PLS-00201 UTL_FILE must be declared.
                    • 7. Re: I Have Problem with Oracle Database 11g Express Edition
                      clcarter
                      PLS-00201 UTL_FILE must be declared.
                      The utl_file is an older package, 11g uses directories to accomplish what used to require the utl_file utilities.

                      Please start a new question and post as much detail on what you're trying to accomplish. Could be what ever package/stored procedure you're running expects execute rights for the utility, might be fixed with a sysdba connection and `grant execute on utl_file to <user>;`.

                      But then again, depends on what you want to do. The full 11g docs can also be helpful, see http://docs.oracle.com/cd/E11882_01/win.112/e10845/apps.htm#sthref741
                      • 8. Re: I Have Problem with Oracle Database 11g Express Edition
                        1002415
                        11g docs are not helpul. not at all. completely disagree.

                        1.- sqlplus connect user/pwd
                        2.- grant execute on utl_file to user;

                        access appears to be granted but still unable to use utl_file!
                        • 9. Re: I Have Problem with Oracle Database 11g Express Edition
                          orafad
                          Welcome to the forums!

                          Please start a new thread for your specific issue. As you should see, this thread is about a problem accessing XE homme page via "getting started" icon.

                          When you do, please describe your specific issue carefully. E.g "unable to use" is likely not a real error message. Also include full version number ("11g" is just a marketing label and useless here).

                          Docs may take some time to learn how to navigate, and so on, but they are necessary and very useful for perhaps 99% of common Oracle related activities.

                          Edited by: orafad on Apr 11, 2013 11:52 AM