Renaming a pluggable database
Renaming a pluggable database After renaming the pdb we need to move the datafiles to new directory if needed.
Read MoreMasking a column using dbms_redact
Masking a column using dbms_redact To mask a sensitive data from any column using dbms_redact package. Here profile column in redactt table is masked. [oracle@tom ~]$ !sq sqlplus /…
Read Moresys and dba privileged schema over DBMS_REDACT
The sys and dba privileged schemas can view the details of columns masked using DBMS_REDACT .
Read MoreHISTORY Command from 12.2 SQL*Plus
SYNTAX HIST[ORY] [n RUN | EDIT | DEL[ETE]] | [CLEAR | LIST] Enables users to run, edit, or delete previously used SQL*Plus, SQL, or PL/SQL commands from the history list…
Read MoreGI RU stuck with error “Unable to lock Central Inventory”
GI Release Update 19.9.0.0.201020″(31750108) patch on GI Home of one of servers. I used opatchauto utility to apply this patch. Following command was run for the same: $<GI_HOME>/OPatch/opatchauto apply <PATCH…
Read MoreHow to stop/start Cost Manager
1. Go to View All Concurrent Requests form System Administrator: (N) Requests > View 2. Query on the concurrent requests for the Cost Manager as below: In Find Requests window:…
Read MoreApps password unable to change due to error “APP-FND-02704: Unable to alter user APPLSYS to change password”
Error: APP-FND-02704: Unable to alter user APPLSYS to change password. Oracle error 28003: has been detected in alterpassword2. SYS@PROD> select username,profile from dba_users where username like ‘APP%’; USERNAME PROFILE ——————–…
Read MoreWorkflow notification mailer not sending emails to users
Issue: Workflow notification mailer not sending emails to users. But mails going out from middle tier server and concurrent program report’s mail going out. Below is the fix. Rebuilding the…
Read MoreApplication clone error in R12.2: Error while executing alter_ebs_logon_trigger.sql
Issue: Recently while doing clone for R12.2 environment, faced the below issue. Configuring: Run file system…. LogFile located at /u01/apps/fs1/inst/apps/PROD_server1/admin/log/clone/run/RCloneApplyAppstier_04190811.log ERROR: Failed to configure the target system, please check the…
Read MoreHow to apply PSU patch in Grid Home
Steps to apply PSU patch in GRID Home, 1. Download the PSU patch from oracle support. 2. Check the opatch version before applying the patch. If you have older opatch…
Read More