Justtechjobs.com Find a programming school near you






Online Campus Both


php-db | 2001071

RE: [PHP-DB] problems connecting to remote oracle database From: Brian S. Dunworth (brian <email protected>)
Date: 07/03/01

Hi Phil...

   Since you have the server name (vs. the IP address) in the HOST= verb,
make sure you have an entry in /etc/hosts for a server called 'staging'

eg:

     $ cat hosts
     127.0.0.1 localhost
     219.70.73.2 staging
     $

 ...obviously, you'd want to put the actual IP address of your 'staging'
server in there, not the one I made up. :)

 - Brian

 -------------------------------------
   Brian S. Dunworth
   Sr. Software Development Engineer
   Oracle Database Administrator
   The Printing House, Ltd.

   (850) 875-1500 x225
   <brian <email protected>>
 -------------------------------------

-----Original Message-----
From: phil <email protected> [SMTP:phil <email protected>]
Sent: Monday, July 02, 2001 7:52 PM
To: php-db <email protected>
Subject: Re: [PHP-DB] problems connecting to remote oracle database

a little more info...

I've just tried a few public oracle-sql tools.
Seems to have the same problem.
I can connect just fine to the database using sqlplus.
But when I try the hand-compiled tools, linked against
libclntsh.so, it doenst properly authenticate to the remote system.

Hey... $ORACLE_HOME/bin/sqlplus isnt linked against
libclntsh.so, funnily enough.

any ideas? Some special magic I need to put in tnsnames.ora, thta I've
othrewise left out?

sample, that works fine with sqlplus;

TEST2.STAGING.our.com =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = staging)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = test2.staging.our.com)
      (SID = test2)
    )
  ) 

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: php-db-unsubscribe <email protected>
For additional commands, e-mail: php-db-help <email protected>
To contact the list administrators, e-mail: php-list-admin <email protected>

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: php-db-unsubscribe <email protected>
For additional commands, e-mail: php-db-help <email protected>
To contact the list administrators, e-mail: php-list-admin <email protected>