cancel
Showing results for 
Search instead for 
Did you mean: 

Multiple oracle instances in single SLD

Former Member
0 Kudos

Hi

There is requirement from management that they need a seperate database in the present SLD (DEV,QAS,PRD). Since they plan to move this database in future to another SLD. I have gone through some SAP notes that u can have multiple SAP systems and underlying databases on a single host. Also I noted that u need to have a seperate transport directory.

My doubt is since SAP SID requires a Database SID during the installation. So how this new database can be incorporated in the present system.

If any white papers,pitfalls are highly appreciated.

Thanks

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi,

Did you want to install a new database instance in your system? The same Version? Or did you want to create a new Database Schema on your running database?

Oracle 8, 9 , 10?

I think is no recomended to do this on a productive system. Probably you should install a separated Oracle Instance but no a new Schema on your SAP DB.

Best Regards,

Erick Ilarraza

Former Member
0 Kudos

Hi Erick

It is the same oracle version i.e 9i rel.2. we need a seperate oracle insance. My concern is even though u installed a new database making it available in the present DEV,QAS,PRD is a problem. How the existing Dialog instances will recognise this new oracle instance.

what i came to know from the documents is that u need to have a seperate SAP systems and underlying the new database is quite possible and u need to take care of sizing. I searched on the net but couldn't find a similar scenario.

Any other inputs are higly appreciated.

Thanks