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
<[EMAIL PROTECTED]>
-------------------------------------
-----Original Message-----
From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
Sent: Monday, July 02, 2001 7:52 PM
To: [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: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
