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. |