Computer

PHP/Oracle Development


Syllabus
Schedule
Reading
Discussion
Project
Test
Resource
Tip

TNSPING

 

Subject: tnsping problem Topic: Geeks Corner: Week 6
Author: George Watson Date: July 21, 2010 11:01 PM

 

I also had an issue with the tnsping command. Dr. Liu helped me to trouble shoot and found that I was calling my service Oracle when I should have been calling it XE since I'm using Express Edition. As Follows:
c:\>tnsping xe

The output from this call allowed me to redefine my $database variable in OracleStandardConnection.php as:
$database='(description=(address=(protocol=tcp)(host=Dave-PC)(port=1521))(connect_data=(server=dedicated)(service_name=xe)))';

And I'm now connecting to my database.

Dr. Liu, thank you for your help and time today!

Thanks
Dave

 

By George Watson (Summer 2010)