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

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

~
~
~
~
~
~
:wq
SQL >@cr8db
database created.
SQL> select status from v$instance;
STATUS
————-
OPne

SQL > Cl scr
SQL > ed run

~
~
~
@$ORACLE_HOME/rdbms/admin/catalog.sql
@$ORACLE_HOME/rdbms/admin/catpmoc.sql
conn system/manger
@ $ ORACLE_HOME/sqlplus/admin/pupbld.sql
~
~
~
~
:wq
SQL > @ run

 

 

Procedure is created.

SQL > select count (*) from tab;

SQL > select * from dba_users;

Screenshot_34

 

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.

Screenshot_35

 

 

Screenshot_36

 

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.

 

Screenshot_37

 

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

Screenshot_38

 

catproc.sql
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

 

Screenshot_39

 

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 &

Screenshot_40

 

Screenshot_41

 

Screenshot_42

 

 

“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 info@tekslate.com, 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 *

    Support


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