Resolution:
Please first read "Chapter 3 Setting up an Administration Server with a Database Backend" in the "TIBCO Administrator Installation Guide." Here is extra information you may need to know.

Please Note that database backend is supported only for the application repository, not for the domain repository, which means you will not be able to perform user management, resource management and application management. There will be no Administrator GUI login available for you to perform these actions as for a file based TIBCO Administrator. Moreover, there is no security available for database backend. If you are familiar with the previous TIBCO Repository, the TIBCO Administrator with database backend essentially only provides the same application repository service.

The following provides the detailed instructions on how to install and configure a database backend. This is only supplemental to the original documentation on a database backend.

Install either the Repository Edition or Enterprise Edition of TIBCO Administrator. At the end of the installation, the installer will automatically launch the TIBCO Domain Utility for server configuration. You will be prompted with:

"Would you like to enable User and Resource Management?"

You need to Select "No", then proceed with the rest of the installation process. If you select "Yes", TIBCO Administrator will not work.

After the installation is finished, you need to open the tibcoadmin_&ltserver or domain name>.tra file under &ltTIBCO_HOME>/administrator/5.1/bin directory and make the following changes:

1. Make sure "repo.isSecurityEnabled=false" is set. The "false" value is set by default. If you change it to "true", TIBCO Administrator will not start.

2. Configure JDBC driver, for example, for Oracle:

If you choose to use the TIBCO bundled JDBC driver, set
    repo.jdbcDriver tibcosoftwareinc.jdbc.oracle.OracleDriver

If you choose to use the Oracle JDBC driver, first append the absolute path of the driver class to tibco.class.path.extended (for example, /opt/oracle/app/oracle/product/8.1.7/jdbc/lib/classes12.zip) then set
    repo.jdbcDriver oracle.jdbc.driver.OracleDriver

3. Configure JDBC URL, for example, for Oracle:

If you choose to use the TIBCO bundled JDBC driver, set
    repo.jdbcURL jdbc:tibcosoftwareinc:oracle://&lthost>:&ltport>SID=&ltdbname>

If you choose to use the Oracle JDBC driver, set
    repo.jdbcURL jdbc:oracle:thin:@&lthost>:&ltport>:&ltdbname>

4. Continue to specify repo.username, repo.password, and repo.dbtype.

Before you can start TIBCO Administrator, you also need to initialize the database. The database initialization tools are available under &ltTIBCO_HOME>/administrator/5.1/bin directory. For example, for Oracle,

If you choose to use the TIBCO bundled JDBC driver, run

repooracleinit tibcosoftwareinc.jdbc.oracle.OracleDriver "jdbc:tibcosoftwareinc:oracle://&lthost>:&ltport>SID=&ltdbname>" &ltuser_name> &ltuser_password>

If you choose to use the Oracle JDBC driver, run

repooracleinit oracle.jdbc.driver.OracleDriver "jdbc:oracle:thin:@&lthost>:&ltport>:&ltdbname>" &ltuser_name> &ltuser_password>

Please note you have to double quote the string for JDBC URL.

Now you can start TIBCO Administrator. The following is more information for other JDBC drivers bundled with TIBCO TRA:

Sybase:
    Driver: tibcosoftwareinc.jdbc.sybase.SybaseDriver
    DB URL: jdbc:tibcosoftwareinc:sybase://&lthost>:&ltport#>databaseName=&ltdatabaseName>

SQL Server:
    Driver: tibcosoftwareinc.jdbc.sqlserver.SQLServerDriver
    DB URL: jdbc:tibcosoftwareinc:sqlserver://&lthost>:&ltport#>databaseName=&ltdatabaseName>

What features are supported by 5.1.2 Administrator with a database backend and how to configure it?