Baanboard.com

Go Back   Baanboard.com > Forum > Baan Quick Support: Functional & Technical > Operating Systems & Databases

User login

Frontpage Sponsor

Main

Poll
For ERP LN feature pack upgrade, what method of install are you using?
Installation Wizard into existing VRC
35%
Installation Wizard into new VRC
42%
Manual into existing VRC
3%
Manual into new VRC
19%
Total votes: 31

Baanboard at LinkedIn


Reference Content

Reply
 
Thread Tools Display Modes
  #1  
Old 13th January 2010, 16:30
kberogluer kberogluer is offline
Junior Member
 
Join Date: Nov 2007
Posts: 8
kberogluer is on a distinguished road
Baan: B40 - DB: Oracle8i - OS: Unix
Baan Database Definitions
Baan: ERP LN 6.1
DB: Oracle 9.2.0.x
OS: Linux - Other
C/S: Both

Hi everyone,

I would like to check if it possible to define two databases on the very same database server( one is default that is always on and other is not on and will be on when needed).

The type of these two databases is Oracle.

The original database definition has a system name field and also parameter field both filled. The second database will be again in the same database server so i think system name field will be same but parameter field will be different in order to define the second database sid.

After completing the database definition phase, i need to assign some companies to the new database. In fact the aim is just to separate companies having data that belongs to recent years.

Is it all correct ? or is there any point missing?

Thanks in advance.
Reply With Quote
  #2  
Old 13th January 2010, 16:50
jclju1's Avatar
jclju1 jclju1 is offline
Guru
 
Join Date: Jan 2002
Posts: 554
jclju1 is on a distinguished road
Baan: Baan IV, Baan 5.0c, SSA ERP LN 6.1 - DB: bisam, Oracle, Informix, Sql Server - OS: Unix (all), Windows
What about users and Baan role in second database?
Reply With Quote
  #3  
Old 14th January 2010, 09:27
kberogluer kberogluer is offline
Junior Member
 
Join Date: Nov 2007
Posts: 8
kberogluer is on a distinguished road
Baan: B40 - DB: Oracle8i - OS: Unix
will be the same if possible
Reply With Quote
  #4  
Old 14th January 2010, 10:19
jclju1's Avatar
jclju1 jclju1 is offline
Guru
 
Join Date: Jan 2002
Posts: 554
jclju1 is on a distinguished road
Baan: Baan IV, Baan 5.0c, SSA ERP LN 6.1 - DB: bisam, Oracle, Informix, Sql Server - OS: Unix (all), Windows
I suppose that database users must be same with same passwords because there are only one ora_users and one ora_groups file.

It seems to me that this scenario will work.
Reply With Quote
  #5  
Old 14th January 2010, 11:48
kberogluer kberogluer is offline
Junior Member
 
Join Date: Nov 2007
Posts: 8
kberogluer is on a distinguished road
Baan: B40 - DB: Oracle8i - OS: Unix
it worths trying i guess. Thanks alot
Reply With Quote
  #6  
Old 16th January 2010, 13:08
Han Brinkman's Avatar
Han Brinkman Han Brinkman is offline
Guru
 
Join Date: Aug 2001
Location: The Netherlands
Posts: 1,155
Han Brinkman has a spectacular aura aboutHan Brinkman has a spectacular aura about
Baan: All - DB: Oracle/ms-sql/db2 - OS: *nix/windows
Works

I can tell you that this kind of setup will work, I have setup this kind of configurations before.
As stated in one of the other posts you indeed need to create the users in both databases (at least if the users are able to use both instances/companies).

Regards,
Han
Reply With Quote
Sponsored Links
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Attach database baan after install application baan ROLAND Tools Administration & Installation 1 17th May 2007 09:54
Baan Systems and Database Administrator Needed SSA-Baan Fan Jobs and Resumes 0 28th January 2004 18:25
Link between Baan Users & Database Users p.cole Tools Administration & Installation 11 22nd March 2003 02:51
Baanboard.com Community Bulletin 01/05/2002 patvdv About Baanboard.com 0 1st May 2002 15:04


All times are GMT +2. The time now is 18:45.


©2001-2017 - Baanboard.com - Baanforums.com