Skip to content
pvmehta.com

pvmehta.com

  • Home
  • About Me
  • Toggle search form
  • sql_doing_fts.sql Oracle
  • executing Function from SQLPLUS prompt Oracle
  • oracle fast start failover best practice Oracle
  • 10g oem configuration Oracle
  • FGA Part-I Oracle
  • Windows based Command line mailing program like mailx (Sednmail for windows) PHP/MYSQL/Wordpress
  • rm_backup_arch_file.ksh Linux/Unix
  • find_du.ksh to find # of files, their sizes in current folder and its subdolder Linux/Unix
  • chk_space_SID.ksh Linux/Unix
  • Adding addidional hard drive and attach it to a linux box. Linux/Unix
  • Processes parameter and its dependencies on OS kernel parameters Linux/Unix
  • RAC 11g with vmware Oracle
  • find_log_switch.sql Find log switches in graphical manner Oracle
  • pvm_pre_change.sql Oracle
  • How To Transfer Passwords Between Databases (ref note: 199582.1) Oracle

Category: RAC

Running PDB on single node in RAC

Posted on 09-Apr-2026 By Admin

Configuring a PDB to Listen on a Specific RAC Node in Oracle Database In Oracle Real Application Clusters (RAC) environments, you may need to restrict a Pluggable Database (PDB) to run on specific nodes. Here’s how to configure PDB MYPDB to listen only on node1: Step-by-Step Configuration 1. Configure the PDB State on Node 1…

Read More “Running PDB on single node in RAC” »

Oracle, RAC, SQL scripts

Oracle 11g RAC on OEL 5 and Vmware 2

Posted on 11-Jan-2009 By Admin No Comments on Oracle 11g RAC on OEL 5 and Vmware 2

http://www.oracle-base.com/articles/11g/OracleDB11gR1RACInstallationOnOEL5UsingVMwareServer2.php

Oracle, RAC

272332.1 CRS 10g Diagnostic Collection Guide

Posted on 04-Jan-2009 By Admin No Comments on 272332.1 CRS 10g Diagnostic Collection Guide

CRS 10g Diagnostic Collection Guide =================================== This document contains guidelines for collecting diagnostic information from a CRS installation. The diagnostics listed in the sections below are necessary for development to be able to help with TARs, bugs and other problems that may arise in the field. CRS Collect all CRS log files, trace files and…

Read More “272332.1 CRS 10g Diagnostic Collection Guide” »

Oracle, RAC

284785.1 How to check RAC Option is currently linked into the Oracle Binary

Posted on 04-Jan-2009 By Admin No Comments on 284785.1 How to check RAC Option is currently linked into the Oracle Binary

Applies to: Oracle Server – Enterprise Edition – Version: 9.2 to 11.1 Information in this document applies to any platform. Goal The goal of this articale is to find whether rac option is linked into Oracle binary or not. Solution steps to check ——————————— 1.Go to $ORACLE_HOME/rdbms/lib 2.run the following command nm -r libknlopt.a |…

Read More “284785.1 How to check RAC Option is currently linked into the Oracle Binary” »

Oracle, RAC

556976.1 Oracle Clusterware: Components installed

Posted on 04-Jan-2009 By Admin No Comments on 556976.1 Oracle Clusterware: Components installed

