Oracle Database 10g Migration to ASM, August 2004Full description
Automatic Storage Management (ASM) is a feature provided by Oracle Corporation within the Oracle Database from release Oracle 10g (revision 1) onwards. ASM aims to simplify the management of databa...Full description
oracle 12c
Brief discussion about Oracle ASMFull description
How to Install Oracle Database 11gR2 on Oracle Linux 7 VMware Workstation
Installation Steps for Oracle 12CFull description
Oracle OCP: Oracle Database 12c Administrator Certified Professional Study Guide (in Russian). The book is focused on the exam objectives. It is designed for DBAs who feel they are ready to attempt...
The Oracle Database 12c R2: Administration Workshop Ed 3 course is designed to provide you with a firm foundation in administration of an Oracle Database. In this course you will gain a conceptual ...Full description
The Oracle Database 12c R2: Administration Workshop Ed 3 course is designed to provide you with a firm foundation in administration of an Oracle Database. In this course you will gain a conceptual ...
Oracle 12c New Features
12cFull description
1Z0-060-Oracle database 12c
Guia para Instalar Oracle Database 12 en LinuxFull description
oracle
oracleDescripción completa
ora
3/11/2017
How to Install Oracle 12c and ASM on RedHat - Oracle Database
As a minimum ensure RedHat RedHat has has the following packages installed on both nodes. unzip (x86_64) xorg-x11-utils-7.5-6.el6.x86_64 binutils-2.20.51.0.2-5.11.e binutils-2.20. 51.0.2-5.11.el6 l6 (x86_64) compat-libcap1-1.10-1 compat-libcap1-1. 10-1 (x86_64) compat-libstdc++-33-3.2.3-69.el6 compat-libstdc++-333.2.3-69.el6 (x86_64) compat-libstdc++-33-3.2.3-69.el6 compat-libstdc++-333.2.3-69.el6 (i686) gcc-4.4.4-13.el6 gcc-4.4.4-13.e l6 (x86_64) gcc-c++-4.4.4-13.el6 gcc-c++-4.4.4-13. el6 (x86_64) glibc-2.12-1.7.el6 glibc-2.12-1. 7.el6 (i686) glibc-2.12-1.7.el6 glibc-2.12-1. 7.el6 (x86_64) glibc-devel-2.12-1.7.el6 glibc-devel-2 .12-1.7.el6 (x86_64) glibc-devel-2.12-1.7.el6 glibc-devel-2 .12-1.7.el6 (i686) ksh libgcc-4.4.4-13.el6 libgcc-4.4.4-1 3.el6 (i686) libgcc-4.4.4-13.el6 libgcc-4.4.4-1 3.el6 (x86_64) libstdc++-4.4.4-13.el6 libstdc++-4.4.4-13 .el6 (x86_64) libstdc++-4.4.4-13.el6 libstdc++-4.4.4-13 .el6 (i686) libstdc++-devel-4.4.4-13.el6 libstdc++-devel-4. 4.4-13.el6 (x86_64) libstdc++-devel-4.4.4-13.el6 libstdc++-devel-4. 4.4-13.el6 (i686) libaio-0.3.107-10.el6 libaio-0.3.10 7-10.el6 (x86_64) libaio-0.3.107-10.el6 libaio-0.3.10 7-10.el6 (i686) libaio-devel-0.3.107-10.el libaio-devel0.3.107-10.el6 6 (x86_64) libaio-devel-0.3.107-10.el libaio-devel0.3.107-10.el6 6 (i686) libXext-1.1 (x86_64) libXext-1.1 (i686) libXtst-1.0.99.2 libXtst-1.0.9 9.2 (x86_64) libXtst-1.0.99.2 libXtst-1.0.9 9.2 (i686) libX11-1.3 (x86_64) libX11-1.3 (i686) libXau-1.0.5 libXau-1. 0.5 (x86_64) libXau-1.0.5 (i686) libxcb-1.5 (x86_64) libxcb-1.5 (i686) libXi-1.3 (x86_64) libXi-1.3 (i686) make-3.81-19.el6 sysstat-9.0.4-11.el6 sysstat-9.0.4-11.e l6 (x86_64) 4. Set the kernel parameters in /etc/sysctl.conf for for both nodes as follows. NOTE NOTE If If the current value for any parameter is higher than the value listed below, do not change the value of that parameter.
3/11/2017
How to Install Oracle 12c and ASM on RedHat - Oracle Database
shmmax - Half the server memory shmmni - 4096 (or greater) fs.file-max - 6815744 (or greater) fs.aio-max-nr - 1048576 (or greater) net.core.rmem_default - 262144 (or greater) net.core.rmem_max - 4194304 or greater) net.core.wmem_default - 262144 (or greater) net.core.wmem_max - 1048576 (or greater) sem - 250 32000 100 128 (or greater) net.ipv4.ip_local_port_range - 9000 65535 5. Ensure oracle account and dba group exists on both nodes. 6. Update the following file /etc/security/limits.conf on both nodes. oracle oracle oracle oracle oracle oracle
soft nproc 16384 hard nproc 16384 soft nofile 20480 hard nofile 65536 soft stack 10240 hard stack 32768
7. Ensure the following line in the /etc/pam.d/login file existis on both nodes. session required pam_limits.so 8. Create the .profile - see File Listings section below. 9. Install ASMLIB. 10. Create a single partition on each device to be used by ASM. 11. Create the ASM disks. For this installation the following disks will need to be created. asm-data01 asm-fra01 asm-redo01 asm-redo02 12. Check to confirm the disk are set-up correctly
3/11/2017
How to Install Oracle 12c and ASM on RedHat - Oracle Database
/usr/sbin/oracleasm listdisks 13. Unzip the files Log on as Oracle cd /u01/app/oracle/SOFTWARE unzip linuxamd64_12102_database_1of2.zip unzip linuxamd64_12102_database_2of2.zip unzip linuxamd64_12102_grid_1of2.zip unzip linuxamd64_12102_grid_2of2.zip unzip p6880880_121010_Linux-x86-64 unzip p20996835_121020_Linux-x86-64
Step-By-Step Guide - ASM Binary Installs 1. Log on to Oracle. 2. Unset ORACLE_HOME and GRID_HOME unset ORACLE_HOME unset GRID_HOME unset ORACLE_SID unset TNS_ADMIN 3. Install Grid Infrastructure Using the GUI cd /u01/app/oracle/SOFTWARE/grid ./runInstaller 4. Follow the instructions as detailed in the screenshots here 5. When prompted run the root scripts in the order specified Log on as root /u01/app/oraInventory/orainstRoot.sh /u01/app/oracle/product/12.1.0/grid/root.sh
3/11/2017
How to Install Oracle 12c and ASM on RedHat - Oracle Database
Step-By-Step Guide - Configure ASM 1. Create the extra Disk Groups . oraenv ORACLE_SID = [oracle] ? +ASM sqlplus / as sysasm SQL> CREATE DISKGROUP FRA01 EXTERNAL REDUNDANCY DISK ‘/dev/asm-fra001′ ATTRIBUTE ‘COMPATIBLE.ASM’=’12.1.0.0.0′,’COMPATIBLE.RDBMS’=’12.1.0.0.0′,’AU_SIZE’=’4M'; SQL> CREATE DISKGROUP REDO01 EXTERNAL REDUNDANCY DISK ‘/dev/asm-redo001′ ATTRIBUTE ‘COMPATIBLE.ASM’=’12.1.0.0.0′,’COMPATIBLE.RDBMS’=’12.1.0.0.0′,’AU_SIZE’=’4M'; SQL> CREATE DISKGROUP REDO02 EXTERNAL REDUNDANCY DISK ‘/dev/asm-redo002′ ATTRIBUTE ‘COMPATIBLE.ASM’=’12.1.0.0.0′,’COMPATIBLE.RDBMS’=’12.1.0.0.0′,’AU_SIZE’=’4M'; 2. Update parameter file with new Diskgroups SQL> ALTER SYSTEM SET ASM_DISKGROUPS=’FRA01′, ‘REDO01′, ‘REDO02′ SCOPE=BOTH SID=’+ASM’ 3. Configure ASM to use huge pages . oraenv ORACLE_SID = [oracle] ? MYDB001 SQL> sqlplus / as sysdba SQL> shutdown immediate; SQL> quit . oraenv ORACLE_SID = [oracle] ? +ASM SQL> sqlplus / as sysasm SQL> alter system set memory_max_target=0 scope=spfile sid=’*’; SQL> alter system set memory_target=0 scope=spfile sid=’*’; SQL> alter system set sga_target=1088M scope=spfile sid=’*’; SQL> alter system set use_large_pages=’ONLY’ scope=spfile sid=’*’; SQL> shutdown immediate; SQL> startup; SQL> quit . oraenv ORACLE_SID = [oracle] ? MYDB001 SQL> sqlplus / as sysdba SQL> startup
3/11/2017
How to Install Oracle 12c and ASM on RedHat - Oracle Database
Step-By-Step – Oracle Database Binary Install 1. Log on to Oracle 2. Unset variables unset ORACLE_BASE unset ORACLE_HOME unset GRID_HOME unset ORACLE_SID unset TNS_ADMIN 3. Install Database Software cd /u01/app/oracle/SOFTWARE/database ./runInstaller 4. Follow the instructions as detailed in the screenshots hereand when prompted run root.sh. cd /u01/app/oracle/product/12.1.0/dbhome_1 ./root.sh 5. Create a symbolic link for TNS directory entries to st op dbca from failing on DB creation and on crsct startup. cd /u01/app/oracle/product/12.1.0/dbhome_1/network/admin ln -s /u01/app/oracle/product/12.1.0/grid/network/admin/tnsnames.ora ln -s /u01/app/oracle/product/12.1.0/grid/network/admin/sqlnet.ora ln -s /u01/app/oracle/product/12.1.0/grid/network/admin/listener.ora
Step-By-Step – Oracle Database Creation 1. Log on to Oracle 2. Create the database using dbca cd /u01/app/oracle/product/12.1.0/dbhome_1/bin ./dbca
3/11/2017
How to Install Oracle 12c and ASM on RedHat - Oracle Database
3. Follow the instructions as detailed in the screenshots here
Step-By-Step – Grid and Database Patching 1. Log on as Oracle 2. Install the latest version of OPatch in the GI home and DB home unzip p6880880_121010_Linux-x86-64.zip -d /u01/app/oracle/product/12.1.0/grid unzip p6880880_121010_Linux-x86-64.zip -d /u01/app/oracle/product/12.1.0/dbhome_1 3. Check the version of OPatch
