• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 585
  • 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_vIT AdminCommented:
Please Check this PHP + Oracle Database Connection Strings

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

Regards,
vijay kadadi
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Microsoft Exchange Server

The MCTS: Microsoft Exchange Server 2010 certification validates your skills in supporting the maintenance and administration of the Exchange servers in an enterprise environment. Learn everything you need to know with this course.

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