set lines 132 set pagesize 3000 spool lob_mvmt select ‘alter table ‘ || table_name || ‘ move lob(‘|| column_name || ‘) store as ( tablespace pnet_data ) ;’ from user_tab_columns where data_type like ‘%LOB%’; spool off
Hello Buddy
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…
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” »
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” »
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” »
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” »
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,…
