The URL for the catalog database.
catalog.url=database_tag\://host:port/
where host is a server name or server plus domain name, depending on your requirements.
The following database tags are supported:
oracle—Oracle
db2—IBM DB2
sqlserver—Microsoft SQL Server
When your catalog database is Oracle using an Oracle ID (SID), the Oracle SID is appended to the catalog.url parameter, as follows:
catalog.url=oracle\://host\:port\:OracleSID
When your catalog database is Oracle using an Oracle Service Name, the Oracle Service Name is appended to the catalog.url parameter, as follows:
catalog.url=oracle\://host\:port/OracleServiceName
When your catalog database is located in an Oracle RAC instance, the catalog.url parameter appears as follows:
catalog.url= oracle\:// (DESCRIPTION=(LOAD_BALANCE=on) (ADDRESS=(PROTOCOL=TCP)(HOST=host1)(PORT=port-of-host1 [ (ADDRESS=(PROTOCOL=TCP)(HOST=host2)(PORT=port-of-host2)) [ (ADDRESS=(PROTOCOL=TCP)(HOST=hostN)(PORT=port-of-hostN)) ]...] (CONNECT_DATA=(SERVICE_NAME=service)))
When your catalog database is IBM DB2, the database name is appended to the catalog.url parameter, using the following syntax:
database tag://host:port;databaseName=database name
Oracle using SID:
catalog.url=oracle\://sequoia.efgco.com\:1521\:bpm catalog.url=oracle\://sequoia\:1521\:bpm
Oracle using Oracle Service Name:
oracle://aspen123.us.xyzco.com\:1521/epmdb.us.xyzco.com oracle://aspen123\:1521/epmdb.us.xyzco.com
Oracle RAC:
catalog.url=oracle\://(DESCRIPTION=(LOAD_BALANCE=on)(ADDRESS=(PROTOCOL=TCP)(HOST=host1)(PORT=1521))(ADDRESS=(PROTOCOL=TCP)(HOST=host2)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=service)))
IBM DB2:
catalog.url=db2\://cypress.abcco.com\:50000;databaseName=EPM_Db catalog.url=db2\://cypress\:50000;databaseName=EPM_Db
Microsoft SQL Server:
catalog.url=sqlserver\://aspen3.us.oracle.com\:1433 catalog.url=sqlserver\://aspen3\:1433
See Server Properties File Examples for specific RDBMS examples.