1,200 sessions, 5 days and countless insights on technology; here’s a sum up of Collaborate 18 covering everything from AI and data security to cloud, autonomous and more: #dbsat

Learn To Love AI, Evolve Your DBA Career, And…

At the Collaborate 18 conference in Las Vegas, members of three of the world’s largest independently run user groups for Oracle apps, tech, and cloud services met to plot their collective futures. Read an overview of the hottest topics of conversation.


EMEAPAC Champions

Advertisements

This blog post explains how to create a secure and encrypted IPSec site-to-site tunnel between Oracle Cloud Infrastructure and another third-party cloud provider. Read more:

Creating a Secure Connection Between Oracle…

In today’s world, having a secure, encrypted, point-to-point channel through which your data can travel from a specific location to the cloud contributes to a safer solution if you want to avoid breaches and data loss.


EMEAPAC Champions

Oracle Autonomous Data Warehouse Cloud Service is the new standard for simplicity. Discover why:

How Oracle’s New Autonomous Data Warehouse Works

Oracle Autonomous Data Warehouse Cloud lets organizations set up a high-powered data warehouse in less than a minute.


EMEAPAC Champions

Recovering From Disaster

March 28, 2018

What if the worst happens and all of your data security processes fail? Building a drama-free disaster recovery capability is key. Discover how:

Recovering From Disaster

Learn how to ease the data security process. Your business depends on it. Discover how:


EMEAPAC Champions

The new story that NetSuite wants to talk about is focused more on the customer. And they still have a lot to say. Here’s how the company continues to grow after being acquired by Oracle:

Post Oracle acquisition, NetSuite is all about…

Before being acquired by Oracle in 2016, NetSuite — along with Salesforce — emerged as one of the star players of the cloud-based SaaS world. Now Netsuite is leveraging Oracle’s global scale and resources to accelerate its international growth.


EMEAPAC Champions

Oracle provides the Smart Update utility to apply patches and upgrade the WebLogic Server installations. Oracle’s Weblogic Server is now a critical component  of Fusion Middleware and every other component of Fusion Middleware requires Weblogic Server to be installed as  a pre-requisite. Applying patches and upgrading Weblogic Server is quite straight forward using the Oracle’s Smart Update utility,the documentation for Oracle Smart Update Utility can be found  here

1. Shutdown and take a complete backup of the WLS environment.

The Startup/Shutdown scripts are placed in $WLS_HOME/user_projects/domains/<domain_name>/bin

2. The Oracle Smart Update Tool is located at  “$WLS_HOME/utils/bsu

3. Launch the the Oracle Smart Update Tool :

4. Once logged in, you will be presented with Oracle Smart Update Dialog.

5.  You can choose to “Register for security updates”, this is usually helpful to keep yourself updated with the latest security updates and product expiration.


6.  Click the “Get Patches” tab to see the latest patches available.

7. On the left pane you would see   Weblogic Servers installed  and on the right pane you will see two tabs. “Get Patches” and “Manage Patches” and a section to show the downloaded patches.

8. Now select the patches and hit the “Download Selected” button, you will be prompted if you wish to to validate and resolve conflicts.

9.  The Validation completes with the following message:

10.  Click “OK” to proceed downloading the patches.

11. Once the patches are downloaded and click the “Manage Patches” tab to proceed with the patch application. In the “Downloaded Patches” section you will notice the patches downloaded, click the “up” arrow to apply the patch

12. You will be prompted with couple of prompts for you to take action:

Click “OK” to proceed

13.  Once more the validation is done, click “OK” to proceed

14.  One more “Are you sure?” prompt, annoying I know :). Click “Proceed” to apply the patch

15. Once the patch is applied you’d see the patch in the Applied Patches “Default” tab

Thats it the patch is now applied. If you face any issues its worth investigating the server logs.

This post talks about the Conversion of  11gR2 non-RAC database to RAC database using rconfig.

Oracle provides 3 methods to convert non-RAC single instance database to RAC databases:

1. DBCA
2. rconfig
3. Enterprise Manager

