61.5 Troubleshooting an Issue When server.xml file Is Not Updated with a Non-Default Port Specified During Identity Reporting Installation

Issue	Suggested Actions
If you specify a different port for the Oracle database (for example,1523) than the default port (1521) when installing Identity Reporting, the new port is not written to the connection URL string in the server.xml file. The sever.xml file contains entries similar to this: <Resource auth="Container" driverClassName="oracle.jdbc.OracleDriver" factory="com.netiq.tomcat.jdbc.pool.CustomBasicDataSourceFactory" initialSize="10" maxIdle="10" maxTotal="50" maxWaitMillis="30000" minIdle="10" name="shared/IDMRPTDataSource" password="/PiJIywBYaZA1MvOKlh5uQ==:ohTS0Kj6+PKzeEwYDkpu0A==:LhYVfBbtVivhX9IukfmuiQ==" testOnBorrow="true" type="javax.sql.DataSource" url="jdbc:oracle:thin:@192.168.32.235:1521/orcl" username="idm_rpt_data" validationInterval="120000" validationQuery="SELECT 1 from DUAL"/> <Resource auth="Container" driverClassName="oracle.jdbc.OracleDriver" factory="com.netiq.tomcat.jdbc.pool.CustomBasicDataSourceFactory" initialSize="10" maxIdle="10" maxTotal="50" maxWaitMillis="30000" minIdle="10" name="shared/IDMRPTCfgUpdateSource" password="SxthAeVNFznTIsmlI/Zgzw==:IpRocpIeUAETDqEc4pWArQ==:kStd+CafPm/qI9RIaGfnFA==" testOnBorrow="true" type="javax.sql.DataSource" url="jdbc:oracle:thin:@192.168.32.235:1521/orcl" username="idm_rpt_cfg" validationInterval="120000" validationQuery="SELECT 1 from DUAL"/> <Resource auth="Container" driverClassName="oracle.jdbc.OracleDriver" factory="com.netiq.tomcat.jdbc.pool.CustomBasicDataSourceFactory" initialSize="10" maxIdle="10" maxTotal="50" maxWaitMillis="30000" minIdle="10" name="shared/IDMRPTCfgDataSource" password="3NkqNV+halUUkP9W3A2O6A==:j4YLuRc5JShrUWurg2wQmA==:7stEUCrG7EVkSIayRU3J2A==" testOnBorrow="true" type="javax.sql.DataSource" url="jdbc:oracle:thin:@192.168.32.235:1521/orcl" username="idmrptuser" validationInterval="120000" validationQuery="SELECT 1 from DUAL"/> </GlobalNamingResources>	Manually change the port in the server.xml file.

Issue

Suggested Actions

If you specify a different port for the Oracle database (for example,1523) than the default port (1521) when installing Identity Reporting, the new port is not written to the connection URL string in the server.xml file.

The sever.xml file contains entries similar to this:

<Resource auth="Container" driverClassName="oracle.jdbc.OracleDriver" factory="com.netiq.tomcat.jdbc.pool.CustomBasicDataSourceFactory" initialSize="10" maxIdle="10" maxTotal="50" maxWaitMillis="30000" minIdle="10" name="shared/IDMRPTDataSource" password="/PiJIywBYaZA1MvOKlh5uQ==:ohTS0Kj6+PKzeEwYDkpu0A==:LhYVfBbtVivhX9IukfmuiQ==" testOnBorrow="true" type="javax.sql.DataSource" url="jdbc:oracle:thin:@192.168.32.235:1521/orcl" username="idm_rpt_data" validationInterval="120000" validationQuery="SELECT 1 from DUAL"/>
<Resource auth="Container" driverClassName="oracle.jdbc.OracleDriver" factory="com.netiq.tomcat.jdbc.pool.CustomBasicDataSourceFactory" initialSize="10" maxIdle="10" maxTotal="50" maxWaitMillis="30000" minIdle="10" name="shared/IDMRPTCfgUpdateSource" password="SxthAeVNFznTIsmlI/Zgzw==:IpRocpIeUAETDqEc4pWArQ==:kStd+CafPm/qI9RIaGfnFA==" testOnBorrow="true" type="javax.sql.DataSource" url="jdbc:oracle:thin:@192.168.32.235:1521/orcl" username="idm_rpt_cfg" validationInterval="120000" validationQuery="SELECT 1 from DUAL"/>
<Resource auth="Container" driverClassName="oracle.jdbc.OracleDriver" factory="com.netiq.tomcat.jdbc.pool.CustomBasicDataSourceFactory" initialSize="10" maxIdle="10" maxTotal="50" maxWaitMillis="30000" minIdle="10" name="shared/IDMRPTCfgDataSource" password="3NkqNV+halUUkP9W3A2O6A==:j4YLuRc5JShrUWurg2wQmA==:7stEUCrG7EVkSIayRU3J2A==" testOnBorrow="true" type="javax.sql.DataSource" url="jdbc:oracle:thin:@192.168.32.235:1521/orcl" username="idmrptuser" validationInterval="120000" validationQuery="SELECT 1 from DUAL"/>
</GlobalNamingResources>

Manually change the port in the server.xml file.