I am trying to install 11g Express Edition Release 2 on a Windows XP (sp3) system that meets the system requirements documented in Oracle® Database Express Edition
My installation was done as follows;
- accepted default settings
- setting the password for SYS and SYSTEM database accounts
- no errors observed during install
- reboot
After the install I verified oracleservicexe service running and had the following issues:
- When I launch "Get Started with Oracle Database 11g Express Edition", Chrome browser opens "127.0.0.1:8080/apex/f?p=4950" and reports an error "Google Chrome could not connect to 127.0.0.1:8080"
- When I try to connect using SQL Plus, "c:\>sqlplus system, enter password used during install, I get the ORA-01089: Immediate shutdown in progress..." error.
Any advice or help would be appreciated. Thanks in advance.
Message was edited by: TDM-TEK
Listed below are logs from the installation (C:\oraclexe\app\oracle\product\11.2.0\server\config\log), which do reveal some errors.
cloneDBCreation.log
-----------------------------
SQL> Create controlfile reuse set database "XE"
2 MAXINSTANCES 8
3 MAXLOGHISTORY 1
4 MAXLOGFILES 16
5 MAXLOGMEMBERS 3
6 MAXDATAFILES 100
7 Datafile
8 'C:\oraclexe\app\oracle\oradata\XE\system.dbf',
9 'C:\oraclexe\app\oracle\oradata\XE\undotbs1.dbf',
10 'C:\oraclexe\app\oracle\oradata\XE\sysaux.dbf',
11 'C:\oraclexe\app\oracle\oradata\XE\users.dbf'
12 LOGFILE
13 GROUP 1 SIZE 51200K,
14 GROUP 2 SIZE 51200K,
15 RESETLOGS;
SP2-0640: Not connected
SQL> exec dbms_backup_restore.zerodbid(0);
SP2-0640: Not connected
SP2-0641: "EXECUTE" requires connection to server
SQL> shutdown immediate;
SP2-0640: Not connected
Database closed.
SP2-0640: Not connected
Database dismounted.
ORA-28056: Writing audit records to Windows Event Log failed
OSD-226848192: Message 226848192 not found; product=RDBMS; facility=SOSD
O/S-Error: (OS 1502) The event log file is full.
SQL> startup nomount pfile="C:\oraclexe\app\oracle\product\11.2.0\server\config\scripts\initXETemp.ora";
ORA-01081: cannot start already-running ORACLE - shut it down first
SQL> Create controlfile reuse set database "XE"
2 MAXINSTANCES 8
3 MAXLOGHISTORY 1
4 MAXLOGFILES 16
5 MAXLOGMEMBERS 3
6 MAXDATAFILES 100
7 Datafile
8 'C:\oraclexe\app\oracle\oradata\XE\system.dbf',
9 'C:\oraclexe\app\oracle\oradata\XE\undotbs1.dbf',
10 'C:\oraclexe\app\oracle\oradata\XE\sysaux.dbf',
11 'C:\oraclexe\app\oracle\oradata\XE\users.dbf'
12 LOGFILE
13 GROUP 1 SIZE 51200K,
14 GROUP 2 SIZE 51200K,
15 RESETLOGS;
SP2-0640: Not connected
SQL> alter system enable restricted session;
SP2-0640: Not connected
SQL> alter database "XE" open resetlogs;
SP2-0640: Not connected
SQL> alter database rename global_name to "XE";
SP2-0640: Not connected
SQL> alter system switch logfile;
SP2-0640: Not connected
SQL> alter system checkpoint;
SP2-0640: Not connected
SQL> alter database drop logfile group 3;
SP2-0640: Not connected
SQL> ALTER TABLESPACE TEMP ADD TEMPFILE 'C:\oraclexe\app\oracle\oradata\XE\temp.dbf' SIZE 20480K REUSE AUTOEXTEND ON NEXT 640K MAXSIZE UNLIMITED;
SP2-0640: Not connected
SQL> select tablespace_name from dba_tablespaces where tablespace_name='USERS';
SP2-0640: Not connected
SQL> select sid, program, serial#, username from v$session;
SP2-0640: Not connected
SQL> alter user sys identified by "&&sysPassword";
SP2-0640: Not connected
SQL> alter user system identified by "&&systemPassword";
SP2-0640: Not connected
SQL> alter system disable restricted session;
SP2-0640: Not connected
SQL> @C:\oraclexe\app\oracle\product\11.2.0\server\config\scripts\postScripts.sql
SQL> connect "SYS"/"&&sysPassword" as SYSDBA
ERROR:
ORA-28056: Writing audit records to Windows Event Log failed
OSD-226806448: Message 226806448 not found; product=RDBMS; facility=SOSD
O/S-Error: (OS 1502) The event log file is full.
ORA-28056: Writing audit records to Windows Event Log failed
OSD-226806448: Message 226806448 not found; product=RDBMS; facility=SOSD
O/S-Error: (OS 1502) The event log file is full.
SQL> set echo on
SQL> spool C:\oraclexe\app\oracle\product\11.2.0\server\config\log\postScripts.log