ORA 257 error
[code language=”sql”] SELECT * FROM V$RECOVERY_FILE_DEST; NAME SPACE_LIMIT SPACE_USED SPACE_RECLAIMABLE NUMBER_OF_FILES ————– ———– ———- —————– ————— /mydisk/rcva 5368709120 109240320 256000 28 SQL> show parameter db_recovery NAME TYPE VALUE ——————————– ———– —————————— db_recovery_file_dest string /opt/oracle/test01/flash_recovery_area db_recovery_file_dest_size big integer 10G Command for changing db_recovery_file_dest SQL> alter system set db_recovery_file_dest=’/opt/oracle/test01/dbs/arch’ scope=both; System altered. [/code]
ASM Setup
BEFORE running the installer, you need to use oracleasm utilities to create the disks. You may need to run this as root but I’m not 100% sure. Probably, root will need to create the directory /dev/oracleasm and give ownership to grid in group oraasm or something like that. It is VERY important that the disks […]
ASM 4 Disks Per Diskgroup
ASM Disks Per Diskgroup To avoid kernel contention, a minimum of four LUNs (Oracle ASM disks) of equal size and performance is recommended for each disk group. Do you plan to have more than 4 disk groups? 1 TB HDD are usually faster than older 500 GB. 4 Disks Per Diskgroup Oracle Doc 4 Disks […]
asm_common.ksh
[code language=”sql”] #!/bin/ksh ############################################################################ # Script Name..: asm_com.ksh # Description..: Common library for ASM items # Author…….: Michael Culp # Date………: 10/17/2008 # Version……: .08 # Modified By..: # Date Modified: # Comments…..: imported from asm_diskmnt.ksh # Schema owner.: # alter session set current # Login User…: # Run Order….: # Dependent on.: # Script […]
Mother Of All ASM Scripts
Mother of all ASM scripts
UDEV
Oracle recently announced that ASMlib will not be certified or supported on Red Hat Enterprise Linux 6. To be more specific, MOS note “Oracle ASMLib Software Update Policy for Red Hat Enterprise Linux Supportd by Red Hat [ID 1089399.1]”, the quote of interest being: “For RHEL6, Oracle will only provide ASMLib software and updates when […]
ASM statistics script
[code language=”sql”] #!/bin/ksh ############################################################################ # Script Name..: # Description..: # Author…….: Michael Culp # Date………: / /2012 # Version……: # Modified By..: # Date Modified: # Comments…..: # Schema owner.: # alter session set current # Login User…: # Run Order….: # Dependent on.: # Script type..: # ############################################################################ echo "ASM File types stored in […]
ASM Views
Oracle has several main v$ views to expose ASM details. Oracle Automated Storage Management has several v$ views to see information About Automated Storage Management disks, diskgroups and other internals. There are seven new v$ views provided in Oracle Database to monitor ASM structures. v$asm_diskgroup: Describes a disk group (number, name, size related info, state, and […]
Support for ASMLib on Red Hat
Oracle will no longer release ASMLib kernel drivers for RHEL 6 kernels. See this note on support.oracle.com Oracle ASMLib Software Update Policy for Red Hat Enterprise Linux Supported by Red Hat (Doc ID 1089399.1) Going to Oracle EL 6 is an option, and may save money in the long run, one vendor to support OS […]