Re: Connect to two different Oracle servers using PHP / Perl ?

livefreeordie wrote:
> Hi,
>
> I'm running Apache 2.2.3, and PHP 5.1.4 on Apache 2.2.3, on a Sparc
> Solaris 5.10 box. Our Oracle DBA installed the Oracle 10g server and
> client on the web server. He also installed the Oracle 9i Client
> (only), so that I can also connect to a remote 8i server.
>
> I have to set my $ORACLE_HOME each time I switch between the two
> clients.
>
> Is there a better way to do this?
>
> How can I configure PHP to connect to both? Is it possible?
>
> I tried to set up Oracle's Instant Client, but I couldn't get it to
> connect to either database. The closest I got to connecting to the
> remote server was an error that said "ORA-12514: TNS:listener does not
> currently know of service requested in connect
> descriptor".
>
> Thanks,
> Jamie

Hi Jamie,

While using the 9i home, type

tnsping your_service_name

Source the 10G home and type lsnrctl status

Make sure your service_name that you tnsping'd above shows up as one for which the 10g listener will accept connections. Type in ORA-12514 in the search engine at tahiti.oracle.com for more information, as it has a good explanation of this error and how to resolve it.

Regards,

Steve Received on Wed Sep 06 2006 - 08:05:56 CDT