Skip to content
pvmehta.com

pvmehta.com

  • Home
  • About Me
  • Toggle search form
  • load SPM baseline from cursor cache Oracle
  • FGA Part-I Oracle
  • Standby Database File Management in 10g with STANDBY_FILE_MANAGEMENT Oracle
  • cold backup scripts to copy locally Linux/Unix
  • v$event_name Oracle
  • Renaming Oracle Instance Name Oracle
  • nfs mount command Linux/Unix
  • sess1.sql Oracle
  • get_ratio.sql get the ratio of users from v$session and this uses CASE-WHEN-THEN clause Oracle
  • ORA-00064: object is too large to allocate on this O/S during startup Oracle
  • FRA Information. Oracle
  • SQL_PLAN.sql for checking real execution plan Oracle
  • eplan.sql Oracle
  • How to remove blank lines using vi editor command Linux/Unix
  • Good Oracle Architecture In Short and point to point Oracle

Category: Oracle

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

Kill a session dynanically using execute immediate

Posted on 04-Jan-2009 By Admin No Comments on Kill a session dynanically using execute immediate

In this Document Goal Solution References Applies to: PL/SQL – Version: 8.1.7.4 to 10.1.0.2 Information in this document applies to any platform. Goal This article presents one suggested way of killing a session using an “ALTER SYSTEM KILL SESSION ‘sid,serial#’ ” statement in PL/SQL dynamically where the sid and serial# are values being passed in…

Read More “Kill a session dynanically using execute immediate” »

Oracle, SQL scripts

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

751131.1 New Article Error 2819 While Requesting a Systemstate Dump

Posted on 04-Jan-2009 By Admin No Comments on 751131.1 New Article Error 2819 While Requesting a Systemstate Dump

Applies to: Oracle Server – Enterprise Edition – Version: 9.0.1 to 11.1 Oracle Server – Enterprise Edition – Version: 8.0 to 11.1 This problem can occur on any platform. Symptoms Using oradebug to create a systemstate may lead to the following error: oradebug dump systemstate 266 Error 2819 encountered by local process [ospid=5529] or oradebug…

Read More “751131.1 New Article Error 2819 While Requesting a Systemstate Dump” »

Oracle, RAC

Posts pagination

Previous 1 … 12 13 14 … 40 Next

Categories

  • AWS (2)
  • Azure (1)
  • Linux/Unix (149)
  • Oracle (392)
  • PHP/MYSQL/Wordpress (10)
  • Power-BI (0)
  • Python/PySpark (7)
  • RAC (17)
  • rman-dataguard (26)
  • shell (149)
  • SQL scripts (341)
  • Uncategorized (0)
  • Videos (0)

Recent Posts

  • load SPM baseline from cursor cache05-Jun-2025
  • Drop all SPM baselines for SQL handle05-Jun-2025
  • Load SPM baseline from AWR05-Jun-2025
  • Drop specific SQL plan baseline – spm05-Jun-2025
  • findinfo.sql (SQL for getting CPU and Active session info)27-May-2025
  • SQL Tracker by SID sqltrackerbysid.sql22-Apr-2025
  • How to connect to Oracle Database with Wallet with Python.21-Mar-2025
  • JSON/XML Types in Oracle18-Mar-2025
  • CPU Core related projections12-Mar-2025
  • Exadata Basics10-Dec-2024

Archives

  • 2025
  • 2024
  • 2023
  • 2010
  • 2009
  • 2008
  • 2007
  • 2006
  • 2005
  • SCRIPT TO LIST RECURSIVE DEPENDENCY BETWEEN OBJECTS UTLDTREE.sql Oracle
  • Renaming the column name Oracle
  • How to remove blank lines using vi editor command Linux/Unix
  • Free conference number from http://www.freeconference.com Oracle
  • Shuffle an array PHP/MYSQL/Wordpress
  • Insert cause enqueue locks Oracle
  • scripts to take listener.log backup Linux/Unix
  • newupload.html PHP/MYSQL/Wordpress

Copyright © 2025 pvmehta.com.

Powered by PressBook News WordPress theme