In this Document Purpose Scope Oracle Clusterware: Components installed. What is the Oracle Clusterware? Components. Components creation. Conclusion. References Applies to: Oracle Server – Enterprise Edition – Version: 10.2.0.3 to 11.1.0.6 Information in this document applies to any platform. Purpose This document is aimed to explain the different parts of the Oracle Clusterware (sometimes also…

Read More “556976.1 Oracle Clusterware: Components installed” »

Oracle, RAC

276434.1 Modifying the VIP or VIP Hostname of a 10g or 11g Oracle Clusterware Node

Posted on 04-Jan-2009 By Admin No Comments on 276434.1 Modifying the VIP or VIP Hostname of a 10g or 11g Oracle Clusterware Node

In this Document Purpose Scope and Application Modifying the VIP or VIP Hostname of a 10g or 11g Oracle Clusterware Node Planning for VIP changes Verifying Current VIP configuration Stopping Resources Syntax for modifying nodeapps Starting Resources Back Up References Applies to: Oracle Server – Enterprise Edition – Version: 10.1.0.2 to 11.1.0.* Information in this…

Read More “276434.1 Modifying the VIP or VIP Hostname of a 10g or 11g Oracle Clusterware Node” »

Oracle, RAC

How to start CRS manually

Posted on 04-Jan-2009 By Admin No Comments on How to start CRS manually

In this Document Purpose Scope How To Manually Start Oracle CRS Clusterware References Applies to: Oracle Server – Enterprise Edition – Version: 10.1.0.2 to 11.1.0.7 Information in this document applies to any platform. Information in this document applies to Unix platforms only. Purpose This article is intended for DBAs having problems to start the CRS…

Read More “How to start CRS manually” »

Oracle, RAC

10g RAC: Troubleshooting CRS Root.sh Problems

Posted on 04-Jan-2009 By Admin No Comments on 10g RAC: Troubleshooting CRS Root.sh Problems

0g RAC: Troubleshooting CRS Root.sh Problems Doc ID: 240001.1 Type: TROUBLESHOOTING Modified Date : 19-MAR-2008 Status: PUBLISHED Symptom(s) ~~~~~~~~~~ The CRS stack does not come up while running root.sh after installing CRS (Cluster Ready Services): You may see the startup timing out or failing. Example: Successfully accumulated necessary OCR keys. Using ports: CSS=49895 CRS=49896 EVMC=49898…

Read More “10g RAC: Troubleshooting CRS Root.sh Problems” »

Oracle, RAC

Configure ssh authentications for RAC

Posted on 04-Jan-2009 By Admin No Comments on Configure ssh authentications for RAC

Applies to: Oracle Server – Enterprise Edition – Version: 10.1.0.2 to 11.1.0.6 Information in this document applies to any platform. Reviewed 22-Oct-2008 Goal This document will explain how to configure SSH, which is required to run a RAC installation. Following the instructions in the installation guide are also correct, but sometimes this will not work,…

Read More “Configure ssh authentications for RAC” »

Oracle, RAC

339939.1 Running Cluster Verification Utility to Diagnose Install Problems

Posted on 04-Jan-2009 By Admin No Comments on 339939.1 Running Cluster Verification Utility to Diagnose Install Problems

In this Document Purpose Scope and Application Running Cluster Verification Utility to Diagnose Install Problems References Applies to: Oracle Server – Enterprise Edition – Version: 10.1 to 11.1 Information in this document applies to any platform. Purpose The purpose of this document is to enable the DBA to diagnose install failures using Cluster Verification Utility…

Read More “339939.1 Running Cluster Verification Utility to Diagnose Install Problems” »

Oracle, RAC

Posts pagination

1 2 Next

Categories

  • Ansible (0)
  • AWS (2)
  • Azure (1)
  • Django (0)
  • GIT (1)
  • Linux/Unix (149)
  • MYSQL (5)
  • Oracle (402)
  • PHP/MYSQL/Wordpress (10)
  • POSTGRESQL (1)
  • Power-BI (0)
  • Python/PySpark (7)
  • RAC (18)
  • rman-dataguard (26)
  • shell (150)
  • SQL scripts (350)
  • SQL Server (6)
  • Uncategorized (3)
  • Videos (0)

Recent Posts

  • runon_allpdbs_show_conname.sh23-Apr-2026
  • runon_allcdbs_find_pdbs.sql23-Apr-2026
  • Running PDB on single node in RAC09-Apr-2026
  • find_arc.sql09-Apr-2026
  • pvm_pre_change.sql08-Apr-2026
  • find_encr_wallet.sql08-Apr-2026
  • find_pdbs.sql08-Apr-2026
  • Creating a Container Database using dbaascli08-Apr-2026
  • track_autoupgrade_copy_progress.sql01-Apr-2026
  • refre.sql for multitenant01-Apr-2026

Archives

  • 2026
  • 2025
  • 2024
  • 2023
  • 2010
  • 2009
  • 2008
  • 2007
  • 2006
  • 2005
  • send attachment from unix-shell script Linux/Unix
  • pvmehta.com SQL scripts
    Find which sessions is accessing object that prevent your session to have exclusive locks in Oracle Oracle
  • All About Trace Fils Oracle
  • Oracle vs MYSQL Architecture differences (For DBAs) MYSQL
  • handling filenname with space Linux/Unix
  • Removing Blank lines from file using grep Linux/Unix
  • Unix command for system configuration Linux/Unix
  • on IBM-AIX for display Linux/Unix

Copyright © 2026 pvmehta.com.

Powered by PressBook News WordPress theme