Re: problems connecting to remote oracle database
| From: | Rouvas Stathis | Date: | Sun, 01 Jul 2001 13:53:11 +0000 |
| Subject: | Re: problems connecting to remote oracle database | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-9997@lists.php.net to get a copy of this message | ||
From Oracle manual :
ORA-01017: invalid username/password; logon denied
Cause: An invalid username or password was entered in an attempt to log
on to Oracle. The username and password must be the same as was
specified in a GRANT CONNECT statement. If the username and password are
entered together, the format is: username/password.
Action: Enter a valid username and password combination in the correct
format.
-Stathis.
phil@bolthole.com wrote:
>
> Hi folks,
>
> I'm having difficulties getting php4 to connect to a remote oracle
> database.
>
> I have an entry in tnsnames.ora, along the lines of
>
> shorthostname = (etc, etc)
>
> and I can use "sqlplus user/name@shorthostname" to connect just fine, as
> a regular user. Even without ORACLE_SID set, since I have it set in
> tnsnames.ora for that entry
>
> But when I try
> ocilogin("user","name","shorthostname");
>
> on a php page, I get a printout of oracle error 01017: authentication
> failed.
> The listener log on that oracle machine confirms that I am actually
> attempting to connect. But no details on what's going wrong.
>
> Any suggestions?