Kbase P4968: How to create a schema holder with Oracle DataServer
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
09/12/2008 |
|
Status: Verified
GOAL:
How to create a schema holder with Oracle DataServer
GOAL:
How to populate tables inside a schema holder database.
GOAL:
Basic Guide to creating an Oracle Schema Holder and connecting Host Based
FACT(s) (Environment):
Oracle DataServer
All Supported Operating Systems
Progress 8.x
Progress 9.x
OpenEdge 10.x
FIX:
Make sure the following is already configured and set up before creating the Schema holder
1. Oracle db has been created
2. If the Progress version that you are working with requires the DataServer components to be built into the progress dataserver executable, probuild has been done.
3. All related environment variables are set.
Steps for creating a schema holder
1. Create an empty Progress database for schema holder. In this example, the database is named orash.
prodb orash empty
2. Connect to the empty orash database in single user mode.
_progres orash -1 (character client or use pro on UNIX)
prowin32 orash -1 (gui client)
3. Go into the Tools -> Data Dictionary -> DataServer -> Oracle Utilities -> Create DataServer Schema.
4. In the "Create/Modify Database Record for DataServer Schema" window,
change the following parameters.
Logical Database Name: myora
Oracle Version: 8
Connection Parameters: -U user -P password
Continue.
5. At the "User ID and Password" window continue. It will use the same username and password that have been entered on the previous window. At this point it is making the connection to the Oracle database to retrieve the schema.
6. At the "Pre-Selection Criteria For Schema Pull" window, select the appropriate areas that will be listed. Once they are listed, select which tables etc that you would like to pull into the Progress Schema Holder.
7. At the "Select ORACLE Objects" window, select the objects that you
would like to retrieve into the Progress Schema Holder (note that
NOTHING is selected by default). this is only retrieving the schema,
not the data. Continue.
8. Once complete, Progress Data Dictionary main menu will come back. The building of the Progress Schema Holder is now complete.
Exit the Progress client.
9. To connect a Progress client on the same machine
_progres orash -1 -db myora -ld "myora" -dt ORACLE -U user -P password
Explanation of Parameters:
The first database listed does not need to have the parameter "-db" before it. However, every subsequent database does. All parameters up to the following "-db" relate to the previous database. e.g. In the line above, the only parameter that relates to the orash database is the "-1" parameter. Because the next parameter after "-1" is a "-db", this means that all other parameters are related
to the myora database (because there is not another -db).
1. "orash -1". To connect to the Progress schema holder (orash) database in single user mode.
2. "-db myora". To connect to an Oracle database called "myora".
3. "-ld "myora". Logical database name is "myora"
4. "-dt ORACLE". "-db myora" is an Oracle database not a Progress database.
5. "-U "user" -P "password". Username and password to be used for connecting to the Oracle database.