Database Blog

Extract a particular file from an zipped archive file to a given directory.

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 More

Query to check when the profile was updated

To 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 More

APEX INSTALLATION WITH HTTP(OHS) SERVER

APEX 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 More

ORA-28000 “the account is locked” in the standby database

INTRODUCTION : 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 More

Installing and Configuring ASMLIb on Oracle Linux 7

Differences 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 More

How to Resolve Error in invoking target ‘agent_nmhs’ of makefile ins_emagent.mk

ins_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 More

error: package cvuqdisk is not installed – grid installation

 While 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 More

oracleasm module not loaded or /dev/oracleasm not mounted

Tried 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 More

R12.2: Workflow Java Deferred Listener Goes Down with java.sql.SQLException: ORA-01000 ,WF_EVENT_OJMSTEXT_QH.ENQUEUE on Maximum Open Cursor

Issue :  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 More

RMAN Backup of SPFILE Returns Error ORA-17507: I/O request size 512 is not a multiple of logical block size

 Issue : 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