Below message keeps repeating in Alert-log. Warning: VKTM detected a time drift. Time drifts can result in an unexpected behavior such as time-outs. Please check trace file for more details.…
Read MoreRenaming 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 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 MoreThe sys and dba privileged schemas can view the details of columns masked using DBMS_REDACT .
Read MoreSYNTAX 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 More1. 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 MoreError: 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 MoreIssue: 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 MoreIssue: 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 MoreSteps 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