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

Processes parameter and its dependencies on OS kernel parameters

Posted on By Admin No Comments on Processes parameter and its dependencies on OS kernel parameters

At this time in 800P, we are having following parameter set. NAME TYPE VALUE ———————————— ———– —————————— processes integer 3500 sessions integer 9000 The main parameter is “processes” parameter as it depends upon the # of semaphores in the system. This parameter depends upon followng kernel values. nproc – Maximum number of processes that can…

Read More “Processes parameter and its dependencies on OS kernel parameters” »

Linux/Unix, shell

Nice Article about semaphores and init.ora Processes parameter relations

Posted on By Admin No Comments on Nice Article about semaphores and init.ora Processes parameter relations

metalink note: 15566.1 PURPOSE Shared memory and semaphores are two important resources for an Oracle instance on Unix. An instance cannot start if it is unable to allocate what it needs. This paper primarily discusses the process Oracle goes through to allocate shared memory and semaphores at instance startup. Other important points unrelated to startup…

Read More “Nice Article about semaphores and init.ora Processes parameter relations” »

Linux/Unix, shell

Temporary Tablespace Information and restriction.

Posted on By Admin No Comments on Temporary Tablespace Information and restriction.

Temporary Tablespace (1) The DEFAULT TEMPORARY TABLESPACE must be of TEMPORARY type. (2) The DEFAULT TEMPORARY TABLESPACE cannot be converted to PERMANENT once it has been defined as the DEFAULT TEMPORARY TABLESPACE. (3) Before dropping the DEFAULT TEMPORARY TABLESPACE, create another one. (4) The DEFAULT TEMPORARY TABLESPACE cannot be taken OFFLINE: (5) The temporary tablespace…

Read More “Temporary Tablespace Information and restriction.” »

Oracle, SQL scripts