You are much better off using multiple users in a single instance. For example, convert and run your old instances to <user1>, <user2> & <user3> in new single instance respectively. You will need to tweak the cache size and max connections params to handle the additional load but it works good and gives you the feel of multiple databases per server.
Then simply create and assign Roles/users to allow cross-user-db information sharing. Be sure to have enough data/log devspaces to grow into ( I have 10 ). If you need additional info/help feel free to email with more questions and, as always, good luck. Kevin -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Dittmar, Daniel Sent: Monday, July 07, 2003 5:06 AM To: 'Dayanand Ochani'; [EMAIL PROTECTED] Subject: RE: Query - Multiple Database Instances in a single client with common OS > We have three different live SAP installations in > three different servers. (All three companies now > belong to same customer) > We have to move these three databases (which are on > different servers) to a common single server. > > We want to know whether 'multiple database instances' > are possible with common operating system (in a single > server) ? It is certainly possible, but generally not recommended for production databases: - kernel parameters like CACHE_SIZE and MAXCPU must be set such that the limits of the machine are distributed among the database instances - devspaces/volumes for different databases shouldn't be placed on the same disk - you should install one copy of the SAP DB software per database instance. Having them share the software installation makes upgrading much harder. Daniel Dittmar -- Daniel Dittmar SAP DB, SAP Labs Berlin [EMAIL PROTECTED] http://www.sapdb.org/ _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
