Is there anyway to run apex on application server while having database on another server. I meant to say that I want to make one database server in which oracle database will be installed and another application server on that apex will be installed? Is there any possible way to do that?
I've tried it by connect through remote database and it is working but I had to install oracle database on both server.
In sort NO !
Oracle Application Express (ApEx) Engine (ApEx vestion 2,3,4,5,18,19) is running only on Oracle Database server, But for best performance, it is strongly recommended to use Web Server on seperate server,
Application Server Options for ApEx
for further information please refer to Oracle ApEx Installaion Guide
and official site https://apex.oracle.com/ regularly!