• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 572
  • Last Modified:

Setting Oracle from WAMP

Hello Experts,

I have installed WAMP on my local desktop and also downloaded phporacleview and kept the folder under WWW path.

Now I have a local database i.e. Oracle version 10.2.0.

Now I want to use phporacleview as similar to myphpadmin for MYSQL database.

Please help me in setting php page to Oracle.

0
swadhinray
Asked:
swadhinray
2 Solutions
 
InsoftserviceCommented:
hi,
u mean to say that u want to quit mysql and instead of that u want to use oracle.
please confirm
0
 
swadhinrayAuthor Commented:
Yes..
0
 
fundacionrtsAdministrador de SistemasCommented:
You need to install InstantClient in your local desktop to enable communication between php and oracle.

Basically, the steps to install InstantClient on your desktop are

1. Download instantclient-basic-win32-10.2.0.4.zip from www.oracle.com
2. Unzip this file in c:\instantclient (or other folder you want)
3. Create file tnsnames.ora in folder c:\instantclient
4. Configure  tnsnames.ora as you need.
5. My Computer > Properties > Advanced options > Environment variables > System variables
   5.1 Modify PATH and set value c:\instantclient;<CURRENT_PATH_VALUE>
   5.2 Create TNS_ADMIN and set value c:\instantclient\tnsnames.ora
6. Edit php.ini and uncomment
extension=php_oci8.dll
7. Restart Apache

At this time, you can acces Oracle using php/apache.

I hope this instructions help you.

Link to detailed instructions: http://www.oracle.com/technetwork/articles/technote-php-instant-084410.html
   5.1 Create variable TNS_ADMIN and set value c:\instantclient\tnsnames.ora
0
 
swadhinrayAuthor Commented:
I have done all the 7 steps now how can I log in to oracle through phporacleview.

Attaching the phporacleview file that I have downloaded.

there is a file "db_oracle.inc" where I need to provide the DB details along with that I need to provide the path, so which path I need to give there ?

Instant client path or oracle home path?

or just let me know how to do the settings.
0
 
kadadi_vCommented:
Please Check this PHP + Oracle Database Connection Strings

http://blogs.oracle.com/alison/2006/04/oracle_database_connection_str.html

Regards,
vijay kadadi
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now