APPX is the Premier Development and Runtime Environment for Business Application Software
(Category) (Category) FAQ's - APPX Software, Inc. :
Submit A Question
Use this page to submit a new question and, optionally, an answer to the question for inclusion in the FAQ database. New questions will be reviewed by the APPX staff and, if accepted, the question and the answer will be moved to the appropriate category.
Questions Pending Review:
(Answer) Connect to 2 Oracle instances simultaneously?
[New Answer in "Submit A Question"]
2010-Feb-12 1:37pm
(Answer) (Category) FAQ's - APPX Software, Inc. : (Category) Submit A Question :
Connect to 2 Oracle instances simultaneously?
Can an APPX application accesses files residing in two different Oracle instances (two different ORACLE_SID)?
=> When you use an Oracle client, there exists a set of Oracle defined environment variables that let you select the desired instance. You can run an Oracle shell script 'oraenv', it will ask you a couple of questions, and set the environment variables accordingly.

Or, you can use the APPX_ORACLE_CONNECT environment variable in an Appx startup script. It passes a standard Oracle Connect string to Oracle.

If you're running APPX/Server, you can't dynamically change environment variables for each client coming in, so you must set up a separate APPX/Server port# for each set of instance-specifying environment variables under which you want your users to run.

See also (Xref) I can't connect to a second instance of the database (Sybase, Oracle, etc.)

[Append to This Answer]
2004-Apr-06 4:00pm
Previous: (Category) APPX Reportwriter
Next: (Answer) New Item
This document is:
[Search] [Appearance] [Show Top Category Only]
This is a Faq-O-Matic 2.719.
Copyright 2003 by APPX Software, Inc. All rights reserved.