ERROR CREATING ORACLE 11G DATABASE MANUALLY
997913Mar 19 2013 — edited Apr 3 2013Hi
I'm new to forum as well new to Oracle DBA , I was trying to create oracle database manually , I got following error , can some please advise how to correct
SQL> startup nomount;
ORACLE instance started.
Total System Global Area 1068937216 bytes
Fixed Size 2220200 bytes
Variable Size 281022296 bytes
Database Buffers 780140544 bytes
Redo Buffers 5554176 bytes
SQL> @createdb.sql
CREATE DATABASE orcl
*
ERROR at line 1:
ORA-01501: CREATE DATABASE failed
ORA-00200: control file could not be created
ORA-00202: control file: '/u02/app/oracle/orcl/control01.ctl/'
ORA-27040: file create error, unable to create file
Linux-x86_64 Error: 21: Is a directory
herre is how my initfile looks
db_name='orcl'
sga_target=1G
processes = 150
audit_file_dest='/u01/app/oracle/admin/orcl/adump'
audit_trail ='db'
db_block_size=8192
db_domain=''
db_recovery_file_dest='/u01/app/oracle/flash_recovery_area'
db_recovery_file_dest_size=2G
diagnostic_dest='/u01/app/oracle'
dispatchers='(PROTOCOL=TCP) (SERVICE=ORCLXDB)'
open_cursors=300
remote_login_passwordfile='EXCLUSIVE'
undo_tablespace='UNDOTBS1'
# You may want to ensure that control files are created on separate physical
# devices
control_files = (/u02/app/oracle/orcl/control01.ctl/,/u01/app/oracle/flash_recovery_area
/orcl/control02.ctl)
compatible ='11.2.0'
Please advise , why I'm getting this error