Unzip particular file from an zip file NOTE : Sometimes we would know the archive file present in zip folder and would like to unzip only that particular file. The…
Read MoreTo check when the profile was updated. QUERY : select p.profile_option_name SHORT_NAME, n.user_profile_option_name “PROFILE NAME”, decode(v.level_id, 10001, ‘Site’, 10002, ‘Application’, 10003, ‘Responsibility’, 10004, ‘User’, 10005, ‘Server’, 10007, ‘SERVRESP’, ‘UnDef’) LEVEL_SET,…
Read MoreAPEX INSTALLATION WITH HTTP(OHS) SERVER Description: 1.We have to install first apex in our database after we have to install http(OHS) server: Apex Installation Unzip Apex files in specific PATH.…
Read MoreINTRODUCTION : This Post describes that account is locked in the standby database, even after the account was unlocked in the primary. Scenario: The user attempts to logon and gets an error ORA-28000…
Read MoreDifferences to start ASMLib on OEL 6 and 7. Quick guide to install (done on OEL 7), start and configure: 1. Install the ASMLib kernel module package as root using…
Read Moreins_emagent.mk During the installation of Oracle 11.2.0.4 on RHEL 7, I faced this error about ins_emagent.mk below: error in invoking target ‘agent nmhs’ of make file ins_emagent.mk In the installation…
Read MoreWhile installing ORACLE GRID INFRASTRUCTURE the below issue is faced. I managed to install the RMP from the grid software itself. Work Around: Locate the cvuqdisk RPM package, which is…
Read MoreTried to create disk using # oracleasm createdisk DATA1 /dev/xvdc11 oracleasm module not loaded or /dev/oracleasm not mounted. SOLUTION: # oracleasm status Checking if ASM is loaded: no Checking if…
Read MoreIssue : R12.2: Workflow Java Deferred Listener Goes Down with java.sql.SQLException: ORA-01000 ,WF_EVENT_OJMSTEXT_QH.ENQUEUE on Maximum Open Cursor Solution : To implement the solution, please execute the following steps: 1. Download…
Read MoreIssue : RMAN Backup of SPFILE Returns Error ORA-17507: I/O request size 512 is not a multiple of logical block size Cause : Snapshot controlfile is configured with the same…
Read More