Database Upgrade in JDE and platform change from AIX to Red Hat Linux 5 for db server

Madav Karna

Active Member
Hi,

We are running JDE 9.0 TR 8.98.4.3 and in our project, we are migrating platform from AIX 6.1 to Red Hat enterprise linux 5 for our database server and also we are patching out from Oracle 11.1 to 11.2.0.7 Below is the scenario. Our Enterprise Server and web servers are running on AIX platform.

The data from the existing database server will be copied to new database machine with Red Hat Linux 5.
DNS alias name will be set pointing to the old database server name.
The database name, connection string and the port number are changing. (port number 1543(existing) to 1521 (new planned)

Since we are setting an alias name the database server name will be retained but we have a platform change for database server.
Would modifying the database data-sources and updating the tnsnames.ora, JDE.INI and JDBJ.INI in this case would help or any other step needs to be followed after that.
It would be great if someone could help us in suggesting an approach or provide us a help material or an oracle document link that would help us in this case.

Any help on the above will be greatly appreciated.

Thanks,
SG Madav Karna
 

glen7x

Active Member
- Make sure you meet the platform and DB MTRs
- Update TNSnames file and propogate
- Update DB DS with the new config (SID and Port).
 

Madav Karna

Active Member
Glen,
Thanks, we did change the db ds and also the tnsnames.ora.
We were able to connect web and fat-client successfully. But we are still facing issues with the deployment server connectivity.
Even after updating the tnsnames.ora, JDE.INI and ODBC it is still trying to connect to the old database, we are wondering from where it is taking the old database name.
Any help on this would be greatly appreciated. Our deployment server runs on Windows 2008 R2.

Thanks,
SG Madav Karna,
91-9790819513
 

Madav Karna

Active Member
Glen,

We were able to solve the deployment server issue, we updated the host name entry and it worked.
Thanks for your time and help :)

Thanks,
SG Madav Karna,
91-9790819513
 
Top