Database Creation

Database can be created in 4 ways: Command line DBCA(database configure assistant) OMF database ASM Database 1.Command line: In command line we have to set the all parameters to create the database Set environment file: #su – oracle $mkdir test (create directory for database) $vi login.sql Set sqlp”_user’@’_Connect_identifier>” Define_editor = …

Read More »


P FILE A P FILE is a traditional text based init.ora parameter file. Typically this resides on the server in the $ORACLE_BASE/admin/SID/p file directory, with a symbolic link pointing to it from the $ORACLE_HOME/dbs directory. SP FILE A SP FILE, Server Parameter File, is a server managed binary file that …

Read More »

Oracle Architecture and Adminstration

Oracle Architecture and Administration 1.1 Duties of a database administrator Now that we have we fairly good understanding about what the Oracle 10g database is used for and how users can interact with it. We now move on to what this book aims to teach you, i.e. basic administration of …

Read More »

Disk Group Administration

Disk Group Administration OCR Voting Disk ASM Parameter file All above files will stored Shared Drive. If you want to add one or more physical disk Fdisk Oracleasm Create DATA DG1 with External. CLICK OK. New Disk is add to ASM Read More: Linux Installation Install Database Software Only Oracle …

Read More »

RAC Administration

Cluster ware provide the services to manage cluster. Cluster Management Node Monitoring Event Services CTS (Cluster Time Syn) Network Management High Availability Shared Disk + Load Balancing Cluster Active / Active Active / Passive Shared drive   OCR , Voting Disk Voting Disk – Records “heart – beat” information all nodes …

Read More »

Openfiler Installation steps

Openfiler Installation steps ENTER /boot – 100MB /tmp – 1gb / – 1gb Remaining leave it. This free space for storage for SAN Give force YES option Open this web url any one of the node1 or node2 username: openfiler password: password Needs to configure …

Read More »

Oracle RAC Architecture

Local Resource :-It can be acted without consult to other instances. Local resource is a resource that is accessible to only one instance within the cluster. Global Resource :- this will consult to another instance.(both instances). It can be an area in memory.A resource can be owned or locked in …

Read More »

Linux Installation on Oracle Virtual box

LINUX Installation

Node1 PUBLIC        , SUBNET PRIVATE       , SUBNET Node2 PUBLIC         , SUBNET PRIVATE        , SUBNET This Ip address are for two servers, but here we are installing only one server named as Node 1 ( Server name )           added two …

Read More »

Install Database Software Only

root#crsctl check cluster – all root#xhost + we have to create disk groups root#su – grid —from grid user on both nodes NODE1,NODE2 grid$vi .bash_profile export ORACLE_BASE=/u01/app/grid export ORACLE_HOME=/u01/app/11.2.0/grid export PATH=$PATH:$ORACLE_HOME/bin :wq! $which asmca —from oracle user on both nodes NODE1,NODE2 oracle$vi .bash_profile export ORACLE_BASE=/u01/app/oracle export ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1/ export PATH=$PATH:$ORACLE_HOME/bin :wq! …

Read More »

Oracle Grid GI Installation Steps

Oracle Grid GI Installation Steps Go to the software location With Grid user run Installer —if issue comes on orainventory then you can follow below steps on node1 and node2 from root user. mkdir -p /u01/app/oraInventory/ chown -R grid:oinstall /u01/app/oraInventory/ Verifying the nodes before install GRID Infrastructure installed successfully. Verify …

Read More »
Subscribe To Newsletter
Be the first to get latest updates and exclusive content straight to your email inbox.
Stay Updated
Give it a try, you can unsubscribe anytime.

Your information will never be shared
Sign-up for exclusive content. Be the first to hear about DBA Centre Blogs.