Kbase P144950: How to Configure AppServer to Connect to Remote Oracle Instance Through Oracle Dataserver?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
17/04/2009 |
|
Status: Unverified
GOAL:
How to configure AppServer to connect to remote Oracle instance through Oracle DataServer?
GOAL:
Step by step instructions on how to configure AppServer to connect to remote Oracle instance
FACT(s) (Environment):
Progress 9.x
OpenEdge 10.x
FIX:
This solution outlines steps to configure an AppServer to connect to remote Oracle instance through DataServer
1. Install Oracle DataServer and application server license on the machine.
2. Configure Oracle Net8 service through Oracle TNS.
This is Oracle DBA's job. Please have Oracle DBA test the connection from SQL Plus running on the machine, make sure SQLPlus can connect to remote Oracle instance without problem. Note the Net8 service name.
3. Create schema holder.
A. Bring up proenv session.
B. cd to the directory where schema holder will be located
C. prodb sh_name empty
D. prowin32 -1 sh_name (or pro sh_name for UNIX)
E. Go to Data Administration menu -> DataServers -> Oracle -> Create schema
Enter Logical name, Oracle user name and password, note, user name should have following format (user_name@net8_service), for example, myuser@ora10g, assuming myuser is Oracle owner name for the tables and ora10g is Net8 service name set up in step 2
Enter OK, at the next screen, select tables or schema objects to pull, enter OK
At this point, the session will connect to Oracle using Net8, schema should be pulled into schema holder
4. Configure AppServer broker to connect to schema holder and Oracle. Use asbroker1 for example, following should are sample related entries in ubroker.properties file
[Environment.asbroker1]
ORACLE_HOME=path_to_oraclt_install
[UBroker.AS.asbroker1]
srvrStartupParam=-db path_to_schema_holder -RO -db ora -ld logical_name -dt Oracle -U oracle_owner@net8_service -P pass_word
5. Test the connection by starting appserver. If the AppServer does not start, check appServer server log file for errors