Hello,

Is it possible to have two different databases under the same instance baan, that is, a baan instance can have two portings or the same porting can access differents database?

The reason of this question is that we need to move a trial company into a new database. The problem is that the real company runs under Oracle 8.0.6 and the version of the new database is 8.1.7.

Thanks a lot,

Juan Sánchez

You have to follow following steps.

1.Take complete export of the test company
2.Delete the tables of those company.
3.Create a new database in ttaad4110m000 with appropriate parameter.
4. Assign the tables of test company to this database in session ttaad4111m000 .
5. Conver to runtime dd
6. Log out/ login
7. Create tables in baan for the test company
8. Import the data from the export taken in 1st step.

As the 2nd database also is Oracle8 you don't need to re-license Baan. Just check whether Baan porting set u have can work with both oracle database version simultaneously.

Do you have any experience about the subject? Do you know if it's a good choice?

Juan,

I am not sure if you can use different porting set version for the same installation/environment.

Hitesh has already explained about creating multiple database instances for the same baan environment.

If you have different Oracle version it would still be working but you have to be aware of how BaaN database drivers are functioning.

[DEV:bsp]/app/lms/lmst/opt/bse/lib/defaults>cat db_resource
use_shm_info:1
dbsinit:01
ora_max_array_fetch:5
ora_max_array_insert:5
nls_lang:american_america.we8iso8859p1
nls_sort:binary
oracle_home:/app/common/oracle/product/8.1.7.2
ora_temporary_tablespace:TEMP
[DEV:bsp]/app/lms/lmst/opt/bse/lib/defaults>

You can have only one ora_home set for a particular login. You can still set different db_resource files for specific users and use them in command line options. But you cannot specific different ora_home for different databases for the same login. So once a ora_home is set, then the driver would use that particular Oracle binaries during execution and most of the Oracle binaries are forward/backward compatible. You still would have to refer to the release notes of the porting set to validate which particular Oracle versions are support.

As Prashanth pointed out u can have only 1 Oracle home for 1 particular Baan login (not unix login). You need to create different logins for ur test database. You should not switch between companies with different database. Further there should not be any table sharing between such companies.

U need to check if your current porting set is valid for both oracle database version or not . This is very crucial.

Creating 2 Baan environments (with different BSE's) is technically possible but not advisable due to elaborate procedure . You may need to re-licence Baan also.

Another important thing is kernel settings in OS and buffers settings in both oracle instance . If any one Oracle instance is not able to create searate shared memory segment , then the system performance may degrade / oracle instance may not start itself.

Further decide on the driver level in both database. According to me it should be same in both database instance. Let some Oracle / Baan user confirm this.

We have done somewhat similar things (not exactly same) in the past.

In order that your live environment is not disturbed at any cost, it's advisable to get Oracle and Baan support advice and confirmation also in this matter.

Hi Hitesh,
I read this and I think I did this before but I am little confused for a particular case.
Our archive companies are getting big and back time is getting more and more.
This is our current Set up.
Baan version = IVb4
Oracle Version = Oracle7
One Bshell and One Oracle database for both production Company 150 and Archive company 500 (for year 2000), 501 (for year 2001) etc.
We back the whole database everyday and we have lots space problem.

What I want to do, please tell me possible or not?

Baan version = IVb4
Oracle Version = Oracle7
One Bshell and two Oracle database, one for production Company 150 and
another for all Archive company 500 (for year 2000), 501 (for year 2001) etc.
We will take everyday backup of first database.
We want to switch company and see data in either Production or Archive company. We ran Data Warehouse Project in Archive database. Archive database is backed up when needed and also on monthly basis.

If you can tell whether this is possible or not. If possible what should I do with archive companies as they are in the same database now.

Thanks in advance.

Sincerely...

Jay

If you can tell whether this is possible or not. If possible what should I do with archive companies as they are in the same database now.
Jay, yes that is possible, but there would be different issues you you would have to consider and plan accordingly.
Adding a database on a server does add more resources to the box. Also, multiple databases causes multiple baan database driver connections, hence some performance impact for the BaaN application.
You can surely add another database and move your company from the existing database to the new one. Time is the big factor in this process for a production downtime. You would have to export the archieve company from the current database, delete tables in the current database, change tabledef's and database definitions to the new database, create tables in new database and then import the data into the new database, create database users.

This is under the assumption that the new database is built according to the sizing, specifications, settings etc etc... wrong NLS settings can cause some datacorruptions, or insufficial rollback segments would affect the import process, do you like to keep it in archieve mode or not for the point in time data etc...

May not seem as simple as it seems but its do-able :p we juggled around the companies across databases few times.

Good Luck...! :)

