two databases in one host

[Former Member]

Hi,

I found with the next doubt,

I ´ve installed a sap system in the DBHOME oracleC14102, this home has created with the oui. Then I want to install the second sap system in the same host.This second sap system is included in the dbhome oracleC14102

The directory oracleC14102 will be duplicate? Or it will included?

[former_member204746]

you should use another ORACLE_HOME for your second database. This way, you will be able to upgrade 1 database at a time later.

[Former Member]

But it´s not possible of this way?

In the installation I´ve this error:

STARTUP NOMOUNT;

exit;

Output of SQL executing program:

SQL*Plus: Release 10.2.0.4.0 - Production on Fri Apr 9 14:02:03 2010

Copyright (c) 1982, 2007, Oracle. All Rights Reserved.

ERROR:

ORA-01031: insufficient privileges

SP2-0751: Unable to connect to Oracle. Exiting SQL*Plus

SAPINST: End of output of SQL executing program e:oracleERP102/bin/sqlplus.

SAPINST found errors.

SAPINST The current process environment may be found in sapinst_ora_environment.log.

2010-04-09, 14:02:04 SAPINST ORACLE stop logging

But I dont know If it´s for this.

[Former Member]

Hi,

.This second sap system is included in the dbhome oracle\C14\102

You planning MCOD ?

I am assuming your have installed one oracle database under one user ID

Created a new user ID for the second install

\oracle\<SID1>\102

\oracle\<SID2>\102

Mark

[former_member204746]

you should have set ORACLE_HOME before installing second instance.

also, have you installed Oracle using SAPSERVER.CMD ?

[Former Member]

i´ve installed the oracle software with sapserver.cmd, after that I´ve done the installation of abap instance, after that I want to install the java instance and I´ve the before error.

In the installation guide explains this about single oracle home

You use a single Oracle Home®0

You can use a single Oracle Home, if you use the same Oracle database version on one host for different database instances.

With a single Oracle Home, you have to install the database software only once.

With a single Oracle Home, you cannot administer your databases independently.

For example, if you want to install a patch set, you have to stop all databases and install the patch set on all databases. When the installation is finished, you have to perform the post-installation tasks of the patch set on all databases.

Edited by: Ruben Torres on Apr 9, 2010 6:08 PM

[former_member204746]

With a single Oracle Home, you cannot administer your databases independently.

For example, if you want to install a patch set, you have to stop all databases and install the patch set on all databases. When the installation is finished, you have to perform the post-installation tasks of the patch set on all databases.

There ya go, one good reason to use 2 ORACLE_HOME...