Download them from  http://www.ibm.com/developerworks/websphere/library/samples/SampleScripts.html

ex1.py  – Create and modify a server, load an application onto the server, and start the server.
ex2.py  – Reverse of ex1.p1 Stop a server on a given node, uninstalls the given application, and removes the server from the configuration.
ex3.py  – Creates a cluster and starts the server
ex4.py  – Demonstrate the invocation of some useful problem
determination actions involving traces and thread dumps.
ex5.py  – Demonstrate the invocation of various application install commands.
ex6.py  – Produce a short summary of some configuration and runtime information about the WebSphere installation.
ex7.py  – Create a JDBCProvider object using a template.
ex8.py  – Demonstrate J2C Security configuration, including the installation of a J2CResourceAdapter and creation of a J2CConnectionFactory.
ex9.py  – Demonstrate the creation of a JDBCProvider, DataSource and CMPConnectorFactory objects
ex10.py – Demonstrate the creation and use of a variable that is used in the creation of a URLProvider object.
ex11.py – Demonstrate the setting of various port numbers
ex12.py – Demonstrate methods for updating configuration attributes that are lists

Hierarchy : One off Patch -> Mini pack -> Family pack & Finally Maintenance Pack

Maintenance pack : Upgrade from one version to another . 12.0.2 -> 12.0.4

Family pack – Fixing the functional modules.FIN.B – Latest family pack for release 12 . FIN is financial B where B denotes the version -. For 11i HRPF.K – K is level of Module.

One off – One off issue

Mini Pack : Small functionality

Enhance functionality like VAT change. – One off else MINI pack. Apps patch is done by adpatch utility. Also look into readme file. “adpatch” is like opatch so can be copied from CD.

Read more…

[applmgr@ebs scripts]$ pwd
/oracle/u01/VIS/inst/apps/VIS_ebs/admin/scripts

[applmgr@ebs scripts]$ adapcctl.sh stop

You are running adapcctl.sh version 120.6.12000000.2

Stopping OPMN managed Oracle HTTP Server (OHS) instance …

adapcctl.sh: exiting with status 0

adapcctl.sh: check the logfile /oracle/u01/VIS/inst/apps/VIS_ebs/logs/appl/admin/log/adapcctl.txt for more information …

[applmgr@ebs scripts]$ adapcctl.sh status

You are running adapcctl.sh version 120.6.12000000.2 Read more…

(Release 12)

Login as database user
cd $ORACLE_HOME/appsutil/scripts/<SID_hostname>

./addbctl.sh start <Database Name> : To start Database

./addlnctl.sh start <Listener Name> : To start Listener

Login as apps user “applmgr”

cd $APPLCSF/scripts/<SID_hostname>
./adstrtal.sh apps/<apps_password>

You can stop the application by:
Login as apps user “applmgr”
./adstpall.sh apps/<apps_password>

For stopping listener and database:
./addlnctl.sh stop <listener_name> : Stop the listener

./addbctl.sh stop immediate : would carry “shutdown immediate” at database

================= Release 12 log ==============

[oracle@apps ~]$ . APPSVIS_ebs.env

Start database and listener before starting middle tier

Login as database user , Locate “addbctl.sh” and run this script

[oracle@apps ~]$ ./addbctl.sh

You are running addbctl.sh version 120.1

addbctl.sh: too few arguments specified.

addbctl.sh [start|stop] {normal|immediate|abort}

[oracle@apps ~]$ ./addbctl.sh start

You are running addbctl.sh version 120.1

Starting the database VIS …

SQL*Plus: Release 10.2.0.3.0 – Production on Sat Feb 14 13:07:25 2009

Copyright (c) 1982, 2006, Oracle. All Rights Reserved.

Connected to an idle instance.
ORACLE instance started.

Total System Global Area 159383552 bytes
Fixed Size 1260600 bytes
Variable Size 88081352 bytes
Database Buffers 58720256 bytes
Redo Buffers 11321344 bytes
Database mounted.
Database opened.
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 – Production
With the Partitioning, OLAP and Data Mining options

addbctl.sh: exiting with status 0

2. Start listener

[oracle@apps ~]$ cd /oradb/oracle/VIS/db/tech_st/10.2.0/appsutil/scripts/VIS_apps/
[oracle@apps VIS_apps]$ ./addlnctl.sh start VIS

You are running addlnctl.sh version 120.1

Logfile: /oradb/oracle/VIS/db/tech_st/10.2.0/appsutil/log/VIS_apps/addlnctl.txt

Starting listener process VIS …

addlnctl.sh: exiting with status 0
[oracle@apps VIS_apps]$

Let’s start the middle Tier

[applmgr@apps scripts]$ ./adstrtal.sh apps/apps

You are running adstrtal.sh version 120.13.12000000.3

Executing service control script:
/orapps/oracle/VIS/inst/apps/VIS_apps/admin/scripts/adopmnctl.sh start
script returned:
****************************************************

You are running adopmnctl.sh version 120.4.12000000.3

Starting Oracle Process Manager (OPMN) …

adopmnctl.sh: exiting with status 0

adopmnctl.sh: check the logfile /orapps/oracle/VIS/inst/apps/VIS_apps/logs/appl/admin/log/adopmnctl.txt for more information …

.end std out.

.end err out.

****************************************************

Executing service control script:
/orapps/oracle/VIS/inst/apps/VIS_apps/admin/scripts/adapcctl.sh start
script returned:
****************************************************

You are running adapcctl.sh version 120.6.12000000.2

Starting OPMN managed Oracle HTTP Server (OHS) instance …

adapcctl.sh: exiting with status 150

