The script below could be added to a script file in order to set up environment variables prior to placing the script into a scheduled crontab cron job. #!/bin/ksh ORACLE_BASE=/<mount-point-1>/oracle ORACLE_HOME=$ORACLE_BASE/product/8.1.7 LD_LIBRARY_PATH=$ORACLE_HOME/lib:/usr/openwin/lib JAVA_HOME=$ORACLE_BASE/jre/1.1.8 TNS_ADMIN=/<mount-point-1>/oracle/product/8.1.7/network/admin ORACLE_SID=TEST ORACLE_DBF=/<mount-point-1>/oracle/oradata/$ORACLE_SID ORACLE_BACKUPS=/<mount-point-2>/backups ORACLE_SBIN=$ORACLE_HOME/sbin ORACLE_ALERT=$ORACLE_BASE/admin/$ORACLE_SID/bdump PATH=/bin:/usr/bin:/etc:/usr/ccs/bin:/usr/openwin/bin:/usr/ucb:/usr/local/bin:/usr/sbin:/usr/X/bin:$JAVA_HOME PATH=${PATH}:$ORACLE_HOME/bin:$ORACLE_HOME/sbin host=`hostname` if [ -z “$ORACLE_BASE” ] || [ -z “$ORACLE_HOME” ] || [ -z …
Monthly Archives: August 2015
Unix for Oracle
The Unix Environment Server monitoring can be done using a number of utilities. Those utilities are top, sar (system activitiy reporter),sadc, vmstat, the Unix (w)atch command, iostat, etc. Note that the results of these processes can parsed and placed into database tables on a scheduled basis for later statistical analysis. top last pid: 15713; load …
The Very Basics of Data Warehouse Design
[gview file=”http://oracledba.ezpowell.com/oracle/papers/TheVeryBasicsOfDataWarehouseDesign.doc”]
Denormalization
[gview file=”http://oracledba.ezpowell.com/oracle/papers/Denormalization.doc”]
Capacity Planning in Oracle
[gview file=”http://oracledba.ezpowell.com/oracle/papers/CapacityPlanning.doc”]
All About Indexes
[gview file=”http://oracledba.ezpowell.com/oracle/papers/AllAboutIndexes.doc”]
Creating a Logical Standby Database
[gview file=”http://oracledba.ezpowell.com/oracle/papers/CreatingLogicalStandbyIn9i.doc”]
Creating a Physical Standby Database
[gview file=”http://oracledba.ezpowell.com/oracle/papers/CreatingPhysicalStandbyIn9i.doc”]
Tuning Redo Log Sync Wait Events
So if you ask very specific and obscure technical questions and you’re not getting answers or you’re getting “don’t know” answers then you might want to figure out that the interviewee is not a walking Oracle manual – if you do come across someone who has memorized all the thousands and thousands of pages of …