Hi. I am using Oracle database XE 18c, Oracle APEX 21.1 and ORDS 22.2 on Windows 7 Professional.
I've developed an app using the above mentioned tools. I always face a problem when deploying the app to another computer because it takes about an hour and half to get up and running.
The new computer could have Windows 7 or above installed.
Installing XE database is much easier. It just asks for a password for SYS and SYSDBA users. But, then I'd need to import a parsing schema for my app to work.
installing APEX(which is a component in the database) and ORDS takes a human intervention for many steps and it takes a lot of time.
So, I am searching for the easiest, free solution to this problem.
I found that I could use containers like docker, but it's not free for commercial use, and it takes time to learn how it works. Plus, it does not work for old versions of Windows like Windows 7(I think most container does not as well).
I could also use virtuals machines like VirtualBox but it's a lot of load to the computers I deploy too. They have small RAMS and slow processors.
So, the solution I am trying right now is to copy my installed programs from my main computer and paste them to the new computer.
But, of course, I'd need first to know where the programs i.e Oracle database XE spread it's files. I know it's not just a folder in my “program files” folder. Of course, there's others. Can all they be recognized?
I know there's registry entries that can be exported. Environment variables which I'd need to set manually. There's also startup programs. Start Menu Files. What else?
What about the services?