oracle11g - Oracle 11g XE installation not working. "Create CONTROLFILE failed" -
i installed oracle 11g xe on windows computer (running on windows xp pro), unfortunately, can't work. there no errors gui installer shows during installation , "installed successfully" message, when try connect oracle using sql command prompt, following error:
sql> connect enter user-name: system enter password: error: ora-01033: oracle initialization or shutdown in progress process id: 0 session id: 0 serial number: 0 the 'get started' shortcut icon takes me :
http://127.0.0.1:8080/apex/f?p=4950 which gives me "unable connect" message
after having spent 2 days doing research on this, found out apart being listener issue, 'oradata\xe' folder located at: e:\oraclexe\app\oracle\oradata\xe empty. think should have contained control files etc.
there errors related creation of control files etc. reported in log files located @ : e:\oraclexe\app\oracle\product\11.2.0\server\config\log , pasting them here ->
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 'e:\oraclexe\app\oracle\oradata\xe\system.dbf', 9 'e:\oraclexe\app\oracle\oradata\xe\undotbs1.dbf', 10 'e:\oraclexe\app\oracle\oradata\xe\sysaux.dbf', 11 'e:\oraclexe\app\oracle\oradata\xe\users.dbf' 12 logfile 13 group 1 size 51200k, 14 group 2 size 51200k, 15 resetlogs; create controlfile reuse set database "xe" * error @ line 1: ora-01503: create controlfile failed ora-01565: error in identifying file 'e:\oraclexe\app\oracle\oradata\xe\system.dbf' ora-27041: unable open file osd-04002: unable open file o/s-error: (os 2) system cannot find file specified. sql> exec dbms_backup_restore.zerodbid(0); begin dbms_backup_restore.zerodbid(0); end; * error @ line 1: ora-00210: cannot open specified control file ora-06512: @ "sys.x$dbms_backup_restore", line 4754 ora-06512: @ line 1 sql> shutdown immediate; ora-01507: database not mounted oracle instance shut down. sql> startup nomount pfile="e:\oraclexe\app\oracle\product\11.2.0\server\config\scripts\initxetemp.ora"; oracle instance started. total system global area 535662592 bytes fixed size 1384760 bytes variable size 226496200 bytes database buffers 301989888 bytes redo buffers 5791744 bytes 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 'e:\oraclexe\app\oracle\oradata\xe\system.dbf', 9 'e:\oraclexe\app\oracle\oradata\xe\undotbs1.dbf', 10 'e:\oraclexe\app\oracle\oradata\xe\sysaux.dbf', 11 'e:\oraclexe\app\oracle\oradata\xe\users.dbf' 12 logfile 13 group 1 size 51200k, 14 group 2 size 51200k, 15 resetlogs; create controlfile reuse set database "xe" * error @ line 1: ora-01503: create controlfile failed ora-01565: error in identifying file 'e:\oraclexe\app\oracle\oradata\xe\system.dbf' ora-27041: unable open file osd-04002: unable open file o/s-error: (os 2) system cannot find file specified. sql> alter system enable restricted session; system altered. sql> alter database "xe" open resetlogs; alter database "xe" open resetlogs * error @ line 1: ora-01507: database not mounted sql> alter database rename global_name "xe"; alter database rename global_name "xe" * error @ line 1: ora-01109: database not open sql> alter system switch logfile; alter system switch logfile * error @ line 1: ora-01109: database not open sql> alter system checkpoint; alter system checkpoint * error @ line 1: ora-01109: database not open sql> alter database drop logfile group 3; alter database drop logfile group 3 * error @ line 1: ora-01507: database not mounted sql> alter tablespace temp add tempfile 'e:\oraclexe\app\oracle\oradata\xe\temp.dbf' size 20480k reuse autoextend on next 640k maxsize unlimited; alter tablespace temp add tempfile 'e:\oraclexe\app\oracle\oradata\xe\temp.dbf' size 20480k reuse autoextend on next 640k maxsize unlimited * error @ line 1: ora-01109: database not open sql> select tablespace_name dba_tablespaces tablespace_name='users'; select tablespace_name dba_tablespaces tablespace_name='users' * error @ line 1: ora-01219: database not open: queries allowed on fixed tables/views sql> select sid, program, serial#, username v$session; sid program ---------- ---------------------------------------------------------------- serial# username ---------- ------------------------------ 1 oracle.exe (pmon) 1 2 oracle.exe (vktm) 1 3 oracle.exe (diag) 1 sid program ---------- ---------------------------------------------------------------- serial# username ---------- ------------------------------ 4 oracle.exe (dia0) 1 5 oracle.exe (dbw0) 1 6 oracle.exe (reco) 1 sid program ---------- ---------------------------------------------------------------- serial# username ---------- ------------------------------ 8 oracle.exe (ckpt) 1 9 sqlplus.exe 3 sys 10 oracle.exe (mmnl) 5 sid program ---------- ---------------------------------------------------------------- serial# username ---------- ------------------------------ 88 oracle.exe (psp0) 1 89 oracle.exe (gen0) 1 90 oracle.exe (dbrm) 1 sid program ---------- ---------------------------------------------------------------- serial# username ---------- ------------------------------ 91 oracle.exe (mman) 1 92 oracle.exe (lgwr) 1 93 oracle.exe (smon) 1 15 rows selected. sql> alter user sys identified "&&syspassword"; alter user sys identified "tiger" * error @ line 1: ora-01109: database not open sql> alter user system identified "&&systempassword"; alter user system identified "tiger" * error @ line 1: ora-01109: database not open sql> alter system disable restricted session; system altered. sql> @e:\oraclexe\app\oracle\product\11.2.0\server\config\scripts\postscripts.sql sql> connect "sys"/"&&syspassword" sysdba connected. sql> set echo on sql> spool e:\oraclexe\app\oracle\product\11.2.0\server\config\log\postscripts.log clonermanrestore.log
sql> startup nomount pfile="e:\oraclexe\app\oracle\product\11.2.0\server\config\scripts\init.ora"; oracle instance started. total system global area 535662592 bytes fixed size 1384760 bytes variable size 226496200 bytes database buffers 301989888 bytes redo buffers 5791744 bytes sql> @e:\oraclexe\app\oracle\product\11.2.0\server\config\scripts\rmanrestoredatafiles.sql; sql> set echo off; to_char(systimest ----------------- 20140530 06:00:59 allocating device.... specifying datafiles... specifing datafiles... restoring ... declare * error @ line 1: ora-19624: operation failed, retry possible ora-19870: error while restoring backup piece e:\oraclexe\app\oracle\product\11.2.0\server\config\seeddb\express.dfb ora-19504: failed create file "e:\oraclexe\app\oracle\oradata\xe\system.dbf" ora-27044: unable write header block of file osd-04008: writefile() failure, unable write file o/s-error: (os 112) there not enough space on disk. ora-06512: @ "sys.x$dbms_backup_restore", line 5827 ora-06512: @ line 16 to_char(systimest ----------------- 20140530 06:01:02 connected. sql> spool e:\oraclexe\app\oracle\product\11.2.0\server\config\log\clonedbcreation.log postdbcreation.log
sql> connect "sys"/"&&syspassword" sysdba connected. sql> set echo on sql> //create or replace directory db_backups 'e:\oraclexe\app\oracle\fast_recovery_area'; sp2-0103: nothing in sql buffer run. sql> begin 2 dbms_xdb.sethttpport('8080'); 3 dbms_xdb.setftpport('0'); 4 end; 5 / dbms_xdb.sethttpport('8080'); * error @ line 2: ora-06550: line 2, column 4: pls-00201: identifier 'dbms_xdb.sethttpport' must declared ora-06550: line 2, column 4: pl/sql: statement ignored ora-06550: line 3, column 4: pls-00201: identifier 'dbms_xdb.setftpport' must declared ora-06550: line 3, column 4: pl/sql: statement ignored sql> create spfile='e:\oraclexe\app\oracle\product\11.2.0\server\dbs/spfilexe.ora' pfile='e:\oraclexe\app\oracle\product\11.2.0\server\config\scripts\init.ora'; file created. sql> shutdown immediate; ora-01507: database not mounted oracle instance shut down. sql> connect "sys"/"&&syspassword" sysdba connected idle instance. sql> startup ; oracle instance started. total system global area 535662592 bytes fixed size 1384760 bytes variable size 226496200 bytes database buffers 301989888 bytes redo buffers 5791744 bytes ora-00205: error in identifying control file, check alert log more info sql> select 'utl_recomp_begin: ' || to_char(sysdate, 'hh:mi:ss') dual; 'utl_recomp_begin:'||to_ch -------------------------- utl_recomp_begin: 06:01:55 sql> execute utl_recomp.recomp_serial(); begin utl_recomp.recomp_serial(); end; * error @ line 1: ora-06550: line 1, column 7: pls-00201: identifier 'utl_recomp.recomp_serial' must declared ora-06550: line 1, column 7: pl/sql: statement ignored sql> select 'utl_recomp_end: ' || to_char(sysdate, 'hh:mi:ss') dual; 'utl_recomp_end:'||to_ch ------------------------ utl_recomp_end: 06:01:55 sql> alter user hr password expire account lock; alter user hr password expire account lock * error @ line 1: ora-01109: database not open sql> alter user ctxsys password expire account lock; alter user ctxsys password expire account lock * error @ line 1: ora-01109: database not open sql> alter user outln password expire account lock; alter user outln password expire account lock * error @ line 1: ora-01109: database not open sql> alter user mdsys password expire; alter user mdsys password expire * error @ line 1: ora-01109: database not open sql> @e:\oraclexe\app\oracle\product\11.2.0\server\apex\apxxepwd.sql "&1" sql> rem copyright (c) oracle corporation 1999 - 2006. rights reserved. sql> rem sql> rem name sql> rem apxxepwd.sql sql> rem sql> rem description sql> rem changes password internal admin user sql> rem sql> rem notes sql> rem assumes sys user connected. sql> rem sql> rem requirents sql> rem - oracle 10g sql> rem sql> rem sql> rem modified (mm/dd/yyyy) sql> rem jstraub 08/01/2006 - created sql> rem jkallman 09/29/2006 - adjusted current_schema flows_030000 sql> rem jkallman 08/02/2007 - change flows_030000 references flows_030100 sql> rem jkallman 07/08/2008 - change flows_030100 references flows_040000 sql> rem jkallman 10/02/2008 - change flows_040000 references apex_040000 sql> sql> rem sql> sql> set define '&' sql> sql> set verify off sql> sql> alter session set current_schema = apex_040000; error: ora-01435: user not exist sql> sql> prompt ...changing password admin ...changing password admin sql> sql> begin 2 3 wwv_flow_security.g_security_group_id := 10; 4 wwv_flow_security.g_user := 'admin'; 5 wwv_flow_security.g_import_in_progress := true; 6 7 c1 in (select user_id 8 wwv_flow_fnd_user 9 security_group_id = wwv_flow_security.g_security_group_id 10 , user_name = wwv_flow_security.g_user) loop 11 12 wwv_flow_fnd_user_api.edit_fnd_user( 13 p_user_id => c1.user_id, 14 p_user_name => wwv_flow_security.g_user, 15 p_web_password => '&1', 16 p_new_password => '&1'); 17 end loop; 18 19 wwv_flow_security.g_import_in_progress := false; 20 21 end; 22 / wwv_flow_security.g_security_group_id := 10; * error @ line 3: ora-06550: line 3, column 5: pls-00201: identifier 'wwv_flow_security.g_security_group_id' must declared ora-06550: line 3, column 5: pl/sql: statement ignored ora-06550: line 4, column 5: pls-00201: identifier 'wwv_flow_security.g_user' must declared ora-06550: line 4, column 5: pl/sql: statement ignored ora-06550: line 5, column 5: pls-00201: identifier 'wwv_flow_security.g_import_in_progress' must declared ora-06550: line 5, column 5: pl/sql: statement ignored ora-06550: line 8, column 23: pl/sql: ora-01219: database not open: queries allowed on fixed tables/views ora-06550: line 7, column 16: pl/sql: sql statement ignored ora-06550: line 13, column 32: pls-00364: loop index variable 'c1' use invalid ora-06550: line 12, column 9: pl/sql: statement ignored ora-06550: line 19, column 5: pls-00201: identifier 'wwv_flow_security.g_import_in_progress' must declared ora-06550: line 19, column 5: pl/sql: statement ignored sql> commit; commit complete. sql> spool off; xe.bat.log
instance created. i have not pasted contents of postscripts.log causing body of question exceed allowed limit of characters.
as suggested in articles/posts on internet, tried connecting oracle sysdba view control_file parameter. got:
sql> connect / sysdba connected. sql> show parameter control_files name type value ------------------------------------ ----------- ------------------------------ control_files string e:\oraclexe\app\oracle\oradata \xe\control.dbf i sorry posting information log files, thought might necessary.
also, pls aware of following:
- i logged in user part of administrators group.
- i using dual boot system, windows xp installed on drive e:
- i have used gui installer , did not meddle in installation process
can oracle expert please ? wrong installation , how work ? have tried reinstalling several times, stuck same issues.
i had problem too, reinstall run administrator solve problems , create databases
Comments
Post a Comment