Hi Jim, I learned with the migration from V9.1.1. When I do these upgrades I always pull all of the compatibility documents, and documentation guides. Since we run OAE, and Banner (Rapid Automation) I pull those too. When I upgraded my first instance from V9.1,1 to V9.1.1 I first had some confusion over the client.properties, and connections.properties files. I found out that using the connections.properties file didn't let me use https, I had to use http and put the port in it.
I then found out the hard way about the user_keystore files. Turns out you this all comes into play when you use a Java level of 1.8.0_201 or higher on the host, or PC client. In 201 they added anon, and NULL to the chyper exclusions. When my host was 1.8.0_131, and PC 1.8.0_151 I did not need them. It is when I upgraded the host to 201 or higher. I also found out the hard way that even using 1.8.0_131 if I had 201 or higher on my PC I needed to have them. We even had one user upgrade there PC Java to a level 201+ and they got the socket error. My fix was to have them upgrade the java.security file on there PC, and remove the anon, and NULL values. This was on my V9.1.1 prod system which I wil lbe upgrading on 2/23.
It took me a while to figure out the keystore. But now I got it working on my AMUPGD, and AMTEST systems. I su to the user the master runs under, and I have the JAVA_HOME set to 1.8.0_231. I run through the commands to create the keystore in the data directoriy, and encrypt it. Then I copy the files to my agents data directories.
You will need to make sure you have the keystore files in the correct location on your PC. There is various documents that say .Appworx, or Appworx directory.
The actual location that worked is. My id is rblumlei.
C:\Users\rblumlei\Appworx\<master> For me master would be directories AMUPGD, or AMTEST, or AMPROD.
IF you are running OAE you need to have your DBA run through the SQL scripts for the Advanced Queuing...
I hope this information helps.. I learned a lot. Buy the way I did install multiple levels of Oracle Java on my PC, and tested them all. I even installed OpenJDK
11 which pay attention to the compatibility notes. It gives a hint to a specific levels ..
Thank you,
Rich
Original Message:
Sent: 02-06-2020 12:17 PM
From: Dryden
Subject: Applications Manager 9.2.3
Hi Rich,
Going up to ver. 9.3.1, did you need to install user_keystore files on everyone's computer? My understanding is that SSL config is required with 9.3
What about user's java versions? In my environment, users have java versions that are below 1.8. IF i'm reading documentation correctly, java 1.8 is the minimum level for users to run the AppWorx client.
Thanks,
Jim
------------------------------
Core Services Specialist
University of New Mexico
Original Message:
Sent: 01-08-2020 10:09 AM
From: Richard Blumlein
Subject: Applications Manager 9.2.3
Hi Jim, I was under the assumption when using the export/import feature the best practice was to be on the same release from and too. I would think it would work, but caution is recommended. We just had someone at our site tell me they tried to export from prod at V9.1.1 into test at V9.3.1 and was given a warning.
When we migrated from AIX to Linux we were on V9.1.1 on both platforms. I installed V9.1.1 on Linuix then we migrated the database over from say AWPROD to AMPROD. We ran the awinstall on Linux. But we also ran a series of bulk change scripts to change all kinds of paths, and environment variables.
Upgrading now from Linux V9.1.1 to V9.3.1 was not so bad. A lot of changes with the new client, and user_keystore files we had to get working.
We have a nice problem we found recently with our OAE success scripts. There is an issue where the SUCCESS.OAE script is not being called which then does not call the COMPLETION. If works 1 out of three times I was told. We are not sure what is going on, and I am working with support. Hopefully they can help us.
The OAE component has changed from using DBMS pipes to Advanced Queuing, and this might have something to do with it.
Hope it goes well for the upgrade on your side. I am new to using the community, it looks very helpful.
Thank you,
Rich
Original Message:
Sent: 01-07-2020 10:47 AM
From: Dryden
Subject: Applications Manager 9.2.3
Hello all,
I'm preparing to upgrade my Applications Manager version 9.1 to version 9.2.3. I have three tiers (Development, Integration and Production) and will be upgrading starting with the Development tier. Does the vendor support object import/export between these two versions? If so, has anyone experienced issues exporting objects from 9.1 into 9.2.3? Any insights are greatly appreciated.
Thank you,
Jim
------------------------------
Core Services Specialist
University of New Mexico
------------------------------