As you know dbca is a utility for create database. But if you get issue on x11 than you may need to create database manually.

My current setup versions are

db version –> 11.2.0.4
grid version –> 12.1.0.2
Os version –> RHEL 7

Here is the steps:

1. Create adump folder

mkdir -p /u01/app/oracle/admin/DB_SID/adump

2. Create init file such as :

*.audit_file_dest=’/u01/app/oracle/admin/DB_SID/adump’
*.audit_trail=’db’
*.compatible=’11.2.0.4.0′
*.db_block_size=8192
*.db_create_file_dest=’+DATA’
*.db_domain=”
*.db_name=’DB_SID’
*.diagnostic_dest=’/u01/app/oracle’
*.dispatchers='(PROTOCOL=TCP) (SERVICE=DB_SIDXDB)’
*.open_cursors=300
*.pga_aggregate_target=1G
*.processes=1500
*.remote_login_passwordfile=’EXCLUSIVE’
*.sessions=1655
*.sga_target=6G
*.undo_tablespace=’UNDOTBS1′
3. Prepare database creation script:

You can change those params for your env.

CREATE DATABASE “DB_SID”
MAXLOGFILES 5
MAXLOGMEMBERS 5
MAXDATAFILES 1000
MAXINSTANCES 1
MAXLOGHISTORY 292
LOGFILE
GROUP 1 ‘+DATA’ SIZE 2048M,
GROUP 2 ‘+DATA’ SIZE 2048M,
GROUP 3 ‘+DATA’ SIZE 2048M
DATAFILE
‘+DATA’ size 1000m,
‘+DATA’ size 1000m
sysaux datafile ‘+DATA’ size 1000m
undo tablespace UNDOTBS1
datafile ‘+DATA’ size 500m
CHARACTER SET AL32UTF8;

4. Follow below steps:

$ export ORACLE_SID=DB_SID
cd $ORACLE_HOME/rdbms/admin

$ sqlplus / as sysdba

SQL> @DB_SID_Create.sql
Database created.

SQL> @$ORACLE_HOME/rdbms/admin/catalog.sql
SQL> @$ORACLE_HOME/rdbms/admin/catproc.sql

SQL> CREATE TEMPORARY TABLESPACE TEMP2 TEMPFILE ‘+ORAFRA’ SIZE 25600M AUTOEXTEND OFF EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1M;

SQL> show parameter control << take this info and put it in init.ora file SQL> shutdown immediate;

SQL> create spfile from pfile;
SQL> startup;


“Two useful technologies for working from anywhere – Cloud Desktop and Cloud SharePoint.”, 

Advertisements