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

Posted on 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 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 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 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 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 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 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

Adding addidional hard drive and attach it to a linux box.

Posted on By Admin No Comments on Adding addidional hard drive and attach it to a linux box.

1) Add hard drive in vmware console. Select any SCSE disk type. 2) From vmware itself you will know that what will its sd number. like will it be sda,sdb.. or sdz. 3) start virtual machine and do the following as root: # fdisk /dev/sdg1 Here create a primary partition and write partition table. now…

Read More “Adding addidional hard drive and attach it to a linux box.” »

Linux/Unix, shell

Oracle10g – Using SQLAccess Advisor (DBMS_ADVISOR) with the Automatic Workload Repository

Posted on By Admin No Comments on Oracle10g – Using SQLAccess Advisor (DBMS_ADVISOR) with the Automatic Workload Repository

PURPOSE This article is a step by step demonstration on how to use the Oracle10g SQLAccess Advisor (DBMS_ADVISOR) package to get recommendations on what Materialized Views to create in order to support a given set of queries (a workload) issued on the database. The workload is imported from the Oracle10g Automatic Workload Repository using a…

Read More “Oracle10g – Using SQLAccess Advisor (DBMS_ADVISOR) with the Automatic Workload Repository” »

Oracle, SQL scripts

SQL_PROFILE – I explaination

Posted on By Admin No Comments on SQL_PROFILE – I explaination

Checked for relevance on 12-May-2008. Clarification/Explanation ========================== The query optimizer can sometimes produce inaccurate estimates about an attribute of a statement due to lack of information,leading to poor execution plans. Traditionally, users have corrected this problem by manually adding hints to the application code to guide the optimizer into making correct decisions. For packaged applications,…

Read More “SQL_PROFILE – I explaination” »

Oracle, SQL scripts