Author |
|
jbrown38
Joined: 21 Jan 2016 Posts: 4 Location: US, Charleston
|
Posted: Thu 21 Jan '16 23:17 Post subject: Apache Server Upgrade With External Oracle DB |
|
|
Hey all, I am brand new to Apache, and I need some help. My company is upgrading our server from Windows Server 2003 to Windows Server 2008 R2. I know I need to install Apache 2.4 and Oracle 11g. What I do not know is how to go about setting these up.
The current setup is:
-OS: Windows Server 2003
-Apache 2.2.4
-Oracle 9i
The Oracle database is on a separate Linux machine, and as far as I am aware, it is a 9i db, which should work with an 11g client. Also, I am not worried about doing this on a test server. The original server is still running, and I have a different machine with WS 2008. This machine will become the Production server once it is up and running properly, and the old server will be flattened.
Thanks in advance for any help, and I apologize if this has been done to death or is incredibly simple, but this is my first time hearing of Apache.[/i] |
|
Back to top |
|
James Blond Moderator
Joined: 19 Jan 2006 Posts: 7371 Location: Germany, Next to Hamburg
|
Posted: Mon 25 Jan '16 16:34 Post subject: |
|
|
What has Apache to do with the database? Unless you use it with mod_*dbd*. |
|
Back to top |
|
jbrown38
Joined: 21 Jan 2016 Posts: 4 Location: US, Charleston
|
Posted: Mon 25 Jan '16 16:44 Post subject: Apache DB |
|
|
All of the code for the Apache Site is stored in a database. The SQL code is run and then accesses and runs the code for the site. I believe Apache has to run on top of Oracle, but I could be wrong. I do know that our program definitely needs to access the db to run. |
|
Back to top |
|
James Blond Moderator
Joined: 19 Jan 2006 Posts: 7371 Location: Germany, Next to Hamburg
|
Posted: Mon 25 Jan '16 17:13 Post subject: |
|
|
Do you use PHP to access the database or something else? |
|
Back to top |
|
jbrown38
Joined: 21 Jan 2016 Posts: 4 Location: US, Charleston
|
Posted: Tue 26 Jan '16 20:57 Post subject: |
|
|
It is definitely not PHP. The only thing running is an instance of python and a couple instances of java. |
|
Back to top |
|
James Blond Moderator
Joined: 19 Jan 2006 Posts: 7371 Location: Germany, Next to Hamburg
|
Posted: Wed 27 Jan '16 10:41 Post subject: |
|
|
Ok, but then the JAVA App that can't run on apache itself but tomcat or jboss or ?? must connect to the database. Or the python as cgi.
You need to figure out what part accesses the database. |
|
Back to top |
|
jbrown38
Joined: 21 Jan 2016 Posts: 4 Location: US, Charleston
|
Posted: Thu 28 Jan '16 17:35 Post subject: |
|
|
Ok, Apache is set up to use Oracle Web Tier to access the db. The database is accessed using a DAD, and then Oracle uses the sql files to set up the website. |
|
Back to top |
|
James Blond Moderator
Joined: 19 Jan 2006 Posts: 7371 Location: Germany, Next to Hamburg
|
Posted: Thu 04 Feb '16 17:09 Post subject: |
|
|
I have no experience with oracle apache. It is a modified version of httpd apache. Since you have to buy oracle apache webserver you have support from oracle. You should ask there. |
|
Back to top |
|