Sap Resource Configuration on Oracle RAC CRS

[Former Member]

Hi,

where I can find useful documentation about create sap resource on Oracle CRS (abapvip, javavip....)?

Regards,

Mario

[Former Member]

You can read SAP Note 1496927 - Protection of SAP instances through Oracle Clusterware and sapctl document attached to it.

[Former Member]

Thank you for your answer.

I've a problem on Oracle CRS (SAP), when I stop sap resource the IP associated remain in "use" so I can't restart the resource until I reboot the machine.

I think that it's a wrong sap crs resource configuration, for example I've two resource that use the same IP

NAME=sap.PPI.abapvip

TYPE=app.appvip.type

STATE=ONLINE

TARGET=ONLINE

ACL=owner:root:rwx,pgrp:root:r-x,other::r--,user:ppiadm:r-x,user:oracle:r-x,group:sapsys:r-x

ACTION_FAILURE_TEMPLATE=

ACTION_SCRIPT=

ACTIVE_PLACEMENT=1

AGENT_FILENAME=%CRS_HOME%/bin/orarootagent%CRS_EXE_SUFFIX%

AUTO_START=restore

CARDINALITY=1

CARDINALITY_ID=0

CHECK_INTERVAL=1

CHECK_TIMEOUT=30

CREATION_SEED=140

DEFAULT_TEMPLATE=PROPERTY(RESOURCE_CLASS=vip)

DEGREE=1

DESCRIPTION=CRS resource type definition for cluster-aware VIP

ENABLED=1

FAILOVER_DELAY=0

FAILURE_INTERVAL=0

FAILURE_THRESHOLD=0

GEN_USR_ORA_STATIC_VIP=

GEN_USR_ORA_VIP=

HOSTING_MEMBERS=

ID=sap.PPI.abapvip

LOAD=1

LOGGING_LEVEL=1

NLS_LANG=

NOT_RESTARTING_TEMPLATE=

OFFLINE_CHECK_INTERVAL=0

PLACEMENT=favored

PROFILE_CHANGE_TEMPLATE=

RESTART_ATTEMPTS=0

SCRIPT_TIMEOUT=60

SERVER_POOLS=*

START_DEPENDENCIES=hard(ora.net2.network) pullup(ora.net2.network)  attraction(sap.PPI.ERS10.abaprep)

START_TIMEOUT=100

STATE_CHANGE_TEMPLATE=

STOP_DEPENDENCIES=hard(ora.net2.network)

STOP_TIMEOUT=100

TYPE_VERSION=2.1

UPTIME_THRESHOLD=1h

USR_ORA_ENV=

USR_ORA_VIP=10.160.1.60

VERSION=

NAME=sap.PPI.javavip

TYPE=app.appvip.type

STATE=ONLINE

TARGET=ONLINE

ACL=owner:root:rwx,pgrp:root:r-x,other::r--,user:ppiadm:r-x,user:oracle:r-x,group:sapsys:r-x

ACTION_FAILURE_TEMPLATE=

ACTION_SCRIPT=

ACTIVE_PLACEMENT=1

AGENT_FILENAME=%CRS_HOME%/bin/orarootagent%CRS_EXE_SUFFIX%

AUTO_START=restore

CARDINALITY=1

CARDINALITY_ID=0

CHECK_INTERVAL=1

CHECK_TIMEOUT=30

CREATION_SEED=156

DEFAULT_TEMPLATE=PROPERTY(RESOURCE_CLASS=vip)

DEGREE=1

DESCRIPTION=CRS resource type definition for cluster-aware VIP

ENABLED=1

FAILOVER_DELAY=0

FAILURE_INTERVAL=0

FAILURE_THRESHOLD=0

GEN_USR_ORA_STATIC_VIP=

GEN_USR_ORA_VIP=

HOSTING_MEMBERS=

ID=sap.PPI.javavip

LOAD=1

LOGGING_LEVEL=1

NLS_LANG=

NOT_RESTARTING_TEMPLATE=

OFFLINE_CHECK_INTERVAL=0

PLACEMENT=favored

PROFILE_CHANGE_TEMPLATE=

RESTART_ATTEMPTS=0

SCRIPT_TIMEOUT=60

SERVER_POOLS=*

START_DEPENDENCIES=hard(ora.net2.network) pullup(ora.net2.network)  attraction(sap.PPI.ERS11.javarep)

START_TIMEOUT=100

STATE_CHANGE_TEMPLATE=

STOP_DEPENDENCIES=hard(ora.net2.network)

STOP_TIMEOUT=100

TYPE_VERSION=2.1

UPTIME_THRESHOLD=1h

USR_ORA_ENV=

USR_ORA_VIP=10.160.1.60

VERSION=

[Former Member]

Can you provide a bit more information about your configuration, actions you are trying to perform and errors you have received?

[Former Member]

Yes of course,

I've two resource SAP configured on the same IP 10.160.1.60, I think that they have a bad configuration (two ip resource on the same ip?).

The problem/bug is that when I shutdown the resource the IP associated remain pingable and when I try to restart the resource they don't startup with the error IP ALREADY IN USE.

So I would like to understand how to configure the resource SAP on CRS in order to investigate the bug.

Unfortunately I'm an oracle DBA and I would like to understand the sap.resource on CRS.

Regards,

[Former Member]

Mario Di Lallo wrote:

I've two resource SAP configured on the same IP 10.160.1.60, I think that they have a bad configuration (two ip resource on the same ip?).

Yes, you need to configure 2 different ip addresses for abapvip and javavip resources. SAP provides its own sapctl script (written in perl) to create/manage SAP resources. As Oracle DBA you can read about sapctl at Providing High Availability for SAP Resources with Oracle Clusterware 11 Release 2.

[Former Member]

Thank you for your answer.

Do you think that I can change the IP of the sap.PPI.javavip without other change?

I can configure anothe IP on the resource without SAP AS configuration?

Regards,

[Former Member]

Why not to use the sapctl script? If not try to check script to understand what it does to create javavip resource.