create database rajpal in Oracle DBA

create database rajpal
                datafile ‘/disk3/oraclate/pal/system/dbf’ size 170 m autoextend on
sysaux datafile ‘/disk3/oradatra/pal/sysaux/dbf’ size 100 m autoextend on
default temporary tablespace temp tempfile ‘/disk3/oradata/pal/temp.dbf’size 20m
default tablespace userdata datafile ‘/disk3/oradata/pal/userdata.dbf’ size 20,
undo tablespace undotbs datafile ‘/disk3/oradata/pal/undotbs.dbf’ size 20m

group 1 (‘/disk3/oradata/pal/redologi1a.log’) size 4m,
group 2 (‘/disk3/oradata/pal/redolog2a.log’) size 4m
controlfile reuse;

SQL >@cr8db
database created.
SQL> select status from v$instance;

SQL > Cl scr
SQL > ed run

conn system/manger
@ $ ORACLE_HOME/sqlplus/admin/pupbld.sql
SQL > @ run



Procedure is created.

SQL > select count (*) from tab;

SQL > select * from dba_users;



Dump destination is latest advance to oracle. It contains all transactions related information whatever we perform against the database. [alert$ORACLE_SID.log]
user related error files will be generated in user dump destination

Core dump destination contains memory related errors.






sanity check includes, whether the control file values (    SCN #]
available physically or not.                                                                   data

$ORACLE_HOME/rdbms/admin/catalog/sql                                user

$ORACLE_HOME/rdbms/admin/catalog/sql                                all

$ORACLE_HOME/rdbms/admin/catalog/sql à [system/manager]

Catalog.sql: contains all user friendly data dictionary vies [base table are not user friendly]
catproc.sql: contains tables, procedures & functions
pupbld.sql: contains default users [6],
default profiles.




Shut about:  Shut down immediately whether the Txs open or not, do not bothers & kills the Txs abruptly

Shutdown transactional: Shutsdown the database after open Txs are committed.

 Shut immediate:  if any open Tx, then it rollbacks the Tx and shutsdown.

Shutdown normal: shutsdown the database, after all the users terminated all the sessions.
Catalog.sql contains no tables, but contains, only views like user



contains pl/sql procedures   up to 8i


Up to ORACLE 8i one server may
contain multiple databases  of different
block sizes

from 9i


From ORACLE 9i one data base can maintain multiple   block sizes




Cpu work

in day not more than 60%
in ningh 100%

effective cpu utilization:

if 1 db going with backup than let the  other databases  do the reports, pl/sql procedures &








“At TekSlate, we are trying to create high quality tutorials and articles, if you think any information is incorrect or want to add anything to the article, please feel free to get in touch with us at, we will update the article in 24 hours.”

0 Responses on create database rajpal in Oracle DBA"

    Leave a Message

    Your email address will not be published. Required fields are marked *


    Please leave a message and we'll get back to you soon.
    Three + 6