cancel
Showing results for 
Search instead for 
Did you mean: 

Oracle reading binary files from other oracle home.

Former Member
0 Kudos

Hi all,

I have two oracle db installed on the same server but on different oracle home.

It seems to me that the second oracle is reading the binaries from the other installation.

I can start this database and the sap instance and it starts on the correct oracle home but I see that it is reading files on the first oracle home.

for example, it saves the spfile under the first oracle_home\database directory. I started it using pfile=<the_correct_ora-home>\database\initSID.ora and set on this init.ora file the correct path for spfile.

But even after this if i change any parameter, it stills change the spfile on the wrong <oracle_home>\database.

Is there a way to fix this ? I mean to make the second oracle to see files under its own oracle home ?

It is oracle 11g under windows 2008.

Remember that all the environment variables is pointing to the correct oracle home and I can start SAP and Oracle as well on this oracle_home.

Thanks in advance,

Joao.

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi Joao,

I don't have a doubt that you are doing these operations under correct sidadm user.

>> I can start this database and the sap instance and it starts on the correct oracle home but I see that it is reading files on the first oracle home.

Could you check the registry entries, under the path below;

HKEY_LOCAL_MACHINE -> SOFTWARE -> SAP -> <SID> -> Environment

Check here ORACLE_HOME and the other variables.

Best regards,

Orkun Gedik

Former Member
0 Kudos

Hi Orkun,

You are correct: the oracle home variabe is pointing to the wrong oracle home but all other variables are correct, including system name, sapdata home,etc.

I tried to change it but whenever I reboot the server it puts the old value on oracle_home.

How can I change it for ever ?

thanks and regards,

Joao.

Former Member
0 Kudos

Hi Joao,

>> I tried to change it but whenever I reboot the server it puts the old value on oracle_home.

It is weird, because these values created by SAP installation and not change neither by SAP nor Oracle during the runtime. I have a doubt that you have an antivirus program or some other 3rd party tool to replace the new values with the old ones, in the registry after reboot.

At this stage, could you verify whether you installed 3rd party application on the SAP server?

Best regards,

Orkun Gedik

Former Member
0 Kudos

Hi Orkun,

No, we don't have anything else installed yet.

Please see what I found out:

Checking those binary errors I found out that the oracle service

OracleServiceDPC (the second instance on this server) is being started from the wrong oracle_home path. Please

see the path to the executables on that service properties:

g:\oracle\dnc\11202\bin\ORACLE.EXE DPC

It is pointing to the other oracle home DNC but starting instance DPC. How can I change that ?

Please see that the oracle home, the listener, etc is correct pointing

to oracle home G:\oracle\DPC\11202.

I would like to disable this service and create the correct one.

Is that possible ?

thanks and regards,

Joao

Former Member
0 Kudos

Hi Joao,

Find the command below;

oradim -new -sid <SID> -startmode A -pfile D:\oracle\<SID>\<Version>\database\init<SID>.ora

Best regards,

Orkun Gedik

Former Member
0 Kudos

Hi Orkun,

I tried it but got the following error:

G:\oracle\DPC\11202\BIN>.\oradim -new -sid DPC -startmode A -pfile G:\oracle\DPC\11202\database\initDPC.ora

DIM-00019: create service error

O/S-Error: (OS 1073) The specified service already exists.

I am digging into it but if you have a solution that would be nice.

It seems that at first I must delete the old service OracleServiceDPC.

Thanks in advance,

Joao

Former Member
0 Kudos

Hi Joao,

You can delete the service by using the command, below;

oradim -delete -sid <SID>

Best regards,

Orkun Gedik

Former Member
0 Kudos

Orkun,

Can I use this?

oradim -delete -sid DPC

Is there any risk to put my installation DPC at risk ?

Thanks again,

Joao

Former Member
0 Kudos

Thanks,

Just saw your reply.

I will try that.

Best regards,

Joao

Former Member
0 Kudos

Orkun,

It worked very well.

Thanks very much for your help.

I will close it and give you your points

Best regards,

Joao

Former Member
0 Kudos

Thank you Joao

Answers (0)