Silent Installation of Oracle database Preface This paper is for silent installation of Oracle Database Practice and Experience of the process of recording. Installation of 10g of silence which is conducted in RHEL AS3U4, 9i silent installation practice is in Windows XP Professional (SP2) on the. 9i installed three common CD-ROM, Oracle installing customized specifically…
RMAN – Veritas NetBackup Integration I just recently got RMAN working with NetBackup. I have been asked to document this at work . Coincidently it makes for a great blog post! #1. It is very important that you document things and how they are done so that other people can learn how to do them,…
Follow Operating System Requirements for OEL 5.x or RHEL 5.x 1. The following packages (or later versions) must be installed on your Linux x86 or Linux x86-64 system: binutils-2.16.91.0.5-23.4 gcc-4.1.0-28.4 gcc-c++-4.1.0-28.4 glibc-devel-2.4-31.2 libgcc-4.1.0-28.4 libstdc++-devel-4.1.0-28.4 libstdc++-4.1.0-28.4 make-3.80-202.2 compat-db 4.1.25-9 2. Ensure that libXp has been installed. The package libXp was not installed in RHEL 5/OEL 5…
How to check if an rpm package is installed on a Red Hat Linux server rpm check, check if package is installed, red hat linux Maintaining a server up-to-date requires regular rpm checks. Each time Red Hat releases a newer version of, for example, samba rpm (and requisites) with fixes for known vulnerabilities one needs…
/* Query to find out if any patch except localisation patch is applied or not, if applied, that what all drivers it contain and time of it’s application*/ select A.APPLIED_PATCH_ID, A.PATCH_NAME, A.PATCH_TYPE, B.PATCH_DRVIER_ID, B.DRIVER_FILE_NAME, B.ORIG_PATCH_NAME, B.CREATION_DATE, B.PLATFORM, B.SOURCE_CODE, B.CREATIONG_DATE, B.FILE_SIZE, B.MERGED_DRIVER_FLAG, B.MERGE_DATE from AD_APPLIED_PATCHES A, AD_PATCH_DRIVERS B where A.APPLIED_PATCH_ID = B.APPLIED_PATCH_ID and A.PATCH_NAME = ‘<patch…
As far as I have recently read, Oracle doesn’t allow you to set some physical features of sub-partitions such as compression clause. I have been mistaken that composite partitioned tables can not be compressed at all. However in data warehouse environments, a general requirement is being able to compress segments of historic partitions of RANGE…
Forms compilation errors parameter Recently all custom forms compilation failed with errors like these: FRM-18108: Failed to load the following objects. Source Module:APPSTAND Source Object: STANDARD_PC_AND_VA Source Module:APPSTAND Source Object: STANDARD_TOOLBAR Source Module:APPSTAND Source Object: STANDARD_CALENDAR Compiling package specification APP_CUSTOM… No compilation errors. or Compiling KEY-NXTBLK trigger on QUERY_FIND data block… Compilation error on KEY-NXTBLK…
The formula used (assuming a conservative TCP/IP network overhead of 30%) for calculating the network bandwidth is : Required bandwidth = ((Redo rate bytes per sec. / 0.7) * 8) / 1,000,000 = bandwidth in Mbps Let us assume the redo rate is a 500 KB/sec. Required bandwidth = ((Redo rate bytes per sec. /…
You may remove Oracle Portal 3.0.9 only if you are not using Oracle Portal with E-Business Suite 11i or if you have migrated existing Oracle Portal 3.0.9 functionality to Oracle Portal 10g . It is recommended that the removal of Oracle Portal 3.0.9 be done only after the migration to Oracle Portal 10g. To remove…