Clarity

We are updating from PPM 13.3 to 15.3, for that we use a database of ORACLE 12g,

When executing the installer.bat the following error occurs:

10/11/17 4:53 PM (ExecTask) FATAL 11-10 16: 53: 40,117 - Failed to initialize Context properties
10/11/17 4:53 PM (ExecTask) java.sql.SQLInvalidAuthorizationSpecException:
[CA Clarity] [Oracle JDBC Driver] [Oracle] ORA-01017: invalid username / password; denied logon

Maybe it is some configuration in ORACLE or some detail with the database controllers of the version to which we are going. But I can not discover the correct diagnosis that will leads me to the solution.

Could you help us with this?

Configuration of the ORACLE database

NLG_CALENDAR GREGORIAN
NLS_CHARACTERSET AL32UTF8
NLS_COMP BINARY
NLS_CURRENCY $
NLS_DATE_FORMAT DD-MON-RR
NLS_DATE_LANGUAGE AMERICAN
NLS_DUAL_CURRENCY $
NLS_ISO_CURRENCY AMERICA
NLS_LANGUAGE AMERICAN
NLS_LENGTH_SEMANTICS BYTE
NLS_NCHAR_CHARACTERSET UTF8
NLS_NCHAR_CONV_EXCP FALSE
NLS_NUMERIC_CHARACTERS.,
NLS_RDBMS_VERSION 12.1.0.2.0
NLS_SORT BINARY
NLS_TERRITORY AMERICA
NLS_TIMESTAMP_FORMAT DD-MON-RR HH.MI.SSXFF AM
NLS_TIMESTAMP_TZ_FORMAT DD-MON-RR HH.MI.SSXFF AM TZR
NLS_TIME_FORMAT HH.MI.SSXFF AM
NLS_TIME_TZ_FORMAT HH.MI.SSXFF AM TZR

Hi Ricardo,

Its just one of few cases where we hit a progress bug and its unable to authenticate. We had similar issues on earlier thread DB Account is getting locked due to upgrade 

Taking the below approach should get you to 15.3 . I have updated the workaround ad you don't need to make changes in 15.2 pre upgrade releases and doing till 14.2 should be enough to get the upgrade done.

Extract the install.jar in my temp directory
- Take the library "c-oracle.jar" inside ...temp\checkinstall\tools\lib and
copy it inside the folder ..temp\tools\lib replacing the existing one.
- Take the file "upgrade-repack.14.1.0.431tpexcludes.jar" contained in ..temp\install-packages\14.1.0
and unbuild (renamed it in upgrade-repack.14.1.0.431tpexcludes.zip ) it in my temp2
directory.
- Take the file "package.jar" contained in upgrade-repack.14.1.0.431tpexcludes.zip and unpackage the package.jar
and replace the c-oracle.jar in package.zip and rebuild the package.jar and again package as upgrade-repack.14.1.0.431tpexcludes.jar

Take the file "package.jar" contained in ..temp\install-packages\14.2.0
and unbuild (renamed it in package.zip and extracted) it in my temp2
directory.
- Take the library "c-oracle.jar" inside ...temp\checkinstall\tools\lib and
copy it inside the folder ..temp2\lib replacing the existing one.
- rebuild the package.jar modified and run the install

Note: Please don't use the windows default zip to perform the workaround and use winzip to perform the workaround

Let me know if you were to overcome the same, else raise a case we will build the files for you and provide the same to you.

Regards

Suman Pramanik 

Thank you so much Suman for your prompt response.
For reasons of client operating time, this will probably be done next week.
I'll let you know the results, once I do what you suggest.

Let me know how it goes

Another easy and certified approach to overcome this 

1. Exact the Install.jar
2. Go under checkinstall --> tools --> Lib
3. Look for c-oracle.jar and copy the same and keep in separate location
4. Go under install-packages and go till folders 14.2 as the problem is there till 14.2
5. Exact the upgrade-repack.14.2.0.237tpexcludes.jar and go under tools --> lib and replace the c-oracle.jar ( Look in point 3 where you made the copy)
6. Under extracted upgrade-repack.14.2.0.237tpexcludes look for package.jar and extract the package.jar
7. Go inside package --> lib and replace the c-oracle.jar ( Look in point 3 where you made the copy)
8. Package the pacakge.jar and then upgrade-repack.14.2.0.237tpexcludes.jar
9. Package the install.jar and re run the upgrade. 

Regards
Suman Pramanik 

The same erros was showed when we to do the new run install.bat: [Oracle] ORA-01017: invalid username / password; denied logon

We send a case 00876460 to CA

Hi Ricardo,

Did you try these steps when I updated 

1. Exact the Install.jar 
2. Go under checkinstall --> tools --> Lib
3. Look for c-oracle.jar and copy the same and keep in separate location
4. Go under install-packages and go till folders 14.2 as the problem is there till 14.2 
5. Exact the upgrade-repack.14.2.0.237tpexcludes.jar and go under tools --> lib and replace the c-oracle.jar ( Look in point 3 where you made the copy) 
6. Under extracted upgrade-repack.14.2.0.237tpexcludes look for package.jar and extract the package.jar 
7. Go inside package --> lib and replace the c-oracle.jar ( Look in point 3 where you made the copy) 
8. Package the pacakge.jar and then upgrade-repack.14.2.0.237tpexcludes.jar 
9. Package the install.jar and re run the upgrade. 

I will also attach the new install.jar to the case 

Regards

Suman Pramanik 

Hi SumanPramanik,

Could you please share with us that install.jar file? We are facing the same issue and we have lost a couple of days with that. So it's quite urgent and we are happy we know the solution now....I was also not able to download the new ISO install file (maybe with corrected lib?) due to following error....

Thanks, 

Matej

Hi Matej

The bug were corrected in 15.4 and downloading the same should be able to fix. Also I guess you need to download the ISO from support site and we will work with you to get you the right access to download.

Regards

Suman Pramanik