Oracle apps admin

Page 1

Oracle Application Administrator Free Tutorials


1. Database Tier 1.1. Set Environment Variables $ cd /u01/oracle/ visdb/9.2.0 $. ./VIS_vision.env $ echo $ORACLE_HOME /u01/oracle/ visdb/9.2.0 1.2. Files in ORACLE_HOME 1.2.1. My SID = VIS and HOST is Vision To view SI D $ echo $ORACLE_SID VIS


Complete Recovery

Here I will delete all the data files and will restore from the backup we taken above. Rename all data files with mv command in Linux. This is just to have a backup with us.


1. 11i 1.1. Execute the following script in the sequence shown below, /u01/oracle/ visdb/9.2.0/appsutil/scripts/VIS_vision/addbctl.sh start /u01/oracle/ visdb/9.2.0/appsutil/scripts/VIS_vision/addlnctl.sh start VIS /u01/oracle/ viscomn/admin/ scripts/VIS_vision/adstrtal.sh apps/apps 1.2. To stop the services execute the script in the following sequence. /u01/oracle/ viscomn/admin/ scripts/VIS_vision/adstpall.sh apps/apps /u01/oracle/ visdb/9.2.0/appsutil/scripts/VIS_vision/addlnctl.sh stop VIS /u01/oracle/ visdb/9.2.0/appsutil/scripts/VIS_vision/addbctl.sh stop immediate 2. R12 2.1. The following scripts are used to Start services. /d01/oracle/VIS/db/ tech_st/10.2.0/appsutil/ scripts/VIS_vision/addbctl.sh start /d01/oracle/VIS/db/ tech_st/10.2.0/appsutil/ scripts/VIS_vision/addlnctl.sh start VIS /d01/oracle/VIS/ inst/apps/VIS_vision/admin/ scripts/adstrtal.sh apps/apps


 Patching  Client

Setup  Cloning  VNC Configuration  OS Auto Login  NFS Configuration  Oracle ADI Setup


Display Setting Report Integration

Please Visit: http://bit.ly/1yUV4Lf


Turn static files into dynamic content formats.

Create a flipbook
Issuu converts static files into: digital portfolios, online yearbooks, online catalogs, digital photo albums and more. Sign up and create your flipbook.