##############################################################################
###### ######
###### Topic : Manual Database deployment ######
###### Author : ExaOra Technologies -- Sagar Sir ######
###### Date : ######
###### ######
##############################################################################
Manual Db creation method:
==========================
1. Add below DB entry vi /etc/oratab
====================================
PROD:/u01/app/oracle/product/19.0.0/db_1:N
or
echo "PROD:/u01/app/oracle/product/19.0.0/db_1:N" >> /etc/oratab
2. create directory structure :
================================
mkdir -p /u01/app/oracle/oradata/PROD
mkdir -p /u01/app/oracle/oradata/PROD/datafile
mkdir -p /u01/app/oracle/oradata/PROD/redolog
mkdir -p /u01/app/oracle/oradata/PROD/controlfile
mkdir -p /u01/app/oracle/oradata/PROD/archivelog
3. Oracle database enviornment variables are :
===============================================
>>$ su - oracle
>>$ . oraenv
>>$ PROD
>>$ echo $ORACLE_SID
4. Create initlization parameter files:
========================================
cd $ORACLE_HOME/dbs
$ vi initPROD.ora
*.compatible='19.0.0' ##################
*.control_files='/u01/app/oracle/oradata/PROD/controlfile/control01.ctl' #####
*.db_block_size=8192 ###
*.db_domain='PROD.oracle.com'
*.db_name='PROD' ###
*.db_unique_name='PROD'
*.diagnostic_dest='/u01/app/oracle/oradata/PROD' ######
*.dispatchers='(PROTOCOL=TCP) (SERVICE=PRODXDB)'
*.open_cursors=300
*.pga_aggregate_target=50M
*.processes=150
*.remote_login_passwordfile='EXCLUSIVE'
*.sga_target=800M
*.undo_tablespace='UNDOTBS1' ###
5. Start database in nomount mode :
=====================
SQL>> startup nomount pfile='$ORACLE_HOME/dbs/initPROD.ora';
6. Create database :
===================
SQL>>
CREATE DATABASE "PROD"
MAXLOGFILES 5
MAXLOGMEMBERS 5
MAXDATAFILES 100
MAXINSTANCES 1
LOGFILE
GROUP 1 '/u01/app/oracle/oradata/PROD/redolog/redo1.log' SIZE 10M,
GROUP 2 '/u01/app/oracle/oradata/PROD/redolog/redo2.log' SIZE 10M,
GROUP 3 '/u01/app/oracle/oradata/PROD/redolog/redo3.log' SIZE 10M
DATAFILE
'/u01/app/oracle/oradata/PROD/datafile/system.dbf' size 700M REUSE
sysaux datafile '/u01/app/oracle/oradata/PROD/datafile/sysaux.dbf' size 500m
undo tablespace UNDOTBS1 datafile '/u01/app/oracle/oradata/PROD/datafile/undo1.dbf'
size 100m
DEFAULT TEMPORARY TABLESPACE temp1
TEMPFILE '/u01/app/oracle/oradata/PROD/datafile/temp01.dbf' SIZE 300M REUSE
CHARACTER SET AL32UTF8
/
7. catalog view and procedures ###Mandatory script
===================================================================
SQL > @$ORACLE_HOME/rdbms/admin/catalog.sql ### sys
SQL > @?/rdbms/admin/catproc.sql ### sys
SQL > @$ORACLE_HOME/sqlplus/admin/pupbld.sql
-- End of pupbld.sql
8. Now validate database.
=========================
>>$ sqlplus "/ as sysdba"
SQL> create spfile from pfile='$ORACLE_HOME/dbs/initPROD.ora';
SQL> shutdown immediate ;
SQL> startup ;
SQL> select name,open_mode,log_mode,database_role from V$database;
SQL> archive log list
SQL> show parameter spfile
cataproc script ended :
SQL> prompt RDBMS Feature Installation completed
RDBMS Feature Installation completed
SQL> prompt ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
SQL>
SQL>
SQL> Rem Indicate that xdb has been Loaded
SQL> Rem Bug 26255427 use default versions and banner
SQL> begin
2 sys.dbms_registry.loaded('XDB');
3 end;
4 /
SQL> alter session set "_ORACLE_SCRIPT" = false;
Session altered.
SQL>
SQL>
SQL>
SQL> Rem *********************************************************************
SQL> Rem END catproc.sql
SQL> Rem *********************************************************************
SQL> select name,open_mode,log_mode,database_role from V$database;
NAME OPEN_MODE LOG_MODE DATABASE_ROLE
--------- -------------------- ------------ ----------------
PROD READ WRITE NOARCHIVELOG PRIMARY
