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 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"