Change database server

We will move our Oracle database to new server (with a different server name). I knew I need to configurate Oracle client on JDE fat client's PC to make JDE fat clients work.

Do I need to delete all JDE.INI on thin clients (who access JDE by Terminal server) so that they will get the new jde.ini when they use JDE first time after the database move?

Besides JDE.INI, what else should I modify in the JDE server side after the database server change?

Thanks a lot.

Yuan Jeff :

Don't forget to create a plan for your new server before moving or altering
any data or file at all!
If not, JDE won't recognize your new server.
JDE is strongly based on machine names and they appear on literally hundreds
of tables, the only way to update them safely
is via a server installation plan.

Sebastian

----------------------------------------------------------------------------
Strictly Personal and Confidential.
This email may contain confidential and proprietary material for the sole
use of the intended recipient. Any review or distribution by others is
strictly prohibited. If you are not the intended recipient please contact
the sender and delete all copies.Thanks.
.
Este mensaje es confidencial.
Puede contener informacion amparada por el secreto profesional. Si usted ha
recibido este e-mail por error, por favor comuniquenoslo inmediatamente via
e-mail y tenga la amabilidad de eliminarlo de su sistema; no debera copiar
el mensaje ni divulgar su contenido a ninguna persona. Muchas gracias.
----------------------------------------------------------------------------

Re: RE: Change database server

Thank you for the advice. It reminds me that when we changed the Deployment server name, a consultant had to change data in tables for us. Do you know any JDE document on steps of changing DB server?

Regards,

Jeff

I think that you need to only update tnsnames.ora file in fat clients, enterprise server, deployment server and Terminal server. JDEdwards gets the database name from the JDE.ini/Datasources and then it uses tnsnames.ora file to resolve where does database resides. It is applicable to Oracle databases only.
Any other suggestions??

RE: RE: Change database server

Jeff :

Unfortunately, I don't know of any specifical document on that.
What you've got to do is :

a) Install OS, C++, and DBMS in your server.
b) Install JDE server software.
c) Run server installation plan from Deployment JDEPLAN environment.
d) Fix JDE.INI on your new server.
e) Add ODBC entries and printers if necessary
f) Start services there.

Sebastian




----------------------------------------------------------------------------
Strictly Personal and Confidential.
This email may contain confidential and proprietary material for the sole
use of the intended recipient. Any review or distribution by others is
strictly prohibited. If you are not the intended recipient please contact
the sender and delete all copies.Thanks.
.
Este mensaje es confidencial.
Puede contener informacion amparada por el secreto profesional. Si usted ha
recibido este e-mail por error, por favor comuniquenoslo inmediatamente via
e-mail y tenga la amabilidad de eliminarlo de su sistema; no debera copiar
el mensaje ni divulgar su contenido a ninguna persona. Muchas gracias.
----------------------------------------------------------------------------