ITPub博客

-- NAME: LFSDIAG.SQL-- -------------------------------------------------------------------------- AUTHOR: Michael Polaski - Oracle Support Services-- -------------------------------------------------------------------------- PURPOSE:-- This script is intended to provide a user friendly guide ...

今天看了一篇文章说是误将新创建的表空间的数据文件放置在了本地系统而不是共享存储上。是Oracle的中文技术支持博客题目是：RAC中误将数据文件创建在本地盘时的修正 于是我想11G 也兼容这些操作的方法，但是11G的新特性有一点就是可以直接支持ASM文件系统直接可以和本地文件系统进行文件的拷贝了，也就...

1  create spfile='+sysdg/ANALYDB/spfileanalydb.ora'  from pfile='/oracle/admin/analydb/pfile/init.ora.222014171919';rm /oracle/product/11.2.0.3/db_1/dbs/spfileanalydb_1.ora2 SQL> show parameter pfile;NAME                   ...

The Oracle JDBC thin driver does not support TAF. TAF is only supported by the JDBC OCI driver. Transparent Application Failover (TAF) is a feature of the Java Database Connectivity (JDBC) Oracle Call Interface (OCI) driver. It enables the application to automatically reconnect to a da...

 开始前的准备工作1、停监听、停服务  srvctl stop listener -n mmdb1  srvctl stop listener -n mmdb2  srvctl stop service -d mmdb -s service_name -n mmdb1  srvctl stop service -d mmdb -s service_name -n mmdb22、查看public IP检查公共网络接口的配...

Applies to:Oracle Server - Enterprise Edition - Version: 8.1.7 to 11.1.0.6Information in this document applies to any platform.GoalA Stored Outline will only be used when the parameter USE_STORED_OUTLINES is set persistently.  If parameter is set  using alter session or ...

Chunk by ROWIDThis example shows the most common usage of this package. After calling the RUN_TASK Procedure, it checks for errors and re-runs in the case of error.DECLARE l_sql_stmt VARCHAR2(1000); l_try NUMBER; l_status NUMBER;BEGIN -- Create the TASK DBMS_PARALLEL_EXECUTE...

Applies to:Oracle Database - Enterprise Edition - Version 9.2.0.4 and laterInformation  in this document applies to any platform.***Checked for relevance on 03-Nov-2011***SymptomsConcurrent truncate on small tables are taking a very long time to be completed. When the truncate is...

rac滚动每个节点逐一打：1 patch grid如下：1.1 关闭crs:节点1:[root@ossoipltedb11 install]# /oracle/app/11.2.0.3/gi/crs/install/rootcrs.pl -unlockUsing configuration parameter file: /oracle/app/11.2.0.3/gi/crs/install/crsconfig_paramsCRS-2791: Starting shutdown of Oracle High Availability Se...

Applies to: Oracle Database - Enterprise Edition - Version 11.2.0.3 to 11.2.0.4 [Release 11.2]Linux x86-64Linux x86Purposeoratop is a utility similar to the unix OS utility top which gives a overview of database performance and can be used in combination with top to get a more comp...

适用于: Oracle Database - Enterprise Edition - 版本 10.2.0.1 和更高版本本文档所含信息适用于所有平台Oracle Clusterware目标本文记录了诊断 Oracle 集群问题所需要上传的日志。获取更多 diagcollection 工具信息，请查看命令"diagcollection.sh -help"的输出。 本文将来会被废止...

ora-600 ktbdchk1: bad dscn大批量dml操作时报错如下：ora-600 ktbdchk1: bad dscnmetlink上有如下描述：ORA-600 on UPDATE statement========= Dump for incident 932331 (ORA 600 [ktbdchk1: bad dscn]) ========----- Beginning of Customized Incident Dump(s) -----[ktbdchk] -- ktbgcl4 -- bad dsc...

Applies to:Oracle Database - Enterprise Edition - Version 8.1.5.0 to 11.2.0.3 [Release 8.1.5 to 11.2]Information  in this document applies to any platform.PurposeThe purpose of the note is to help customers troubleshoot Virtual Circuit Waits.Troubleshooting Steps ...

1 原来rac环境上创建service：  srvctl add service -d lteidba -s lteidbasr -r lteidba1 -a lteidba2 -P BASIC -y automatic -e SELECT -m BASIC -z 5 -w 180  启动：  srvctl start service -d lteidba  -s lteidbasr  停止：  srvctl stop service -d lteidba  -s lteidbasr...

Creating ASMSNMP User reports ORA-15306: ASM Password File Update Failed On At Least One Node. (文档 ID 1137504.1)Applies to: Oracle Database - Enterprise Edition - Version 11.1.0.7 and laterInformation in this document applies to any platform.SymptomsCreating the ASMSNM...

Applies to:Oracle Database - Personal Edition - Version 8.0.6.0 and laterOracle Database - Standard Edition - Version 8.0.6.0 and laterOracle Database - Enterprise Edition - Version 8.0.6.0 and laterInformation in this document applies to any platform.PurposeThe purpose of the note is ...

Oracle_TimesTen_and_In-Memory_Database_Cache_11g_Ed_1http://www.itpub.net/thread-1841496-1-1.html

10205版本：SQL> select * from x2 where (select   count(*) from x1 aa where c1=d1) > d1 - d2;        D1         D2---------- ----------         1          2Executi...

http://www.itpub.net/thread-1839226-1-1.html

 1  主库日志模式修改：SQL>alter database force logging;Databasealtered.2 为备库创建dump日志目录： $mkdir -p /oracle/db_base/admin/test/test/adump$ mkdir -p/oracle/db_base/admin/test/test/pdb1/...