Lab 2 – Oracle Db Creation – Industry Standards Manual

mkdir -p /u01/app/oracle/oradata/gopi
mkdir -p /u01/app/oracle/admin/gopi/adump

cd $ORACLE_HOME/dbs
vi initgopi.ora( my dbname is gopi)

db_name=’gopi’
db_domain=”
audit_file_dest=’/u01/app/oracle/admin/gopi/adump’
compatible=’12.2.0.0.0′
sga_target=800m
control_files=’/u01/app/oracle/oradata/gopi/control01.ctl’,’/home/oracle/u02/oradata/gopi/control02.ctl’
db_block_size=8192
diagnostic_dest=’/u01/app/oracle/admin/gopi’
remote_login_passwordfile=’EXCLUSIVE’
undo_tablespace=’UNDOTS01′
open_cursors=300
processes=1000

$export ORACLE_SID=gopi
$sqlplus / as sysdba
SQL> startup nomount

SQL> CREATE DATABASE gopi
USER SYS IDENTIFIED BY sys_password
USER SYSTEM IDENTIFIED BY system_password
LOGFILE GROUP 1 (‘/u01/app/oracle/oradata/gopi/redo01.log’) SIZE 100M,
GROUP 2 (‘/u01/app/oracle/oradata/gopi/redo02.log’) SIZE 100M,
GROUP 3 (‘/u01/app/oracle/oradata/gopi/redo03.log’) SIZE 100M
MAXLOGFILES 5
MAXLOGMEMBERS 5
MAXLOGHISTORY 1
MAXDATAFILES 100
CHARACTER SET US7ASCII
NATIONAL CHARACTER SET AL16UTF16
EXTENT MANAGEMENT LOCAL
DATAFILE ‘/u01/app/oracle/oradata/gopi/system01.dbf’ SIZE 500M REUSE
SYSAUX DATAFILE ‘/u01/app/oracle/oradata/gopi/sysaux01.dbf’ SIZE 500M REUSE
DEFAULT TABLESPACE users
DATAFILE ‘/u01/app/oracle/oradata/gopi/users01.dbf’
SIZE 500M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED
DEFAULT TEMPORARY TABLESPACE temp
TEMPFILE ‘/u01/app/oracle/oradata/gopi/temp01.dbf’
SIZE 20M REUSE
UNDO TABLESPACE undotbs01
DATAFILE ‘/u01/app/oracle/oradata/gopi/undotbs01.dbf’
SIZE 200M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED;

SQL> @?/rdbms/admin/catalog.sql
SQL> @?/rdbms/admin/catproc.sql
SQL> @?/rdbms/admin/utlrp.sql

SQL> select * from dba_registry; (to check catalog and catproc ran successfully).

SQL> show parameter control_files
SQL> select group#,members,bytes/1024/1024 “Size in MB” ,status from v$log;
SQL> select group#,type,member from v$logfile;
SQL> select * from v$CONTROLFILE;
SQL> select tablespace_name,sum(bytes)/1024/1024/1024 from dba_data_files group by tablespace_name order by 2 desc;
SQL> select tablespace_name,sum(bytes)/1024/1024/1024 from dba_temp_files group by tablespace_name order by 2 desc;
SQL> select tablespace_name,sum(bytes)/1024/1024/1024 from dba_segments group by tablespace_name order by 2 desc;