PEAR - Oracle10g connection failure
| From: | tonYa | Date: | Tue, 08 Jun 2004 01:07:24 +0000 |
| Subject: | PEAR - Oracle10g connection failure | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-187896@lists.php.net to get a copy of this message | ||
Hi there,
we are developing application for users with different database environment.
I ve tested it with MySQL and SQL.
Now I am stuck on Oracle 10g.
I am trying php and PEAR.
I have the following parameters:
Windows Server 2000
PHP 4.3.6
PEAR 1.8
APACHE 2.0.49
Oracle 10g
- ORACLE_HOME = C:\oracle\product\10.1.0\db_1 in ....Oracle\KEY_OraDb10g_home1 in Registry
ORACLE_SID = webEvalOracle
(same variables in ...Oracle\SYSMAN\OracleDBConsolewebEvalOracle in Registry)
- WEBEVALO =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = tonya)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = webEvalO)
)
)
in TNSnames.ora
- php.ini:
extension=php_oci8.dll
extension=php_oracle.dll
errors are:
1. for PEAR: [nativecode=ORA-12154: TNS:could not resolve the connect identifier specified]
/*php code:
$dbms="oci8";
$dbhost="tonya"; //localhost or tonya
$dbuser="root"; // schema name
$dbpass="my_pass";
$dbname="webevalo"; //or "webevaloracle" for the full name
$connectionObj=new connectionClass($dns);
*/
2. in PHP can't connect either( $dbconnect=OCILogon($dbuser, $dbpass, $dbname))
So I was wandering if you can help me - either give me some advises or may be point to the source
where I can retrieve the info I need.
really appreciate your time and help
Tonya
www.one45.com