All the 3 have their own benefits and can be used to suit one’s needs. My recent work involved the conversion of non-RAC single instance database to RAC database using rconfig, although I’ve tested all the 3 methods but concluded on rconfig.

Pre-requisites:

1. Configure Shared Storage setup ASM, NFS (NAS) or clustered storage.

2. A clustered Grid Infrastructure install with at least one Scan listener address. See

Oracle Grid Infrastructure Installation Guide 11g Release 2 (11.2) Linux

3.  rconfig imposes a restriction on the choice of listener. The listener must be the default listener, and it must run from the Grid Infrastructure home.

srvctl add listener -p 1522

After conversion, you can reconfigure the listener as required.

4.  Install Clustered Oracle Database Software as per documentation, this can be done by choosing the right configuration option. Refer to :

http://download.oracle.com/docs/cd/E11882_01/install.112/e10813/racinstl.htm#BABJGBHB

I’ve installed the new 11gR2 clustered ORACLE_HOME at

/u01/app/oracle/product/11.2.0/db_2

on both the nodes orarac01 and orarac02



Converting Single Instance Database using rconfig

1. As an “oracle” OS user navigate to

$ORACLE_HOME/assistants/rconfig/sampleXMLs

2. Open the sample file ConvertToRAC_AdminManaged.xml using a text editor such as vi. This XML sample file contains comment lines that provide instructions on how to edit the file to suit your site’s specific needs.

3.  Ensure you edit the xml with convert verify="ONLY"
The following are the sample entries:


<!--Specify current OracleHome of non-rac database for SourceDBHome -->
 /u01/app/oracle/product/11.2.0/db_1
<!--Specify OracleHome where the rac database should be configured. It can be same as SourceDBHome -->
 /u01/app/oracle/product/11.2.0/db_2
<!--Specify SID of non-rac database and credential. User with sysdba role is required to perform conversion -->

...

<!--Specify the list of nodes that should have rac instances running for the Admin Managed Cluster Database. LocalNode should  be the first node in this nodelist. -->

...

<!--Specify Database Area Location to be configured for rac database.If this field is left empty, current storage will be use d for rac database. For CFS, this field will have directory path. -->
 +DATA

4.  Move the spfile to the shared location, in this case the Single Instance Database was hosted on file system, in this process we will move the datafiles from file system storage to ASM.

So create spfile in the shared disk location


SQL>create spfile='+DATA/TEST/spfiletest.ora' from pfile;

You can check if the file is created through “asmcmd”

5. Take a backup of existing $SOURCE_ORACLE_HOME/dbs/initTEST.ora, and create a new $SOURCE_ORACLE_HOME/dbs/initTEST.ora with the following parameter:


spfile='+DATA/TEST/spfiletest.ora'

6. Restart the Database

7. Now lets test if “rconfig” is ready for conversion, navigate to $ORACLE_HOME/bin and issue the following command


$./rconfig $ORACLE_HOME/assistants/rconfig/sampleXMLs/ConvertToRAC_AdminManaged.xml

The above command validates( as we’ve set convert=”ONLY”) if rconfig is ready for conversion. If the output throws any error, diagnose and troubleshoot to fix the issue. Refer to the following output for successful validation:


...

 Operation Succeeded

There is no return value for this step

..

8. Now are we are ready for conversion, edit the xml file “ConvertToRAC_AdminManaged.xml” and change:

from:


..
 <n:Convert verify="ONLY">
..

to


..
 <n:Convert verify="YES">
..

9. Perform the conversion


$./rconfig $ORACLE_HOME/assistants/rconfig/sampleXMLs/ConvertToRAC_AdminManaged.xml

The conversion will take some time to complete. The progress can be monitored from the logs located at $ORACLE_BASE/cfgtoollogs/rconfig

10. Once the conversion is complete you’d get a similar message in step 7.

11. Perform sanity checks and tweak the listener to suit your needs.

That sums up the procedure to convert Single Instance Oracle Database to RAC database. Please do share your thoughts and comments.

Reference:

http://download.oracle.com/docs/cd/E11882_01/install.112/e17214/cvrt2rac.htm#BABGGEGJ