The installinstance command takes an xml file with the instance configuration as an argument. The following gives an example of such files.

Example format for Oracle:


<instance>
  <given-name>Oracle test instance</given-name>
  <group-name>Test</group-name>
  <sub-group-name></sub-group-name>
  <dbms-type>oracle</dbms-type>
  <connection-info>
    <port>1521</port>
    <host>192.168.0.203</host>
    <sid>ORCL11GD</sid>
  </connection-info>
  <admin>
    <authentication>
      <operator>admin</operator>
      <username>sys as sysdba</username>
      <password>mysyspassword</password>
    </authentication>
    <framework-placement>dbwatch</framework-placement>
  </admin>
  <sql>
    <authentication>
      <operator>admin</operator>
      <username>sys as sysdba</username>
      <password>mysyspassword</password>
    </authentication>
  </sql>
  <report>
    <authentication>
      <operator>admin</operator>
      <username>dbwatch</username>
      <password>mypassword</password>
    </authentication>
  </report>
  <monitoring-engine>
    <username>dbwatch</username>
    <password>mypassword</password>
    <adm-username>sys as sysdba</adm-username>
    <adm-password>mysyspassword</adm-password>
    <inst-user>sys as sysdba</inst-user>
    <tablespace>
      <tablespace-name>dbw_ole_220414</tablespace-name>
      <tablespace-location>/u02/oradata/ORCL11GD/</tablespace-location>
      <tablespace-size>50</tablespace-size>
      <tablespace-maxsize>500</tablespace-maxsize>
      <tablespace-autoextensible>YES</tablespace-autoextensible>
      <tablespace-filename>dbwatch.DBF</tablespace-filename>
    </tablespace>
  </monitoring-engine>
  <properties>
    <authentication>
      <username>dbwatch</username>
      <password>mypassword</password>
    </authentication>
  </properties>
</instance>

Example format for SQLServer:


<instance>
  <given-name>SQLServer test instance</given-name>
  <dbms-type>sqlserver</dbms-type>
  <group-name>Test</group-name>
  <sub-group-name></sub-group-name>
  <connection-info>
    <port-or-instance>59348</port-or-instance>
    <host>localhost</host>
  </connection-info>
  <admin>
    <authentication>
      <operator>admin</operator>
      <auth-mode>sqlserver</auth-mode>
      <login>sa</login>
      <password>mysapassword</password>
    </authentication>
    <framework-placement>dbwatch</framework-placement>
  </admin>
  <sql>
    <authentication>
      <operator>admin</operator>
      <auth-mode>sqlserver</auth-mode>
      <login>sa</login>
      <password>mysapassword</password>
    </authentication>
  </sql>
  <report>
    <authentication>
       <operator>admin</operator>
       <auth-mode>sqlserver</auth-mode>
       <login>dbwatch</login>
       <password>mypassword</password>
    </authentication>
  </report>
  <monitoring-engine>
    <auth-mode>sqlserver</auth-mode>
    <database>dbwatch</database>
    <login>dbwatch</login>
    <password>mypassword</password>
    <adm-login>sa</adm-login>
    <adm-password>mysapassword</adm-password>
    <inst-login>sa</inst-login>
    <databases>
      <database>dbwatch</database>
      <data-location>C:\Program Files\Microsoft SQL Server\MSSQL11.SQLEXPRESS\MSSQL\DATA\</data-location>
      <log-location>C:\Program Files\Microsoft SQL Server\MSSQL11.SQLEXPRESS\MSSQL\DATA\</log-location>
      <log-size>50</log-size>
      <data-size>50</data-size>
      <log-size-max>500</log-size-max>
      <data-size-max>500</data-size-max>
    </databases>
  </monitoring-engine>
  <properties>
     <authentication>
       <auth-mode>sqlserver</auth-mode>
	   <login>dbwatch</login>
	   <password>mypassword</password>
	</authentication>
  </properties>
</instance>

The auth-mode tag can have two values sqlserver or windows. When auth-mode is sqlserver, a username and password must also be defined. When using auth-mode windows, OS authentication is used and there is no need to provide a username and password.

Feedback

Was this helpful?

Yes No
You indicated this topic was not helpful to you ...
Could you please leave a comment telling us why? Thank you!
Thanks for your feedback.

Post your comment on this topic.

Post Comment