Using EXP/IMP Migrate Oracle 9i to 11g
Using EXP/IMP Migrate Oracle 9i to 11g Preparation Check the size of the segment, the number of objects, the job, and the record count of all tables. @db_migrate_precheck_v1.0.sql Tablespaces. @get_create_tablespace_v1.0.sql@create_tablespace.sql Users and privileges. SET LONG 2000000SET PAGES 0exec DBMS_METADATA.SET_TRANSFORM_PARAM(DBMS_METADATA.SESSION_TRANSFORM, 'SQLTERMINATOR', TRUE);exec DBMS_METADATA.SET_TRANSFORM_PARAM(DBMS_METADATA.SESSION_TRANSFORM, 'PRETTY', TRUE);SELECT dbms_meta...
Configuring Storage Device Path Persistence Using UDEV on RHEL
Configuring Storage Device Path Persistence Using UDEV on RHEL For Oracle Automatic Storage Manager (ASM) to use disks, it needs to be able to identify the devices consistently and for them to have the correct ownership and permissions. In Linux you can use ASMLib to manage these tasks, but it is seen as an additional layer of complexity and has never really gained any popularity. Instead, many people use the Linux device manager "udev" to perform these tasks. This article presents a brief o...
db_install_11g.rsp
db_install_11g.rsp ###################################################################### Copyright(c) Oracle Corporation 1998,2013. All rights reserved.#### #### Specify values for the variables listed below to customize #### your installation. #### #### Each variable is associated with a comment. The comment ###...
Deinstall Oracle RAC Database
Deinstall Oracle Database 11g and latest SI Delete oracle instance. dbca -silent -deleteDatabase \ -sourceDB orcl \ -sysDBAUserName sys \ -sysDBAPassword oracle 11g and latest RAC Remove ORACLEHOME∗∗and∗∗ORACLE_HOME** and **ORACLEHOME∗∗and∗∗GRID_HOME. rm -rf /u01/app/grid/*rm -rf /u01/app/11.2.0/grid/*rm -rf /u01/app/oraInventory/*rm -rf /u01/app/oracle/* Remove oracle files. rm -rf /tmp/.oraclerm -rf /var/tmp/.oraclerm -f /etc/init/oracle-ohasd.confrm -f /etc/init.d/ohasdrm -f /...
dbca_11g.rsp
dbca.rsp ################################################################################ #### DBCA response file #### ------------------ #### Copyright 1998, 2014, Oracle Corporation. All Rights Reserved. #### #### Specify values f...
Installing Oracle Database 10.2.0.5 on CentOS 7.9
Installing Oracle Database 10.2.0.5 on CentOS 7.9 Operating System: CentOS 7.9 Database Software: 10201_database_linux_x86_64.cpio Database Patches: p8202632_10205_Linux-x86-64.zip Operating System Package Requirements Checking Package Requirements. rpm -q --qf '%{NAME}-%{VERSION}-%{RELEASE} (%{ARCH})\n' \make gcc glibc glibc-devel compat-db compat-gcc compat-gcc-c++ \compat-libstdc++ compat-libstdc++-devel gnome-libs openmotif21 setarch \libaio libaio-devel Installing Packages. yum -y i...
Installing Oracle Database 11.2.0.3 RAC on OL 7.4
Installing Oracle Database 11.2.0.3 RAC on OL 7.4 Operating System: Oracle Linux Server 7.4 Oracle Database: p10404530_112030_Linux-x86-64_{1..3}of7.zip Database Patches: Packages Requirements rpm -q --qf '%{NAME}-%{VERSION}-%{RELEASE} (%{ARCH})\n' \bc binutils elfutils-libelf elfutils-libelf-devel fontconfig-devel \glibc glibc-devel ksh libaio libaio-devel libXrender libX11 libXau \libXi libXtst libgcc libnsl librdmacm libstdc++ libstdc++-devel \libxcb libibverbs make smartmontools syss...
Installing Oracle Database 11.2.0.3 on OL 7.4
Installing Oracle Database 11.2.0.3 on OL 7.4 Operating System: Oracle Linux Server 7.4 Oracle Database: p10404530_112030_Linux-x86-64_{1..2}of7.zip Database Patches: Oracle Oracle Single Instance Requirements rpm -q --qf '%{NAME}-%{VERSION}-%{RELEASE} (%{ARCH})\n' \bc binutils elfutils-libelf elfutils-libelf-devel fontconfig-devel \glibc glibc-devel ksh libaio libaio-devel libXrender libX11 libXau \libXi libXtst libgcc libnsl librdmacm libstdc++ libstdc++-devel \libxcb libibverbs make s...
Installing Oracle Database 19.3.0.0 on RHEL 8.7
Installing Oracle Database 19.3.0.0 on RHEL 8.7 Operating System: RHEL 8.7, 8.10 Database Software: LINUX.X64_193000_db_home.zip Oracle Oracle Single Instance Requirements rpm -q --qf '%{NAME}-%{VERSION}-%{RELEASE} (%{ARCH})\n' \bc binutils elfutils-libelf elfutils-libelf-devel fontconfig-devel \glibc glibc-devel ksh libaio libaio-devel libXrender libX11 libXau \libXi libXtst libgcc libnsl librdmacm libstdc++ libstdc++-devel \libxcb libibverbs make smartmontools sysstat unzip xorg-x11-xa...
Installing Oracle Database 19.3.0.0 RAC on RHEL 8.7
Installing Oracle Database 19.3.0.0 RAC on RHEL 8.7 Operating System: RHEL 8.7 Database Software: LINUX.X64_193000_grid_home.zip, LINUX.X64_193000_db_home.zip Oracle Standalone Cluster Requirements Minimum Available Space Requirements for Oracle Standalone Cluster With GIMR Configuration Redundancy Level DATA Disk Group MGMT Disk Group Oracle Fleet Patching and Provisioning Total Storage External 1 GB 28 GB Each node beyond four: 5 GB 1 GB 30 GB Normal 2 GB 56 GB Each node beyond...
