Create new oracle instance or On demand instance.

Note: 
1) Requires oracle version as an input.

2) Please provide catalog_user, catalog_pwd and catalog_service only when catalog_connect is yes. Do not provide it when catalog connect option is no. See examples 1 and 2 below.

3) When SQl connect string is "/" do not provide oracle_pwd and oracle_service. Example 4.

4) The option host_user_name is local/domain administrator user name for Windows client, and it is oracle user for Unix client. The host password need not be provided for unix clients (option [-p2 host_pwd] ) Example 3.

Usage:
qoperation execscript -sn CreateOracleInstance.sql -si client_name -si instance_name 
	-si oracle_home -si Oracle_version
	-si default_Storage_policy -si log_storage_policy -si cmd_storage_policy
	-si SQL_connection_user(user to login sqlplus) -p2 SQL_connection_pwd -si Oracle_service
	-si yes/no(catalog_connect) [-si catalog_user] [-p2 catalog_pwd] [-si catalog_service]
	-si host_user_name [-p2 host_pwd]


Example:

1)No catalog connect used (windows):


qoperation.exe execscript -sn CreateOracleInstance.sql -si My_client -si my_instance -si C:\oracle\product\10.2.0\db_3 -si  11.1.0.6.0 -si my_data_SP -si my_log_sp -si my_cmd_sp -si sys -p2 pwd -si COMMV -si no -si myDomain\administrator -p2 pwd


2)Using catalog connect (windows):


qoperation.exe execscript -sn CreateOracleInstance.sql -si My_client -si my_instance -si C:\oracle\product\10.2.0\db_3 -si  11.1.0.6.0 -si my_data_SP -si my_log_sp -si my_cmd_sp -si sys -p2 pwd -si COMMV -si yes -si catalog_user_name -p2 catalog_user_pwd -si oracle_service -si myDomain\administrator -p2 pwd


3) Using catalog connect (unix):


qoperation.exe execscript -sn CreateOracleInstance.sql -si My_client -si my_instance -si /opt/oracle/home/10.2.0/db_3 -si  11.1.0.6.0 -si my_data_SP -si my_log_sp -si my_cmd_sp -si sys -p2 pwd -si COMMV -si yes -si sys -p2 pwd -si COMMV -si ORACLE_USER 


4) Using "/" as the connection string(with catalog connect, windows):


qoperation.exe execscript -sn CreateOracleInstance.sql -si My_client -si my_instance -si C:\oracle\product\10.2.0\db_3 -si  11.1.0.6.0 -si my_data_SP -si my_log_sp -si my_cmd_sp -si / -si yes -si sys -p2 pwd -si COMMV -si myDomain\administrator -p2 pwd

 
5) create on demand instance:


qoperation.exe execscript -sn CreateOracleInstance.sql -si My_client -si "On Demand Instance"