Oracle-XE

christooss · 2008-12-02 03:19:20

1. I have installed oracle xe with PKGBUILD
2. I have added my user to dba
3. I can connect to sqlplus sys as sysdba so database is running

But.. I cannot connect to localhost:8080/apex

Any ideas?

/etc/rc.d/oracle-xe status is returning this:

LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 02-DEC-2008 04:18:46
Copyright (c) 1991, 2005, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC_FOR_XE)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 10.2.0.1.0 - Production
Start Date 02-DEC-2008 03:50:57
Uptime 0 days 0 hr. 27 min. 49 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Default Service XE
Listener Parameter File /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/network/admin/listener.ora
Listener Log File /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/network/log/listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC_FOR_XE)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=homer.local)(PORT=1521)))
Services Summary...
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...
Service "XE_XPT" has 1 instance(s).
Instance "XE", status BLOCKED, has 1 handler(s) for this service...
The command completed successfully

sebekk23 · 2010-07-21 07:31:57

Any errors during instalation/configuration ? I have

[root@myhost config]# sh /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/config/script_s/oraconfig.sh

Oracle Database 10g Express Edition Configuration
-------------------------------------------------
This will configure on-boot properties of Oracle Database 10g Express
Edition.  The following questions will determine whether the database should
be starting upon system boot, the ports it will use, and the passwords that
will be used for database accounts.  Press <Enter> to accept the defaults.
Ctrl-C will abort.

Specify the HTTP port that will be used for Oracle Application Express [8080]:

Specify a port that will be used for the database listener [1521]:


Specify your sga size [128M]:

Specify your pga size [96M]:
Specify a password to be used for database accounts.  Note that the same
password will be used for SYS and SYSTEM.  Oracle recommends the use of
different passwords for each database account.  This can be done after
initial configuration:
Confirm the password:
Starting Oracle Net Listener...
LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 20-JUL-2010 14:10:57

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

Starting /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 10.2.0.1.0 - Production
System parameter file is /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/network/admin/listener.ora
Log messages written to /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/network/log/listener.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC_FOR_XE)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost.localdomain)(PORT=1521)))

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC_FOR_XE)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 10.2.0.1.0 - Production
Start Date                20-JUL-2010 14:10:59
Uptime                    0 days 0 hr. 0 min. 0 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Default Service           XE
Listener Parameter File   /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/network/admin/listener.ora
Listener Log File         /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/network/log/listener.log
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC_FOR_XE)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost.localdomain)(PORT=1521)))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
  Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
Done
Configuring Database...ni ma...
ni ma...

ORACLE instance started.

Total System Global Area  134217728 bytes
Fixed Size            1257596 bytes
Variable Size           58724228 bytes
Database Buffers       71303168 bytes
Redo Buffers            2932736 bytes

