need help connecting to remote Oracle
Posted by: ms01 (---.njit.edu)
Date: April 29, 2007 02:04AM

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 = MYDcool smiley
)
)

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.


Options: ReplyQuote
Re: need help connecting to remote Oracle
Posted by: CyberSpatium (71.237.217.---)
Date: April 29, 2007 04:29AM

this is not a wamp issue. contact your schools it department to find out how to connect to their oracle server and if they allow you to connect to it.

CyberSpatium
----------------------
WAMP English Forum Admin

Need help? Check out my WAMP User Manual/Guide here!

Please visit my latest website Clarify Loans:
clarifyloans.com[/url

Options: ReplyQuote


Sorry, only registered users may post in this forum.