I desperate to connect to my University Oracle. I using the latest WAMP5 and my University Oracle is 10g. What do you need to do to connect to the university remote Oracle. I edited the php.ini where extension=php_oci8.dll? I downloaded the oracle client from oracle website, created tnsnames.ora
MYDB =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = prophet.njit.edu)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = MYD
)
)
I don't if I enter the host correctly, in my case I enter the address of my university oracle
The port = 1521 and SID = course, but not sure if the connect Identifier is SID or do you need to enter this
My University iSQL* Plus have these three field you must enter to log in
Username
Password
Connect Identifier = course
I also modify the path environment.
Secondly, is there a test script to test the connection?
I would appreciated if there is suggestion.