adapcctl.sh: check the logfile /orapps/oracle/VIS/inst/apps/VIS_apps/logs/appl/admin/log/adapcctl.txt for more information …

.end std out.

.end err out.

****************************************************

Executing service control script:
/orapps/oracle/VIS/inst/apps/VIS_apps/admin/scripts/adoacorectl.sh start
script returned:
****************************************************

You are running adoacorectl.sh version 120.11.12000000.2

Starting OPMN managed OACORE OC4J instance …

adoacorectl.sh: exiting with status 204

adoacorectl.sh: check the logfile /orapps/oracle/VIS/inst/apps/VIS_apps/logs/appl/admin/log/adoacorectl.txt for more information …

.end std out.

.end err out.

****************************************************

Executing service control script:
/orapps/oracle/VIS/inst/apps/VIS_apps/admin/scripts/adformsctl.sh start
script returned:
****************************************************

You are running adformsctl.sh version 120.12.12000000.3

Starting OPMN managed FORMS OC4J instance …

adformsctl.sh: exiting with status 204

adformsctl.sh: check the logfile /orapps/oracle/VIS/inst/apps/VIS_apps/logs/appl/admin/log/adformsctl.txt for more information …

.end std out.

.end err out.

****************************************************

Executing service control script:
/orapps/oracle/VIS/inst/apps/VIS_apps/admin/scripts/adoafmctl.sh start
script returned:
****************************************************

You are running adoafmctl.sh version 120.6.12000000.2

Starting OPMN managed OAFM OC4J instance …

adoafmctl.sh: exiting with status 204

adoafmctl.sh: check the logfile /orapps/oracle/VIS/inst/apps/VIS_apps/logs/appl/admin/log/adoafmctl.txt for more information …

.end std out.

.end err out.

****************************************************

Executing service control script:
/orapps/oracle/VIS/inst/apps/VIS_apps/admin/scripts/adalnctl.sh start
script returned:
****************************************************

adalnctl.sh version 120.3

Checking for FNDFS executable.
Starting listener process APPS_VIS.

adalnctl.sh: exiting with status 0

adalnctl.sh: check the logfile /orapps/oracle/VIS/inst/apps/VIS_apps/logs/appl/admin/log/adalnctl.txt for more information …

.end std out.

.end err out.

****************************************************

Executing service control script:
/orapps/oracle/VIS/inst/apps/VIS_apps/admin/scripts/adcmctl.sh start
script returned:
****************************************************

You are running adcmctl.sh version 120.14

Starting concurrent manager for VIS …
Starting VIS_0214@VIS Internal Concurrent Manager
Default printer is noprint

adcmctl.sh: exiting with status 0

adcmctl.sh: check the logfile /orapps/oracle/VIS/inst/apps/VIS_apps/logs/appl/admin/log/adcmctl.txt for more information …

.end std out.

.end err out.

****************************************************

Executing service control script:
/orapps/oracle/VIS/inst/apps/VIS_apps/admin/scripts/jtffmctl.sh start
script returned:
****************************************************

You are running jtffmctl.sh version 120.3

Validating Fulfillment patch level via /orapps/oracle/VIS/apps/apps_st/comn/java/classes
Fulfillment patch level validated.
Starting Fulfillment Server for VIS on port 9300 …

jtffmctl.sh: exiting with status 0

.end std out.

.end err out.

****************************************************

adstrtal.sh: Exiting with status 4

adstrtal.sh: check the logfile /orapps/oracle/VIS/inst/apps/VIS_apps/logs/appl/admin/log/adstrtal.log for more information …

(Release 11)

Execute the following script in the sequence shown below

$ORACLE_HOME/appsutil/scripts/VIS_vision/addbctl.sh start $ORACLE _HOME/appsutil/scripts/VIS_vision/addlnctl.sh start VIS /u01/oracle/viscomn/admin/scripts/VIS_vision/adstrtal.sh apps/apps

To stop the services execute the script in the following sequence.

/u01/oracle/viscomn/admin/scripts/VIS_vision/adstpall.sh apps/apps $ORACLE_HOME/appsutil/scripts/VIS_vision/addlnctl.sh stop VIS $ORACLE_HOME/appsutil/scripts/VIS_vision/addbctl.sh stop immediate

Installation
The following scripts must be run as a user with SYSDBA privilege:
* SPCREATE.SQL: Creates entire Statspack environment (calls SPCUSR.SQL, SPCTAB.SQL, SPCPKG.SQL) * SPDROP.SQL: Drops entire Statspack environment (calls SPDTAB.SQL, SPDUSR.SQL)

The following scripts are run as a user with SYSDBA privilege by the preceding calling scripts:
* SPDTAB.SQL: Drops Statspack tables
* SPDUSR.SQL: Drops the Statspack user (PERFSTAT)

The following scripts are run as PERFSTAT by the preceding calling scripts:
* SPCUSR.SQL: Creates the Statspack user (PERFSTAT)
* SPCTAB.SQL: Creates Statspack tables
* SPCPKG.SQL: Creates the Statspack package

Scripts for Statspack Reporting and Automation

The following scripts must be run as PERFSTAT:
* SPREPORT.SQL: Generates a Statspack report
* SPREPSQL.SQL: Generates a Statspack SQL report for the specific SQL hash value specified
* SPREPINS.SQL: Generates a Statspack report for the database and instance specified
* SPAUTO.SQL: Automates Statspack statistics collection (using DBMS_JOB)

Scripts for Statspack Performance Data Maintenance
The following scripts must be run as PERFSTAT:
* SPPURGE.SQL: Purges a limited range of Snapshot IDs for a given database instance.
* SPTRUNC.SQL: Truncates all performance data in Statspack tables

Read more…