Hi Gustavo.de.Almeida-DATAPREV
This is due to your DB parameters. Ensure they are set as in the installation guide.
CA PPM 15.1 is very sensible to db parameters. If they are not 100% correct, csk (PMO) hangs on "driver.xml" when installing.
https://docops.ca.com/ca-ppm/15-1/en/installing-and-upgrading/set-up-the-ca-ppm-database
Set the Required Oracle Database Parameters
Set the required parameters in the following table for your new database:
Name | Value |
---|
Character Set | AL32UTF8 |
National Character Set | UTF8/AL16UTF16 |
nls_date_format | YYYY-MM-DD HH24:MI:SS |
nls_sort | BINARY |
nls_comp | BINARY |
query_rewrite_enabled | true |
Cursor_sharing | FORCE |
Set the following parameter values to optimize performance when running CA PPM Release 15.1 with Oracle 12.1.0.2.
- optimizer_adaptive_features=false
- optimizer_inmemory_aware=false
- optimizer_adaptive_reporting_only=true
InitNIKU.ORA Parameter File Samples with Recommended Settings
The following initNIKU.ora file uses Automatic Memory Management (AMM). The following samples are the recommended parameter settings. However, you can adjust the settings according to your environment.
Windows
*.audit_file_dest='C:\apps\oracle\admin\niku\adump' *.audit_trail='db' *.compatible='11.2.0' *.control_files='C:\apps\oracle\oradata\niku\control01.ctl','C:\apps\oracle\oradata\niku\control02.ctl' *.cursor_sharing='FORCE' *.db_block_size=8192 *.db_domain='' *.db_name='niku' *.diagnostic_dest='C:\apps\oracle' *.job_queue_processes=20 *.memory_max_target=16G *.memory_target=12G *.nls_comp='binary' *.nls_date_format='YYYY-MM-DD HH24:MI:SS' *.nls_sort='binary' *.open_cursors=1000 *.processes=1000 *.remote_login_passwordfile='EXCLUSIVE' *.sessions=1000 *.session_cached_cursors=1000 *.sga_max_size=0 *.sort_area_size=0 *.streams_pool_size=512M
Linux (Non-Windows)
*.compatible='11.2.0' *.control_files='/niku/oracle/oradata/niku/control01.ctl','/niku/oracle/oradata/niku/control02.ctl','/niku/oracle/oradata/niku/control03.ctl' *.core_dump_dest='/niku/oracle/admin/niku/cdump' *.cursor_sharing='FORCE' *.db_block_size=8192 *.db_cache_size=16777216 *.db_domain='' *.db_file_multiblock_read_count=16 *.db_name='niku' *.diagnostic_dest='/niku/oracle/admin/niku/udump' *.filesystemio_options='SetAll' *** for non ASM instances. *.job_queue_processes=20 *.memory_max_target=16G *.memory_target=12G *.nls_comp='binary' *.nls_date_format='YYYY-MM-DD HH24:MI:SS' *.nls_sort='binary' *.open_cursors=1000 *.processes=1000 *.remote_login_passwordfile='EXCLUSIVE' *.sessions=1000 *.session_cached_cursors=1000 *.sga_max_size=0 *.sga_target=0 *.sort_area_size=0 *.streams_pool_size=512M *.undo_management='AUTO' *.undo_tablespace='UNDOTBS1' *** The memory target and tablespace sizes can be adjusted depending upon the customer implementation. If customers are using Linux Huge pages, the DBA can disable AMM and use SGA and PGA instead, until Oracle supports AMM and Linux Huge pages. SQLNET.ora parameters: NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT) SQLNET.INBOUND_CONNECT_TIMEOUT = 0 SQLNET.SEND_TIMEOUT = 600 (Applicable for Oracle 11.2.0.4, Oracle Bug 18841764)