Erman Arslan's Oracle Forum - Re: Standard Mgr and Inventory, always running on one particular node of RAC db.

Re: Standard Mgr and Inventory, always running on one particular node of RAC db.

Posted by ashish_oracleguy on Dec 08, 2016; 7:27pm
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/Standard-Mgr-and-Inventory-always-running-on-one-particular-node-of-RAC-db-tp1693p1713.html

Hi Erman,
Thanks for the reply.

First , we have only one App node.

Also the issue I am trying to address right now, is that:

We are running 3 node RAC db for our EBS 12.2
If we do NOT bring up the instance on 3rd node, and only start the DB on node 1 and 2, and then start the
EBS app tier, the standard mgr and inventory mgr do not start.

So it seems the starting of standard mgr and inventory mgr, are tied up with the DB instance running on node 3.

Here is the copy of the tnsnames.ora on the EBS app tier

VCPP=
(DESCRIPTION=
(ADDRESS=(PROTOCOL=tcp)(HOST=xx.xx.xx.218)(PORT=1521))
(ADDRESS=(PROTOCOL=tcp)(HOST=xx.xx.xx.219)(PORT=1521))
(ADDRESS=(PROTOCOL=tcp)(HOST=xx.xx.xx.217)(PORT=1521))
(CONNECT_DATA=
(SERVICE_NAME=VCPP)
)
)

VCPP1=
(DESCRIPTION=
(ADDRESS=(PROTOCOL=tcp)(HOST=xx.xx.xx.218)(PORT=1521))
(ADDRESS=(PROTOCOL=tcp)(HOST=xx.xx.xx.219)(PORT=1521))
(ADDRESS=(PROTOCOL=tcp)(HOST=xx.xx.xx.217)(PORT=1521))
(CONNECT_DATA=
(SERVICE_NAME=VCPP)
(INSTANCE_NAME=VCPP1)
)
)

VCPP1_FO=
(DESCRIPTION=
(ADDRESS=(PROTOCOL=tcp)(HOST=xx.xx.xx.218)(PORT=1521))
(ADDRESS=(PROTOCOL=tcp)(HOST=xx.xx.xx.219)(PORT=1521))
(ADDRESS=(PROTOCOL=tcp)(HOST=xx.xx.xx.217)(PORT=1521))
(CONNECT_DATA=
(SERVICE_NAME=VCPP)
(INSTANCE_NAME=VCPP1)
)
)

VCPP2=
(DESCRIPTION=
(ADDRESS=(PROTOCOL=tcp)(HOST=xx.xx.xx.218)(PORT=1521))
(ADDRESS=(PROTOCOL=tcp)(HOST=xx.xx.xx.219)(PORT=1521))
(ADDRESS=(PROTOCOL=tcp)(HOST=xx.xx.xx.217)(PORT=1521))
(CONNECT_DATA=
(SERVICE_NAME=VCPP)
(INSTANCE_NAME=VCPP2)
)
)

VCPP2_FO=
(DESCRIPTION=
(ADDRESS=(PROTOCOL=tcp)(HOST=xx.xx.xx.218)(PORT=1521))
(ADDRESS=(PROTOCOL=tcp)(HOST=xx.xx.xx.219)(PORT=1521))
(ADDRESS=(PROTOCOL=tcp)(HOST=xx.xx.xx.217)(PORT=1521))
(CONNECT_DATA=
(SERVICE_NAME=VCPP)
(INSTANCE_NAME=VCPP2)
)
)

VCPP3=
(DESCRIPTION=
(ADDRESS=(PROTOCOL=tcp)(HOST=xx.xx.xx.218)(PORT=1521))
(ADDRESS=(PROTOCOL=tcp)(HOST=xx.xx.xx.219)(PORT=1521))
(ADDRESS=(PROTOCOL=tcp)(HOST=xx.xx.xx.217)(PORT=1521))
(CONNECT_DATA=
(SERVICE_NAME=VCPP)
(INSTANCE_NAME=VCPP3)
)
)

