I'm currently looking to install ILM.
For this, I need APEX (on every DB where ILM will be) + JVM (< 10g) + Text + XML DB + HTML DB + mod_plsql...
First of all, I found all this quite a lot of things to install if we have a lot of DB instances, but ok...
But, in APEX installation guide, I found a very disturbing recommendation:
1. Shutdown any existing Oracle database instances ... !!!!
We have nodes running more than 100 DB instances. Is it mandatory to do such thing ?? It render this almost unfeasible ..
And if yes, why is this so ? Does it modify oracle binaries in Oracle Home?
The current approach for the ILM Assistant does require a copy on every instance. We're aware of the need and desire to manage multiple instances from a single node, and we've placed this requirement high on our wishlist.
As for APEX requiring the database instance to shut down .... hmmm ... I don't recall having to do this after an APEX install. I suggest visiting the Application Express forum and posting the question there.
All you need to run the ILM Assistant is APEX, formerly known as HTML Db and a web server which is required by APEX. Although with 11g you can use the PL/SQL Gateway instead of the web server.
I am not aware that you have to shutdown the instances as they need to be up to install APEX into the database.
No it does not modify the Oracle binaries.
Also just to clarify, you don't have to shut the database down to install APEX (it's really just a precaution incase someone is connected and doing something that could interfere with the APEX installation).
I have performed lots of APEX installs/upgrades without shutting the DB down first (and then bringing it back up of course).
Hope this helps.
Well, ok then. I was just really surprised by reading the installation guide, mentionning the recommendation to shutdown all instances except the one where APEX will be installed, and also to stop the listener.. (we have 5-6 listeners for more than 100 DBs)
thanks for the reply