Create Database on Oracle server named TWS with Tablespaces of TWS_DATA and TWS_TEMP
Create user oracle on TWS server
Create user batch on TWS server
Install Oracle 10.2.0.3 on the TWS server - use advanced options to deselect enterprise options and do not create a db
Add the following to /etc/oratab:
dummy:/opt/oracle/product/10.2.0:N
Add the following to the oracle user's .bash_profile:
export ORAENV_ASK=NO; export ORACLE_SID=dummy; . oraenv
Update oracle user environment by running:
$ source .bash_profile
Create a tnsnames.ora file in /apps/oracle/product/10.2.0/network/admin which contains the following:
# TNSNAMES.ORA Network Configuration File: C:oracleora92networkadmintnsnames.ora
# Generated by Oracle configuration tools.
TWS.ORACLESERVERNAME =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = oracleservername)(PORT = 1521))
)
(CONNECT_DATA =
(SID = TWS)
(SERVER = DEDICATED)
)
)
mkdir /opt/tws
chown batch.batch /opt/tws
Install TWS 8.3
install for user batch
point to TWS.oradev for the database
install path /opt/tws
user system for oracle admin
use batch_tws user for TWS oracle user
enter TWS_DATA for the TWS data tablespace
enter TWS_TEMP for the TWS temp tablespace
Documentation for TWS http://publib.boulder.ibm.com/infocenter/tivihelp/v3r1/index.jsp?toc=/com.ibm.tivoli.itws.doc/toc.xml
Cleanup Commands: do not do in production:
ResetPlan –scratch
StartUp
Get things started after reset (only on a new setup):
JnextPlan
Set limit:
conman
lc ;10
Do a test command job from conman:
sbd “ls”;logon=batch
Do a test script job from conman:
sbf “/path/to/script.sh”;logon=batch
Do this when resetting plan for the day and do not want to extend (if there is a problem)
JnextPlan -for 0000 # To not extend the plan (i.e. just reset for today)
Show schedule
ss
Show jobs
sj
No comments:
Post a Comment