ORACLE & Multiple databases
Posted 27 October 1999 - 12:50 PM
However, if you are on NT it is a major problem.
In the PRO4.ini file you have the connect parameter which
takes the form username/password@host_name (the same as a normal SQL call). This will route via SQLNET. We had a problem for about 3 months where users were getting thrown out of the system with an Oracle end-of-communication-channel error. The only way this could be resolved was to remove the @host_name part of the connect string and all
was OK (under very light loads it seemed OK but with 2+ users disaster struck !!).
As you can't use the @host_string part of the call you are limited to using the default database set up in the registry.
We are using multiple schemas within the same database to enable us to emulate a multiple database environment, this is OK for development but not ideal for live.
We use version 4.6, Oracle 188.8.131.52.5a and NT4.
Posted 27 October 1999 - 01:01 PM
commercial system which integrate to Oracle Financials, aswell as
having edicated ProIV/Oracle databases.
The way this is achieved (ProIV Could not tell us) is as follows.
1. Create the rquired number of Oracle Instances/databases.
2. Use one as a 'primary' point of reference and use this within
the users login profile (Unix) - variable ORACLE_SID to point to
3. Within this 'primary' SID, you have to create links to connect
the required databases. This has to be done in the database
CREATE PUBLIC DATABASE LINK link-name CONNECT TO user IDENTIFED BY password
4. Within the 'primary' SID create synonyms (also PROIV filename)
i.e there is a file in ProIV called CUSTOMER (see below)
The ar.ar_customer..... table below exists in our Oracle Financials DB.
CREATE SYNONYM CUSTOMER FOR AR.AR_CUSTOMER_PROFILE_AMOUNTS@link-name;
Repeat this process for all tables required for all required databases.
Any problems, get in touch!!
Posted 28 October 1999 - 02:30 PM
I was curious, with your solution, can the end customer easily setup alternate regions?
Many of our clients set up at least two regions: live and test. For the most part, we provide the scripts necessary from them to create their multiple regions. (Our scripts set the SID and other values so that each user can access any instance of our applications.)
If the system administrator of the end user is able to set up multiple regions without a great deal of work, your solution sounds better than what we have for our needs....
Posted 16 December 1999 - 06:59 PM
I am assuming that you have separate physical Oracle databases rather than a single database with multiple schemas. If you have multiple schemas, there are a number if different solutions.
For separate physical databases, use the following:-
In the alternate file name in @F, use the following format:
Lets say your database is 'TEST1', user is 'OPS' and it contains the table 'MYTABLE', the alternate in @F would be:-
In the initialisation file (for unix) .proivrc mention:-
[DATABASE - TEST1]
where ??? represents the connection parameters for the server/database.
PROIV will access the table MYTABLE from the remote database using the connection specified. In this way you can use serveral databases together. They may be Oracle/Sybase or any other.
SQL_USERNAME & SQL_PASSWORD etc still hold the DEFAULT database.
Reply to this topic
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users