Hi
We are currently using PRO 6.2 and are looking to migrate to Oracle 10g from pro-isam/cisam.
We have pro-iv running on a linux ES5 server and a Oracle database running on a Linux server.
To test connectivity we have created a dummy file in PRO with 1 key and 1 alpha field and also created an equivalent table in Oracle. My question is, how do you set up your connection string between pro-iv and the Oracle DB and are there any on-line user manuals?
If it's easier to connect to Oracle running on windows we can do this instead as a starting point.
Cheers Geoff
How to Connect Pro-IV to Oracle Database
Started by Geoff Riley, Nov 17 2009 02:37 PM
2 replies to this topic
#2
Posted 17 November 2009 - 06:48 PM
Geoff,
I assume from what you say that the Oracle DB is on a different Linux box than ProIV.
If so, you need to configure things so that ProIV as the "Oracle client" can find the Oracle "service" (the database) on the other box.
There's more than one way to go about this but, keeping it simple, if I recall correctly you need to worrry about the following:
Configuring the service and running the Oracle listener on the database box (probably done by default).
Installing the Oracle client-side stuff on your ProIV box (I imagine you have already if an Oracle-capable ProIV is working).
Configuring the servicename on the ProIV machine side (just a tnsnames.ora file in the simple case I think - Google it).
The historical Oracle connection string is of the form dbusername/password@servicename
You should be able to test connecting just by using SQL*Plus (or other interactive SQL tool) before trying with ProIV (this is a good idea anyway for sanity checking..)
In the simplest case I think the connect info can be set for ProIV with the following ProIV unix environment variables:
export SQL_USERNAME=dbusername
export SQL_PASSWORD=password@servicename
Good luck. If no one there has used Oracle before you're on a steep learning curve
I assume from what you say that the Oracle DB is on a different Linux box than ProIV.
If so, you need to configure things so that ProIV as the "Oracle client" can find the Oracle "service" (the database) on the other box.
There's more than one way to go about this but, keeping it simple, if I recall correctly you need to worrry about the following:
Configuring the service and running the Oracle listener on the database box (probably done by default).
Installing the Oracle client-side stuff on your ProIV box (I imagine you have already if an Oracle-capable ProIV is working).
Configuring the servicename on the ProIV machine side (just a tnsnames.ora file in the simple case I think - Google it).
The historical Oracle connection string is of the form dbusername/password@servicename
You should be able to test connecting just by using SQL*Plus (or other interactive SQL tool) before trying with ProIV (this is a good idea anyway for sanity checking..)
In the simplest case I think the connect info can be set for ProIV with the following ProIV unix environment variables:
export SQL_USERNAME=dbusername
export SQL_PASSWORD=password@servicename
Good luck. If no one there has used Oracle before you're on a steep learning curve
Nothing's as simple as you think
Reply to this topic
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users