摘要:
In the event you cannot mount your ASM disk groups, you will be unable to start any databases using those disk groups. Here is a possible error reported when mounting ASM disk groups:SQL> startup mountORA-15032: not all alterations performedORA-15063: diskgroup "<DISK GROUP NAME>" 阅读全文
摘要:
This article describes the steps to migrate a database from Non-ASM to ASM and vice-versa. To setup ASM, please followNote 452924.1 - How to Prepare Storage for ASMNote 265633.1 - ASM Technical Best PracticesNote 249992.1 - New Feature on ASM (Automatic Storage Manager).Scope and ApplicationA schedu 阅读全文
摘要:
Thisdocument provides a procedure to configure/reconfigure the ( High AvailabilityService ) HAS and CSS resource on Oracle Grid Infrastructure for nonRAC setup Solution 1) Whenyou install grid infrastructure for single instance, at the end we run root.sh, that directs you to run the following scrip. 阅读全文
摘要:
This document will list the possible meta characters for asm_diskstring parameter Solution* and [] are the two valid meta characters for asm_diskstring parameter.SQL> alter system set asm_diskstring='/dev/raw/raw*' scope=both;System altered.SQL> select path from v$asm_disk;PATH-------- 阅读全文
摘要:
After installing a non-RAC (Real Application Clusters) 10g database, you notice an ocssd.bin process running.ps -ef | grep ocssd.binoracle 11139 11056 0 14:02:14 pts/52 0:00 grep ocssd.binoracle 1824 1 0 Mar 12 ? 0:01 /oracle/64bit/10.1.0/bin/ocssd.bin Solution In a non-RAC environment, the ocssd.b. 阅读全文
摘要:
If using pfile, it must be a filesystem file on local filesystem.If using spfile, then it can be in the following locations.-- a filesystem file spfile on local filesystem-- spfile on shared device-- a ASM file in a ASM diskgroup (only for spfile for DB instances before 11.2)Trying to put ASM spfile 阅读全文
摘要:
In a single asm_diskstring parameter we can have 255 characters and this excludes the asterisk (*) , comma (,) and single-quote ('). This is limited by v$asm_disk.path column's datatype length. In an ASM instance we can have multiple asm_diskstring parameters. But the values from them are co 阅读全文