on 08-12-2011 8:25 PM
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.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
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
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
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
User | Count |
---|---|
84 | |
25 | |
12 | |
9 | |
6 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.