Dear Mr. Rao,
Can I have the second database in Baanbase or TP. I tried creating another company 200 and assign it to Baanbase.
But I am not able to create table and giving 515 error.
Thanks

Jay

Jay,

I am not sure with BaaN/Triton-Base.

According to the tools error manual-
515 ELICENSEERROR This indicates a license error; probably an unpatched binary.
Refer to the other thread on the board -

Bisam on BaanIVc4 (http://www.baanboard.com/baanboard/showthread.php?s=&threadid=13323)

According to Dikkie -
The only thing you have to consider is the Baan licence. If your original installation is not able for TBASE/ Bisam, you have to change the licence to make it work.

As Prashanth told , u can have Baan base /oracle provided u are apropriately licensed and proper sizing is done.

But looking at ur original post, I believe ur only problem is hard disk space because u take complete database backup. In Oracle it is possible to take the backup of part of the database. Or alternatively u can take the backups of your live company through Baan export itself. We use Baan export at our place for daily backup.

Thanks Prasanth and Hitesh,
Now I have more questions...
How to create a new Oracle Database. It has to be in same Oracle Home I know. Is it just creating a new database instance or something else. I am confused because of , how to create users and group. Current we triton/triton as user/password and group as triton.
Thanks in advance

Jay

Hi Jay

You will need to create the following users/roles

grant dba to triton identified by triton;
create role r_triton;
grant r_triton to triton;
alter user triton default tablespace LIVESMALLDAT temporary tablespace TEMPORARY_DATA;


For each user that connects to Baan create as follows:
create user test_user identified by test_user;
grant create session to test_user;
grant r_triton to test_user;
alter user test_user default tablespace LIVESMALLDAT temporary tablespace TEMPORARY_DATA;

I would generate a script from the ora_users file.

You may not need to grant dba to triton -
connect , resource, create session may be sufficient.

You could also use ora?_admin and ora?_maint

Hi everybody,

just to stir up this discussion a bit:

It is not true, that the different databases need to have the same ORACLE_HOME!!! When you define the databases in "Maintain Databases" you can enter in the "Parameter" field the ORACLE_HOME (and other parameters) to be used.

It is also not true, that you can not switch with a user between companies in different Oracle instances. Baan is handling this perfectly ok!

We have this setup in several places and poses no problem at all. You only have to consider two restrictions:

a) You have only one ora_users file, therefore the passwords in the different Oracle instances must be the same, if a baan user is working in companies accross Oracle instances.

b) As mentioned before, it is not advaisable to have logical tables accross Oracle instances or to mix tables of a single company in several Oracle instancs. Technically this is possible with Baan, but transaction consistency (Rollback) is not given anymore.

I hope, I could contribute to the overall confusion a bit :-)

Enjoy

Markus

Markus is right with the ORACLE_HOME. Sorry, I overlooked it early. We are trying to upgrade to Oracle-9i (9.2.0.3) and we have some problems using the 8.1.7.2 driver paramters from the $BSE/lib/defaults/db_resource. We faced some data corruptions due to NLS settings etc. Not yet sure if its BaaN or Oracle problem.

It also seems something dependent on the porting sets versions. Also seems like having a uniform database version is good but if one already has big databases and lesser downtimes then we have to do only one at a time to take it slow, test, evaluate and go ahead with others.

It seems when we upgraded the porting set and changed the executeable binaries to 9.2.0.3 it seemed working fine, but for the porting set is a buggy one with some other good and bad features.

Got case with BaaN support and working on it...:cool:

@Markus

it is possible to configure tables of one company in different Oracle databases.
But:

it's not easy to design on Oracle, because you had to setup a distributed database.
If you do this, you had also transaction consistency.

Martin