oracle asm training

Label:2015-10-24DirectoryResources[1] Management and maintenance of ASM under oracle11g RAC[2] Oracle 11g RAC with ASM installed on RHEL5 (simplified version)[3] Oracle 11g r2+rac+asm+oraclelinux6.4 installation details (figure)[4] Oracle11gr2+

switch to the configuration file directory[Email protected] ~]# CD/ETC/UDEV/RULES.DDefine the necessary rule profiles[email protected] rules.d]# Touch 99-oracle-asmdevices.rules[email protected] rules.d]# cat 99-oracle-asmdevices.ruleskernel== "sd*", bus== "scsi", program== "/sbin/scsi_id-g-u-s%p", result== "1iet_00010001", name= "OCR1", owner= "grid", Group= "Asmadmin", mode= "0660"kernel== "sd*", bus== "

Oracle10g manually create a database stored in ASMProject Process:0. Add two SCSI hard disks to the computer.1. Install ASM2. Create two ASM disk groups: GROUP1 and GROUP23. Create a database. First, create a parameter file and save it as $ ORACLE_HOME/dbs/initnestling. ora.4. Create a password file $ ORACLE_HOME/dbs/orapwdnestling5. Create a path for tracking and log files6. Start the database to the nomount status.7. Create and run the database crea

Tags: Database file solution Data Recovery Oracle"Fault description"ASM Disk group dropped, ASM instance cannot mount. ASM Disk Group has 4 500G disks, database and ASM software 10.2.0.1, the Oracle database is in urgent need of r

1. Close the database completely. 2. Close the database and modify the server parameter file to use Oracle Managed Files (OMF ). 3. edit and execute the following RMAN Script: startup nomount; restore controlfile from '/u1/c1.ctl'; alter database mount; backup as copy database format' + dgroup1'; switch database to copy; SQL "ALTER DATABASE RENAME '/u1/log1' TO '+ dgroup1'"; # Repeat RENAME command for all online redo log members... alter database ope

diskgroup_name drop alias They have different forms of expression, but they are essentially the same and have the same effect. 3) aliases are only valid for files and cannot be used to create aliases for directories. V. Others 1. Modify the ASM disk rebalancing speed. Command: Alter diskgroup diskgroup_name rebalance power N; N = 0, 1, 2 ,... 11) Note: Letter N represents the speed of rebalancing. 0 indicates that the rebalance function is disabled

Tags: oracle common ASM Operations CommandIn an Oracle RAC environment, use a grid account to performRun asmcmd into ASM command mode, such as:[Email protected] ~]$ AsmcmdAsmcmd>Asmcmd> du//displays all disk space occupied by ASM files in the specified

Label:ASM disks do not recognize several phenomena: 1) GI home directory or its subdirectory permissions error 2) Incorrect permissions for ASM disks 3) ASM instance is not started or ASM Disk Group is not on Mount 4) ASM Disk Group resources are not online 5) Incorrect permissions for

ASM is an outstanding new feature in Oracle Database 10 Gb. It provides file system, logical volume manager, software RAID and other services in a platform-independent manner. ASM can strip and mirror disks, so as to add or remove disks and automatically balance I/O when the database is loaded to delete "hot spots ". It also supports direct and asynchronous I/O a

COMPATIBLE.ASM value of all disk headers, preventing 10g software products from mounting incompatible disk groups, while Oracle DATABASE 11g uses the values in PAT.PST contains a set of entries that describe each disk in a group of disks. For each disk, PST tracks the following:n Disk status (online or offline, for example)N Number of MembersN Member ListThe last block of the PST saves the heartbeat of the disk group.

signalled during mount of diskgroup DG_xxxxNOTE: cache dismounting group 1/0x000061a1f (DG_xxxx)ERROR: diskgroup DG_xxxx was not mountedTue Jul 7 05:50:10 2015Shutting down instance: further logons disabledWe can see that crash recovery is required when Oracle ASM is mounted, where the checkpoint is 6295.7329. Check the trace and find that the position read by the checkpoint is as follows:NOTE: starting re

Label:Oracle Version: Oracle 11g 1 . Determine your Linux version: [[Email protected] ~] #uname-R 2.6.32-431.el6.x86_64 2.6.32-431.el6.x86_64, which is Linux 6 2, installation oracleasm Kernel: [email protected] ~]# Yum install kmod-oracleasm 3. Download two installation packages:oracleasmlib and oracleasm-support [[Email protected] ~] #wget http://oss.oracle.com/projects/oracleasm-support/dis

/10.2.0/db_1/bin/kfed ': No such file or directorymake: [ikfed] Error 1 (ignored) mv/u01/app/oracle/ Product/10.2.0/db_1/rdbms/lib/kfed/u01/app/oracle/product/10.2.0/db_1/bin/kfedchmod 751/u01/app/oracle/product/ 10.2.0/db_1/bin/kfed[[emailprotected] lib]$ which kfed/u01/app/oracle/product/10.2.0/db_1/bin/kfed[[email p

Tags: Oracle database operating system ASM ASM installation ASM ConfigurationASM Installation of Oracle InstallationThe last time we talked about building an Oracle environment, let's look at the installation of

1. log on to the ASM instance and check whether the ASM disk is correct [oracle @ rhel5 ~] $ ExportORACLE_SID + ASM [oracle @ rhel5 ~] $ SqlplusassysdbaSQLselectname, statefromv $ asm_diskgroup; nbsp .. 1. log on to the ASM insta

------------ ----------- -------- ---------- ---------- -------------------- ------------------1 0 NORMAL 2048 0 xifenfei_0000/dev/raw/raw11 1 NORMAL 784 0 xifenfei_0001/dev/raw/raw21 2 NORMAL 7059 0 xifenfei_0002/dev/raw/raw3--Close the databasesqlgt; shutdown immediate;Database closed.Database dismounted.ORACLE instance shut down.--Close ASMsqlgt; shutdown ImmediateASM diskgroups dismountedASM instance shutdown View the disk for the bare device The code is as follows

There are still many steps to generate a shared disk and mount it to asm when Oracle VM builds Oracle RAC. Record it. The premise is that a linux has been installed in the VM.1. here I create five disks, cd C: \ Program Files \ Oracle \ VirtualBoxVBoxManage.exe createhd-filename D: \ OracleVM \

/orcl # Vi/etc/fstab /Dev/sdb1/U02/oradata/orclOcfs2_ Netdev, datavolume0 0 # Vi/etc/sysconfig/o2cb Os2cb_heartbeat_threshold = 601 9. Install asm and configure asm. # Rpm-ivh oracleasm-support-2.0.4-1.el5.i386.rpm # Rpm-ivh oracleasm-2.6.18-8.el5-2.0.4-1.el5.i686.rpm(Package based on different kernels) # Rpm-ivh oracleasmlib-2.0.3-1.el5.i386.rpm #/Etc/init. d/oracleasm configure

The sys password of the Oracle 10g ASM instance sometimes needs to be modified. The modification method is to directly modify the password file of the ASM instance, which is different from that of the user in the database instance. We cannot use the alter user command to modify the sys user password of the ASM database

Oracle 11g + RAC + RHEL6.5 + udev + ASM + PSU Installation Summary 1. Preparations before installation: Operating System: RHEL6.5 Storage: Huawei, multi-path configured Bind the business network card and heartbeat network card and pass the redundancy test. YUM source configuration BASH/SSL vulnerability patches 2. Check System Requirements A. LINUX version Cat/etc/issue B. Memory (at least 1 GB) Grep