This content has been marked as final. Show 5 replies
Hi,1 person found this helpful
We are moving our Database to a new server which means that the hostname which is configured in the Listener needs to be updated.Yes, that's the point to configure the new database hostname.
The SID would remain same, the password for account APEX_PUBLIC_USER might change. Basic connection type is being used for DB configuration.
Do I need to update the apex-config.xml (apex.db.hostname)
You can change the password for the APEX_PUBLIC_USER there as well. Note that it's "encrypted" there by default. You can change it by entering the plaintext password as follows
It will be encrypted again upon the first start of your APEX Listener after you've changed that value.
Would this be the only change required in my web server?If you didn't move the web server as well and you don't have any firewall rules or proxy rules to adjust, this would be all.
1. Does that mean that I just need to stop the APEX listener, make changes in apex-config.xml file and restart the APEX listener? Would that be enough?
2. What about the other option - delete the configuration file, restart the tomcat and redo the entire configuration process?
The 1st option looks simple to me, since I am new to APEX. I can't myself try these changes and need to guide another person to perform these changes, so I want to be sure that the steps are correct.
What are the cases where one should prefer 2nd option? Any disadvantages of the 1st option?
Sorry for asking too many questions.
1. Does that mean that I just need to stop the APEX listener, make changes in apex-config.xml file and restart the APEX listener? Would that be enough?Yes.
2. What about the other option - delete the configuration file, restart the tomcat and redo the entire configuration process?This will work as well, though it seems to be a little more effort.
What are the cases where one should prefer 2nd option? Any disadvantages of the 1st option?I'd recommend to restart with a fresh configuration upon some major change in the APEX Listener to make sure I didn't miss some new parameter or change in default settings.
The first option is fast and if the last time you've reviewed your configuration wasn't ago too long, it's probably the best way, since you reduce the probability of incorporating errors by doing something differently than before. On the other hand, you might want to take the chance to actually make a review or see if any default has changed, and perhaps look into the release notes and documentation to decide if that's okay for you. Stuff like that.
Sorry for asking too many questions.No big deal, really.
Thanks Udo for the help!
Can you also tell me how to stop and start Apex listener on Tomcat?
I'm glad to hear it worked for you.
APEX Listener is deployed and behaves exactly like any other application you run on your Tomcat, which means you can use the Tomcat Manager to start/stop it. See the [url http://tomcat.apache.org/tomcat-6.0-doc/manager-howto.html#Start_an_Existing_Application]Manager App HOW-TO for details.