Hello,
I\'m trying to connect to a remote Oracle database. I\'m completely inexperienced with Oracle (web site was originally intended to be written for PHP & MySQL), so the more detailed any tips are the better. I\'ve looked over the Oracle functions in the PHP manual and feel comfortable with them, so my biggest question is on connecting. I\'ve gotten bits and pieces from searching through the forums already, but might not have enough knowledge to put it all together yet. Web server is Cobalt Qube 3 running Apache and Linux.
What I\'ve learned:
- Must add Oracle client software
In apachectl (file does not seem to exist on Cobalt Qube 3... locate turned up nothing. Other options?):
- Add ORACLE_HOME = path
- export ORACLE_HOME
$connect is $ORACLE_HOME/network/admin/TNSNAMES.ORA
- I am unfamiliar with this file but it must be set up as follows (but am not sure what goes with it):
MY_SID =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = MY.world)
(PROTOCOL = TCP)
(Host = IP_ADDRESS)
(PORT = 1521)
)
)
(CONNECT_DATA =
(MY_SID = 0734D1)
)
)
- Ensure listener is running on server (using listener.ora (another file I am unfamiliar with)
- Compile PHP with Oracle enabled (is this required? Is it possible to get around that by doing putenv? I want to avoid recompiling if at all possible)
Anyway, I know that I have a bit of learning to do and that you all can probably help on a bit. Any help is appreciated, though, as our Oracle administrator is on vacation for the week and I need to get moving. I can probably find out some of the other information from our IT department, but they\'re reluctant to do anything other than set up the Oracle server to talk with the web server.
Thank you for any assistance,
Sean
I\'m trying to connect to a remote Oracle database. I\'m completely inexperienced with Oracle (web site was originally intended to be written for PHP & MySQL), so the more detailed any tips are the better. I\'ve looked over the Oracle functions in the PHP manual and feel comfortable with them, so my biggest question is on connecting. I\'ve gotten bits and pieces from searching through the forums already, but might not have enough knowledge to put it all together yet. Web server is Cobalt Qube 3 running Apache and Linux.
What I\'ve learned:
- Must add Oracle client software
In apachectl (file does not seem to exist on Cobalt Qube 3... locate turned up nothing. Other options?):
- Add ORACLE_HOME = path
- export ORACLE_HOME
$connect is $ORACLE_HOME/network/admin/TNSNAMES.ORA
- I am unfamiliar with this file but it must be set up as follows (but am not sure what goes with it):
MY_SID =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = MY.world)
(PROTOCOL = TCP)
(Host = IP_ADDRESS)
(PORT = 1521)
)
)
(CONNECT_DATA =
(MY_SID = 0734D1)
)
)
- Ensure listener is running on server (using listener.ora (another file I am unfamiliar with)
- Compile PHP with Oracle enabled (is this required? Is it possible to get around that by doing putenv? I want to avoid recompiling if at all possible)
Anyway, I know that I have a bit of learning to do and that you all can probably help on a bit. Any help is appreciated, though, as our Oracle administrator is on vacation for the week and I need to get moving. I can probably find out some of the other information from our IT department, but they\'re reluctant to do anything other than set up the Oracle server to talk with the web server.
Thank you for any assistance,
Sean