Kbase P18153: What are the minimum requirements to configure Oracle DataSe
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
29/09/2003 |
|
Status: Unverified
GOAL:
What are the minimum requirements to configure Oracle DataServer.
FACT(s) (Environment):
Progress 9.x
FIX:
The following procedure assumes the following:
- Progress and Oracle reside in the same machine.
- Have access to the Oracle instance tables (it's possible to execute SELECT statements.)
- The executables have been linked correctly or have been created with the PROBUILD utility.
1) Set the the environment variables:
ORACLE_HOME=<Directory where Oracle is installed>
ORACLE_SID=<Name of the Oracle instance>
2) Get an Oracle user and password that can perform a select statement on the desired Oracle tables.
3) Create and empty DB for the holder.
4) Open a Progress session and go to the Data Administration. Connect to the holder DB and go to menu: DataServer > ORACLE Utilities > Create DataServer Schema... section.
Type:
Logical Database Name: <Name of the Oracle instance>
Oracle Version: <Version of Oracle>
Connection Parameters: -U <Oracle user> -P <Oracle Password>
Then the OK button.
5) Progress will ask the Oracle user and password, since you have provided the user and password already you can ignore this.
6) You will be prompted to define which objects you are going to pull into the schema holder.
Type the following:
Object Name: * (leave '*' if you don't know the table name)
Object Type: table
Object Owner: * (leave '*' if you don't know the owner of the table)
7) Select the tables that you want to access from Progress 4GL.
8)Disconnect the schema holder and close the Progress session.
9) Connect to the Oracle DB like this:
pro <holder name> -1 -RO -db <Oracle instance name> -dt ORACLE