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 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...
dbca_11g.rsp
dbca.rsp ################################################################################ #### DBCA response file #### ------------------ #### Copyright 1998, 2014, Oracle Corporation. All Rights Reserved. #### #### Specify values f...
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...
Installing Oracle Database 9.2.0.8 on RHEL 4.8
Installing Oracle Database 9.2.0.8 on RHEL 4.8 Operating System: RHEL4.8-x86_64-AS Database Software: amd64_db_9204_Disk{1..3}.cpio.gz Database Patches: p4547809_92080_Linux-x86-64.zip Requirements rpm -q --qf '%{NAME}-%{VERSION}-%{RELEASE} (%{ARCH})\n' \gcc glibc-kernheaders glibc-headers glibc-devel compat-gcc-32 compat-gcc-32-c++ \libstdc++-devel glibc-devel libaio Install packages. mkdir /mnt/rhisomount /dev/cdrom /mnt/rhisocd /mnt/rhiso/RedHat/RPMS/rpm -ivh gcc-3.4.6-11.x86_64.rpmrpm...
Oracle database preinstall 11g rpm
Oracle database preinstall 11g rpm Installing the Oracle Preinstallation RPM [root@rac-1 ~]# yum -y install oracle-rdbms-server-11gR2-preinstall.x86_64[root@rac-1 ~]# cat /var/log/oracle-rdbms-server-11gR2-preinstall/results/orakernel.logAdding group oinstall with gid 54321Adding group dbaAdding user oracle with user id 54321, initial login group oinstall, supplementary group dba and home directory /home/oracleChanging ownership of /home/oracle to oracle:oinstallPlease set password for ora...
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...
Oracle database preinstall 19c rpm
Oracle database preinstall 19c rpm Installing the Oracle Preinstallation RPM Use Oracle Preinstallation RPM to simplify operating system configuration in preparation for Oracle software installations. When installed, the Oracle Preinstallation RPM does the following: Automatically downloads and installs any additional RPM packages needed forinstalling Oracle Grid Infrastructure and Oracle Database, and resolves anydependencies Creates an oracle user, and creates the oraInventory (oinsta...
Oracle Database Endian Format
Oracle Database Endian Format SQL> select * from v$transportable_platform order by platform_id;PLATFORM_ID PLATFORM_NAME ENDIAN_FORMAT----------- ---------------------------------------- -------------- 1 Solaris[tm] OE (32-bit) Big 2 Solaris[tm] OE (64-bit) Big 3 HP-UX (64-bit) Big 4 HP-UX IA (64-bit) Big 5 HP Tru64 UNIX ...
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...
