AnsweredAssumed Answered

Upgrade Failed- error (2): Connection Refused

Question asked by Uruj on Dec 14, 2012
Latest reply on Mar 14, 2014 by kp1
Hi,

Our upgrade from 12.0.4 to 13.0.1 is failing with error (from install.log):
Command: install database schema file
To URL:
jdbc:clarity:oracle://localhost:1521;SID=NIKU;BatchPerformanceWorkaround=true;
InsensitiveResultSetBufferSize=0;ServerType=dedicated;supportLinks=true
As user: niku
For vendor: oracle

Process:
D:\DVD01135604M\install-packages\12.1.1\upgrade-repack.12.1.1.1208\upgrade\12.
1.1\preupgrade/PREUPGRADE_VALIDATE_FIN_PLANS_DATA.xml

Total time: 0H:0M:4S
Exception in thread "main" java.sql.SQLException: [CA Clarity][Oracle JDBC
Driver]Error establishing socket to host and port: localhost:1521. Reason:
Connection refused: connect.

In properties.xml though, we have only one database entry (for port 1524);
following entry is being made itself for port 1521:

added by us:[b] <database id="CLARITY" useURL="false" jndiDatabaseId="jdbc/NikuDS"
vendor="oracle" serviceName="CLARITY" serviceId="CLARITY" instanceName=""
driver="com.ca.clarity.jdbc.oracle.OracleDriver"
url="jdbc:clarity:oracle://10.10.4.9:1524;SID=CLARITYU;BatchPerformanceWorkaro
und=true;InsensitiveResultSetBufferSize=0;ServerType=dedicated;supportLinks=tr
ue" username="niku1" password="nikupw" schemaName="CLARITY"/>

added in properties.xml automatically after installation begins:
<database id="Niku" jndiDatabaseId="jdbc/NikuDS" vendor="oracle"
serviceName="niku" serviceId="niku"
driver="com.ca.clarity.jdbc.oracle.OracleDriver"
url="jdbc:clarity:oracle://localhost:1521;SID=NIKU;BatchPerformanceWorkaround=
true;InsensitiveResultSetBufferSize=0;ServerType=dedicated;supportLinks=true"
username="niku" password="niku" schemaName="niku"/>

and with the above the values the connection is refused and the upgrade fails.

Please help as we are unable to proceed further.

regards,
Uruj

Outcomes