VCPP3_FO=
(DESCRIPTION=
(ADDRESS=(PROTOCOL=tcp)(HOST=xx.xx.xx.218)(PORT=1521))
(ADDRESS=(PROTOCOL=tcp)(HOST=xx.xx.xx.219)(PORT=1521))
(ADDRESS=(PROTOCOL=tcp)(HOST=xx.xx.xx.217)(PORT=1521))
(CONNECT_DATA=
(SERVICE_NAME=VCPP)
(INSTANCE_NAME=VCPP3)
)
)

VCPP_FO=
(DESCRIPTION=
(ADDRESS=(PROTOCOL=tcp)(HOST=xx.xx.xx.218)(PORT=1521))
(ADDRESS=(PROTOCOL=tcp)(HOST=xx.xx.xx.219)(PORT=1521))
(ADDRESS=(PROTOCOL=tcp)(HOST=xx.xx.xx.217)(PORT=1521))
(CONNECT_DATA=
(SERVICE_NAME=VCPP)
(INSTANCE_NAME=VCPP1)
)
)

VCPP_BALANCE=
(DESCRIPTION=
(ADDRESS_LIST=
(LOAD_BALANCE=YES)
(FAILOVER=YES)
(ADDRESS=(PROTOCOL=tcp)(HOST=xx.xx.xx.218)(PORT=1521))
(ADDRESS=(PROTOCOL=tcp)(HOST=xx.xx.xx.219)(PORT=1521))
(ADDRESS=(PROTOCOL=tcp)(HOST=xx.xx.xx.217)(PORT=1521))
)
(CONNECT_DATA=
(SERVICE_NAME=VCPP)
)
)

FNDFS_PVCPAP01=
(DESCRIPTION=
(ADDRESS=(PROTOCOL=tcp)(HOST=PVCPAP01.xxx.xx)(PORT=1666))
(CONNECT_DATA=
(SID=FNDFS)
)
)

FNDFS_PVCPAP01.xxx.xx=
(DESCRIPTION=
(ADDRESS=(PROTOCOL=tcp)(HOST=PVCPAP01.xxx.xx)(PORT=1666))
(CONNECT_DATA=
(SID=FNDFS)
)
)

FNDFS_VCPP_PVCPAP01=
(DESCRIPTION=
(ADDRESS=(PROTOCOL=tcp)(HOST=PVCPAP01.xxx.xx)(PORT=1666))
(CONNECT_DATA=
(SID=FNDFS)
)
)

FNDFS_VCPP_PVCPAP01.xxx.xx=
(DESCRIPTION=
(ADDRESS=(PROTOCOL=tcp)(HOST=PVCPAP01.xxx.xx)(PORT=1666))
(CONNECT_DATA=
(SID=FNDFS)
)
)

FNDSM_PVCPAP01_VCPP=
(DESCRIPTION=
(ADDRESS=(PROTOCOL=tcp)(HOST=PVCPAP01.xxx.xx)(PORT=1666))
(CONNECT_DATA=
(SID=FNDSM)
)
)

FNDFS_APPLTOP_pvcpap01=
(DESCRIPTION=
(ADDRESS_LIST=
(ADDRESS=(PROTOCOL=tcp)(HOST=PVCPAP01.xxx.xx)(PORT=1666))
)
(CONNECT_DATA=
(SID=FNDFS)
)
)

VCPP_patch=
(DESCRIPTION=
(ADDRESS=(PROTOCOL=tcp)(HOST=xx.xx.xx.218)(PORT=1521))
(ADDRESS=(PROTOCOL=tcp)(HOST=xx.xx.xx.219)(PORT=1521))
(ADDRESS=(PROTOCOL=tcp)(HOST=xx.xx.xx.217)(PORT=1521))
(CONNECT_DATA=
(SERVICE_NAME=ebs_patch)
(INSTANCE_NAME=VCPP1)
)
)

