Cognos Planning 10.1.1 fix pack 3
Windows 2008 R2 server
There is a difference in time to do import of deployment packages in the Cognos Planning PROD and DEV environments. In Production it takes 1 minute, in Development servers it take 40 minutes.
On the Cognos Planning server there is little use of CPU or Memory, also on the Oracle server there is little use of CPU and Memory. It looks like it is waiting.
The time between the step “Creating…” and “Created…” in CAC Monitor Console Deployments is the one that take time because of this.
In the file SQLNET.ORA the search order is defined to access the Oracle database.
If there are firewalls between the DEV servers and the PROD DNS/LDAP servers, then this can happen if the LDAP is first in the list. The Oracle client need to time out before it will look into the TNSNAMES file on the server to find the Oracle database.
Open the file C:\orarun\tnsadmin\sqlnet.ora on the Cognos servers
NAMES.DIRECTORY_PATH= (LDAP, TNSNAMES, EZCONNECT, HOSTNAME)
NAMES.DIRECTORY_PATH= ( TNSNAMES, EZCONNECT, HOSTNAME)
Save the file.
Test to use the deployment import again in Cognos Planning.
Then it should be faster.