Cannot connect to Oracle database server on WAMP
Moderator: General Moderators
-
sonumittal
- Forum Newbie
- Posts: 9
- Joined: Thu Jun 05, 2008 12:51 am
Cannot connect to Oracle database server on WAMP
Everah | This thread was split from another thread.
ok......
tanks......
also i have another probelmmm,,,,,,,,
when i try to make connection to remote oracle server using php comand oci_connect...it gives error fatal error call to undefined function oci_connect........
i m using wamp ....i have oracle developer suite and toad installed on my local pc....
i have editted php.ini ....but still ion phpinfo it does not show oci8 extensino loaded.......
tell me wat t odo........
ok......
tanks......
also i have another probelmmm,,,,,,,,
when i try to make connection to remote oracle server using php comand oci_connect...it gives error fatal error call to undefined function oci_connect........
i m using wamp ....i have oracle developer suite and toad installed on my local pc....
i have editted php.ini ....but still ion phpinfo it does not show oci8 extensino loaded.......
tell me wat t odo........
- RobertGonzalez
- Site Administrator
- Posts: 14293
- Joined: Tue Sep 09, 2003 6:04 pm
- Location: Fremont, CA, USA
Re: Cannot connect to Oracle database server on WAMP
Are you sure you are loading the extension? Did you restart your web server after making the php.ini changes? Have you checked your server error logs to see if you are getting any errors?
-
sonumittal
- Forum Newbie
- Posts: 9
- Joined: Thu Jun 05, 2008 12:51 am
Re: Cannot connect to Oracle database server on WAMP
ya i ahve done chenges in the php.ini ans restarted the web server.....
log says php_oracle and php_oci.dll not found.....
but the file is at the ame address told by the error log..........
log says php_oracle and php_oci.dll not found.....
but the file is at the ame address told by the error log..........
- RobertGonzalez
- Site Administrator
- Posts: 14293
- Joined: Tue Sep 09, 2003 6:04 pm
- Location: Fremont, CA, USA
Re: Cannot connect to Oracle database server on WAMP
Post the part of your php.ini where you are including the oracle extensions.
-
sonumittal
- Forum Newbie
- Posts: 9
- Joined: Thu Jun 05, 2008 12:51 am
Re: Cannot connect to Oracle database server on WAMP
i m using wamp server 2c.........
;;;;;;;;;;;;;;;;;;;;;;;;;
; Paths and Directories ;
;;;;;;;;;;;;;;;;;;;;;;;;;
; UNIX: "/path1:/path2"
;include_path = ".:/php/includes"
;
; Windows: "\path1;\path2"
;include_path = ".;c:\php\includes"
; The root of the PHP pages, used only if nonempty.
; if PHP was not compiled with FORCE_REDIRECT, you SHOULD set doc_root
; if you are running php as a CGI under any web server (other than IIS)
; see documentation for security issues. The alternate is to use the
; cgi.force_redirect configuration below
doc_root =
; The directory under which PHP opens the script using /~username used only
; if nonempty.
user_dir =
; Directory in which the loadable extensions (modules) reside.
extension_dir = "c:/wamp/bin/php/php5.2.6/ext/"
; Whether or not to enable the dl() function. The dl() function does NOT work
; properly in multithreaded servers, such as IIS or Zeus, and is automatically
; disabled on them.
enable_dl = On
;;;;;;;;;;;;;;;;;;;;;;
; Dynamic Extensions ;
;;;;;;;;;;;;;;;;;;;;;;
;
; If you wish to have an extension loaded automatically, use the following
; syntax:
;
; extension=modulename.extension
;
; For example, on Windows:
;
; extension=msql.dll
;
; ... or under UNIX:
;
; extension=msql.so
;
; Note that it should be the name of the module only; no directory information
; needs to go here. Specify the location of the extension with the
; extension_dir directive above.
; Windows Extensions
; Note that ODBC support is built in, so no dll is needed for it.
; Note that many DLL files are located in the extensions/ (PHP 4) ext/ (PHP 5)
; extension folders as well as the separate PECL DLL download (PHP 5).
; Be sure to appropriately set the extension_dir directive.
;extension=php_bz2.dll
;extension=php_curl.dll
;extension=php_dba.dll
;extension=php_dbase.dll
;extension=php_exif.dll
;extension=php_fdf.dll
extension=php_gd2.dll
;extension=php_gettext.dll
;extension=php_gmp.dll
;extension=php_ifx.dll
;extension=php_imap.dll
;extension=php_interbase.dll
;extension=php_ldap.dll
extension=php_mbstring.dll
;extension=php_mcrypt.dll
;extension=php_mhash.dll
;extension=php_mime_magic.dll
;extension=php_ming.dll
;extension=php_msql.dll
;extension=php_mssql.dll
extension=php_mysql.dll
extension=php_mysqli.dll
extension=php_oci8.dll
;extension=php_openssl.dll
extension=php_pdo.dll
;extension=php_pdo_firebird.dll
;extension=php_pdo_mssql.dll
extension=php_pdo_mysql.dll
extension=php_pdo_oci.dll
extension=php_pdo_oci8.dll
extension=php_pdo_odbc.dll
;extension=php_pdo_pgsql.dll
;extension=php_pdo_sqlite.dll
;extension=php_pgsql.dll
;extension=php_pspell.dll
;extension=php_shmop.dll
;extension=php_snmp.dll
;extension=php_soap.dll
;extension=php_sockets.dll
extension=php_sqlite.dll
;extension=php_sybase_ct.dll
;extension=php_tidy.dll
;extension=php_xmlrpc.dll
;extension=php_xsl.dll
;extension=php_zip.dll
[OCI8]
; enables privileged connections using external credentials (OCI_SYSOPER, OCI_SYSDBA)
;oci8.privileged_connect = Off
; Connection: The maximum number of persistent OCI8 connections per
; process. Using -1 means no limit.
;oci8.max_persistent = -1
; Connection: The maximum number of seconds a process is allowed to
; maintain an idle persistent connection. Using -1 means idle
; persistent connections will be maintained forever.
;oci8.persistent_timeout = -1
; Connection: The number of seconds that must pass before issuing a
; ping during oci_pconnect() to check the connection validity. When
; set to 0, each oci_pconnect() will cause a ping. Using -1 disables
; pings completely.
;oci8.ping_interval = 60
; Tuning: This option enables statement caching, and specifies how
; many statements to cache. Using 0 disables statement caching.
;oci8.statement_cache_size = 20
; Tuning: Enables statement prefetching and sets the default number of
; rows that will be fetched automatically after statement execution.
;oci8.default_prefetch = 10
; Compatibility. Using On means oci_close() will not close
; oci_connect() and oci_new_connect() connections.
;oci8.old_oci_close_semantics = Off
[PostgresSQL]
; Allow or prevent persistent links.
pgsql.allow_persistent = On
;;;;;;;;;;;;;;;;;;;;;;;;;
; Paths and Directories ;
;;;;;;;;;;;;;;;;;;;;;;;;;
; UNIX: "/path1:/path2"
;include_path = ".:/php/includes"
;
; Windows: "\path1;\path2"
;include_path = ".;c:\php\includes"
; The root of the PHP pages, used only if nonempty.
; if PHP was not compiled with FORCE_REDIRECT, you SHOULD set doc_root
; if you are running php as a CGI under any web server (other than IIS)
; see documentation for security issues. The alternate is to use the
; cgi.force_redirect configuration below
doc_root =
; The directory under which PHP opens the script using /~username used only
; if nonempty.
user_dir =
; Directory in which the loadable extensions (modules) reside.
extension_dir = "c:/wamp/bin/php/php5.2.6/ext/"
; Whether or not to enable the dl() function. The dl() function does NOT work
; properly in multithreaded servers, such as IIS or Zeus, and is automatically
; disabled on them.
enable_dl = On
;;;;;;;;;;;;;;;;;;;;;;
; Dynamic Extensions ;
;;;;;;;;;;;;;;;;;;;;;;
;
; If you wish to have an extension loaded automatically, use the following
; syntax:
;
; extension=modulename.extension
;
; For example, on Windows:
;
; extension=msql.dll
;
; ... or under UNIX:
;
; extension=msql.so
;
; Note that it should be the name of the module only; no directory information
; needs to go here. Specify the location of the extension with the
; extension_dir directive above.
; Windows Extensions
; Note that ODBC support is built in, so no dll is needed for it.
; Note that many DLL files are located in the extensions/ (PHP 4) ext/ (PHP 5)
; extension folders as well as the separate PECL DLL download (PHP 5).
; Be sure to appropriately set the extension_dir directive.
;extension=php_bz2.dll
;extension=php_curl.dll
;extension=php_dba.dll
;extension=php_dbase.dll
;extension=php_exif.dll
;extension=php_fdf.dll
extension=php_gd2.dll
;extension=php_gettext.dll
;extension=php_gmp.dll
;extension=php_ifx.dll
;extension=php_imap.dll
;extension=php_interbase.dll
;extension=php_ldap.dll
extension=php_mbstring.dll
;extension=php_mcrypt.dll
;extension=php_mhash.dll
;extension=php_mime_magic.dll
;extension=php_ming.dll
;extension=php_msql.dll
;extension=php_mssql.dll
extension=php_mysql.dll
extension=php_mysqli.dll
extension=php_oci8.dll
;extension=php_openssl.dll
extension=php_pdo.dll
;extension=php_pdo_firebird.dll
;extension=php_pdo_mssql.dll
extension=php_pdo_mysql.dll
extension=php_pdo_oci.dll
extension=php_pdo_oci8.dll
extension=php_pdo_odbc.dll
;extension=php_pdo_pgsql.dll
;extension=php_pdo_sqlite.dll
;extension=php_pgsql.dll
;extension=php_pspell.dll
;extension=php_shmop.dll
;extension=php_snmp.dll
;extension=php_soap.dll
;extension=php_sockets.dll
extension=php_sqlite.dll
;extension=php_sybase_ct.dll
;extension=php_tidy.dll
;extension=php_xmlrpc.dll
;extension=php_xsl.dll
;extension=php_zip.dll
[OCI8]
; enables privileged connections using external credentials (OCI_SYSOPER, OCI_SYSDBA)
;oci8.privileged_connect = Off
; Connection: The maximum number of persistent OCI8 connections per
; process. Using -1 means no limit.
;oci8.max_persistent = -1
; Connection: The maximum number of seconds a process is allowed to
; maintain an idle persistent connection. Using -1 means idle
; persistent connections will be maintained forever.
;oci8.persistent_timeout = -1
; Connection: The number of seconds that must pass before issuing a
; ping during oci_pconnect() to check the connection validity. When
; set to 0, each oci_pconnect() will cause a ping. Using -1 disables
; pings completely.
;oci8.ping_interval = 60
; Tuning: This option enables statement caching, and specifies how
; many statements to cache. Using 0 disables statement caching.
;oci8.statement_cache_size = 20
; Tuning: Enables statement prefetching and sets the default number of
; rows that will be fetched automatically after statement execution.
;oci8.default_prefetch = 10
; Compatibility. Using On means oci_close() will not close
; oci_connect() and oci_new_connect() connections.
;oci8.old_oci_close_semantics = Off
[PostgresSQL]
; Allow or prevent persistent links.
pgsql.allow_persistent = On
-
madan koshti
- Forum Commoner
- Posts: 50
- Joined: Fri Jun 06, 2008 4:25 am
Re: Cannot connect to Oracle database server on WAMP
Hi,
In which php.ini file your are doing this change ?? (I mean php/php.ini ?? or anywhere else).
You need to run phpinfo() and check "Configuration File (php.ini) Path" variable and
"Loaded Configuration File" from where your php.ini will be used.make changes there and restart the wamp server.
Hope it will work.
In which php.ini file your are doing this change ?? (I mean php/php.ini ?? or anywhere else).
You need to run phpinfo() and check "Configuration File (php.ini) Path" variable and
"Loaded Configuration File" from where your php.ini will be used.make changes there and restart the wamp server.
Hope it will work.
-
sonumittal
- Forum Newbie
- Posts: 9
- Joined: Thu Jun 05, 2008 12:51 am
Re: Cannot connect to Oracle database server on WAMP
php info tell
configuration file path c:\windows
laoded file configuration c:\wamp\bin\apache\apache 2.2.8\bin\php.ini
Tell me which file is used by the php
sine there is no file in c:\windows........
also i have changed php.ini configuration in 2 locations...
first in apache folder
second in php folder
i m using wampserver 2c on vista.........
configuration file path c:\windows
laoded file configuration c:\wamp\bin\apache\apache 2.2.8\bin\php.ini
Tell me which file is used by the php
sine there is no file in c:\windows........
also i have changed php.ini configuration in 2 locations...
first in apache folder
second in php folder
i m using wampserver 2c on vista.........
-
madan koshti
- Forum Commoner
- Posts: 50
- Joined: Fri Jun 06, 2008 4:25 am
Re: Cannot connect to Oracle database server on WAMP
Hi ,
According to me , if ur phpinfo shows "configuration file path c:\windows" then there must
be php.ini file in c:\windows\ .Are you sure that there is no php.ini file ?
Anyway , Have you tryed by changing php.ini (in both apache/ and php/ folders ?)
and restarting WAMP server ?
According to me , if ur phpinfo shows "configuration file path c:\windows" then there must
be php.ini file in c:\windows\ .Are you sure that there is no php.ini file ?
Anyway , Have you tryed by changing php.ini (in both apache/ and php/ folders ?)
and restarting WAMP server ?
- RobertGonzalez
- Site Administrator
- Posts: 14293
- Joined: Tue Sep 09, 2003 6:04 pm
- Location: Fremont, CA, USA
Re: Cannot connect to Oracle database server on WAMP
Remember that PHP, by default, has configuration settings built into it. So even if there is no ini file it will still run with defaults.
In your PHP info output there should be something that tells you where the ini file is being looked for. If it isn't there, copy one of the other ones on your system to that path (better yet, make a link to it). Restart the web server and see if that had any effect.
In your PHP info output there should be something that tells you where the ini file is being looked for. If it isn't there, copy one of the other ones on your system to that path (better yet, make a link to it). Restart the web server and see if that had any effect.