RAC
Microjoey
OCM,Fanatic RAC
展开
-
LISTENER
ora.LISTENER.lsnr ora.LISTENER_ASM.lsnr ora.LISTENER_RIM.lsnr ora.LISTENER_SCAN1.lsnr原创 2012-05-18 14:10:47 · 509 阅读 · 0 评论 -
ORA-25141:
Elapsed: 00:00:00.02h1-SQL> create tablespace USERS datafile '+HIGH/h/users01.dbf' size 500M extent autoextend on;create tablespace USERS datafile '+HIGH/h/users01.dbf' size 500M extent autoextend原创 2012-04-18 20:40:57 · 2269 阅读 · 0 评论 -
tpch
tpch原创 2012-04-18 17:06:18 · 586 阅读 · 0 评论 -
ORA-00304: requested INSTANCE_NUMBER is busy
[oracle@nshexdaj4db01 dbs]$ ls spfileh_ios.ora spfileh_ios.ora[oracle@nshexdaj4db01 dbs]$ sqlplus / as sysdbaSQL*Plus: Release 12.1.0.0.2 Beta on Wed Apr 18 01:12:44 2012Copyright (c) 1982原创 2012-04-18 13:22:04 · 3049 阅读 · 0 评论 -
asmcmd difference between sysdba and sysasm
asmcmd difference between sysdba and sysasm原创 2012-04-16 10:54:13 · 1032 阅读 · 0 评论 -
asmcmd not execute cp command
ASMCMD [+data0411] > cp spfile +data0411/RACSTR/copying +data0411/spfile -> +data0411/RACSTR/spfileASMCMD-8016: copy source '+data0411/spfile' and target '+data0411/RACSTR/spfile' failedORA-1950原创 2012-04-16 10:52:28 · 2562 阅读 · 0 评论 -
CRS not update the config file
create spfile='+DATA0411/spfile' from pfile='/u01/app/base/admin/racstr/scripts/init.ora';srvctl modify database -d racstr -p +DATA0411/spfile[cdccrs@node01 trace]$ sqlplus / as sysdbaSQL*Plus原创 2012-04-16 10:51:49 · 424 阅读 · 0 评论 -
Difference between CSSDAGENT and CSSDMONITOR
CSSDAGENT - This process is spawned by OHASD and is responsible for spawning the OCSSD process, monitoring for node hangs (via oprocd functionality), and monitoring to the OCSSD process for hangs (via原创 2012-04-16 19:35:49 · 2584 阅读 · 0 评论 -
OHASD
OHASDIn a cluster, OHASD runsas root; in an Oracle Restart environment, where OHASD manages application resources, itruns as the oracle user.原创 2012-04-16 18:52:13 · 662 阅读 · 0 评论 -
asmcmd error -- clsecho: No such file or directory
Question:when using asmcmd ,encounter the error:[cdccrs@node01 ~]$ asmcmdsh: /u01/app/base/product/12.1.0/dbhome_1/bin/clsecho: No such file or directorysh: /u01/app/base/product/12.1.0/db原创 2012-04-16 18:17:11 · 11656 阅读 · 0 评论 -
srvctl modify the spfile,but db start using old spfile
create spfile='+DATA0411/spfile' from pfile='/u01/app/base/admin/racstr/scripts/init.ora';srvctl modify database -d racstr -p +DATA0411/spfile[cdccrs@rwsaq01 trace]$ sqlplus / as sysdbaSQL*Plu原创 2012-04-16 18:15:19 · 855 阅读 · 0 评论 -
ORA-01618: redo thread 2 is not enabled - cannot mount 错误
今天用两台linux red hat 4 搭建RAC(10G)的时候出现此错误,后来解决了,给分享一下。我刚刚建立好RAC,能打开节点1,打开节点2时报此错,查看节点1的日志如下:SQL>select * from v$Log;// 只有节点1的日志,却没有节点2的日志GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARC STATUS FIRST_CHA原创 2012-04-19 19:12:09 · 1479 阅读 · 0 评论 -
ins 32025 oracle
ins 32025 oracle原创 2012-04-22 15:51:37 · 992 阅读 · 0 评论 -
TNS-12541: TNS:no listener
TNS-12541: TNS:no listener原创 2012-05-18 10:33:00 · 753 阅读 · 0 评论 -
ORA-01017
ORA-01017原创 2012-05-17 17:19:00 · 611 阅读 · 0 评论 -
ORA-12516
ORA-12516:TNS:listener could not find available handler with matching protocol stackCause:None of the known and available service handlers for the given SERVICE_NAME support the client's p原创 2012-05-16 08:40:04 · 1653 阅读 · 1 评论 -
cell smart table scan
cell smart table scan原创 2012-05-15 17:26:29 · 904 阅读 · 0 评论 -
SCN what,why,how?
http://www.orainternals.com/2012/01/20/scn-what-why-and-how/原创 2012-05-14 15:45:22 · 441 阅读 · 0 评论 -
RAC object remastering ( Dynamic remastering )
http://www.oaktable.net/content/rac-object-remastering-dynamic-remastering原创 2012-05-14 15:41:40 · 319 阅读 · 0 评论 -
cluster_interconnec
cluster_interconnec原创 2012-05-08 09:52:47 · 349 阅读 · 0 评论 -
ORA-12720: operation requires database is in EXCLUSIVE mode
PROBLEMWhen I try to create an controlfile for a RAC database using the CONTROLFILE Trace. I was throw with the below error messageSQL> @c.sqlCREATE CONTROLFILE REUSE DATABASE "XE1" RESE原创 2012-04-22 22:58:22 · 4298 阅读 · 0 评论 -
关于Exadata
Oracle在今年旧金山的OOW大会上发布了自己和HP合作的第一款硬件产品——Exadata。Exadata包含主机Database Machine和存储Exadata StorageServer两种产品,硬件产品由HP提供,Oracle提供软件支持。Oracle号称该款产品在数据仓库的环境下,相比传统的Oracle数据库有着数量级的性能提升。到底该产品有着怎样的改进和亮点才会让Oracle如此自转载 2012-04-22 16:08:01 · 1518 阅读 · 0 评论 -
oracle RACG
oracle RACG is what?原创 2012-04-16 18:41:42 · 676 阅读 · 0 评论 -
Encounter ORA-03113 Error when create spfile from pfile
SQL> create spfile='+DATA0411/spfile' from pfile='/u01/app/base/admin/racstr/scripts/init.ora';create spfile='+DATA0411/spfile' from pfile='/u01/app/base/admin/racstr/scripts/init.ora'*ERROR at原创 2012-04-15 11:16:22 · 1060 阅读 · 0 评论 -
11gR2 Oracle clusterware log files
Oracle Database uses a unified log directory structure to consolidate the Oracle Clusterware component log files. This consolidated structure simplifies diagnostic information collection and assists d原创 2012-04-15 15:09:08 · 964 阅读 · 0 评论 -
Oracle 11gR2 clusterware startup sequence
Metalink:http://blog.csdn.net/microjoey/article/details/7462855ohasd -> orarootagent->ora.cssdmonitor: Monitors CSSD and node health (along with the cssdagent). Try to restart the node i原创 2012-04-15 14:58:05 · 975 阅读 · 0 评论 -
Difference for LIOT and SIOT
difference原创 2012-04-15 08:04:44 · 388 阅读 · 0 评论 -
Introduce the OHAS(Oracle High Availability Service)
What is the HAS?原创 2012-04-15 06:28:03 · 383 阅读 · 0 评论 -
cssd for bug
[root@rwsaq02 lib]# crsctl check crsCRS-4638: Oracle High Availability Services is onlineCRS-4535: Cannot communicate with Cluster Ready ServicesCRS-4530: Communications failure contacting Cluster原创 2012-04-14 21:25:09 · 890 阅读 · 0 评论 -
ORA-01041
h1-SQL> startup pfile=?/dbs/inith1.oraORA-03113: end-of-file on communication channelORA-01041: internal error. hostdef extension doesn't exist原创 2012-04-25 10:31:16 · 521 阅读 · 0 评论 -
ora 00240 control file enqueue
ora 00240 control file enqueue原创 2012-04-25 08:31:30 · 821 阅读 · 0 评论 -
Simple explanation of Wait Event “cursor: pin s”
http://swervedba.wordpress.com/2011/03/30/cursor-pin-s/http://swervedba.wordpress.com/tag/cursor-pin-s-wait-on-x-oracle-11g/原创 2012-04-24 15:08:27 · 435 阅读 · 0 评论 -
How to Troubleshoot Grid Infrastructure Startup Issues [ID 1050908.1]
In this Document Purpose Scope and Application Troubleshoot Grid Infrastructure Startup Issues Start up sequence: Cluster status Case 1: OHASD does not start Case 2: O转载 2012-04-10 20:36:17 · 8848 阅读 · 0 评论 -
Finding alert.log file in 11g [ID 438148.1]
Metalink - ID 438148.1In this Document Purpose Scope and Application Finding alert.log file in 11gApplies to: Oracle Server - Enterprise Edition - Version: 11.1.0.6 and later转载 2012-04-08 21:45:55 · 843 阅读 · 0 评论 -
ASM Command-Line Utility(ASMCMD)
ASMCMD is a command-line utility that you can use to easily view and manipulate files and directories within Automatic Storage Management (ASM) disk groups. It can list the contents of disk groups, pe原创 2012-04-15 14:44:50 · 576 阅读 · 0 评论 -
ASM
1,what is the asm?ASM is an integrated volume manager for storingOracle database files - includingdatafiles,redo logs,backups,controlfiles and spfiles. ASM allows administrators to add and r原创 2012-04-15 14:26:19 · 474 阅读 · 0 评论 -
cluster_database false or ture - ORA-01102
Today,Create one rac db by using scripts,encounter an error:ORA-01102: cannot mount database in EXCLUSIVE modesolution:modify the cluster_database from true to false,the script can run.原创 2012-04-15 07:32:05 · 711 阅读 · 0 评论 -
Information about ora.OC4J in Rac Environment
You can find the status of oc4j and gsd is offline when you installed 11.2.0.1 Rac,like following info.NAME=ora.oc4jTYPE=ora.oc4j.typeTARGET=OFFLINESTATE=OFFLINENAME=ora.gsdTYPE=or原创 2012-04-15 09:20:25 · 2276 阅读 · 0 评论 -
Oracle RAC Clusterware Components
Oracle Clusterware includes the following processes: Link toOracle RAC clusterware startup sequence (11gR2) 1) Cluster Ready Services (CRS)原创 2012-04-15 15:06:13 · 524 阅读 · 0 评论 -
11gR2 Clusterware and Grid Home - What You Need to Know [ID 1053147.1]
In this Document Purpose Scope and Application 11gR2 Clusterware and Grid Home - What You Need to Know 11gR2 Clusterware Key Facts Clusterware Startup Sequence Important Log原创 2012-04-15 14:59:20 · 1257 阅读 · 0 评论