Configuring an Oracle RAC database

Before you begin

1. Set up Oracle RAC 11g R2  or later (OCFS or ASM.)
2. Configure the Oracle database (RAC) instance; for example, "BMCRAC".
3. Configure Listeners and the EM console and make sure they are up and running.
4. Make sure you have sys, portal schema owner, user, and access details available.
5. After everything is running, check to see whether you can log in to the EM console with sys user and sysdba role. 

---------------------------
Login with user : sys
Connect As : Sysdba provide password and login.
---------------------------

To configure an Oracle RAC database

Click Database and click the Server tab.

Click Tablespaces.

Click the Create button.

The tablespace creation process starts.

Provide the following details:
Name: PORTAL_TB
Extent Management: Locally Managed
Type: Permanent
Status: Read Write
Select the Use bigfile tablespace check box.
Click Add.


Click Continue.

SQL is returned that looks similar to the following example:

CREATE BIGFILE TABLESPACE "PORTAL_TB" DATAFILE '+DATA(DATAFILE)' SIZE 100M AUTOEXTEND ON NEXT 100M MAXSIZE UNLIMITED LOGGING EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO

Click OK.
The tablespace is created.

Repeat the steps above to create the tablespace index, PORTAL_TB_INDEX. 

Creating users (schema owners)

Click users.









Click Create.


Verify the results.

Click Roles and select ConnectMGMT_USERDBA.

Click System Privileges.


Create this schema owner user.
The SQL command will look similar to the following example:
CREATE USER "PORTAL" PROFILE "DEFAULT" IDENTIFIED BY "*******" DEFAULT TABLESPACE "PORTAL_TB" TEMPORARY TABLESPACE "TEMP" ACCOUNT UNLOCK GRANT SYSDBA TO "PORTAL" GRANT UNLIMITED TABLESPACE TO "PORTAL" GRANT "CONNECT" TO "PORTAL" GRANT "DBA" TO "PORTAL" GRANT "MGMT_USER" TO "PORTAL"

Create one more operational user by selecting Users > Create.

Click Roles.

Complete the creation of user.

CREATE USER "PORTAL_OP" PROFILE "DEFAULT" IDENTIFIED BY "*******" DEFAULT TABLESPACE "PORTAL_TB" TEMPORARY TABLESPACE "TEMP" ACCOUNT UNLOCK GRANT DELETE ANY TABLE TO "PORTAL_OP" GRANT EXECUTE ANY PROCEDURE TO "PORTAL_OP" GRANT INSERT ANY TABLE TO "PORTAL_OP" GRANT SELECT ANY TABLE TO "PORTAL_OP" GRANT UPDATE ANY TABLE TO "PORTAL_OP" GRANT "CONNECT" TO "PORTAL_OP" GRANT "MGMT_USER" TO "PORTAL_OP"SQL will look like :-

Log in as root to any one node, for example, bladerac1.bmc.com and do following steps:

1. Create a folder called: /portalDB
2. Copy the setup folder to this machine and extract the contents.

cd /portalDB
unzip BMCAUTOPORTAL10_Lin64.zip cd /portalDB/Disk1/utility/oracle
chmod -R +777 /portalDB

Open oracle_master.sql and search and replace: @@./schema with: @@/portalDB/Disk1/utility/oracle/schema

1. Promptaccept user_owner_name char prompt 'SCHEMA OWNER USER NAME [FOUNDATION]: ' default FOUNDATIONaccept user_oper_name char prompt 'OPERATION USER NAME [FOUNDATION_OPER]: ' default FOUNDATION_OPERpromptChange : /portalDB/Disk1/utility/oracle/utils/configuration/grantperms.sql For :-OLD :

DEFINE user_owner_name = 'PORTAL'
DEFINE user_oper_name = 'PORTAL_OP'
--prompt
--accept user_owner_name char prompt 'SCHEMA OWNER USER NAME [FOUNDATION]: ' default FOUNDATION
--accept user_oper_name char prompt 'OPERATION USER NAME [FOUNDATION_OPER]: ' default FOUNDATION_OPER
_-prompt_to New :

Save utils/configuration/grantperms.sql
=====================
Log in  to EM console as the Portal user with anormal role.
https://bladerac1.bmc.com:1158/em/console/logon/logon
=====================

Create JOBS: Select Database > Server > Jobs.
From this page, click Job Library. Select SQL Script from the list and click Go.


Click the Parameters tab.

WHENEVER SQLERROR EXIT FAILURE;CONN PORTAL/<PORTAL_PASSWORD>;@/portalDB/Disk1/utility/oracle/oracle_master.sql PORTAL_TB PORTAL_TB_INDEX


Click Credentials tab.


Click Save to Library.

Select EXECUTE ORACLE_MASTER.SQL and click Submit.
Verify the execution status:


Grant permission to the Portal Operator user:
Log in to the EM console as the Portal user with a normal role.
https://bladerac1.bmc.com:1158/em/console/logon/logon
=====================

Create JOBS: Select Database > Server > Jobs.
From this page, click Job Library. Select SQL Script from the list and click Go.

Click the Parameters tab.
Enter:
WHENEVER SQLERROR EXIT FAILURE;
CONN PORTAL/<PORTAL_PASSWORD>;
@/portalDB/Disk1/utility/oracle/utils/configuration/grantperms.sql




Click the Credentials tab.

Click Save to Library.

Select Setup Portal Permissions and click Submit.


Portal RAC database confiugration is complete and can be consumed by the Portal installer to set up the server.