My Oracle Support Banner

How to Add Big Data SQL Resource to CRS When Install User and Grid User are Different (Doc ID 2443842.1)

Last updated on JULY 20, 2024

Applies to:

Oracle Big Data SQL - Version 3.2.0 and later
Information in this document applies to any platform.

Symptoms

The Big Data SQL(BDS) 3.2.x installer is unable to add a BDS MTA extproc resource to Cluster Ready Services (CRS) for Oracle Clusterware (Grid) when database and Grid are running with different users.

If Grid is available, by default the BDS extproc process is added into CRS. This behavior can be changed with the --crs parameter to the bds-database-install.sh script. In the case that Grid is not available or --crs=false was used in the bds-database-install script, the BDS MTA extproc needs to be manually managed. This means that in case of a crash, it needs to be manually started.

BDS MTA extproc is not able to run properly if is registered in CRS on BDS pre-3.2.0 versions when database and Grid run with different users. Starting from 3.2.0, the BDS installer prevents CRS registration in this case.

The goal of this note is to provide a workaround for the above scenario in BDS 3.2.

In the BDS 3.2 failure case the install message looks like this :
$ ./bds-database-install.sh --install --reqkey=db.reqkey --aux-run-mode=su
bds-database-install: platform is : Linux
bds-database-install: script started at : Wed Aug 22 19:08:05 JST 2018
bds-database-install: running location : /u01/app/oracle/product/12.2.0.1/dbhome_1/BDSJaguar-3.2.1/<CLUSTERNAME><HOSTNAME3>.<DOMAINNAME>
bds-database-install: ORACLE_SID : <SID>
bds-database-install: ORACLE_HOME : /u01/app/oracle/product/12.2.0.1/dbhome_1
bds-database-install: configuration spfile : spfile.<ID>
bds-database-install: Grid home : /u01/app/12.2.0.1/grid
bds-database-install: db resource : <DB_RESOURCE_NAME>
bds-database-install: mta extproc sid : <SID>
bds-database-install: use of crsctl : false
bds-database-install: grid nodes : <DB_HOSTNAME1>,<DB_HOSTNAME2>
bds-database-install: verifying ssh connection with grid nodes

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
Symptoms
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.