Hi Supriya,
Are you able to connect to database via any client tools like oracle SQL developer. Also PPM 13.1 was never tested to work with Oracle 12. Please perform the test below to see the exact reason
Instructions:
1. Go to the CSA > Properties > Application tab
2. At the end of the JVM Parameters for the CSA service (not the App service), add a space (' ') and then these values:
-Xdebug -Xnoagent -Djava.compiler=NONE -Xrunjdwp:transport=dt_socket,server=y,suspend=n,address=5005
3. Click Save.
4. Stop, deploy, and start the CSA service.
5. Navigate to the DWH properties page in the CSA.
6. At the putty terminal in the production server where the CSA was restarted, type:
jdb -connect com.sun.jdi.SocketAttach:hostname=localhost,port=5005
7. The following should probably appear with a prompt awaiting more information:
Initializing jdb ...
>
8. Type in the following command, making sure that the case sensitivity is precise:
stop at com.niku.nsa.util.NsaUtil:43
9. Go back to the CSA and click Save. This will likely not complete, you have to go back to the jdb program in putty now.
10. If at this point you see a message saying Breakpoint hit on com.niku.nsa.util.NsaUtil.getConnectionStatus(), line=43, perform the next two steps otherwise skip them.
11. Type in the following commands:
print e
print info
print dwhDatabaseId_
print db_.getUrl()
12. You should now see an Exception message displayed that either refers to a database or network issue to be addressed. It will also include the JDBC url being used, the credentials, and also whether the database ID is correctly Datawarehouse or null or niku or something else.
13. Type in the commands:
clear com.niku.nsa.util.NsaUtil:43
resume
quit
14. If no longer needed, you can now remove the JVM parameters that were added in the CSA and then stop/deploy/start the CSA services again