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 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 03-APR-2008 16:18:08 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=darkside.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 03-APR-2008 16:18:08 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=darkside.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... 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 ----------------- 20080403 04:18:09 Allocating device.... Specifying datafiles... Specifing datafiles... Restoring ... 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/seeddb/xeseed.dfb ORA-19505: failed to identify file "/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/config/seeddb/xeseed.dfb" ORA-27037: unable to obtain file status Linux Error: 2: No such file or directory Additional information: 3 ORA-06512: at "SYS.X$DBMS_BACKUP_RESTORE", line 5149 ORA-06512: at line 16 TO_CHAR(SYSTIMEST ----------------- 20080403 04:18:09 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@darkside (PMON) 1 41 oracle@darkside (MMON) 3 42 oracle@darkside (RECO) 1 SID PROGRAM SERIAL# ---------- ------------------------------------------------ ---------- USERNAME ------------------------------ 40 oracle@darkside (MMNL) 3 44 oracle@darkside (CKPT) 1 48 oracle@darkside (PSP0) 1 SID PROGRAM SERIAL# ---------- ------------------------------------------------ ---------- USERNAME ------------------------------ 45 oracle@darkside (LGWR) 1 46 oracle@darkside (DBW0) 1 47 oracle@darkside (MMAN) 1 SID PROGRAM SERIAL# ---------- ------------------------------------------------ ---------- USERNAME ------------------------------ 43 oracle@darkside (SMON) 1 39 sqlplus@darkside (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: 04:18:18 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: 04:18:18 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 alter user sys identified by "essagala" * ERROR at line 1: ORA-01109: database not open alter user system identified by "essagala" * 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"