Thursday, November 15, 2018

DBA Interview Questions

Steps to create database manually
1)Oracle software must be installed
2)  Create Parameter file in $ORACLE_HOME/dbs
3)Create Directory structure as per Pfile
4)Set environmental variables to connect to SID
5) Write Create Database script
6) Run Post DB create scripts
QL> ?@$ORACLE_HOME/rdbms/admin/catalog.sql
SQL> ?@$ORACLE_HOME/rdbms/admin/catproc.sql
QL> ?@$ORACLE_HOME/rdbms/admin/pupbld,sql

No comments:

Post a Comment