IP Restriction for Oracle EBS
1. Oracle TNS Listener Security ENABLE VALID NODE CHECKING Valid Node Checking allows or denies access from specified IP addresses to Oracle services. To enable Valid Node Checking, set the …
Read MoreEvangelist – Philanthropist – Mentor
1. Oracle TNS Listener Security ENABLE VALID NODE CHECKING Valid Node Checking allows or denies access from specified IP addresses to Oracle services. To enable Valid Node Checking, set the …
Read More1.Change the GUEST user statement to the following in $CONFIG_FILE <oa_user type=”GUEST”> <username oa_var=”s_guest_user”>GUEST</username> <password oa_var=”s_guest_pass”>GUEST</password> Use upper case letters. 3. Run AP Tier Autoconfig. 4. Verify the $FND_TOP/secure/<host>.dbc file …
Read MorePatch fails with error “Error occurred in version checking”. I was apply patch on the test instance, before applying on the production instance. While apply the patch I found this …
Read MoreRaw Devices on RHEL 5 or OEL 5 Be aware that raw device technology had been deprecated in RedHat Linux 5 (RHEL5) and Oracle Enterprise Linux 5 OEL5). / Linux Kernel …
Read MoreInstalling Oracle 11g RAC on virtual servers using VMware. This post describes the installation of Oracle 11g RAC on virtual servers.Hardware The following hardware was used for the installation: Operating …
Read MoreToday I tried to login as sysdba i was given this error “ORA-01031 Insufficeint Privilege”. So I thought to write troubleshooting tips for ORA-01031 Facts About Operating System Authentication 1. …
Read MoreToday, I had cleared my IZ046 Managing Oracle on Linux for DBA’s, the exam was sechdule for 9 a.m. I was on time for the exam. The most of the …
Read MoreSimulating Asm by faking hardware 1. Faking Hardware 2. Instaling ASM Lib 3. Configuring the disks 4. Install DB & ASM instance Faking Hardware: Step 1) Here we create 4 …
Read MoreSteps for Renaming Redo Log Members Shut down the database. 1. SHUTDOWN 2. Copy the redo log files to the new location.Operating system files, such as redo log members, must …
Read MoreDatabase Statistics Statspack is different from BSTAT/ESTAT Statspack collects more data, including high-resource SQL It precalculates many ratios such as cache hit ratios, rates and transaction statistics It uses permanent …
Read More