Oracle Connection from Linux PC

ClubSS · 10-24-2006, 12:17 PM

Hi,

Please help! I have a Linux PC running Fedora Core 4. It has a reporting tool in a web interface written in PHP. This tool calls data from our back office system which runs on an Oracle database.

The problem is my colleague who created the web interface is no longer with the company, and has taken his knowledge with him! Previously, this PC and the DB server were on the same LAN. We have now moved the DB to another server, in a hosting environment. This is on a separate LAN altogether. I need to get the web site to read from this new location.

Is it not just a matter of changing an IP address somewhere, so the website knows were to look for the data?

My Linux and PHP knowledge is extremely limited (I know more about women!), so all assistance will be appreciated.

Thanks

Skie · 10-24-2006, 04:59 PM

You'll need to change the IP address and make sure that the username, database name and password are the same. You may also need to make sure that the proper port on the new server is not blocked by that server.

ClubSS · 10-26-2006, 08:19 AM

Thanks, but where would I do that?

Is there something like a Data Source Administrator application or utility where one creates and edits Database connections?

ClubSS · 11-16-2006, 02:12 AM

Anyone?

10-24-2006, 12:17 PM	#1 (permalink)
ClubSS Registered User Join Date: Oct 2006 Posts: 4 OS: XP	Oracle Connection from Linux PC Hi, Please help! I have a Linux PC running Fedora Core 4. It has a reporting tool in a web interface written in PHP. This tool calls data from our back office system which runs on an Oracle database. The problem is my colleague who created the web interface is no longer with the company, and has taken his knowledge with him! Previously, this PC and the DB server were on the same LAN. We have now moved the DB to another server, in a hosting environment. This is on a separate LAN altogether. I need to get the web site to read from this new location. Is it not just a matter of changing an IP address somewhere, so the website knows were to look for the data? My Linux and PHP knowledge is extremely limited (I know more about women!), so all assistance will be appreciated. Thanks

10-24-2006, 04:59 PM	#2 (permalink)
Skie Manager, Alternative Comp Join Date: Mar 2003 Location: Chicago burbs Posts: 2,194 OS: Gentoo Linux, CentOS, OS X My System	You'll need to change the IP address and make sure that the username, database name and password are the same. You may also need to make sure that the proper port on the new server is not blocked by that server. __________________

10-26-2006, 08:19 AM	#3 (permalink)
ClubSS Registered User Join Date: Oct 2006 Posts: 4 OS: XP	Thanks, but where would I do that? Is there something like a Data Source Administrator application or utility where one creates and edits Database connections?

11-16-2006, 02:12 AM	#4 (permalink)
ClubSS Registered User Join Date: Oct 2006 Posts: 4 OS: XP	Anyone?