multiple oracle instances on one server
| From: | Florian Clever | Date: | Wed, 03 Apr 2002 23:54:15 +0000 |
| Subject: | multiple oracle instances on one server | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-18177@lists.php.net to get a copy of this message | ||
Hello,
I have two Oracle instances running on a Mandrake 8.1 box.
SIDs are PM and QA.
All the Oracle environment variables are set on Apache startup. And
$ORACLE_SID=pm is set to.
So connecting via ocilogon($user, $pass, '') to the db with SID=pm without
specifying a service it works.
As soon as I specify a service ocilogon ($user, $pass, 'pm') I get
"ORA-12535: TNS:operation timed out".
It works if I connect via sqlplus like this:
sqlplus user/pass@pm.
So I am wondering what the difference is on how sqlplus and PHP's OCI
connect or which Settings (ENV Vars) control this.
Florian
http://fc.clever-soft.com