Oracle Invntry

[Former Member]

In one server we have three systems all the three are for dev one is for R3, then ECC and BW.

The oracle inventory shows as below for the systems

TRD

Oracle Home : /oracle/TRD/102_64

Central Inventory : /oracle/SMD/oraInventory

from : /var/opt/oracle/oraInst.loc

SMD

Oracle Home : /oracle/SMD/102_64

Central Inventory : /oracle/SMD/oraInventory

from : /oracle/SMD/102_64/oraInst.loc

CRD

Oracle Home : /oracle/CRD/102_64

Central Inventory : /oracle/SMD/oraInventory

from : /var/opt/oracle/oraInst.loc

My question is, in the central inventory for the TRD and the CRD it shows different sid,

do i need to make any changes for it or this is by default.

I am wondering if this will cause any major issue if not changed or can we just can ignore it.

The path for the SMD shows as : /oracle/SMD/102_64/oraInst.loc, in which location

can i change it to /var/opt/oracle/oraInst.loc or can ignore it.

-

---

In the same box where i said there are three systems, the file system /oracle/client is same for the three systems on that system.

The /oracle/client link points to 10201 which should point to 10202. Which is as below

rrrxxx-ww 1 smdadm sapsys Aug 4 2008 instclint -> /oracle/client/10x_64/instclint_10201

rrxxww-rrr 2 smdadm sapsys NOv 7 2006 instclint_10201

rrxxww-rrr 2 smdadm sapsys DEC 4 2006 instclint_10202

Please help me how can i change the link to the 10202.( any procedure)

Before i can change the link, as far as i know i need to schedule the downtime and stop the ALL SAP systems on that server and change the link and restart

the system.

Are there any precautions to take apart from the downtime. Please help.

Thanks.

[sunny_pahuja2 · Accepted solution]

>

> In one server we have three systems all the three are for dev  one is for  R3, then ECC and BW.
> 
> The oracle inventory shows as below for the systems
> TRD
> Oracle Home       : /oracle/TRD/102_64
> Central Inventory : /oracle/SMD/oraInventory
>    from           : /var/opt/oracle/oraInst.loc
> 
> SMD
> Oracle Home       : /oracle/SMD/102_64
> Central Inventory : /oracle/SMD/oraInventory
>    from           : /oracle/SMD/102_64/oraInst.loc
> 
> CRD
> Oracle Home       : /oracle/CRD/102_64
> Central Inventory : /oracle/SMD/oraInventory
>    from           : /var/opt/oracle/oraInst.loc
> 
> My question is, in the central inventory for the TRD and the CRD it shows different sid, 
> do i need to make any changes for it or this is by default.
> I am wondering if  this will cause any major issue if not changed or can we just can ignore it.
> 
> The path for the SMD shows as : /oracle/SMD/102_64/oraInst.loc, in which location 
> can i change it to /var/opt/oracle/oraInst.loc or can ignore it.
If you are talking about orainventory then you don't need to change anything...If you are doing oracle upgrade or you are installing new system then only you have to change orainventroy... to point to right oracle home...
As in our case we have multiple system on same host and we have a single orainventory...
> -
> 
> In the same box where i said there are three systems, the file system /oracle/client is same for the three systems on that system.
> 
> The /oracle/client link points to 10201 which should point to 10202. Which is as below
> 
>  rrrxxx-ww 1 smdadm     sapsys         Aug  4  2008 instclint -> /oracle/client/10x_64/instclint_10201
>  rrxxww-rrr 2 smdadm     sapsys         NOv  7  2006 instclint_10201
>  rrxxww-rrr 2 smdadm     sapsys         DEC  4  2006 instclint_10202
> 
> 
> Please help me how can i  change the link to the 10202.( any procedure)
> 
> Before i can change the link, as far as i know i need to schedule the downtime and stop the ALL SAP systems on that server and change the link and restart 
> 
> the system.
> 
> Are there any precautions to take apart from the downtime. Please help.
you can use ln command to change link..hgope it will work..
Thanks
sunny
> Thanks.

[Former Member · Accepted solution]

Hi Sunny,

Thanks for the reply.

We are not doing any updgrade, already the system is installed. AS per your advice i need not change the SID for oracle inventory.

what about the path for the oracle inventory, as in the above for TRD and CRD the path shows from : /var/opt/oracle/oraInst.loc, but for SMD it shows from : /oracle/SMD/102_64/oraInst.loc.

It is showing same in the QA box. Should i change the path to /var/opt/oracle/oraInst.loc for SMD, i am wondering in the future there may be problems.

anup

[former_member204746]

Try these commands:

cd /oracle/client

rm instclint

ln -s /oracle/client/10x_64/instclint_10201 instclint

good luck.

[Former Member]

Hi Eric,

Thanks for the reply.

you gave a command rm instclint (which will remove instclint, i don't want to remove)

I just want to point the link from oracle/client/10x_64/instclint_10201 to oracle/client/10x_64/instclint_10202 which is as below.

rrrxxx-ww 1 smdadm sapsys Aug 4 2008 instclint -> /oracle/client/10x_64/instclint_10201

to

rrrxxx-ww 1 smdadm sapsys Aug 4 2008 instclint -> /oracle/client/10x_64/instclint_10202

I am sorry, please correct. what is the procedure to do. As far as i know i need to stop all the systems on that host before doing the change.

Please reply

thanks.

[Former Member]

Eric is correct,

rm will remove instclint and ln command will create it again pointing to new location.

I think, the only change in Eric's command should be,

ln -s /oracle/client/10x_64/instclint_10202 instclint

Regards,

Kiran

[Former Member]

We have multiple systems in one server, under the filesystem /var/opt/oracle the oracle inventory file exists only for two systems which is as below

edsmd05:ora<sid> 1> ls -l

total 12

-rw-rr 1 root sys 54 Apr 7 2007 D01_oraInst.loc

-rw-rr 1 root sys 54 Apr 3 2007 C01_oraInst.loc

-rw-rr 1 root sys 54 Dec 8 2008 oraInst.loc

-rw-rr 1 root sys 54 Dec 8 2008 oraInst.loc.save

The other system which is RPT does't have RPT_oraInst.loc file, can we create a file directly,do i need to restart the system for the changes to take into effect.

Are there any other precaustions tobe taken for the file before creating or after creating the same RPT_oraInst.loc file.

Thanks.

anup

[former_member204746]

no, don't mess with files from this directory. Oracle installer is responsible to modify these files.