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…
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…
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,…
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” »
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” »
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…
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,…
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.” »
Note:144152.1 Understanding 9i Real Application Clusters Cache Fusion Recovery
Step-1 Run @temp_use.sql as following. Following is the code for temp_use.sql SELECT b.TABLESPACE, b.segfile#, b.segblk#, b.blocks, a.SID, a.serial#, a.username, a.osuser, a.status, c.sql_text FROM v$session a, v$sort_usage b, v$sqlarea c WHERE a.saddr = b.session_addr AND a.SQL_HASH_VALUE = c.HASH_VALUE and a.sid not in (select distinct sid from v$mystat) ORDER BY b.TABLESPACE, b.segfile#, b.segblk#, b.blocks / set pagesize…
Read More “When error comes for temporary tablespace with version <= 9i” »