TO_CHAR(SYSTIMEST
-----------------
20100720 02:11:02

Allocating device....
Specifying datafiles...
Specifing datafiles...
Restoring ...
Restoring ...2
declare
*
ERROR at line 1:
ORA-19624: operation failed, retry possible
ORA-19870: error reading backup piece
/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/config/xeseed.dfb
ORA-19502: write error on file "/usr/lib/oracle/xe/oradata/XE/sysaux.dbf",
blockno 41505 (blocksize=8192)
ORA-27072: File I/O error
Linux Error: 2: No such file or directory
Additional information: 4
Additional information: 41505
Additional information: 45056
ORA-06512: at "SYS.X$DBMS_BACKUP_RESTORE", line 5149
ORA-06512: at line 17



TO_CHAR(SYSTIMEST
-----------------
20100720 02:12:27

Create controlfile reuse set database "XE"
*
ERROR at line 1:
ORA-01503: CREATE CONTROLFILE failed
ORA-01565: error in identifying file '/usr/lib/oracle/xe/oradata/XE/system.dbf'
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3


BEGIN dbms_backup_restore.zerodbid(0); END;

*
ERROR at line 1:
ORA-00210: cannot open the specified control file
ORA-06512: at "SYS.X$DBMS_BACKUP_RESTORE", line 4168
ORA-06512: at line 1


ORA-01507: database not mounted


ORACLE instance shut down.
ORACLE instance started.

Total System Global Area  134217728 bytes
Fixed Size            1257596 bytes
Variable Size           58724228 bytes
Database Buffers       71303168 bytes
Redo Buffers            2932736 bytes
Create controlfile reuse set database "XE"
*
ERROR at line 1:
ORA-01503: CREATE CONTROLFILE failed
ORA-01565: error in identifying file '/usr/lib/oracle/xe/oradata/XE/system.dbf'
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3



System altered.

alter database "XE" open resetlogs
*
ERROR at line 1:
ORA-01507: database not mounted


alter database rename global_name to "XE"
                                     *
ERROR at line 1:
ORA-01109: database not open


alter system switch logfile
*
ERROR at line 1:
ORA-01109: database not open


alter system checkpoint
*
ERROR at line 1:
ORA-01109: database not open


alter database drop logfile group 3
*
ERROR at line 1:
ORA-01507: database not mounted


ALTER TABLESPACE TEMP ADD TEMPFILE '/usr/lib/oracle/xe/oradata/XE/temp.dbf' SIZE 20480K REUSE AUTOEXTEND ON NEXT 640K MAXSIZE UNLIMITED
*
ERROR at line 1:
ORA-01109: database not open


select tablespace_name from dba_tablespaces where tablespace_name='USERS'
                            *
ERROR at line 1:
ORA-01219: database not open: queries allowed on fixed tables/views only



       SID PROGRAM                           SERIAL#
---------- ------------------------------------------------ ----------
USERNAME
------------------------------
    49 oracle@myhost (PMON)                      1


    41 oracle@myhost (MMON)                      3


    42 oracle@myhost (RECO)                      1



       SID PROGRAM                           SERIAL#
---------- ------------------------------------------------ ----------
USERNAME
------------------------------
    37 oracle@myhost (MMNL)                      3


    44 oracle@myhost (CKPT)                      1


    48 oracle@myhost (PSP0)                      1



       SID PROGRAM                           SERIAL#
---------- ------------------------------------------------ ----------
USERNAME
------------------------------
    45 oracle@myhost (LGWR)                      1


    46 oracle@myhost (DBW0)                      1


    47 oracle@myhost (MMAN)                      1



       SID PROGRAM                           SERIAL#
---------- ------------------------------------------------ ----------
USERNAME
------------------------------
    43 oracle@myhost (SMON)                      1


    39 sqlplus@myhost (TNS V1-V3)                     1
SYS


11 rows selected.

alter user sys identified by "oracle"
                             *
ERROR at line 1:
ORA-01109: database not open


alter user system identified by "oracle"
                                *
ERROR at line 1:
ORA-01109: database not open



System altered.

CREATE OR REPLACE LIBRARY dbms_sumadv_lib AS '/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/lib/libqsmashr.so';
*
ERROR at line 1:
ORA-01109: database not open


create or replace directory DATA_PUMP_DIR as '/usr/lib/oracle/xe/app/oracle/admin/XE/dpdump/'
*
ERROR at line 1:
ORA-01109: database not open


commit
*
ERROR at line 1:
ORA-01109: database not open


BEGIN dbms_swrf_internal.cleanup_database(cleanup_local => FALSE); END;

      *
ERROR at line 1:
ORA-06550: line 1, column 7:
PLS-00201: identifier 'DBMS_SWRF_INTERNAL.CLEANUP_DATABASE' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored


commit
*
ERROR at line 1:
ORA-01109: database not open


   dbms_xdb.sethttpport('8080');
   *
ERROR at line 2:
ORA-06550: line 2, column 4:
PLS-00201: identifier 'DBMS_XDB.SETHTTPPORT' must be declared
ORA-06550: line 2, column 4:
PL/SQL: Statement ignored
ORA-06550: line 3, column 4:
PLS-00201: identifier 'DBMS_XDB.SETFTPPORT' must be declared
ORA-06550: line 3, column 4:
PL/SQL: Statement ignored



File created.

ORA-01507: database not mounted


ORACLE instance shut down.
ORACLE instance started.

Total System Global Area  134217728 bytes
Fixed Size            1257596 bytes
Variable Size           58724228 bytes
Database Buffers       71303168 bytes
Redo Buffers            2932736 bytes
ORA-00205: error in identifying control file, check alert log for more info



'UTL_RECOMP_BEGIN:'||TO_CH
--------------------------
utl_recomp_begin: 02:12:49

BEGIN utl_recomp.recomp_serial(); END;

      *
ERROR at line 1:
ORA-06550: line 1, column 7:
PLS-00201: identifier 'UTL_RECOMP.RECOMP_SERIAL' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored



'UTL_RECOMP_END:'||TO_CH
------------------------
utl_recomp_end: 02:12:49

alter user hr password expire account lock
*
ERROR at line 1:
ORA-01109: database not open


alter user ctxsys password expire account lock
*
ERROR at line 1:
ORA-01109: database not open


alter user outln password expire account lock
*
ERROR at line 1:
ORA-01109: database not open


alter user mdsys password expire
*
ERROR at line 1:
ORA-01109: database not open


alter user flows_020100 password expire
*
ERROR at line 1:
ORA-01109: database not open


alter user flows_files password expire
*
ERROR at line 1:
ORA-01109: database not open


ni ma...
alter user sys identified by "o"
                             *
ERROR at line 1:
ORA-01109: database not open


alter user system identified by "o"
                                *
ERROR at line 1:
ORA-01109: database not open


Done
Starting Oracle Database 10g Express Edition Instance...Done
Installation Completed Successfully.
To access the Database Home Page go to "http://127.0.0.1:8080/apex"

and (like You) can't get localhost:8080/apex working (SQLplus don't work proper either)

Last edited by sebekk23 (2010-07-21 07:32:43)

Misfit138 · 2010-07-21 14:15:33

Necrobumping is strongly discouraged. See http://wiki.archlinux.org/index.php/For … Bumping.27
However, this software seems to be at the same version as the OP, so it will be allowed.

Arch Linux

#1 2008-12-02 03:19:20

Oracle-XE

#2 2010-07-21 07:31:57

Re: Oracle-XE

#3 2010-07-21 14:15:33

Re: Oracle-XE

Board footer