Oracle 10g installation in server where already Oracle 9 exist.

[Former Member]

Hi,

We are planning to install Solution Manger 7.0 in UAT server where already R/3, BW and Portal are installed.

R/3, BW and Portal are installed with Oracle 9 in this server. Now, I am going to install Solution manger 7.0 with Oracle 10g.

My question is, if I install Oracle10g in the same server, it will affect of the oracle 9 systems.

Is there any special prerequisite for in this scenario?

All the application database are installed under /Oracle directory.

Please suggest on this to proceed the installation.

Regards,

Vamsheedhar.

[markus_doehr2 · Accepted solution]

> R/3, BW and Portal are installed with Oracle 9 in this server. Now, I am going to install Solution manger 7.0 with Oracle 10g.

Just as a remark: you're aware that Oracle 9 is out of support already?

> My question is, if I install Oracle10g in the same server, it will affect of the oracle 9 systems.

Not if you do it "correctly"

> Is there any special prerequisite for in this scenario?

Read the installation guide and install Oracle using "RUNINSTALLER" (not runInstaller)

> All the application database are installed under /Oracle directory.

Don't know what you mean with that...

Markus

[Former Member · Accepted solution]

Hi Markus,

Thanks for the reply.

Don't know what you mean with that...

I mean under /oracle directory all the sub directories are created for individual applications for example.

/oracle/QAS/920_64

/oracle/PQA/920_64

/oracle/TBW/920_64

/oracle/SLM/102_64

Here SLM is the Solution Manager SID.

Here under directory /oracle the below files are there.

**********************************************************************drwxrwxrwx 4 oraqas dba 512 Feb 14 2006 jre

drwxrwxrwx 3 root other 512 Jun 1 2006 u11

drwxrwxrwx 3 root other 512 Jun 1 2006 u10

drwxrwxrwx 3 root other 512 Jun 1 2006 u09

drwxrwxrwx 3 root other 512 Jun 1 2006 u08

drwxrwxrwx 3 root other 512 Jun 1 2006 u07

drwxrwxrwx 3 root other 512 Jun 1 2006 u06

drwxrwxrwx 3 root other 512 Jun 1 2006 u05

drwxrwxrwx 3 root other 512 Jun 1 2006 u04

drwxrwxrwx 3 root other 512 Jun 1 2006 u03

drwxrwxrwx 3 root other 512 Jun 1 2006 u02

drwxrwxrwx 3 root other 512 Jun 1 2006 u01

drwxrwxrwx 3 oraqas dba 512 Jul 19 2006 local

drwxrwxrwx 11 root other 512 Aug 3 2006 SID

drwxrwxrwx 6 oraqas dba 512 Aug 9 2006 oui

drwxrwxrwx 7 oratbw dba 512 Aug 9 2006 doc

-rwxrwxrwx 1 orapqa dba 0 Sep 8 2006 1.txt

drwxrwxrwx 20 oratbw dba 512 Aug 16 2007 TBW

drwxrwxrwx 6 oraqas dba 512 Nov 30 2008 NGNPROD

-rwxrwxrwx 1 root other 121 Dec 2 2008 l.lst

-rwxrwxrwx 1 root other 121 Dec 2 2008 d.lst

drwxrwxrwx 3 root other 512 Dec 2 2008 u30

drwxrwxrwx 3 root other 512 Dec 2 2008 u29

drwxrwxrwx 3 root other 512 Dec 2 2008 u28

drwxrwxrwx 3 root other 512 Dec 2 2008 u27

drwxrwxrwx 3 root other 512 Dec 2 2008 u26

drwxrwxrwx 3 root other 512 Dec 2 2008 u25

drwxrwxrwx 3 root other 512 Dec 2 2008 u24

drwxrwxrwx 3 root other 512 Dec 2 2008 u23

drwxrwxrwx 3 root other 512 Dec 2 2008 u22

drwxrwxrwx 3 root other 512 Dec 2 2008 u21

drwxrwxrwx 3 root other 512 Dec 2 2008 u20

drwxrwxrwx 3 root other 512 Dec 2 2008 u19

drwxrwxrwx 3 root other 512 Dec 2 2008 u18

drwxrwxrwx 3 root other 512 Dec 2 2008 u17

drwxrwxrwx 3 root other 512 Dec 2 2008 u16

drwxrwxrwx 3 root other 512 Dec 2 2008 u15

drwxrwxrwx 3 root other 512 Dec 2 2008 u14

drwxrwxrwx 3 root other 512 Dec 2 2008 u13

drwxrwxrwx 3 root other 512 Dec 2 2008 u12

drwxrwxrwx 9 oraqas dba 512 Dec 3 2008 admin

drwxrwxrwx 26 orapqa dba 1536 Dec 5 2008 PQA

drwxrwxrwx 7 oratbw dba 512 Jul 21 10:46 client

drwxrwxrwx 5 oraqas dba 512 Jul 21 11:39 stage

drwxr-xr-x 18 oraslm dba 512 Jul 24 10:21 SLM

drwxrwxrwx 13 oratbw dba 512 Jul 24 13:43 oraInventory

drwxrwxrwx 26 oraqas dba 1536 Jul 27 15:59 QAS**********************************************************************

My worry is If I install 10g, will it be overwrite the existing files of oracle 9.

Regards,

Vamsheedhar.

Edited by: JaganMohan Chitikena on Jul 28, 2009 1:47 PM

[markus_doehr2 · Accepted solution]

> I mean under /oracle directory all the sub directories are created for individual applications for example.

>

> /oracle/QAS/920_64

> /oracle/PQA/920_64

> /oracle/TBW/920_64

>

> /oracle/SLM/102_64

so a new installation will create

/oracle/<newSID>/102_64.

Markus

[Former Member · Accepted solution]

My questionis If I install 10g, will it be overwrite the existing files of oracle 9 under /oracle folder

Edited by: JaganMohan Chitikena on Jul 28, 2009 2:02 PM

[markus_doehr2 · Accepted solution]

Please look at my post.

I wrote:

It will create a new directory of structure

/oracle/<newSID>/102_64

Markus

[Former Member · Accepted solution]

Markus,

You are right. It will create a new directory.

Just again asking for to get confidence on this.

While installing Oracle 10g, will it not overwrite the existing files of Oracle 9 under /oracle directory?

Regards,

Vamsheedhar.

[Former Member · Accepted solution]

Hi,

What Marcus means in his reply is that whenever a new oracle database is installed, the executables and bin files will be created in its own oracle home directory.

In ur case, the oracle executables will be extracted in the directory /oracle/SLM/102_64.

Regards,

Varadhu

[Former Member]

Thanks Markus and Varadha.

The issue is resolved by changing path of oraInventory in the below file.

/var/opt/oracle/oraInst.loc

Regards,

Vamsheedhar.

[Former Member]

No it will not be overright the oracle 9i with oracle 10g. u shoud have to upgrade it as per SAP.

Thanks

Presu