DATABASE SIZE (datafiles + tempfiles + redologfiles)
To get accurate size of the database, We have to combined the sizes of all datafiles, tempfiles and redologfiles. select round ((++)/1024/1024/1024,2) “DB_size_in_GB” from ( select sum(bytes) data_size from dba_data_files…
Function not available to this responsibility : When accessing CUSTOM FORM
After fresh clone, Application technical team used to report that ‘Function not available to this responsibility’ error when they are trying to access custom form. CAUSE: Missing the entry of…
EBS LOGIN URL from database:
Connect to apps user $sqlplus apps/apps QUERY 1: SELECT home_url FROM icx_parameters; QUERY 2: SELECT profile_option_value FROM fnd_profile_option_values WHERE profile_option_id= (SELECT profile_option_id FROM fnd_profile_options WHERE profile_option_name = ‘APPS_FRAMEWORK_AGENT’) AND…
DATABASE HANGS
ERROR MESSAGE IN ALERTLOG FILE: ORACLE Instance PROD – Archival Error ORA-16038: log 4 sequence# 9961 cannot be archived ORA-19502: write error on file “”, block number (block size=) ORA-00312:…
RMAN COLD BACKUP AND RESTORE
Simple RMAN script to take cold database backup: For taking RMAN cold database backup, Database should be in mount status, Which can be noticed from below scipt. mkdir -p /BACKUP/PROD…
NID Utility in Oracle – RENAME DATABASE
DBNEWID (NID) utility was introduced in Oracle 10g, Which can change the database identifier (DBID) and the database name (DBNAME). NID utility allows us to change Only DBID Only DBNAME…
ORA-27125: unable to create shared memory segment when run DBCA
I have installed 10gR2 on linux environment, When running DBCA it got filed with below error ORA-27125: unable to create shared memory segment SOLUTION: cd $ORACLE_HOME/bin mv oracle …
ORA-01031: insufficient privileges when connect as sysdba
Not able to connect Oracle database, When issue command — > sqlplus “/ as sysdba” $ sqlplus “/ as sysdba” SQL*Plus: Release Production on Wed Jan 22 02:09:17 2014 Copyright…
Create New Application user from existing user in EBS R12
We can create new application user from existing user with same responsibility, Which can be achieved from FNDLOAD utility. Here I would like to create new user with name ‘APPADMIN’…
REP-0004: Warning: Unable to open user preference file
Symptoms: All concurrent requests that run REPORTS are printing the following warning in the request log. “REP-0004: Warning: Unable to open user preference file” Your local (customized) Oracle Reports preference…