The SQLAccess Advisor
DBMS_ADVISOR :- 1. Gather a number of SQL statements that will form the tuning workload. 2. Check that the user running DBMS_ADVISOR has the ADVISOR privilege, and has SELECT access…
Read MoreAPP-FND-01542: This Applications Server is not authorized to access this database.
By default in Oracle Applications R12, users are not able to access Forms directly via the following url: http://hostname:port/forms/frmservlet The following error would pop out: APP-FND-01542: This Applications Server is…
Read MoreAlert Log:Warning: VKTM detected a time drift,Time drifts can result in an unexpected behavior such as time-outs.
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
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 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 More