Reg: Hosting a site with oracle in server

Question

User-151352204 posted

Hi 

I have two websites in one server. One site runs with MSSQL and another one with oracle. While running in local machine I install Oracle and use TNS.ora in oracle admin folder to run the site. 

Means now i have to install oracle express in server to run the site? ( oracle runs on another server but not on host server).

Thank you

Answer 1

User1508394307 posted

The database server does not need to be installed on the same box where web server is. If your database will be located on another server then you simply need to change connection string (typically in the web.config file) from localhost to that server. If you have no other server, then you would need to install oracle on the same server. 

Answer 2

User1196771204 posted

What is important here is that you must allow DB Remote Connection to your Oracle database. By doing so, you can simply put your site on any server in this world and you can simply change the connection string on your site and point it to your Oracle database

Please mark this response as an "answer" if it helps you. Thanks heaps! 

Answer 3

User-801004448 posted

You will need to install Oracle data access components on web server for asp.net to connect to Oracle database on remote database server.