Consultor Eletrônico

Status: Verified

GOAL:

How to change Oracle Database connection parameters within the schema holder?

GOAL:

How to change Oracle Database connection parameters when no Oracle database is available?

GOAL:

How to define new Oracle Database connection settings within the schema holder?

FACT(s) (Environment):

Progress 8.x
Progress 9.x
OpenEdge 10.x
Oracle DataServer

FIX:


If on Windows:

1. Start the Data Administration tool from your Progress icon group.

2. Connect to your Oracle DataServer schema holder database:

Go to the Main menu and then select Database -> Connect.
Enter the appropriate parameters and connect to your schema holder.

3. You now need to switch to the Oracle database settings (this will not connect to the Oracle database using the existing settings):

Go to the Menu and then select Database -> Select Working Database.
Select the Oracle database.

When it asks you whether you want to connect to this database, click "NO".

4. Now that the Oracle database has been selected, you can change the connection information:

Go to the Menu and then select DataServer -> Oracle Utilities -> Edit Connection Information.

5. Change the connection information as you desire.

If on UNIX or LINUX:

1. Start the Data Dictionary and connect to the Oracle DataServer schema holder:

pro <schemaHolder.db> -rx -p _dict.p

2. You now need to switch to the Oracle database settings (this will not connect to the Oracle database using the existing settings):

Go to the Menu and then select Database -> Select Working Database.
Select the Oracle database.

When it asks you whether you want to connect to this database, click "NO".

3. Now that the Oracle database has been selected, you can change the connection information:

Go to the Menu and then select DataServer -> Oracle Utilities -> Edit Connection Information.

4. Change the connection information as you desire.