| db creation ctl error [message #460383] |
Thu, 10 June 2010 23:10  |
reym21
Messages: 241
Registered: February 2010
Location: Philippines
|
Senior Member |
|
|
Pls. help me... I need this dB by Saturday! Thank you in advanced.
It's been 2 days from now that I'm bugging with this kind of error in my manual dB creation. I used DBCA first but we had a default directory settings, that's why I resorted to create the db manually. The dB was already created and currently has a status of STARTED.. I cannot mount it due to this error:
SQL> startup nomount
ORACLE instance started.
Total System Global Area 247463936 bytes
Fixed Size 2235856 bytes
Variable Size 177840688 bytes
Database Buffers 67108864 bytes
Redo Buffers 278528 bytes
SQL> alter database mount;
alter database mount
*
ERROR at line 1:
ORA-00205: error in identifying control file, check alert log for more info.
SQL> select * from v$instance;
INSTANCE_NUMBER INSTANCE_NAME
--------------- ----------------
HOST_NAME
----------------------------------------------------------------
VERSION STARTUP_T STATUS PAR THREAD# ARCHIVE LOG_SWITCH_WAIT
----------------- --------- ------------ --- ---------- ------- ---------------
LOGINS SHU DATABASE_STATUS INSTANCE_ROLE ACTIVE_ST BLO
---------- --- ----------------- ------------------ --------- ---
1 arcs
bir-dbs
10.2.0.4.0 11-JUN-10 STARTED NO 0 STOPPED
ALLOWED NO ACTIVE UNKNOWN NORMAL NO
This is what my alertlog captured:
----------------------------------
ORA-00202: control file: '/VOL02/oradata/arcs/control/control01.ctl'
ORA-27037: unable to obtain file status
SVR4 Error: 2: No such file or directory
Here is my script:
----------------------------------
CREATE DATABASE arcs
MAXLOGFILES 50
MAXINSTANCES 1
MAXDATAFILES 100
MAXLOGHISTORY 1
DATAFILE '/VOL02/oradata/arcs/system/system01.dbf' SIZE 400M REUSE
SYSAUX DATAFILE '/VOL02/oradata/arcs/system/sysaux01.dbf SIZE 400M REUSE
UNDO TABLESPACE UNDOTBS
DATAFILE '/VOL02/oradata/arcs/undo/undotbs01.dbf' SIZE 200M REUSE
AUTOEXTEND ON NEXT 5120K MAXSIZE UNLIMITED
CHARACTER SET WE8ISO8859P1
NATIONAL CHARACTER SET AL16UTF16
LOGFILE GROUP 1 ('/VOL02/oradata/arcs/redo/redo01.log') SIZE 500M,
GROUP 2 ('/VOL02/oradata/arcs/redo/redo02.log') SIZE 500M,
GROUP 3 ('/VOL02/oradata/arcs/redo/redo03.log') SIZE 500M;
CREATE TABLESPACE "USERS" DATAFILE '/VOL02/oradata/arcs/data/users01.dbf'
SIZE 300M REUSE AUTOEXTEND ON NEXT 5M MAXSIZE 1500M;
CREATE TEMPORARY TABLESPACE "TEMP" TEMPFILE '/VOL02/oradata/arcs/temp/temp01.dbf
'
SIZE 40M REUSE AUTOEXTEND ON NEXT 640K MAXSIZE UNLIMITED
EXTENT MANAGEMENT LOCAL;
ALTER DATABASE DEFAULT TEMPORARY TABLESPACE "TEMP";
CREATE TABLESPACE arcs
DATAFILE '/VOL03/oradata/arcs/data/arcs_data01.dbf'
SIZE 30M REUSE AUTOEXTEND ON NEXT 1280K MAXSIZE UNLIMITED
EXTENT MANAGEMENT LOCAL;
CREATE TABLESPACE indx
DATAFILE '/VOL03/oradata/arcs/ndex/indx01.dbf'
SIZE 30M REUSE AUTOEXTEND ON NEXT 1280K MAXSIZE UNLIMITED
EXTENT MANAGEMENT LOCAL;
@/appl1/home/oracle/10.2/rdbms/admin/catalog.sql;
@/appl1/home/oracle/10.2/rdbms/admin/catproc.sql;
@/appl1/home/oracle/10.2/sqlplus/admin/pupbld.sql;
CREATE SPFILE='/appl1/home/oracle/10.2/dbs/spfilearcs.ora' FROM
PFILE='/appl1/home/oracle/10.2/dbs/initarcs.ora';
My INITarcs.ORA
-------------------------------------------------------
*.audit_file_dest='/appl1/home/oracle/10.2/admin/arcs/adump'
*.background_dump_dest='/appl1/home/oracle/10.2/admin/arcs/bdump'
*.control_files='/VOL02/oradata/arcs/control/control01.ctl','/VOL02/oradata/arcs
/control/control02.ctl','/VOL02/oradata/arcs/control/control03.ctl'
*.core_dump_dest='/appl1/home/oracle/10.2/admin/arcs/cdump'
*.db_block_buffers=550
*.db_block_size=8192
*.db_domain=''
*.db_file_multiblock_read_count=16
*.db_files=80
*.db_name='arcs'
*.instance_name='arcs'
*.job_queue_processes=10
*.log_archive_dest='/u1archive/arcs/arcsarch'
*.log_archive_format='%t_%s_%r.dbf'
*.log_buffer=32768
*.max_dump_file_size='10240'
*.open_cursors=300
*.parallel_max_servers=5
*.processes=100
*.remote_login_passwordfile='EXCLUSIVE'
*.shared_pool_size=150075699
*.undo_management='AUTO'
Regards..
|
|
|
|
|
|
| Re: db creation ctl error [message #460392 is a reply to message #460383] |
Fri, 11 June 2010 00:22  |
hkchital
Messages: 128
Registered: September 2008
Location: Singapore
|
Senior Member |
|
|
If you are trying to CREATE DATABASE, the command is run in NOMOUNT mode. The CREATE DATABASE also creates the controlfiles.
Therefore, your sequence should be
STARTUP NOMOUNT
CREATE DATABASE ..............
Hemant K Chitale
|
|
|
|
| Re: db creation ctl error [message #460411 is a reply to message #460383] |
Fri, 11 June 2010 02:24 |
reym21
Messages: 241
Registered: February 2010
Location: Philippines
|
Senior Member |
|
|
I'm now facing this problem after editing my script for bugs...
I'm almost there in the successful manual db creation, redo and control files are already there...
SQL> @arcs_dbc-61010a.sql
CREATE DATABASE arcs
*
ERROR at line 1:
ORA-01092: ORACLE instance terminated. Disconnection forced
SQL> shutdown abort/immediate
ORA-24324: service handle not initialized
ORA-01041: internal error. hostdef extension doesn't exist
SQL> startup nomount PFILE='/appl1/home/oracle/10.2/dbs/initarcs.ora';
ORA-24324: service handle not initialized
ORA-01041: internal error. hostdef extension doesn't exist
SQL> startup nomount
ORA-24324: service handle not initialized
ORA-01041: internal error. hostdef extension doesn't exist
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
