Thank you for looking.
If possible what would be the best way to do this.
Kind Regards
John
Solved
Pointing Middleware Server to another Database
Best answer by Sajith D
Hi John,
Looks like you are running Apps 10.
You should be able to change the database connection string from the MWS Admin console. The JDBC connection string can be changed in “common>database”. Still would need a reconfiguration afterwards to get everything setup.
Cheers
Hi,
Re configuring the application server instance pointing to the new database would be the way to go. As long as you know the passwords for the internal system users in the back end database you should be good to go. You can of course reset them from the database and use the new passwords in the installer if you are not sure about the passwords. Making sure that the patch/delivery level for the new database matches the deliveries applied to the application server instance is quite important to make sure there is no incompatibilities.
Cheers
I thought that was the way to go and had already tried it but when I tried reconfiguring the application server instance but there wasn’t an option to change the database.
Am I missing somehting.
John
Hi John,
Looks like you are running Apps 10.
You should be able to change the database connection string from the MWS Admin console. The JDBC connection string can be changed in “common>database”. Still would need a reconfiguration afterwards to get everything setup.
Cheers
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.