tag:blogger.com,1999:blog-81424537381875476352024-03-13T13:41:16.650-07:00Welcome to the database wizard!Ruminations of the database world and philosophy of all database things great and small. Where we attempt to conjure up magic with your databases.Unknownnoreply@blogger.comBlogger118125tag:blogger.com,1999:blog-8142453738187547635.post-16231672966375599282022-03-31T10:30:00.001-07:002022-03-31T10:30:20.465-07:00Exachk to the rescue!<p> So do you have a large and complex Oracle Exadata environment and need to perform a health check or resolve a tricky issue? Well, one thing to keep in mind is that Oracle support may ask you to run some diagnostics to provide logs and so forth. This is where the utility exachk comes to the resue!</p><p><br /></p><p>What is exachk? Well according to the Oracle Exadata documentation, this nifty utility "<span style="background-color: #fcfbfa; color: #1a1816; font-family: "Oracle Sans", -apple-system, "system-ui", "Segoe UI", "Helvetica Neue", Arial, sans-serif; font-size: 16px;">provide a lightweight and non-intrusive health check framework for the Oracle stack of software and hardware components."</span></p><p><span style="background-color: #fcfbfa; color: #1a1816; font-family: "Oracle Sans", -apple-system, "system-ui", "Segoe UI", "Helvetica Neue", Arial, sans-serif; font-size: 16px;">As an extra bonus, the ExaChk utility works not only for Oracle Exadata engineered systems, but can diagnose issues with other Oracle database appliances such as the Exalogic and Oracle Database Appliance (ODA) systems. Recently, we had a power issue at work that required me to troubleshoot why the Oracle Clusterware (CRS) and ASM failed to come back on line after the power reboot. I tried to start the CRS using standard Oracle 19c RAC commands like crsctl and srvctl with no success as it complained about storage related issues on the Exadata Cloud @ Customer environment since we DBAs unfortunately are not provided with access to the grid disks and cell storage servers due to the setup. So how do you use Exachk? It is really simple actually. You can run it by default as the grid user and by default it runs all of the options to perform a full collection of the Exadata ecosystem. If you use the exachk -a that will run all options for diagnostic collection tasks. It then collects the details for the health check of the Exadata system into a series of tar files to upload to Oracle support.</span></p><p>So the next time you face a challenging Exadata or Oracle engineered system issue, be sure to use the powerful ExaChk utility!</p><p><br /></p><p><span style="background-color: #fcfbfa; color: #1a1816; font-family: "Oracle Sans", -apple-system, "system-ui", "Segoe UI", "Helvetica Neue", Arial, sans-serif; font-size: 16px;">References and Further Reading</span></p><h1 class="KM" style="background-color: white; color: #4e5052; font-family: Arial, Helvetica, sans-serif; font-size: 20px;">Oracle Exadata Database Machine EXAchk <docid>(Doc ID 1070954.1)</docid></h1><p><span style="color: #1a1816; font-family: "Oracle Sans", -apple-system, system-ui, "Segoe UI", "Helvetica Neue", Arial, sans-serif;">Oracle Exachk Quick Start Guide</span></p><p><span style="color: #1a1816; font-family: "Oracle Sans", -apple-system, system-ui, "Segoe UI", "Helvetica Neue", Arial, sans-serif;">https://docs.oracle.com/en/engineered-systems/health-diagnostics/exachk/oexug/quick-start-guide.html#GUID-7C8BEBDC-5125-4493-A8FC-799023FAFC06</span></p>Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-8142453738187547635.post-54996216199298873052021-02-04T22:50:00.002-08:002022-03-31T10:33:34.349-07:00Happy 2021 A New Age <p> Hello my dear readers,</p><p>It has been a long time since I posted but ya know life sometimes gets in the way. Lots of moving, work, travel and projects and the past few years have been life changing on so many levels. This will be a non tech post but next ones will be some new database content!</p><div>I learned Exadata and Oracle Cloud! After many years of hearing about these amazing platforms and attending sessions at past Oracle conferences, I was able last year to get hands on experience working on several large Exadata X4-8 systems. It has been a lot of fun learning and also using Oracle 19c new features like multi-tenancy pluggable databases, Oracle Cloud (OCI) and setting up Oracle 13c Cloud control as well. So fun! </div><div><br /></div><div>More to come my fellow data professionals and colleagues!</div><div><br /></div><div>-Ben</div><p></p><p><b><br /></b></p><p><b><br /></b></p><p><br /></p>Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-8142453738187547635.post-9008633483203095172016-01-19T16:47:00.000-08:002016-01-19T16:47:03.244-08:00ASM Diskgroup Analysis TipRecently I have been performing multiple Oracle 12c RAC setups and digging deep into ASM internals. Besides query the ASM environment via the V$ASM_DISK and V$ASM_DISKGROUP dynamic tables, these lesser known command line tools provide detailed troubleshooting assistance for solving difficult ASM issues with your Oracle environments.<br />
<br /><br />
As a reference point for today's discussion, I found a very useful support note from Oracle that explains all three utilities to analyze Oracle ASM environments:<br />
<br /><br />
<span class="p_AFHoverTarget xq" id="kmPgTpl:sd_r1:0:dv_rDoc:0:ol22" style="color: black; font-size: 130%; font-weight: bold;"><label>ASM tools used by Support : KFOD, KFED, AMDU</label></span><br />
<span class="p_AFHoverTarget xq" style="color: black; font-size: 130%; font-weight: bold;"><label> (Doc ID 1485597.1)</label></span><br />
<span class="p_AFHoverTarget xq" style="color: black;"><label><br /></label></span><br />
<span class="p_AFHoverTarget xq" style="color: black;"><label>So let's take a look at each one in terms of how and why you would use these ASM diagnostic tools.</label></span><br />
<span class="p_AFHoverTarget xq" style="color: black;"><label><br /></label></span><br />
<span class="p_AFHoverTarget xq" style="color: black;"><label><strong>kfod</strong></label></span><br />
<br /><br />
Kfod is a quick and dirty tool to examine the current ASM configuration for ownership, sizes and device mappings. Ensure that your kfod is in the local path for $GRID_HOME/bin/kfod to allow execution of the tool.<br />
<span style="font-size: xx-small;"><br /></span><br />
<span class="p_AFHoverTarget xq" style="color: black;"><label><span style="font-size: xx-small;">$ which kfod<br />/u01/app/grid/12.1.0/grid/bin/kfod</span></label></span><br />
<span style="font-size: xx-small;"><br /></span><br />
To get help with kfod use the help=y option:<br />
<br /><br />
<span class="p_AFHoverTarget xq" style="color: black;"><label><span style="font-size: xx-small;">$ kfod help=y<br />_asm_a/llow_only_raw_disks KFOD allow only raw devices [_asm_allow_only_raw_disks=(TRUE)/FALSE]<br />_asm_l/ibraries ASM Libraries[_asm_libraries=lib1,lib2,...]<br />_asms/id ASM Instance[_asmsid=sid]<br />_b/oot Running in pre-install env (boot=TRUE/FALSE)<br />_f/lexinfo Provide flexinfo (_flexinfo=TRUE/FALSE)<br />_p/atch_lib Patchlib [_patch_lib=<asmclntsh_path>]<br />_u/ser OS Username<br />asm_/diskstring ASM Diskstring [asm_diskstring=discoverystring, discoverystring ...]<br />asmc/ompatibility Include diskgroup ASM compatibility [asmcompatibility=TRUE/(FALSE)]<br />cli/ent_cluster client cluster name<br />clus_/version cluster version<br />clust/er KFOD cluster [cluster=TRUE/(FALSE)]<br />db_/unique_name db_unique_name for ASM instance[db_unique_name=dbname]<br />dbc/ompatibility Include diskgroup DB compatibility [dbcompatibility=TRUE/(FALSE)]<br />disk_/access Disk access method [disk_access=DIRECT/(INDIRECT)]<br />disks Disks to discover [disks=raw,asm,badsize,all]<br />ds/cvgroup Include group name [dscvgroup=TRUE/(FALSE)]<br />f/orce Force option to delete files (force=TRUE/FALSE)<br />g/roup Disks in diskgroup [group=diskgroup]<br />h/ostlist hostlist[hostlist=host1,host2,...]<br />metadata_a/usize AU Size for Metadata Size Calculation<br />metadata_c/lients Client Count for Metadata Size Calculation<br />metadata_d/isks Disk Count for Metadata Size Calculation<br />metadata_n/odes Node Count for Metadata Size Calculation<br />metadata_r/edundancy Redundancy for Metadata Size Calculation<br />na/me Include disk name [name=TRUE/(FALSE)]<br />no/hdr KFOD header suppression [nohdr=TRUE/(FALSE)]<br />ol/r Import credentials to OLR [olr=TRUE/(FALSE)]<br />op KFOD options type [OP=DISKS/CANDIDATES/MISSING/GROUPS/INSTS/VERSION/PATCHES/PATCHLVL/CLIENTS/RM/RMVERS/DFLTDSTR/GPNPDSTR/METADATA/CREDCRECLUS/GETCLSTYPE/CREDEXPORT/GETASMGUID/CREDDELCLUS/CREDVERIFY/UPGRADEVERIFY/ALL]<br />p/file ASM parameter file [pfile=parameterfile]<br />r/im_disk_access Rim disk access method [rim_disk_access=DIRECT/(INDIRECT)]<br />s/tatus Include disk header status [status=TRUE/(FALSE)]<br />v/erbose KFOD verbose errors [verbose=TRUE/(FALSE)]<br />w/rap wrap file for credentials<br />KFOD-01000: USAGE: kfod op=<op> asm_diskstring=... | pfile=...</op></asmclntsh_path></span></label></span><br />
<span class="p_AFHoverTarget xq" style="color: black;"><label><br /></label></span><br />
<span class="p_AFHoverTarget xq" style="color: black;"><label><span style="font-size: xx-small;"><strong>kfod status=TRUE asm_diskstring='<your_path_to_asm_devices>' disk=ALL</your_path_to_asm_devices></strong></span></label></span><br />
<span class="p_AFHoverTarget xq" style="color: black;"><label><br /></label></span><br />
<span class="p_AFHoverTarget xq" style="color: black;"><label><span style="font-family: Arial, Helvetica, sans-serif; font-size: xx-small;">$ kfod verbose=true, disks=all status=true op=disks \<br />> asm_diskstring='/dev/oracleasm/disks/*'<br />WARNING: Using brute force method to determine the size of /dev/oracleasm/disks/sddlmfdrv0.<br /> There will be performance issues. Please check configuration to determine the cause for the failure of ioctl<br />--------------------------------------------------------------------------------<br /> Disk Size Header Path User Group<br />================================================================================<br /> 1: 409600 Mb MEMBER /dev/oracleasm/disks/sddlma grid oinstall<br /> 2: 409600 Mb MEMBER /dev/oracleasm/disks/sddlmb grid oinstall<br /> 3: 409600 Mb MEMBER /dev/oracleasm/disks/sddlmc grid oinstall<br /> 4: 409600 Mb MEMBER /dev/oracleasm/disks/sddlmd grid oinstall<br /> 5: 409600 Mb MEMBER /dev/oracleasm/disks/sddlme grid oinstall<br /> 6: 409600 Mb MEMBER /dev/oracleasm/disks/sddlmf grid oinstall<br /> 7: 409600 Mb MEMBER /dev/oracleasm/disks/sddlmg grid oinstall</span></label></span><br />
<span class="p_AFHoverTarget xq" style="color: black;"><label><br /></label></span><br />
<span class="p_AFHoverTarget xq" style="color: black;"><label><br /></label></span><br />
<span class="p_AFHoverTarget xq" style="color: black;"><label><strong>kfed</strong></label></span><br />
<span class="p_AFHoverTarget xq" style="color: black;"><label><br /></label></span><br />
<span class="p_AFHoverTarget xq" style="color: black;"><label>Kfed differs from the other tools in that it shows lower level metadata mappings for block size and endian counts for ASM disks and diskgroups. The help is provided by entering kfed with no options:</label></span><br />
<span class="p_AFHoverTarget xq" style="color: black;"><label><br /></label></span><br />
<span class="p_AFHoverTarget xq" style="color: black;"><label><span style="font-family: "Courier New", Courier, monospace; font-size: x-small;"><span style="font-size: xx-small;">$ kfed<br />as/mlib ASM Library [asmlib='lib']<br />aun/um AU number to examine or update [AUNUM=number]<br />aus/z Allocation Unit size in bytes [AUSZ=number]<br />blkn/um Block number to examine or update [BLKNUM=number]<br />blks/z Metadata block size in bytes [BLKSZ=number]<br />ch/ksum Update checksum before each write [CHKSUM=YES/NO]<br />cn/t Count of AUs to process [CNT=number]<br />de/v ASM device to examine or update [DEV=string]<br />dm/pall Don't suppress repeated lines when dumping corrupt blocks [DMPALL=YES/NO]<br />o/p KFED operation type [OP=READ/WRITE/MERGE/REPAIR/NEW/FORM/FIND/STRUCT]<br />p/rovnm Name for provisioning purposes [PROVNM=string]<br />s/eek AU number to seek to [SEEK=number]<br />te/xt File name for translated block text [TEXT=string]<br />ty/pe ASM metadata block type number [TYPE=number]<br />v/erb Verbose execution [verbose=YES|NO]</span></span></label></span><br />
<span class="p_AFHoverTarget xq" style="color: black;"><label><br /></label></span><br />
<span class="p_AFHoverTarget xq" style="color: black;"><label><br /></label></span><br />
<span class="p_AFHoverTarget xq" style="color: black;"><label>To run kfed, you need to specify the ASM disk mapping including the fully qualified device path as shown in the below example:</label></span><br />
<span class="p_AFHoverTarget xq" style="color: black;"><label><br /></label></span><br />
<span class="p_AFHoverTarget xq" style="color: black;"><label><span style="font-family: "Courier New", Courier, monospace; font-size: xx-small;">$ kfed read /dev/oracleasm/disks/sddlmbd<br />kfbh.endian: 1 ; 0x000: 0x01<br />kfbh.hard: 130 ; 0x001: 0x81<br />kfbh.type: 1 ; 0x002: KFBTYP_DISKHEAD<br />kfbh.datfmt: 1 ; 0x003: 0x01<br />kfbh.block.blk: 0 ; 0x004: blk=0<br />kfbh.block.obj: 2147483675 ; 0x008: disk=22<br />kfbh.check: 2341676564 ; 0x00c: 0x8b932613<br />kfbh.fcn.base: 0 ; 0x010: 0x00000000<br />kfbh.fcn.wrap: 0 ; 0x014: 0x00000000<br />kfbh.spare1: 0 ; 0x018: 0x00000000</span></label></span><br />
<br /><br />
<span class="p_AFHoverTarget xq" style="color: black;"><label><br /><br />
<br /></label></span><span class="p_AFHoverTarget xq" style="color: black;"><label><strong>amdu</strong></label></span><br />
<span class="p_AFHoverTarget xq" style="color: black;"><label><br /></label></span><br />
<span class="p_AFHoverTarget xq" style="color: black;"><label>Last but not least is probably one of my favorite ASM command line tools called amdu which provides a nicely formatted report for a specific ASM diskgroup that consolidates most of the information generated by kfod and kfed into a simple file called report.txt </label></span><br />
<span class="p_AFHoverTarget xq" style="color: black;"><label><br /></label></span><br />
<span class="p_AFHoverTarget xq" style="color: black;"><label>For the many options with amdu to get help make sure to specify the help=y parameter as shown below:</label></span><br />
<span class="p_AFHoverTarget xq" style="color: black;"><label><br /></label></span><br />
<span class="p_AFHoverTarget xq" style="color: black;"><label><span style="font-family: inherit; font-size: xx-small;">$ amdu help=y<br />al/lides Dump indirect blks unconditionally<br />-allides: AMDU ordinarily skips over empty indirect blocks. Specifying<br /> this option tells AMDU to dump those blocks unconditionally. Be<br /> warned that this can make the resulting AMDU dump quite large.</span></label></span><br />
<span class="p_AFHoverTarget xq" style="color: black;"><label><span style="font-family: inherit; font-size: xx-small;">au/size AU size for corrupt disks<br />-ausize <bytes>: This option must be set when -baddisks is set. It<br /> must be a power of 2. This size is required to scan a disk looking<br /> for metadata, and it is normally read from the disk header. The<br /> value applies to all disks that do not have a valid header. The<br /> value from the disk header will be used if a valid header is<br /> found.</bytes></span></label></span><br />
<span class="p_AFHoverTarget xq" style="color: black;"><label><span style="font-family: inherit; font-size: xx-small;">ba/ddisks Include disks with bad headers<br />-baddisks <diskgroup>: Normally disks with bad disk headers, or that<br /> look like they were never part of a disk group, will not be<br /> scanned. This option forces them to be scanned anyway and to be<br /> considered part of the given diskgroup. This is most useful when<br /> a disk header has been damaged. The disk will still need to have<br /> a valid allocation table to drive the scan unless -fullscan is<br /> used. In any case at least one block in the first two AUs must be<br /> valid so that the disk number can be determined. The options<br /> -ausize and -blksize are required since these values are normally<br /> fetched from the disk header. If the diskgroup uses external<br /> redundancy then -external should be specified. These values will<br /> be compared against any valid disks found in the diskgroup and<br /> they must be the same.</diskgroup></span></label></span><br />
<span class="p_AFHoverTarget xq" style="color: black;"><label><span style="font-family: inherit; font-size: xx-small;">bl/ksize ASM block size for corrupt disks<br />-blksize <bytes>: This option must be set when -baddisks is set. It<br /> must be a power of 2. This size is required to scan a disk looking<br /> for metadata, and it is normally read from the disk header. The<br /> value applies to all disks that do not have a valid header. The<br /> value from the disk header will be used if a valid header is<br /> found.</bytes></span></label></span><br />
<span class="p_AFHoverTarget xq" style="color: black;"><label><span style="font-family: inherit; font-size: xx-small;">c/ompare Compare file mirrors<br />-compare: This option only applies to file extraction from a normal or<br /> high redundancy disk group. Every extent that is mirrored on more<br /> than one discovered disk will have all sides of its mirror<br /> compared. If they are not identical a message will be reported<br /> on standard error and the report file. The message will indicate<br /> which copy was extracted. A count of the blocks that are not<br /> identical will be in the report file.</span></label></span><br />
<span class="p_AFHoverTarget xq" style="color: black;"><label><span style="font-family: inherit; font-size: xx-small;">dir/ectory Directory from previous dump<br />-directory <string>: This option completely eliminates the discovery<br /> phase of operation. It specifies the name of a dump directory from<br /> a previous run of AMDU. The report file and map files are read<br /> instead of doing a discovery and scan. The parsing of these ASCII<br /> files is very dependent on them being exactly as written by AMDU.<br /> AMDU is unlikely to work properly if they have been modified by<br /> a text editor, or if some of the files are missing or truncated.<br /> Note that the directory may be a copy FTPed from another<br /> machine. The other machine may even be a different platform<br /> with a different endianess.</string></span></label></span><br />
<span class="p_AFHoverTarget xq" style="color: black;"><label><span style="font-family: inherit; font-size: xx-small;">dis/kstring Diskstring for discovery<br /> -diskstring <string>: By default the null string is used for<br /> discovery. The null string should discover all disks the user has<br /> access to. Many installations specify an asm_diskstring parameter<br /> for their ASM instance. If so that parameter value should be given<br /> here. Multiple discovery strings can be specified by multiple<br /> occurrences of -diskstring <string>. Beware of shell syntax<br /> conflicts with discovery strings. Diskstrings are usually the same<br /> syntax the shell uses for expanding path names on command lines so<br /> they will most likely need to be enclosed in single quotes.</string></string></span></label></span><br />
<span class="p_AFHoverTarget xq" style="color: black;"><label><span style="font-family: inherit; font-size: xx-small;">du/mp Diskgroups to dump<br />-dump <diskgroup>: This option specifies the name of a diskgroup to<br /> have its metadata dumped. This option may be specified multiple<br /> times to dump multiple diskgroups. If the diskgroup name is ALL<br /> then all diskgroups encountered will be dumped. The diskgroup name<br /> is not case sensitive, but will be converted to uppercase for all<br /> reports. If this option is not specified then no map or image<br /> files will be created, but -extract and -print may still work.</diskgroup></span></label></span><br />
<span class="p_AFHoverTarget xq" style="color: black;"><label><span style="font-family: inherit; font-size: xx-small;">exc/lude Disks to exclude<br />-exclude <string>: Multiple exclude options may be specified. These<br /> strings are used for discovery just like the values for diskstring.<br /> Only shallow discovery is done on these diskstrings. Any disks<br /> found in the exclude discovery will not be accessed. If they are<br /> also discovered using the -diskstring strings, then the report will<br /> include the information from shallow discovery along with a message<br /> indicating the disk was excluded.</string></span></label></span><br />
<span class="p_AFHoverTarget xq" style="color: black;"><label><span style="font-family: inherit; font-size: xx-small;">exte/rnal Assume external redundancy<br />-external: Normally AMDU determines the diskgroup redundancy from the<br /> disk headers. However this is not possible with the -baddisks<br /> option. It is assumed that the redundancy of the -baddisks<br /> diskgroup is normal or high unless this option is given to specify<br /> external redundancy.</span></label></span><br />
<span class="p_AFHoverTarget xq" style="color: black;"><label><span style="font-family: inherit; font-size: xx-small;">extr/act Files to extract<br />-extract <diskgroup>.<file_number>: This extracts the numbered file<br /> from the named diskgroup, case insensitive. This option may be<br /> specified multiple times to extract multiple files. The extracted<br /> file is placed in the dump directory under the name<br /> <diskgroup>_<number>.f where <diskgroup> is the diskgroup name<br /> in uppercase, and <number> is the file number. The -output option<br /> may be used to write the file to any location. The extracted file<br /> will appear to have the same contents it would have if accessed<br /> through the database. If some portion of the file is unavailable<br /> then that portion of the output file will be filled with<br /> 0xBADFDA7A, and a message will appear on stderr.</number></diskgroup></number></diskgroup></file_number></diskgroup></span></label></span><br />
<span class="p_AFHoverTarget xq" style="color: black;"><label><span style="font-family: inherit; font-size: xx-small;">fi/ledump Dump files rather than extract<br />-filedump: This option causes the file objects in the command line to<br /> have their blocks dumped to the image files rather than extracted.<br /> This can be combined with the -novirtual option to selectively<br /> dump only some of the metadata files. It may also be used to dump<br /> user files (number >= 256) so that all mirrored copies can be<br /> examined.</span></label></span><br />
<span class="p_AFHoverTarget xq" style="color: black;"><label><span style="font-family: inherit; font-size: xx-small;">fo/rmer Include dropped disks<br />-former: Normally disks marked as former are not scanned, but this<br /> option will scan them and include their contents in the output.<br /> This is useful when it is necessary to look at the contents of a<br /> disk that was dropped. Note that dropped normal disks will not have<br /> any entries in their allocation tables and thus only the physically<br /> addressed extents will be dumped. Force dropped disks will not have<br /> status former in their disk headers and are not affected by this<br /> option. However if DROP DISKGROUP is used, the disks will have the<br /> contents as of the time of the drop, and will be in status former.<br /> Thus this option is useful for extracting files from a dropped<br /> diskgroup.</span></label></span><br />
<span class="p_AFHoverTarget xq" style="color: black;"><label><span style="font-family: inherit; font-size: xx-small;">fu/llscan Scan entire disk<br />-fullscan: This option reads every AU on the disk and looks at the<br /> contents of the AU rather than limiting the AU's read based on the<br /> allocation table. This is useful when the allocation table is<br /> corrupt or needs recovery. An AU will be written to the image file<br /> if it starts with a block that contains a valid ASM block header.<br /> The file and extent information for the map will be extracted from<br /> the block header. Physically addressed metadata will be dumped<br /> regardless of its contents. This option is incompatible with<br /> extracting a file. It is an error to specify -extract with this<br /> option. Note that this option is likely to find old garbage<br /> metadata in unallocated AU's since there is no means of<br /> determining what is allocated. Thus there may be many different<br /> copies of the same block, possibly of different versions.</span></label></span><br />
<span class="p_AFHoverTarget xq" style="color: black;"><label><span style="font-family: inherit; font-size: xx-small;">h/ex Always print block contents in hex<br />-hex: This prints the block contents in hex without attempting to print<br /> them as ASM metadata. This is useful when the block is known to not<br /> be ASM metadata. It avoids the ASM block header dump and ensures<br /> the block is not accidentally interpreted as ASM metadata. This<br /> option requires at least one -print option.</span></label></span><br />
<span class="p_AFHoverTarget xq" style="color: black;"><label><span style="font-family: inherit; font-size: xx-small;">noa/cd Do not dump ACD<br />-noacd: This option limits the dumping of the Active Change Directory<br /> to just the control blocks that contain the checkpoint. There is<br /> 126 MB of ACD per ASM instance (42 MB for external redundancy). It<br /> is normally of no interest if there has been a clean shutdown or<br /> no updates for a while. This option avoids dumping a lot of<br /> unimportant data. The blocks will still be read and checked for<br /> corruption. The map file will still contain entries for the ACD<br /> extents, but the block counts will be zero.</span></label></span><br />
<span class="p_AFHoverTarget xq" style="color: black;"><label><span style="font-family: inherit; font-size: xx-small;">nod/ir Do not create a dump directory<br />-nodir: No dump directory is created, and no files are created in it.<br /> The directory name is not written to standard out. The report file<br /> is written to standard out before any block printouts from any<br /> -print options. This option conflicts with -filedump. It is an<br /> error to specify this and extract a file to the dump directory.</span></label></span><br />
<span class="p_AFHoverTarget xq" style="color: black;"><label><span style="font-family: inherit; font-size: xx-small;">noe/xtract Do not create extracted file<br />-noextract: This prevents files from being extracted to an output<br /> file, but the file will be read and any errors in selecting the<br /> correct output will be reported. This is most useful in<br /> combination with the -compare option.</span></label></span><br />
<span class="p_AFHoverTarget xq" style="color: black;"><label><span style="font-family: inherit; font-size: xx-small;">noh/eart Do not check for heartbeat<br />-noheart: Normally the heartbeat block will be saved at discovery time<br /> and checked when the disk is scanned. A sleep is added between<br /> discovery and scanning to ensure there is time for the heartbeat<br /> to be written. If the heartbeat block changes then it is most<br /> likely that the diskgroup containing this disk is mounted by an<br /> active ASM instance. An error and warning is generated but<br /> operation proceeds normally. This option suppresses this check<br /> and avoids the sleep.</span></label></span><br />
<span class="p_AFHoverTarget xq" style="color: black;"><label><span style="font-family: inherit; font-size: xx-small;">noi/mage Do not create image files<br />-noimage: No image files will be created n the dump directory. All<br /> the reads specified by the read options will still be done. The<br /> map files may be used to find blocks on the disks themselves. In<br /> the map file, the count of blocks dumped, the image file sequence<br /> number, and the byte offset in the image file will all always be<br /> zero (C00000 S0000 B0000000000)</span></label></span><br />
<span class="p_AFHoverTarget xq" style="color: black;"><label><span style="font-family: inherit; font-size: xx-small;">nom/ap Do not create map or image files<br />-nomap: No map file is created and no image file is created. The only<br /> output is the report file. The -noimage option is assumed if this<br /> is set since an image file without a map is useless. The options<br /> -noscan and -noread also result in no map or image files, but<br /> -nomap still reads the metadata to check for I/O errors and corrupt<br /> blocks.</span></label></span><br />
<span class="p_AFHoverTarget xq" style="color: black;"><label><span style="font-family: inherit; font-size: xx-small;">nop/rint Do no print block contents<br />-noprint: This suppresses the printout of the block contents for<br /> blocks printed with the -print option. It is useful for getting<br /> just the block reports without a lot of data. This option requires<br /> at least one -print option.</span></label></span><br />
<span class="p_AFHoverTarget xq" style="color: black;"><label><span style="font-family: inherit; font-size: xx-small;">norea/d Shallow discovery only<br />-noread: This eliminates any reading of any disks at all. Only shallow<br /> discovery will be done. The report will end after the discovery<br /> section. It is an error to specify this option and specify a file<br /> to extract or blocks to print. It is an error to specify this<br /> and -fullscan.</span></label></span><br />
<span class="p_AFHoverTarget xq" style="color: black;"><label><span style="font-family: inherit; font-size: xx-small;">norep/ort Do not generate a report<br />-noreport: This suppresses the generation of the report file. It is<br /> most useful in combination with -nodir and -print to get block<br /> printouts without a lot of clutter. It is unnecessary to include<br /> this with -directory since no report is generated then anyway.</span></label></span><br />
<span class="p_AFHoverTarget xq" style="color: black;"><label><span style="font-family: inherit; font-size: xx-small;">nosc/an Deep discovery only<br />-noscan: This eliminates any reading of any disks after deep<br /> discovery. This results in just doing a deep discovery using the<br /> disksting parameter. The report will end after the discovery<br /> section. It is an error to specify this option and specify a file<br /> to extract. It is an error to specify this and -fullscan.</span></label></span><br />
<span class="p_AFHoverTarget xq" style="color: black;"><label><span style="font-family: inherit; font-size: xx-small;">nosu/bdir Do not create a dump directory<br />-nosubdir: No dump directory is created, but files are still created.<br /> The directory name is not written to standard out. The report file<br /> and any other dump or extract files are written to the current<br /> directory or to the directory indicated by -parentdir. This means<br /> that if multiple AMDU dumps are requested using this option, the<br /> report file will always correspond to the last dump requested.</span></label></span><br />
<span class="p_AFHoverTarget xq" style="color: black;"><label><span style="font-family: inherit; font-size: xx-small;">nov/irtual Do not dump virtual metadata<br />-novirtual: This option eliminates reading of any virtual metadata.<br /> Only the physically addressed metadata will be read. This<br /> implicitly eliminates the ACD and extent maps so -noacd and<br /> -noxmap will be assumed.</span></label></span><br />
<span class="p_AFHoverTarget xq" style="color: black;"><label><span style="font-family: inherit; font-size: xx-small;">nox/map Do not dump extent maps<br />-noxmap: This option eliminates reading of the indirect extents<br /> containing the file extent maps. This is the bulk of the metadata<br /> in most diskgroups. Even the entries in the map file will be<br /> eliminated.</span></label></span><br />
<span class="p_AFHoverTarget xq" style="color: black;"><label><span style="font-family: inherit; font-size: xx-small;">o/utput Files to create for extract<br />-output <file_name>: This option specifies a different file for<br /> writing an extracted file. The file will be overwritten if it<br /> already exists. This option requires that exactly one file is<br /> extracted via the -extract option. Required with -directory</file_name></span></label></span><br />
<span class="p_AFHoverTarget xq" style="color: black;"><label><span style="font-family: inherit; font-size: xx-small;">pa/rent Parent for dump directory<br />-parent <path_name>: By default the dump directory is created in the<br /> current directory, but another directory can be specified using<br /> this option. The parent directory for the dump directory must<br /> already exist.</path_name></span></label></span><br />
<span class="p_AFHoverTarget xq" style="color: black;"><label><span style="font-family: inherit; font-size: xx-small;">pr/int Block to print<br />-print <block_spec>: This option prints one or more blocks to standard<br /> out. This option may be specified multiple times to print multiple<br /> <block_spec>s. The printout contains information about how each<br /> block was read as well as a formatted printout. Multiple blocks<br /> matching the same <block_spec> may be found when scanning the<br /> disks. For example there may be multiple disks that have headers<br /> for the same diskgroup and disk number. If the block is from a<br /> mirrored file then multiple copies should exist on different disks.<br /> If multiple copies of the same block have identical contents then<br /> only one formatted printout of the contents will be generated, but<br /> a header will be printed for each copy. A <block_spec> may include<br /> a count of sequential blocks to print. A <block_spec> may specify<br /> a block either by disk or file.<br /> <block_spec> ::= <single_block> | <single_block>.C<count><br /> <single_block> ::= <report_disk_block> | <group_disk_block> |<br /> <extent_file_block> | <virtual_file_block> | <xmap_file_block><br /> <report_disk_block> ::=<br /> <group_name>.N<report_number>.A<au_number>.B<block_number><br /> <group_disk_block> ::=<br /> <group_name>.D<disk_number>.A<au_number>.B<block_number><br /> <extent_file_block> ::=<br /> <group_name>.F<file_number>.X<physical_extent>.B<block_number><br /> <virtual_file_block> ::=<br /> <group_name>.F<file_number>.V<virtual_block_number><br /> <xmap_file_block> ::=<br /> <group_name>.F<file_number>.M<extent_map_block_number></extent_map_block_number></file_number></group_name></xmap_file_block></virtual_block_number></file_number></group_name></virtual_file_block></block_number></physical_extent></file_number></group_name></extent_file_block></block_number></au_number></disk_number></group_name></group_disk_block></block_number></au_number></report_number></group_name></report_disk_block></xmap_file_block></virtual_file_block></extent_file_block></group_disk_block></report_disk_block></single_block></count></single_block></single_block></block_spec></block_spec></block_spec></block_spec></block_spec></block_spec></span></label></span><br />
<span class="p_AFHoverTarget xq" style="color: black;"><label><span style="font-family: inherit; font-size: xx-small;">r/egistry Dump registry files<br />-registry: The ASM registries will be read and dumped to the image<br /> file. There will be no block consistency checks since these files<br /> do not have ASM cache headers. To dump one specific registry<br /> specify -filedump and include the file object for the registry<br /> (e.g. DATA.255).</span></label></span><br />
<span class="p_AFHoverTarget xq" style="color: black;"><label><span style="font-family: inherit; font-size: xx-small;">s/pfile Extract usable spfile<br />-spfile: This causes extract to render the resulting file in a form<br /> that is directly usable by startup. Without this option, AMDU<br /> will extract the file as a regular ASM file including all ASM<br /> specific headers and such</span></label></span><br />
<span class="p_AFHoverTarget xq" style="color: black;"><label><span style="font-family: inherit; font-size: xx-small;"><br /></span></label></span><br />
<span class="p_AFHoverTarget xq" style="color: black;"><label><span style="font-family: inherit;"><strong>Now let's take a look at the overall syntax for using AMDU is below:</strong></span></label></span><br />
<span class="p_AFHoverTarget xq" style="color: black;"><label><span style="font-family: inherit; font-size: xx-small;">.</span></label></span><br />
<span class="p_AFHoverTarget xq" style="color: black;"><label><span style="font-family: "Courier New", Courier, monospace; font-size: xx-small;"><strong>amdu -diskstring '<your_path_to_asm_disks -dump="" diskgroup="" nbsp="">'</your_path_to_asm_disks></strong></span></label></span><br />
<span class="p_AFHoverTarget xq" style="color: black;"><label><span style="font-size: xx-small;"> </span></label></span><br />
<span class="p_AFHoverTarget xq" style="color: black;"><label><span style="font-size: xx-small;">AMDU creates a new subdirectory with the prefix amdu_ plus date and time as naming convention after execution that houses the reports for ASM metadata.</span></label></span><br />
<span class="p_AFHoverTarget xq" style="color: black;"><label><span style="font-size: xx-small;"><br /></span></label></span><br />
<span class="p_AFHoverTarget xq" style="color: black;"><label><span style="font-family: "Courier New", Courier, monospace; font-size: xx-small;">$ amdu -diskstring '/dev/oracleasm/disks/*' -dump DG_DATA</span></label></span><br />
<span class="p_AFHoverTarget xq" style="color: black;"><label><span style="font-size: xx-small;"><br /></span></label></span><br />
<span class="p_AFHoverTarget xq" style="color: black;"><label><span style="font-size: xx-small;">amdu_2015_07_16_16_27_02/<br />WARNING: Using brute force method to determine the size of /dev/oracleasm/disks/sddlmfdrv0.<br /> There will be performance issues. Please check configuration to determine the cause for the failure of ioctl</span></label></span><br />
<span class="p_AFHoverTarget xq" style="color: black;"><label><span style="font-size: xx-small;">The report.txt file contains the details on the ASM disk metadata for review.</span></label></span><br />
<span class="p_AFHoverTarget xq" style="color: black;"><label><span style="font-size: xx-small;"><br /></span></label></span><br />
<span class="p_AFHoverTarget xq" style="color: black;"><label><span style="font-size: xx-small;">******************************* AMDU Settings ********************************<br />ORACLE_HOME = /u01/app/grid/12.1.0/grid<br />System name: Linux<br />Node name: ora-ben01<br />Release: 2.6.32-504.el6.x86_64<br />Version: #1 SMP Tue Sep 16 01:56:35 EDT 2014<br />Machine: x86_64<br />amdu run: 19-JUL-15 16:27:02<br />Endianess: 1</span></label></span><br />
<span class="p_AFHoverTarget xq" style="color: black;"><label><span style="font-size: xx-small;">--------------------------------- Operations ---------------------------------<br /> -dump DG_DATA</span></label></span><br />
<span class="p_AFHoverTarget xq" style="color: black;"><label><span style="font-size: xx-small;">------------------------------- Disk Selection -------------------------------<br /> -diskstring '/dev/oracleasm/disks/*'</span></label></span><br />
<span class="p_AFHoverTarget xq" style="color: black;"><label><span style="font-size: xx-small;">------------------------------ Reading Control -------------------------------</span></label></span><br />
<span class="p_AFHoverTarget xq" style="color: black;"><label><span style="font-size: xx-small;">------------------------------- Output Control -------------------------------</span></label></span><br />
<span class="p_AFHoverTarget xq" style="color: black;"><label><span style="font-size: xx-small;"><br /></span></label></span><br />
<span class="p_AFHoverTarget xq" style="color: black;"><label><span style="font-size: xx-small;">********************************* DISCOVERY **********************************</span></label></span><br />
<span class="p_AFHoverTarget xq" style="color: black;"><label><span style="font-size: xx-small;">----------------------------- DISK REPORT N0001 ------------------------------<br /> Disk Path: /dev/oracleasm/disks/sddlmk<br /> Unique Disk ID:<br /> Disk Label:<br /> Physical Sector Size: 512 bytes<br /> Disk Size: 409600 megabytes<br /> Group Name: DG_DATA<br /> Disk Name: DG_DATA_0000<br /> Failure Group Name: DG_DATA_0000<br /> Disk Number: 0<br /> Header Status: 3<br /> Disk Creation Time: 2015/07/16 19:55:33.792000<br /> Last Mount Time: 2015/07/18 10:24:19.387000<br /> Compatibility Version: 0x0c100000(12010000)<br /> Disk Sector Size: 512 bytes</span></label></span><br />
<span class="p_AFHoverTarget xq" style="color: black;"><label><br /></label></span><br />
<span class="p_AFHoverTarget xq" style="color: black;"><label>So when you are faced with a challenging ASM issue or for general verification after a complex large scale Oracle RAC and ASM build, be sure to take advantage of these excellent ASM tools!</label></span><br />
<span class="p_AFHoverTarget xq" style="color: black;"><label><br /></label></span><br />
<span class="p_AFHoverTarget xq" style="color: black; font-weight: bold;"><label><br /></label></span><br />
<span class="p_AFHoverTarget xq" style="color: black; font-weight: bold;"><label><br /></label></span><br />
<span class="p_AFHoverTarget xq" style="color: black; font-weight: bold;"><label><br /></label></span><br />
<span class="p_AFHoverTarget xq" style="color: black; font-weight: bold;"><label><br /></label></span><br />
<span class="p_AFHoverTarget xq" style="color: black; font-weight: bold;"><label><br /></label></span><br />
<span class="p_AFHoverTarget xq" style="color: black; font-weight: bold;"><label><br /></label></span><br />
<span class="p_AFHoverTarget xq" style="color: black; font-weight: bold;"><label><br /></label></span><br />
<span class="p_AFHoverTarget xq" style="color: black; font-weight: bold;"><label><br /></label></span><br />
<span class="p_AFHoverTarget xq" style="color: black; font-weight: bold;"><label><br /></label></span><br />
<span class="p_AFHoverTarget xq" style="color: black; font-weight: bold;"><label><br /></label></span><br />
<span class="p_AFHoverTarget xq" style="color: black; font-weight: bold;"><label><br /></label></span>Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-8142453738187547635.post-91918793275778153332015-11-05T20:18:00.000-08:002015-11-05T20:20:03.983-08:00Oracle ASM Disks and multi path issue- Solution So today I needed to create some new ASM disks on Hitachi enterprise storage with HDLM Hitachi Dynamic Link Manager multipathing setup with Oracle Linux 6.6 environment on a two node Oracle 12c RAC cluster. Unfortunately when I tried to create new ASM disks using the ASMLib and the Oracle ASM create disk command it failed to create the disks! I thought this to be odd because I had used the fdisk command on Linux to add a new partition on each of the LUNs presented to the OS for ASM. Permissions were correct and fdisk showed that the partitions were created for the newly provisioned LUNs to Linux.<br />
<br />
I found a blog post that mentions a similar issue and MOS note that references the issue and workaround solution:<br />
<br />
<span style="background-color: white; font-family: "tahoma" , "verdana" , "helvetica" , sans-serif; font-size: 14px; font-weight: bold; text-align: right;">ASMLib: oracleasm createdisk command fails: Device '/dev/emcpowera1 is not a partition [Failed] (Doc ID 469163.1)</span><br />
<br />
Now while this references EMC storage, the same issue and solution applies to other multipathing software and storage arrays such as Hitachi storage with HDLM in my case.<br />
<br />
Instead of using the 'oracleasm createdisk' command I had to use an internal tool called asmtool that usually is called behind the scenes by Oracle tools.<br />
<br />
<span style="background-color: #e0eaf1; font-family: "courier new" , "courier" , monospace; font-size: 12px;"># /usr/sbin/asmtool -C -l /dev/oracleasm -n VOL1 -s /dev/emcpowera1 -a force=yes</span><br />
<div style="text-align: right;">
<br /></div>
<div style="text-align: right;">
This saved me hours of frustration this week when I had to build new ASM disks and do a migration for a customer solution in a very short time period. Hopefully it will also save you hours of grief .</div>
<div style="text-align: right;">
<br /></div>
<div style="text-align: left;">
<br /></div>
<div style="text-align: left;">
Getting used to Hitachi storage is a bit new for me but since I have years of EMC storage administration experience it is not too steep a learning curve and quite a bit of fun learning new things!</div>
<div style="text-align: right;">
<br /></div>
<span style="background-color: white; font-family: "tahoma" , "verdana" , "helvetica" , sans-serif; font-size: 14px; font-weight: bold; text-align: right;"><br /></span>Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-8142453738187547635.post-63424423370932959912015-10-24T21:24:00.000-07:002015-10-24T21:24:46.394-07:00On Solving the Right ProblemDear Readers,<br />
<br /><br />
It has been quite a while since I wrote on the blog due to some past things that occupied my personal time that had to be addressed. Recently I began to solve new performance related problems for a customer. Here is the scenario:<br />
<br /><br />
Oracle 12c RAC<br />
Large enterprise SAN<br />
Converged infrastructure<br />
<br /><br />
The target goal is to achieve a minimal performance level (SLA) for storage and system performance. <br />
<br /><br />
The customer is only receiving a low number of storage performance in terms for overall IOPS with their two node Oracle 12c RAC configuration. <br />
<br /><br />
So with little information to go by from past experiences, I asked how they measure such performance values.<br />
<br /><br />
Enter the Benchmark Tools!<br />
<br /><br />
The customer is using a third party performance tool to measure performance for CPU, system and storage figures. So what is this tool you might ask? Well hold on for a minute we will get to that question in a short while. My first DBA spidey sense was to get the data from the horse's mouth so to speak that is from Oracle! I logged into the Oracle 12c RAC cluster and pulled the recent AWR reports from the cluster and noticed that overall there were no serious performance issues!<br />
<br /><br />
It turns out that the performance tool is reporting different numbers than the Oracle database!<br />
<br /><br />
Hmm well that sure is very odd! I review the infrastructure between customer sites and lo and behold find that configurations are different! So that calls to mind that Oracle per se is not guilty but a more fundamental issue of apples to oranges comparisons. Which leads to my next thought process<br />
<br /><br />
FIND AND SOLVE THE RIGHT PROBLEM<br />
<br /><br />
ASK THE RIGHT QUESTION<br />
<br /><br />
I know this seems obvious to most of us Oracle DBA types right? Well you'd be surprised at how many customers spin their wheels attempting to solve a performance issue by mistaking the forest for the weeds. Instead of immediate jumping to conclusions, take a deep breath and step back to look at the big picture. The following comes to mind:<br />
<br /><br />
Examine<br />
1. Storage configuration- disks, HBA, HBA, multi path configurations<br />
2. Firmware and patch levels for infrastructure- servers, SAN, networks<br />
3. Review OS configurations and releases<br />
4. Run basic tests to collect data points- Oracle AWR, sar, vmstat, et al.<br />
<br /><br />
<br /><br />
Stay tuned on my next series of blog posts on how to exactly solve these types of problems. Oh yeah and get ready, set and go for Oracle Open World this coming week!!<br />
<br /><br />
Cheers,<br />
-B<br />
<br /><br />
<br />Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-8142453738187547635.post-56684442648705656732014-10-04T17:40:00.002-07:002014-10-04T17:40:16.632-07:00Oracle OpenWorld 2014 Dear Readers,<br />
<br />
This year's Oracle Open World 2014 was a lot of learning and meeting old and new friends.<br />
What a fun and great conference!<br />
<br />
The big highlights for me were:<br />
<br />
Oracle 12c In Memory Database- in sight and everywhere this was a key mantra at the event.<br />
<br />
Big Data SQL- another new thing that intrigues me is using SQL to manage Big Data applications with Hadoop, NoSQL and other applications.<br />
<br />
Engineered systems- Oracle demo grounds featured Exadata, Exalogic, Big Data Appliance (BDA), etc front and center.<br />
<br />
Last but not least, Oracle Public Cloud was a centerpiece in the keynotes and sessions. Oracle is now a serious contender to not only IBM, HP, Cisco, and EMC but to Amazon Web Services (AWS) with public cloud offerings.<br />
<br />
Last year, Oracle introduced hands on labs (HOL) to allow participants to learn first hand new technologies aside from the standard product marketing and general conference sessions.<br />
<br />
This year the hands on labs (HOL) were greatly expanded and I spent the majority of my time attending a dozen or so of these excellent sessions for learning first hand how to work with Oracle Public Cloud, virtualization, big data and NoSQL.<br />
<br />
Prior to OOW, I attended the 2 day Oracle ACE Director summit and had a great experience learning first hand from Oracle's Thomas Kurian, EVP of Product Development as well as many product and engineering folks from Oracle.<br />
<br />
Last but certainly not least, I presented at the Delphix booth on performing Oracle E-Business Suite Upgrades with Delphix and had a great attendance. Next month I am presenting at the BGOUG conference in Sofia, Bulgaria which will be an exciting event.Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-8142453738187547635.post-36307502275247012592014-09-24T16:39:00.001-07:002014-09-24T16:39:56.013-07:00OOW 2014 eventsDear readers,<br />
<br />
This year promises to be an exciting Oracle OpenWorld.<br />
<br />
I will be presenting in the Delphix booth on using Delphix to perform upgrades with Oracle E-Business Suite. Hope to see you all there and we also will have a Clone Attack with demo software available to learn about Delphix. In addition, DBVisit will be presenting REPAttack to show demos how to replicate seamless Oracle environments with the DBVisit software.<br />
<br />
I am headed to the Oracle ACE Director briefing so stay tuned and hope to see everyone there.Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-8142453738187547635.post-58782047676197389182014-09-10T10:05:00.001-07:002014-09-10T10:07:34.252-07:00Oracle 12c RAC and Flex ASM Overview<div>
<br /></div>
Dear Readers,<br />
<br />
In preparation for upcoming Oracle Open World 2014 and BGOUG 2014 (Bulgarian User Oracle Group) conferences, I will write a series of tips and tricks for new Oracle 12c RAC and ASM features. Today I would like to review the new Oracle 12c RAC Flexible ASM feature. For our discussion as a reference point you can source details in the useful My Oracle Support (http://support.oracle.com) note <b style="background-color: white; font-family: Tahoma, Verdana, Helvetica, sans-serif; font-size: 14px; text-align: right;">FAQ: Oracle Flex ASM 12c / 12.1 (Doc ID 1573137.1)</b><br />
<br style="background-color: white; font-family: Tahoma, Verdana, Helvetica, sans-serif; font-size: 14px; text-align: right;" /><span style="background-color: white; font-family: Tahoma, Verdana, Helvetica, sans-serif; font-size: 14px; text-align: right;">Which contains a wealth of detailed information for the setup and configuration of an Oracle 12c Flex ASM environment. So, what is Oracle 12c Flex ASM you might be asking? Well it is a new method for managing clustered storage within Oracle 12c RAC environments. In the past releases of Oracle RAC and ASM prior to 12c, one had to build individual ASM instances on each cluster node for an Oracle RAC configuration. If any single node failed, the surviving RAC nodes would take control in a quorum event managed by Oracle cluster ware. However, there were some performance and availability issues with that architecture. To remediate the weak points of the Oracle RAC and ASM environment, Oracle development re-architected the model for ASM. By allowing shared control of ASM within a cluster via a single ASM instance, flex ASM was born. Oracle provides a good architecture diagram below for the design.</span><table border="0" cellpadding="0" cellspacing="0" id="kmPgTpl:sd_r1:0:dv_rDoc:0:tl5" style="background-color: white; color: #003d5b; font-family: Tahoma, Verdana, Helvetica, sans-serif; font-size: 11px; width: 100%px;" summary=""><tbody>
<tr id="kmPgTpl:sd_r1:0:dv_rDoc:0:rl12"><td id="kmPgTpl:sd_r1:0:dv_rDoc:0:cf40" width="10"><img alt="" height="10" id="kmPgTpl:sd_r1:0:dv_rDoc:0:s13" src="https://support.oracle.com/epmos/adf/images/t.gif" width="10" /></td><td align="left" id="kmPgTpl:sd_r1:0:dv_rDoc:0:cf49"><br /></td></tr>
</tbody></table>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjPvKKI4cfBJTnsjnoQ1gsg9DSFJlowYZNM4d7Hvzhs_Gjc7XvzvLZ3bzC0dQTVb32WxIt6U_Tfa8gh6VxWkI2yNMYoDVgChRMv9rKhoaLyVxL5_-3htcuPRx1ZyObENyAgIgHNJqYhNXc/s1600/flexasm2.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjPvKKI4cfBJTnsjnoQ1gsg9DSFJlowYZNM4d7Hvzhs_Gjc7XvzvLZ3bzC0dQTVb32WxIt6U_Tfa8gh6VxWkI2yNMYoDVgChRMv9rKhoaLyVxL5_-3htcuPRx1ZyObENyAgIgHNJqYhNXc/s1600/flexasm2.jpg" height="258" width="320" /></a></div>
<br />
<table border="0" cellpadding="0" cellspacing="0" id="kmPgTpl:sd_r1:0:dv_rDoc:0:tl5" style="background-color: white; color: #003d5b; font-family: Tahoma, Verdana, Helvetica, sans-serif; font-size: 11px; width: 100%px;" summary=""><tbody>
<tr id="kmPgTpl:sd_r1:0:dv_rDoc:0:rl12"><td id="kmPgTpl:sd_r1:0:dv_rDoc:0:cf40" width="10"><br /></td><td align="left" id="kmPgTpl:sd_r1:0:dv_rDoc:0:cf49"><span class="p_AFHoverTarget xq" id="kmPgTpl:sd_r1:0:dv_rDoc:0:ol22" style="color: black; font-size: 14px; padding: 0px 6px 0px 0px; text-align: right;"><label><br />Source: Oracle 12c ASM Documentation, Oracle Corporation 2014<br /><br />Users, applications and database clients can now connect from a single ASM instance in the cluster with makes for better availability and additional failover capabilities. Stay tuned for future Oracle 12c RAC and ASM installments.<br /><br /><br /></label></span></td></tr>
</tbody></table>
Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-8142453738187547635.post-14462822345406863052013-12-01T09:01:00.000-08:002013-12-01T09:01:07.867-08:00I am now a pilot!Dear readers,
<p>Last week, I passed my private pilot oral exam and flight test called a checkride and now have my private pilot license!
</p><p>
<p>The checkride was challenging and intense but I had a great experience and learned a lot about myself and from the awesome examiner in Santa Rosa.
</p><p>
Here is a picture of me after passing my checkride with my awesome instructor:
</p><p>
<div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjjB6dfw5muNo80JeG1KNGmMndUNG72K3RkXDVyiiSDSP64qztiA3ltZ2Gf7r0DcrynMSN8dXKP2u0L4IxEI_fqcQPqG5w60NcZN6c-9vnsCn_Kn5AJrs_9KKtZAqDZ-fzuDXGo4PFKKPA/s1600/ppcheckridepassed.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjjB6dfw5muNo80JeG1KNGmMndUNG72K3RkXDVyiiSDSP64qztiA3ltZ2Gf7r0DcrynMSN8dXKP2u0L4IxEI_fqcQPqG5w60NcZN6c-9vnsCn_Kn5AJrs_9KKtZAqDZ-fzuDXGo4PFKKPA/s320/ppcheckridepassed.jpg" /></a></div>
</p><p>
I was able to fly from Palo Alto to Sacramento and then on to Oroville to visit family and friends for this year's Thanksgiving dinner and to avoid the nasty holiday traffic on the freeway! As I soared to over 5000 feet, I could see the massive traffic on the ground and smiled that I was able to bypass this. Flying into Oroville was fun and a very nice large airport for a very small town of less than 50,000 people.
</p>Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-8142453738187547635.post-58442911271831848132013-11-22T21:55:00.001-08:002013-11-22T21:58:29.174-08:00Big Data Interview with OTN from Oracle Open World 2013<p><br>Below is my interview with the Oracle Technology Network on Big Data from this year's Oracle OpenWorld conference:
</p></br><a href="http://www.youtube.com/watch?v=-54lo2byPXo">Big Data Interview at Oracle Open World</a>Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-8142453738187547635.post-5708097856813903832013-10-11T14:37:00.001-07:002013-10-11T14:37:57.400-07:00OOW 2013 Review<br>Dear readers,
</br>
<br>This year was quite an exciting yet different OOW 2013 conference. Before the conference, I attended the Oracle ACE Director briefing with Oracle product management to learn the inside scoop before the show for new products. We then had a nice dinner thanks to the Oracle ACE program at the Walt Disney Museum.
</br>
<br>
<div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj0F2juXOmdNoLM9y9LTk1jY3UdY-_o_uo7p4QU1QJmMJBwxNrcEfoVkUJ1egnBPaJbYtXN4ptFWhF2-LmhGDfOe1VP1IMAgi8F4VQNCr6i3O4M8KvuxM81Rg2fGl37ETKwQn26VdXTB1U/s1600/oow1.jpg" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj0F2juXOmdNoLM9y9LTk1jY3UdY-_o_uo7p4QU1QJmMJBwxNrcEfoVkUJ1egnBPaJbYtXN4ptFWhF2-LmhGDfOe1VP1IMAgi8F4VQNCr6i3O4M8KvuxM81Rg2fGl37ETKwQn26VdXTB1U/s1600/oow1.jpg" /></a></div>
</br>
<br>
At the museum, I had the opportunity to view many cool things from Walt Disney's lifetime of achievement as the father of animation.
</br>
<br>
<div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjqq_3XQO7qWrP53Mv2yGy6gE8RkVDLUAIZGYRrB0aJQCNrh65Qcnre8nzHxmeDLWnNVcKJDNlzsbMgn3d_D7rFhWnCCV8bPGs88H1uY-ohl4af2uGjtkFgygA8B_coeUj_BTqU2lBaHBg/s1600/mickey.jpg" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjqq_3XQO7qWrP53Mv2yGy6gE8RkVDLUAIZGYRrB0aJQCNrh65Qcnre8nzHxmeDLWnNVcKJDNlzsbMgn3d_D7rFhWnCCV8bPGs88H1uY-ohl4af2uGjtkFgygA8B_coeUj_BTqU2lBaHBg/s1600/mickey.jpg" /></a></div>
</br>
<br>
At the start of the Oracle Openworld 2013 conference, the big announcements were that for the new 12c in memory database as well as the Oracle Public cloud.
</br>
<br>
<div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg2wCXfpN1NDu2bLsurJYpfUApF7tF1beAvJ8OwHlT8ExpiTKoN5p38ZtTekIKboC4CWX3EEL534QV5FVXIV_idiW575xSlMJyPICpeT_tVwD4LTvfto3uBA9_VRLrjrJhiJeDKFHMu7tQ/s1600/OOW2013.jpg" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg2wCXfpN1NDu2bLsurJYpfUApF7tF1beAvJ8OwHlT8ExpiTKoN5p38ZtTekIKboC4CWX3EEL534QV5FVXIV_idiW575xSlMJyPICpeT_tVwD4LTvfto3uBA9_VRLrjrJhiJeDKFHMu7tQ/s1600/OOW2013.jpg" /></a></div>
</br>
<br>
To me the in memory database functions of Oracle 12c are the most exciting and even the bus at SF had them too!
</br></br>
<br>
<div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi3SZNgnDA7dtcnVYCapQzflhWbq6xWaVxMq1Asdi8eSjuAAgtFor-pre4UaON0SVLKittNhfg4jD9-XK19OMQ_JCfvqOJBh99xp-itsE2UnalNAmagz5bEQCY-c1flkp41CQpt6MhB1ZM/s1600/12cbus.jpg" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi3SZNgnDA7dtcnVYCapQzflhWbq6xWaVxMq1Asdi8eSjuAAgtFor-pre4UaON0SVLKittNhfg4jD9-XK19OMQ_JCfvqOJBh99xp-itsE2UnalNAmagz5bEQCY-c1flkp41CQpt6MhB1ZM/s1600/12cbus.jpg" /></a></div>
</br>
Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-8142453738187547635.post-41940624909596775272013-08-05T15:15:00.000-07:002013-08-05T15:15:00.862-07:00Oracle 12c New Feature: How to backup pluggable databases<p><br>Oracle 12c introduced the new multi-tenant feature called Pluggable Databases (PDB). We will show how to take a backup of the pluggable database components in this post.
</p></br>
<b><p><br>Setup for RMAN with Oracle 12c</p></br></b>
<p><br>In order to use the Oracle 12c Recovery Manager (RMAN) utility for pluggable database backups, you need to first enable archivelog mode.</p></br>
<div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgv7VyqHeUER3YYIf4NHiqjoYuPdbkixIYkoa_xzWz63Cwk7urbyBgXl5Hol1VUE7V3Ayyg5Ne56dpwn70zRXsL8Y6wHgMMBodsPoMdEA_HaoOFW4RkpeU8NE2lsBByeIBXS7LKw_3yyQA/s1600/12c+archivelog.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgv7VyqHeUER3YYIf4NHiqjoYuPdbkixIYkoa_xzWz63Cwk7urbyBgXl5Hol1VUE7V3Ayyg5Ne56dpwn70zRXsL8Y6wHgMMBodsPoMdEA_HaoOFW4RkpeU8NE2lsBByeIBXS7LKw_3yyQA/s320/12c+archivelog.jpg" /></a></div>
<p><br> Once archivelog mode is enabled, we can take a backup of the pluggable database</p></br>
<p><br>
<div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgoaXeF69G75j5Rc-hEe-Qm9-pGShbibFG34iCG7sgm06P3ID0NDAQPFmzz5VobzuDJFgdt4gpVbgMsrMdVVg9xKvOctmTODNEQlBtTQ0pidVD3X5-xbQ0-aNOVAbbesPN-JmFvZCt3wq8/s1600/12c+backup+rman+pdb.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgoaXeF69G75j5Rc-hEe-Qm9-pGShbibFG34iCG7sgm06P3ID0NDAQPFmzz5VobzuDJFgdt4gpVbgMsrMdVVg9xKvOctmTODNEQlBtTQ0pidVD3X5-xbQ0-aNOVAbbesPN-JmFvZCt3wq8/s320/12c+backup+rman+pdb.jpg" /></a></div>
<br><p>Now we can verify that the backup image is available from RMAN for our pluggable database</br></p>
<p><br>
<div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEim4hgWOh0OaJaFolJE_s3Z0gKB0S4p_tqavU38YB3KR9Xrr-EzuRD-nbGpTk3twJKGJ1jjsI06L6l4kyh7m3eiROvilXy7IsyJvKWGRfTpXsS-fd18LtrgxMZqwsLvhaEtWhmFIFZAyJM/s1600/12c+rman+pdb+list+backup.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEim4hgWOh0OaJaFolJE_s3Z0gKB0S4p_tqavU38YB3KR9Xrr-EzuRD-nbGpTk3twJKGJ1jjsI06L6l4kyh7m3eiROvilXy7IsyJvKWGRfTpXsS-fd18LtrgxMZqwsLvhaEtWhmFIFZAyJM/s320/12c+rman+pdb+list+backup.jpg" /></a></div>
</p></br>
<p><br><b> Backup for root component of Oracle 12c Pluggable Databases</p></br></b>
<p><br>
In a nutshell, an Oracle 12c PDB consists of two parts: a root component and a seed component that includes the data. Earlier we performed a full database backup of the entire pluggable database but let us say that we just want to backup the root itself. We can do so with the RMAN command BACKUP DATABASE ROOT as shown in the following example:
</p></br>
<p><br>
<div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgk8D6rQHxvzLPdeuOs1utPAvFAdFSYWQB3e2Y_1sZde0p77IL6PTKobz57pxlq_-gWYoIWtoVMrMJ0BvJG8e-ccp62m_b6zhTOvsPSJ3ztXW73iY4Slx3SJMDucFpvbahd5vdoEoYlBrI/s1600/12c+backup+pdb+root+only.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgk8D6rQHxvzLPdeuOs1utPAvFAdFSYWQB3e2Y_1sZde0p77IL6PTKobz57pxlq_-gWYoIWtoVMrMJ0BvJG8e-ccp62m_b6zhTOvsPSJ3ztXW73iY4Slx3SJMDucFpvbahd5vdoEoYlBrI/s320/12c+backup+pdb+root+only.jpg" /></a></div>
</p></br><p><br>
</p></br>
<p><br></p></br><p><br>
Now let us verify the root backup for our PDB with Oracle 12c:
</p></br>
<p><br></p></br><p><br>
<div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjcK9x9stoDOIem8rZTwdp6V_J7fikuIRr3RZEhUXfnN-51SDQ0P7N-dJK7YoVaUMBpw2DNwMeH0J6Y_qXGyQjiYfP5zDuDdN7EAGAj7bA_1GDdfS8dwqtRlskNwqBtDDN4pLbuPzdEvOI/s1600/12c+root+list+backup+pdb.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjcK9x9stoDOIem8rZTwdp6V_J7fikuIRr3RZEhUXfnN-51SDQ0P7N-dJK7YoVaUMBpw2DNwMeH0J6Y_qXGyQjiYfP5zDuDdN7EAGAj7bA_1GDdfS8dwqtRlskNwqBtDDN4pLbuPzdEvOI/s320/12c+root+list+backup+pdb.png" /></a></div>
</p></br>
<br><p> Stay tuned when we visit how to restore pluggable databases with RMAN and Oracle 12c! </br></p>
Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-8142453738187547635.post-1715700910164846112013-08-01T14:51:00.000-07:002013-08-01T15:32:07.834-07:00Oracle 12c Installation on Oracle Linux 6<p><br>Dear readers, I decided to finally get around to installing Oracle 12c (12.1.0) on Oracle Linux 6 today. One key difference is the increased disk space requirements from 11g to 12c for the basic database configuration. I recall that 11gR2 requires almost 4GB of disk storage space. Now, for a basic enterprise installation with Oracle 12c, you need at least 6.4Gb of disk space!
<p><br>
<b>Pre-requisites for Oracle Linux 6 with Oracle 12c
</b></br></p>
<p><br>
Oracle Linux 6 requirements are available online from Oracle documentation. To simplify package and OS dependency requirements, you can deploy the Oracle Linux 6 RPM available from Oracle called oracle-rdbms-server-12cR1-preinstall
</br></p>
<br><p>Wim Coekerts has a good write up on this:
</br></p>
<br><p>
https://blogs.oracle.com/wim/entry/easily_install_oracle_rdbms_12cr1
</br></p>
Here is the basic screen shot of the storage requirements for 12c:
</p></br>
<div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjAietZEqrs4CT0ernY6UpSyxeSJx7KMa9XNlElSllum3S0P9j8IWWOVrq0_sJserrRqfE34PzU3xBZQZ_tBHlNwo1swphhRJS61LVRk7gjbDrwLzN_bGWV0Pr_nhEmOPGNINHtU-kcADg/s1600/oracle+12c+disk+requirement.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjAietZEqrs4CT0ernY6UpSyxeSJx7KMa9XNlElSllum3S0P9j8IWWOVrq0_sJserrRqfE34PzU3xBZQZ_tBHlNwo1swphhRJS61LVRk7gjbDrwLzN_bGWV0Pr_nhEmOPGNINHtU-kcADg/s320/oracle+12c+disk+requirement.jpg" /></a></div>
<br><p>
Like the previous setup screens for 11gR2 we have choice of desktop versus server class database system with Oracle so I will not bore you with these details.
</br></p>
<br><p>
Now we have the new choice to configure the database and also the new multi-tenant feature called pluggable database
</br></p>
<div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjqVSqnmmi78Sj285XwXfErEWk8qFBVTdmDpMvD9uCx76o9gGzGmuWypTjpckF8VJHFPynGgV8p3B4jhGz1FNRP3GBpQVvU2i4vi3FNfVSPcTv8HzD1nu-OuI55Lx_Oa-6LB8jWivuqios/s1600/oracle+12c+install+choose+sid+and+pg.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjqVSqnmmi78Sj285XwXfErEWk8qFBVTdmDpMvD9uCx76o9gGzGmuWypTjpckF8VJHFPynGgV8p3B4jhGz1FNRP3GBpQVvU2i4vi3FNfVSPcTv8HzD1nu-OuI55Lx_Oa-6LB8jWivuqios/s320/oracle+12c+install+choose+sid+and+pg.jpg" /></a></div>
<p><br>
One difference in the configuration lies instead of using the Oracle Enterprise Manager (OEM) console, Oracle 12c installer now asks you if you wish to use the new Oracle 12c Cloud Control. Since for sake of first setup with 12c, we are not using this option, we ignore it.
</p></br>
<br><p> Now we are off to the races for the actual installation for 12c:
</br></p>
<div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg8DYPghaEGDGfTeLsVRk1TJ0FDueVunfvhqEvITugzIXcWTMMMfi69QVg2TixcUCM7g6mNtLmeNA1wF2gcVYuCVbidK8Ts5QaB6SUFGImhWrWUrWeZBUvsSkhDBbIljYciFlwKvh5VgsU/s1600/oracle12c+preinstall.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg8DYPghaEGDGfTeLsVRk1TJ0FDueVunfvhqEvITugzIXcWTMMMfi69QVg2TixcUCM7g6mNtLmeNA1wF2gcVYuCVbidK8Ts5QaB6SUFGImhWrWUrWeZBUvsSkhDBbIljYciFlwKvh5VgsU/s320/oracle12c+preinstall.jpg" /></a></div>
<br><p>
At the end, run the usual root.sh scripts that are called out for under root user.
</br></p>
<br><p>
<div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgYvGcF3zEdO5J6v-iJmTaUUjQ138ArgiNaBV9Uibvy1ns8YfzJsya8Ql5GwVP7wHxVIB6O2ISf7sZ_YLfN61_wNJC8WSPs5W2eSpbpbx6wVvrkQrBIU5k8pV4PDJFpT6voGuq5-u-H918/s1600/finish+oracle12c.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgYvGcF3zEdO5J6v-iJmTaUUjQ138ArgiNaBV9Uibvy1ns8YfzJsya8Ql5GwVP7wHxVIB6O2ISf7sZ_YLfN61_wNJC8WSPs5W2eSpbpbx6wVvrkQrBIU5k8pV4PDJFpT6voGuq5-u-H918/s320/finish+oracle12c.jpg" /></a></div>
</p></br>
<br><p>We verify the status of the newly created Oracle 12c database:
</p></br>
<p><br>
<div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiDwkev3leQFMfjO_2mjV_X1zpXK85CyWPKfusMZgpGcbSuEUDZ8sPs_ezTmYDVE2bMHuAk7_34fQm9g80SMNe0rf4NLknhDHAs5ejvvssZuRNQzCgn4X6T1stuHFNAFj9vlPxPfD06gFo/s1600/verify+12c.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiDwkev3leQFMfjO_2mjV_X1zpXK85CyWPKfusMZgpGcbSuEUDZ8sPs_ezTmYDVE2bMHuAk7_34fQm9g80SMNe0rf4NLknhDHAs5ejvvssZuRNQzCgn4X6T1stuHFNAFj9vlPxPfD06gFo/s320/verify+12c.jpg" /></a></div>
<br><p>The new Oracle 12c management console has a host of new features as shown below that we will explore in future posts:
</br></p>
<div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiK3q34ZnoJ9_s3U3GtttalXAjRmsHE6A0_sIsDXmP9UX09zUHdyKfKKcVxaBvQ4n1__4p5wzHEQAyB3cTaVV_DY5AVgH47STLc1sc44Y3xCOjOB9I5oUyhrx8GWZjDBrVw6upLN7VNsZA/s1600/ora12c+console.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiK3q34ZnoJ9_s3U3GtttalXAjRmsHE6A0_sIsDXmP9UX09zUHdyKfKKcVxaBvQ4n1__4p5wzHEQAyB3cTaVV_DY5AVgH47STLc1sc44Y3xCOjOB9I5oUyhrx8GWZjDBrVw6upLN7VNsZA/s320/ora12c+console.jpg" /></a></div>
<br><p>
Stay tuned!</br></p>
Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-8142453738187547635.post-29743435275570423022013-07-24T16:23:00.000-07:002013-07-24T16:34:51.908-07:00Software Defined Networks (SDN)<p>One hot topic that I would like to discuss today is that of software defined networks (SDN) in respect to Oracle and other database platforms. Key vendors that provide core technologies around this area are provided by VMware, Redhat, and Oracle. First let us cover the basics of SDN.
</p>
<p>
<b>VMware Software Defined Network
</b></p><p>
http://www.vmware.com/solutions/datacenter/software-defined-datacenter/networking.html
</p><p>
From VMware approach, the new vCloud Director suite provides the tools to implement an end to end software defined network and virtualized ecosystem along with robust technologies such as VMware vCenter and VMware vSphere. According to VMware the Software Data Center:
</p><p>
<b>The Software-Defined Data Center: Operating Principles
</b></p><p>
Rather than mask the inherent rigidity of specialized hardware under a tangle of scripts, the Software-Defined Data center leapfrogs these constraints to change the way all data center services are delivered.
</p><p>
As implemented in VMware’s vCloud Suite, the virtualization principles of abstraction, pooling and automation are applied to compute, storage, networking, security, and availability. This creates the Virtual Data Center, a new construct that aggregates these software-defined services and enables intelligent, policy-based provisioning, automation, and monitoring. APIs and other connectors provide seamless extensibility to third-party platforms and public cloud services.
</p><p>
Below is the architecture for vCloud environment for SDN:</p><br>
<div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEihmb7mk1RKKVqV-cW6PmYI8W-jRAnYt-InBbBTKTDFz6yJwT5W5TgWQAerMh9zjACqamzCVfOL_dir3We3WVR_JPFn8l3zCwcefTnaOTQPyrv8dCo5BGf16X8GOvDfiE5Rky-5IvxtYtE/s1600/vcloud.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEihmb7mk1RKKVqV-cW6PmYI8W-jRAnYt-InBbBTKTDFz6yJwT5W5TgWQAerMh9zjACqamzCVfOL_dir3We3WVR_JPFn8l3zCwcefTnaOTQPyrv8dCo5BGf16X8GOvDfiE5Rky-5IvxtYtE/s320/vcloud.jpg" /></a></div>
</br><p>
Taken together, these capabilities comprise VMware Cloud Infrastructure, the virtualized infrastructure at the heart of the Software-Defined Data Center. As highly capable as it is, this “engine” is not sufficient on its own. It must be fully managed, which encompasses everything from delivering access to the right services with the right approvals to ensuring the performance, compliance and efficiency of your private cloud.
</p><p>
These management capabilities—delivered via VMware Cloud Management—are specifically designed to provide deep insight into cloud infrastructure performance, while enabling services to be provisioned and accessed in any available cloud.
</p><p>
For many companies, the Software-Defined Data Center will coexist in a heterogeneous environment with multiple hypervisors, hardware from different vendors, and various public cloud services. You can abstract away this complexity by extending VMware Cloud Management beyond your vSphere-enabled Software-Defined Data Center—to impose uniform governance, control, access and self-service over your entire heterogeneous, hybrid cloud environment.
<br></p><p>
Cloud Service Provisioning: Automate the provisioning of infrastructure and applications within the Software-Defined Data Center, and beyond it across multiple clouds and platforms.
Cloud Operations Management: Manage the health, risk, efficiency and compliance of your infrastructure and applications.
Cloud Business Management: Govern and manage cloud services as a critical element of running IT like a business.
</p><p><br>
<b>Oracle Software Defined Network
</b></p></br><p>
Oracle has a different approach to software defined networking and virtualized data centers that is more application focused along the core suite of applications that run Oracle database and Oracle systems.</p>
<p>
http://www.oracle.com/us/products/networking/virtual-networking/sdn/overview/index.html
</p>
<br>Below is an overview of the approach for SDN taken by Oracle:
</br>
<div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjD4NVVMuHl-wCMJtCbztxNQ-_o1CGU9oC2By0Fo7hs-9zNNdGVy9DiN0UHeV9jt34no80QG-JBDk2Wa5RKQib31JyfxURcxbrbsfYdCCQCpR0xj7TsZecTgzPhxbe7tcer7WD9n__WuAw/s1600/Oracle+SDN+architecture.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjD4NVVMuHl-wCMJtCbztxNQ-_o1CGU9oC2By0Fo7hs-9zNNdGVy9DiN0UHeV9jt34no80QG-JBDk2Wa5RKQib31JyfxURcxbrbsfYdCCQCpR0xj7TsZecTgzPhxbe7tcer7WD9n__WuAw/s320/Oracle+SDN+architecture.jpg" /></a></div>
<p>
Last but not least, completely integrated systems that merge SDN with hardware, storage, compute and network converged infrastructure are now on the market and provide turn key solutions to large customers who require a quick time to market data center such as that provided by VCE (http://www.vce.com) via the vBlock platform. A good overview of the vBlock is available below:
</p><p>
http://www.cisco.com/web/GR/connect2013/pdfs/014_emc_vmware_thanos.pdf
<br><p>
Until next time
</br></p>
Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-8142453738187547635.post-50075937124097359592013-07-10T19:23:00.001-07:002013-07-10T19:27:43.103-07:00Oracle 12c New Features and ReleaseOracle 12c has been released this month and this is the biggest news since Oracle 11g came out some time back.
<p>
Below are some new features:
</p>
<br>Oracle cloning
</br><br>Oracle PDB
</br><br>Oracle RAC and ASM enhancements
</br><br>Oracle security enhancements
</br><p>
<a href="http://docs.oracle.com/cd/E16655_01/server.121/e17906/chapter1.htm#AREANO02530">Oracle 12c New Features</a>
</p>
<br>
As an Oracle RAC expert, the deployment features for Oracle 12c RAC and ASM are quite exciting and should make highly available scalable clusters with the new Flex cluster more fun and powerful for large enterprise data centers. Per the 12c new features for Flex RAC clusters:
</br>
<br>
"Oracle Flex Cluster is a new Oracle Clusterware based topology utilizing two types of cluster nodes: Hub Nodes and Leaf Nodes. Hub Nodes represent traditional nodes, tightly coupled using network and storage. Leaf Nodes are a new type of node that runs a lighter weight stack and does not require direct shared storage connectivity."
</br><p>
I also like the new 12c policy based approach to database and RAC deployments:
</p><br>
"Oracle Grid Infrastructure allows running multiple applications in one cluster. Using a policy-based approach, the workload introduced by these applications can be allocated across the cluster using a policy set. In addition, a policy set enables different policies to be applied to the cluster over time as required. Policy sets can be defined using a web-based interface or a command-line interface.
</br><br>
Hosting various workloads in the same cluster helps to consolidate the workloads into a shared infrastructure that provides high availability and scalability. Using a centralized policy-based approach allows for dynamic resource reallocation and prioritization as the demand changes."
</br><br>
Stay tuned for exciting new developments as I test out the many new 12c features from Oracle. Oracle has truly raised the bar once again for enterprise database and application technology! Bravo!</br>Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-8142453738187547635.post-65107840129399243632013-06-04T06:24:00.001-07:002013-06-04T06:25:36.941-07:00Oracle RAC Timezone woes and solution<br><p>
Recently had a timezone issue with an Oracle 11gR2 RAC cluster. Even though I had set the host time and date, for some reason it did not get propagated to the Oracle RAC configuration.
<br><p>
There are couple of ways to set timezone for an Oracle 11.2 RAC cluster. First is the easy way by using srvctl commands:
<br><p>
srvctl setenv database -d <db_unique_name> -T <name>=<val>
<br><p>
srvctl setenv database -d racdb -T TZ=US/Eastern
<br><p>
In the first case, if this did not work, we need to edit a configuration file called s_crsconfig_{racnodename}_env.txt located under the
$GRID_HOME/crs/install directory.
<br><p>
Here is my example for the edits performed of the above file on both RAC nodes, using first node as sample:
<br><p>
[root@racnode1$ vi /oracle/11.2.0/grid/crs/install/s_crsconfig_racnode1_env.txt
<br><p>
### This file can be used to modify the NLS_LANG environment variable, which determines the charset to be used for messages.
<br><p>### For example, a new charset can be configured by setting NLS_LANG=JAPANESE_JAPAN.UTF8
<br><p>### Do not modify this file except to change NLS_LANG, or under the direction of Oracle Support Services
<p><br>
<br><p><strong>TZ=US/Pacific</strong>
<br><p>NLS_LANG=AMERICAN_AMERICA.AL32UTF8
<br><p>TNS_ADMIN=
<br><p>ORACLE_BASE=
<br><p>
<br><p>
Restart the Oracle 11.2 Clusterware services and database and run srvctl to confirm setting changes.
<br><p>
Unknownnoreply@blogger.com3tag:blogger.com,1999:blog-8142453738187547635.post-7710509706152577492013-06-03T07:34:00.002-07:002013-06-04T06:07:20.154-07:00Migrating single instance Oracle 11g database to Oracle 11gR2 RAC and ASMRecently over the past few years, I've been involved with customer engagements to migrate legacy single instance environmnents to Oracle 11gR2 RAC and ASM. In this post, I will detail out the high level steps on how to perform this for ERP environments with SAP and Oracle.
<br>
<p>
I will spend a few blog posts on this topic due to the complex nature of migrating from single instance to Oracle RAC.
<p>
<br>
<p>
1. Migrate single instance Oracle non-ASM to Oracle 11gR2 RAC and ASM
<br><p>
2. Migrate single instance Oracle ASM to Oracle 11gR2 RAC.
<br><p>
SAP ECC 7.x now allows you to directly install Oracle ASM in the new Oracle 11gR2 Grid infrastructure environment. This means that you can build and configure your Oracle 11gR2 ASM disks and provision them without having to first migrate with RMAN from single instance Oracle to ASM.
<br><p>
Case 1: Migrate single instance Oracle non-ASM to Oracle 11gR2 RAC and ASM
<br><p>
The steps to migrate Oracle single instance to Oracle 11gR2 RAC are as follows:
<br><p>
1. Install Oracle 11gR2 Grid infrastructure
<br><p>
2. Provision disks for ASM
<br><p>
3. Configure and create ASM instances
<br><p>
4. Use RMAN to transfer non-ASM Oracle database to ASM configuration
<br><p>
5. Install Oracle 11gR2 RAC database software in new ORACLE_HOME
<br><p>
6. Perform cluster infrastructure configuration for public, private, VIP, and SCAN requirements per Oracle 11gR2 documentation
<br><p>
7. Install Oracle 11gR2 RAC grid infrastructure for a cluster
<br><p>
8. Use rconfig to complete the migration to Oracle 11gR2 RAC
<br><p>
Note: for SAP with Oracle RAC, you MUST use Oracle 11.2.0.2 or later release to obtain support from SAP.
ASM must use a ACFS fileystem as well.
<br><p>
Case 2: Migrate single instance Oracle ASM to Oracle 11gR2 RAC
<br><p>
The steps for case 2 are as follows for an environment with Oracle single instance and ASM:
<br><p>
1. Install Oracle 11gR2 RAC database software in new ORACLE_HOME
<br><p>
2. Run the rootcrs.pl -deconfig -force script for single instance GRID_HOME with Oracle ASM
<br><p>
3. Install Oracle 11gR2 RAC Grid infrastructure for new GRID_HOME on cluster node hosts
<br><p>
4. Add ASM disks from single instance to cluster services with ASMCA utility
<br><p>
5. Migrate single instance with rconfig scripts
<br><p>
I will add details in future posts as the tasks are very complex and involved. For now, I wanted to give a high level summary since this is not well documented.
<br><p>
Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-8142453738187547635.post-70486032049076977062013-04-12T18:59:00.000-07:002013-04-12T18:59:02.201-07:00First solo flight and my quest to become a private pilot for fun!
This year I started my journey to accomplish a childhood dream of earning my private pilot license to have the freedom and skill to fly aircraft in my free time. This past week I completed my first solo flight successfully at KPAO airport in Palo Alto!
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjuUHpI7zMIV02WiTLXFg40jBMO8voS5-2vAOPO4LqSCcjjOu55KDvMn8y8PKr6bA_edDxDdCy36FKSFGgf-W47Ex6ZwnCzfoF0d5cw255CWNdydWTox8eQBiz8HsZyvtZEW9S33bSHiDk/s1600/benfirstsolo.JPG" imageanchor="1" ><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjuUHpI7zMIV02WiTLXFg40jBMO8voS5-2vAOPO4LqSCcjjOu55KDvMn8y8PKr6bA_edDxDdCy36FKSFGgf-W47Ex6ZwnCzfoF0d5cw255CWNdydWTox8eQBiz8HsZyvtZEW9S33bSHiDk/s320/benfirstsolo.JPG" /></a>
It was exciting when my instructor, Gordon Reade at Sundance Flying Club stepped out after signing my logbook to solo and wished me luck before I taxi and took off from Runway 31. After the tower granted me clearance to take off, I lined up and used full throttle to rotate (Vr) at about 55kts in the Cessna 172SP aircraft (837SP) to complete my first solo flight of three takeoffs and landings in the traffic pattern over the bay at KPAO airport. It was fun and best of all I was relaxed and confident in my newly acquired skills. All three landings were smooth on touchdown and my instructor congratulated me on a solo flight well done. Now I look forward to completing my cross country flights and passing my checkride to receive my private pilot license! Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-8142453738187547635.post-53164500453872691792013-04-12T18:53:00.001-07:002013-04-12T18:53:36.684-07:00NoCOUG Events for April and May 2013As the new conference director for the Northern California Oracle User Group (NoCOUG), we have many exciting events planned for the Oracle user community.
Next week, on April 16th we have a meetup for cloud computing with Oracle technology at the Hacker Dojo in Mountain View, CA:
http://www.meetup.com/Northern-California-Oracle-Users-Group/events/112651522/?a=me1_grp&rv=me1&_af_eid=112651522&_af=event
In May, we have the NoCOUG spring/summer conference planned with events for Big Data and Oracle technology.
http://www.technicalconferencesolutions.com/pls/caat/caat_abstract_reports.schedule?conference_id=124
To attend this exciting conference you may sign up below and RSVP:
http://www.nocoug.org/rsvp.html
So if you are in northern California please come learn the latest greatest things about all things Oracle.
Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-8142453738187547635.post-33590733685349947372012-12-28T14:32:00.001-08:002012-12-28T14:32:14.867-08:00End of 2012Year in review
As we end 2012, in closing I have not posted much due to work and many activities wrapping up the year. My new Oracle R12 EBS book is available and ready for folks to learn the tips and tricks for Oracle R12 Financials from Oracle Press. Each year I pursue a new goal and try to master or improve a skill or ability. This keeps me sharp and motivated and happy. Last year, I learned to scuba dive. Right now, I am learning to fly! My goal by 2013 is to pass my checkride and obtain my private pilot license. I have always had a passion for aviation and aeronautics. I am doing this purely as a hobby and do not want to be a professional pilot. For one, the pay is quite low until one has a decade of experience and two, I like working in technology as a job better than to fly planes for a living. I also will be focused on bring new events to the NoCOUG Oracle User Group in the bay area and northern California for Oracle users who want to learn new developments in database technology from Oracle. Happy Holidays and best wishes to all for a safe, peaceful and prosperous 2013!
Cheers,
Ben
Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-8142453738187547635.post-44502622947133569292012-04-02T12:25:00.003-07:002012-04-02T12:40:35.387-07:00Quick tip: Cloning Oracle 11gR2 RAC node in Oracle VM 3.0.3Oracle VM 3.0.3 Server and Manager provide you with the ability to clone virtual machines quickly and easily. However, as of yet, there is not live hot clone facility available. The Oracle RAC VM must be powered off before you perform the clone operation. <br /><br />There are two options available for cloning within Oracle VM: simple clone and advanced clone. Simple clone takes a quick snapshot of the VM to be copied to the new clone. Advanced provides you with the ability to create a custom clone process based on a menu driven GUI that you can create based on your requirements for cloning VM images.Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-8142453738187547635.post-74680328765690596502012-03-29T21:25:00.003-07:002012-03-29T21:32:14.657-07:00Upgrading Oracle VM 3.0.3 to latest patchsetRecently I had to upgrade an older version of Oracle VM 3.0 to the latest patch version to resolve some bugs in the initial releases of OVM 3.0. Below are the steps that I followed to perform the upgrade.<br /><br /><br />1. Download the patchset from Oracle Support (http://support.oracle.com)<br />2. Unzip the patch to the OVM Manager /tmp directory<br />3. backup config files for OVM Manager:<br /><br />. Back up/copy the Oracle VM Manager configuration file located at:<br /># /u01/app/oracle/ovm-manager-3/.config<br /><br />4. Mount the ISO image for the upgrade:<br /><br /># mount -o loop V29654-01.iso /mnt<br /># cd /mnt<br /># ls<br />components runUpgrader.sh upgrade<br /># <br /><br />Upgrade OVM 3.x to OVM 3.0.3:<br /><br /># ./runUpgrader.sh<br />Oracle VM Manager 3.0.3.126 upgrade util<br /><br />Oracle VM Manager is running ...<br /><br />Verifying installation status ...<br />Read Oracle VM Manager config file ...<br />Skipping database upgrade for the same product version (3.0.3 to 3.0.3)<br />Found Oracle VM Manager install files ...<br />Found Oracle VM Manager upgrader ...<br />Found Oracle WebLogic Server ...<br />Found Java ...<br />Using the following information :<br /> Database Host : localhost<br /> Database SID : XE<br /> Database LSNR : 1521<br /> Oracle VM Schema : ovs<br /> Oracle VM Manager UUID : 0004fb00000100004bd6b7c313170105<br /> Current Build ID : 3.0.3.126<br />Using /tmp/workdir.hcUHL29831 for backup and export location.<br />Using /tmp/patchdir.Rvea29832 for patching.<br />Undeploying previous version of Oracle VM Manager application ...<br />Undeploying Oracle VM Manager help ...<br /><br />Note: make sure that OVM Manager is up and running during the upgrade!<br /><br />Once completed, the version should look like this:<br /><br /><a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhsPpJkFAk01Vd9V6T45a2Ptmzr4aLz6zHayC6a1Vz8gXShq4JG6sRDV_eAiv7nAGWCTGkU9jPpAMoo0LXa2MGaK_bOPwo2Sj1PCtICA1vXCTHaTJ3DCiJWWGpmJOeLbVDgGvQCUGy0O8U/s1600/postupgradeOVM3.3.jpg"><img style="float:left; margin:0 10px 10px 0;cursor:pointer; cursor:hand;width: 400px; height: 171px;" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhsPpJkFAk01Vd9V6T45a2Ptmzr4aLz6zHayC6a1Vz8gXShq4JG6sRDV_eAiv7nAGWCTGkU9jPpAMoo0LXa2MGaK_bOPwo2Sj1PCtICA1vXCTHaTJ3DCiJWWGpmJOeLbVDgGvQCUGy0O8U/s400/postupgradeOVM3.3.jpg" border="0" alt=""id="BLOGGER_PHOTO_ID_5725542837179576354" /></a><br /><br /><br />In my next series of posts for OVM 3.0.3, I will discuss how to deploy Oracle 11gR2 RAC environment as well as use the new features for OVM 3.0.3 such as live migration and converting P2V- physical to virtual as well as managing an OVM 3.x environment.Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-8142453738187547635.post-2476354623932176462012-03-29T21:15:00.003-07:002012-03-29T21:24:59.971-07:00Uploading templates for OVM 3.0.3 to ftp serverDear readers,<br /><br />Its been a while since I've blogged due to many busy demands between work, finishing a new Oracle book and scuba diving. Recently, I setup a new Oracle VM 3.0.3 environment and the interface and tools have changed quite a bit since I last worked with OVM 2.2 version. One challenge is that now in OVM 3.0.3 you have to upload the VM templates via a web http or ftp server and no longer can you copy the Oracle VM templates over to the /OVS/seed_pool directory on the OVM server. In my case, I hit a wall of frustration trying to import a template for OVM 3.0.3 via a Windows FTP server. The solution for importing Oracle VM 3.0.3 templates into OVM manager is to use the following ftp string:<br /><br /><br />ftp://domainname%5Cusername:password@url-path<br /><br />in our case we have:<br /><br />ftp://oraben%5Coracle:mypassword@winftpserver.benoracle.com/V25331-01.zip<br /><br />In my experience, OVM Manager prefers that you use the root base directory of the ftp server.<br />Otherwise you will have server access denied errors and the template import operation will fail.<br /><br />Once you have imported the template into OVM 3.0.3 you will see a screen similar to the following:<br /><br /><a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgj0KU-RLy7zSEODPr7gw14Web2JzQBlwsMi65NmHNYi_zn-GuGPZIB64Pd634GOp0BAMpi3aBvtlJ2noRHf87iPb0ATlVR8TTOMveieHB1B4PB1DCJxqFokFJ59eSP-gFBlko11gsBrBo/s1600/OVMTemplateimported.jpg"><img style="float:left; margin:0 10px 10px 0;cursor:pointer; cursor:hand;width: 400px; height: 206px;" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgj0KU-RLy7zSEODPr7gw14Web2JzQBlwsMi65NmHNYi_zn-GuGPZIB64Pd634GOp0BAMpi3aBvtlJ2noRHf87iPb0ATlVR8TTOMveieHB1B4PB1DCJxqFokFJ59eSP-gFBlko11gsBrBo/s400/OVMTemplateimported.jpg" border="0" alt=""id="BLOGGER_PHOTO_ID_5725541156290235634" /></a><br /><br />Hope this helps. Stay tuned for a continuation of my series on tips and tricks for Oracle VM 3.0.3Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-8142453738187547635.post-83381903267420764472011-11-28T11:33:00.000-08:002011-11-28T11:43:21.954-08:00How to fix archive stuck error with Oracle 11gR2Recently, I encountered an issue with Oracle R12 EBS environment unable to login to database tier with APPS schema with our Oracle 11gR2 database tier.<br /><br />ORA-00257: archiver error. Connect internal only, until freed.<br /><br />Sure enough, upon examination of the ADRCI alert.log entries, I found this:<br /><br />* 2011-10-27 16:24:51.990 4265 krsh.c<br />ARC1: Error 19809 Creating archive log file to '+FRA'<br />*** 2011-10-27 16:24:51.990 2864 krsi.c<br />krsi_dst_fail: dest:1 err:19809 force:0 blast:1<br />DDE rules only execution for: ORA 312<br />----- START Event Driven Actions Dump ----<br />---- END Event Driven Actions Dump ----<br />----- START DDE Actions Dump -----<br />Executing SYNC actions<br />----- START DDE Action: 'DB_STRUCTURE_INTEGRITY_CHECK' (Async) -----<br />Successfully dispatched<br />----- END DDE Action: 'DB_STRUCTURE_INTEGRITY_CHECK' (SUCCESS, 0 csec) -----<br />Executing ASYNC actions<br />----- END DDE Actions Dump (total 0 csec) -----<br />DDE: Problem Key 'ORA 312' was flood controlled (0x5) (no incident)<br />ORA-00312: online log 2 thread 3: '+DATA/vis/onlinelog/group_2.259.743840813'<br />ORA-00312: online log 2 thread 3: '+FRA/vis/onlinelog/group_2.259.743840815'<br /><br />Solution:<br />The Fast Recovery Area (FRA) is full with old archive log files so we need to clean this up by removing old archive logs.<br />If you have production environment, back these up to tape or storage for recovery and archival purposes.<br /><br />Login to RMAN and run the following commands:<br /><br />RMAN> CONNECT target /<br /> <br />connected TO target DATABASE: INSTANT (DBID=1234567890)<br /> <br />RMAN> crosscheck archivelog ALL;<br /> <br />Note: You can schedule this command once a week. <br />The crosscheck command does NOT DELETE the information about the logs that it <br />could NOT find ON disk, it just updates their STATUS IN the repository AS 'EXPIRED'.<br />TO obtain a list OF logs marked AS 'EXPIRED' USE the following command: <br /> <br />RMAN> list expired archivelog ALL; <br /> <br />IF it IS NOT necessary TO keep the information about these <br />logs IN the repository, DELETE them WITH command: <br /> <br />RMAN> DELETE expired archivelog ALL;<br /><br /><br />RMAN> delete archivelog all completed before 'SYSDATE-1';<br /><br />The above RMAN command will delete old archive logs past 24 hours. <br /><br />Now you should be able to connect to the database.<br /><br /><br />Below are some useful queries to check on FRA available space:<br /><br />SQL> SELECT name, free_mb, total_mb, free_mb/total_mb*100 "%" FROM v$asm_diskgroup;<br /><br />NAME FREE_MB TOTAL_MB %<br />------------------------------ ---------- ---------- ----------<br />DATA 823641 1044450 78.8588252<br />FRA 207743 511992 40.5754387<br />LOG 306958 307191 99.9241514<br /><br /><br />SQL><br /><br />set lines 100<br />col name format a60<br />select name<br />, floor(space_limit / 1024 / 1024) "Size MB"<br />, ceil(space_used / 1024 / 1024) "Used MB"<br />from v$recovery_file_dest<br />order by name<br />/<br /><br /><br />NAME Size MB Used MB<br />------------------------------------------------------------ ---------- ----------<br />+FRA 102400 302965<br /><br /><br />If you want to change the default size for the FRA you can issue the following command from SQL*PLUS:<br /><br />SQL> alter system set db_recovery_file_dest_size=600G;<br /><br />System altered.<br /><br />Then you should archive logs:<br />SQL> archive log all;<br />3 logs archived.Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-8142453738187547635.post-43951758173473346462011-10-16T13:58:00.001-07:002011-10-16T14:12:23.071-07:00My review Oracle OpenWorld 2011Dear readers,<br /><br />Oracle OpenWorld 2011 was a fantastic event with many new product announcements including Oracle Public Cloud as well as Oracle Big Data Appliances along with Exalytics for Business Intelligence. Before the conference, I had the pleasure of attending the Oracle ACE Director briefing at Oracle HQ in Redwood Shores under NDA to learn of new developments at Oracle.<br /><br />After the ACED briefing, I headed to San Francisco with my fellow Oracle ACE Director, Arup Nanda and we checked into the Hilton Hotel. The computers failed during checkin so we had the keep the patience of a saint which paid off with a free complimentary full breakfast. My hotel room had the most amazing view of the entire San Francisco Bay area including views of the Golden Gate bridge and Alcatraz island!<br /><br /><a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgmvGgahvxUks2FJN_WdT5Wq0leQgNZymAMkZD-L18nSyqU-L8kfSa95B0zM8pTsbjrXe3kc7w3QOrML5bL3LYf8-VC3WG9I7Cvz721nhjjnxoUS7YIKmu_5gCO-JxqobEuboBURo2doaQ/s1600/IMG_0476.jpg"><img style="display:block; margin:0px auto 10px; text-align:center;cursor:pointer; cursor:hand;width: 299px; height: 400px;" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgmvGgahvxUks2FJN_WdT5Wq0leQgNZymAMkZD-L18nSyqU-L8kfSa95B0zM8pTsbjrXe3kc7w3QOrML5bL3LYf8-VC3WG9I7Cvz721nhjjnxoUS7YIKmu_5gCO-JxqobEuboBURo2doaQ/s400/IMG_0476.jpg" border="0" alt=""id="BLOGGER_PHOTO_ID_5664198291272143554" /></a><br /><br />My favorite part of the conference was meeting new people and the special interest groups (SIG) for virtualization with Oracle. I had a great time meeting a lot of Oracle gurus including Jonathan Lewis, Tim Gorman, Doug Burns, James Morle, Michael Abbey, and my co-author Syed Jaffar Hussein of my Oracle 11g RAC book as well as James and Kerry from PACKT Press. Some more cool things at OOW this year was the America's cup winning yacht:<br /><br /><a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiKXrAfFC1YyIcaw7vOc4aQTljrskPQcmlugzSK1DNzyBMF_wywOWW5LHL6nIrDfZnHpkZn05XCAhYZQJAy1ZRcBLeuBUDcBfB-trkFOGU-hYbhp4u4Z3HgLxXD0XZPXL9bK1kj6-sFmqU/s1600/IMG_0479.JPG"><img style="display:block; margin:0px auto 10px; text-align:center;cursor:pointer; cursor:hand;width: 400px; height: 299px;" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiKXrAfFC1YyIcaw7vOc4aQTljrskPQcmlugzSK1DNzyBMF_wywOWW5LHL6nIrDfZnHpkZn05XCAhYZQJAy1ZRcBLeuBUDcBfB-trkFOGU-hYbhp4u4Z3HgLxXD0XZPXL9bK1kj6-sFmqU/s400/IMG_0479.JPG" border="0" alt=""id="BLOGGER_PHOTO_ID_5664199170261923138" /></a><br /><br />This year we had a great time at OTN night and the appreciation event was wonderful with Sting in concert. Funny because it seemed like Sting was singing in slow motion on songs like Roxanne! <br /><br /><a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj2KT0D5F_DzqXDbpL65OASQsoTQaLYPatQv6_sFKQjnA-3U1tu5FhhARuDaxmVMcvD3AY0bwhdp23G9ajZe5C43auk8Ip9lOnKjY5NWPbzJ_UosPV4xOprdzdbgt6h6URRqxnHJcEKjbk/s1600/IMG_0526.JPG"><img style="display:block; margin:0px auto 10px; text-align:center;cursor:pointer; cursor:hand;width: 400px; height: 299px;" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj2KT0D5F_DzqXDbpL65OASQsoTQaLYPatQv6_sFKQjnA-3U1tu5FhhARuDaxmVMcvD3AY0bwhdp23G9ajZe5C43auk8Ip9lOnKjY5NWPbzJ_UosPV4xOprdzdbgt6h6URRqxnHJcEKjbk/s400/IMG_0526.JPG" border="0" alt=""id="BLOGGER_PHOTO_ID_5664199830990580914" /></a><br /><br />The lightshow with Sting was incredible!<br /><br /><a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgYHRWPW65lez1T8IIyOquIHEexCaWl-M8GDwA7L9ipHZQUDf_MB9U9RWnzkq8uQ7hqWpPvBDSM6GU_7emtWWDVWToRqoSkqwQUEZXLakyGUhL8PKSoGWowy7XVCAoogp_Ux7_TQFzy__g/s1600/IMG_0520.JPG"><img style="display:block; margin:0px auto 10px; text-align:center;cursor:pointer; cursor:hand;width: 400px; height: 299px;" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgYHRWPW65lez1T8IIyOquIHEexCaWl-M8GDwA7L9ipHZQUDf_MB9U9RWnzkq8uQ7hqWpPvBDSM6GU_7emtWWDVWToRqoSkqwQUEZXLakyGUhL8PKSoGWowy7XVCAoogp_Ux7_TQFzy__g/s400/IMG_0520.JPG" border="0" alt=""id="BLOGGER_PHOTO_ID_5664200625914302818" /></a><br /><br /><br />On Tuesday, I delivered my session on database security and would like to thank the 400+ attendees who came to my session. I do hope it was informative and useful to your journey to implementing security for your Oracle environments. The weather was a bit challenging with lots of rain and cold this year.<br /><br /><a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEglq0y2xZYGxRbT-elOZ2KVA90BjMjv4DlilFA-zRffDI4llKeBtnAqdj5nAcnvyVWCa7T91mv5KaWCeK_39aNefbA7JFmI7MRcNz3cMZKhtg8mc2lct0p7ywTF4zNmzGjiJMub8abRgiA/s1600/IMG_0519.JPG"><img style="display:block; margin:0px auto 10px; text-align:center;cursor:pointer; cursor:hand;width: 400px; height: 299px;" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEglq0y2xZYGxRbT-elOZ2KVA90BjMjv4DlilFA-zRffDI4llKeBtnAqdj5nAcnvyVWCa7T91mv5KaWCeK_39aNefbA7JFmI7MRcNz3cMZKhtg8mc2lct0p7ywTF4zNmzGjiJMub8abRgiA/s400/IMG_0519.JPG" border="0" alt=""id="BLOGGER_PHOTO_ID_5664200299003428402" /></a><br /><br /> Fortunately I had an umbrella to keep me dry.<br />I would like to thank Justin, Lillian, and Vikki for all their hard work to make the OOW conference and ACE briefing a total victory and success this year.Unknownnoreply@blogger.com0