VCPP1_patch=
(DESCRIPTION=
(ADDRESS=(PROTOCOL=tcp)(HOST=xx.xx.xx.218)(PORT=1521))
(ADDRESS=(PROTOCOL=tcp)(HOST=xx.xx.xx.219)(PORT=1521))
(ADDRESS=(PROTOCOL=tcp)(HOST=xx.xx.xx.217)(PORT=1521))
(CONNECT_DATA=
(SERVICE_NAME=ebs_patch)
(INSTANCE_NAME=VCPP1)
)
)

VCPP1_FO_patch=
(DESCRIPTION=
(ADDRESS=(PROTOCOL=tcp)(HOST=xx.xx.xx.218)(PORT=1521))
(ADDRESS=(PROTOCOL=tcp)(HOST=xx.xx.xx.219)(PORT=1521))
(ADDRESS=(PROTOCOL=tcp)(HOST=xx.xx.xx.217)(PORT=1521))
(CONNECT_DATA=
(SERVICE_NAME=ebs_patch)
(INSTANCE_NAME=VCPP1)
)
)

VCPP2_patch=
(DESCRIPTION=
(ADDRESS=(PROTOCOL=tcp)(HOST=xx.xx.xx.218)(PORT=1521))
(ADDRESS=(PROTOCOL=tcp)(HOST=xx.xx.xx.219)(PORT=1521))
(ADDRESS=(PROTOCOL=tcp)(HOST=xx.xx.xx.217)(PORT=1521))
(CONNECT_DATA=
(SERVICE_NAME=ebs_patch)
(INSTANCE_NAME=VCPP2)
)
)

VCPP2_FO_patch=
(DESCRIPTION=
(ADDRESS=(PROTOCOL=tcp)(HOST=xx.xx.xx.218)(PORT=1521))
(ADDRESS=(PROTOCOL=tcp)(HOST=xx.xx.xx.219)(PORT=1521))
(ADDRESS=(PROTOCOL=tcp)(HOST=xx.xx.xx.217)(PORT=1521))
(CONNECT_DATA=
(SERVICE_NAME=ebs_patch)
(INSTANCE_NAME=VCPP2)
)
)

VCPP3_patch=
(DESCRIPTION=
(ADDRESS=(PROTOCOL=tcp)(HOST=xx.xx.xx.218)(PORT=1521))
(ADDRESS=(PROTOCOL=tcp)(HOST=xx.xx.xx.219)(PORT=1521))
(ADDRESS=(PROTOCOL=tcp)(HOST=xx.xx.xx.217)(PORT=1521))
(CONNECT_DATA=
(SERVICE_NAME=ebs_patch)
(INSTANCE_NAME=VCPP3)
)
)

VCPP3_FO_patch=
(DESCRIPTION=
(ADDRESS=(PROTOCOL=tcp)(HOST=xx.xx.xx.218)(PORT=1521))
(ADDRESS=(PROTOCOL=tcp)(HOST=xx.xx.xx.219)(PORT=1521))
(ADDRESS=(PROTOCOL=tcp)(HOST=xx.xx.xx.217)(PORT=1521))
(CONNECT_DATA=
(SERVICE_NAME=ebs_patch)
(INSTANCE_NAME=VCPP3)
)
)

VCPP_FO_patch=
(DESCRIPTION=
(ADDRESS=(PROTOCOL=tcp)(HOST=xx.xx.xx.218)(PORT=1521))
(ADDRESS=(PROTOCOL=tcp)(HOST=xx.xx.xx.219)(PORT=1521))
(ADDRESS=(PROTOCOL=tcp)(HOST=xx.xx.xx.217)(PORT=1521))
(CONNECT_DATA=
(SERVICE_NAME=ebs_patch)
(INSTANCE_NAME=VCPP1)
)
)