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;

   Dump destination is the 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.

Inclined to build a profession as Oracle DBA Training? Then here is the blog post on, explore Oracle DBA Training

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

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

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

Shutdown normal: shuts down the database, after all the users terminated all the sessions.

Catalog.sql

contains no tables, but contains, only views like user  

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 database can maintain multiple   block sizes

CPU Work

in a day not more than 60%

in night 100%

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

For an in-depth knowledge, click on below

• Oracle DBA Interview Questions
• Introduction to Oracle 10g DBA
• Create database link Oracle DBA
• Client-server computing in Oracle DBA