This content has been marked as final. Show 6 replies
Ok ... the intent of this feature is to permit remote installation. So, to correctly install the Assistant, you must logged into that system using your remote link:
sqlplus "sys/my_password@ORCLDB as sysdba"
@ilma_install my_password ILM_ASSISTANT ORCLDB
You should be able to access the application after the successful installation.
Before you attempt this, you should uninstall the product; otherwise, you may see additional errors during the 2nd install attempt.
Let us know if this works.
Thanks for the reply.
But What I meant is I wanted the ILM assistant up and running in my Oracle XE, but the managed database is in my ORCLDB (10g EE).
Is the any possible way? because I don't want to install anything (HTTP server, application Server, Oracle Text) to my 10g EE.
Ah ... remote access is a very desirable feature. Unfortunately, we have not yet implemented it within the ILM Assistant. At this point, I do not know of any work-around that keeps all pieces off your target enterprise system. One thing to note is that you could install just the APEX and ILM Assistant PL/SQL packages on the target system. Then, you could use the PL/SQL gateway and avoid having the HTTP server on the same box as your enterprise. Would that work for you?
The PL/SQL gateway was introduced in 10gR2 as a way to utilize the embedded HTTP server in the Oracle server. Its setup is tricky but doable. Here is a link that may help:
Anyway, you install Apex and ILMA on your ee system just like you would on any machine. Next, you have to set up the PL/SQL gateway on the ee system so it can find Apex on your ee machine. Once that is done, your remote browser should be able to find the ILM Assistant. One thing to note, Apex and ILMA are both just PL/SQL-based packages that run on the target machine. The thing you're trying to do is invoke the Apex PL/SQL procedures from your browser, which may or may not be located on the same physical box as your ee system.
I've not personally used or set up the gateway, but I know of others who have had success with it.
Hope this gets you a bit farther! :)