5
Sep

Enforcing password complexity for database users

It is recommended to enforce checks and response actions for failed logins, password complexity, password expiration and password reuse.
 
Password complexity can be implemented through profiles.
 
The script for password management implementation utlpwdmg.sql can be used to create a new function to verify password complexity rules.
 
Verify Function is a quick and easy way to enforce quality of database passwords—for example, they should contain a certain number of characters, should not be identical to the username, and so on.
 
By executing this script utlpwdmg.sql, it will attach the function to the profile DEFAULT, which is the default profile for all users.
 

The following password complexity is set with the 'utlpwdmg.sql' script.
 

  • Password length less than 8
  • Password same as or similar to user
  • Password same as username reversed
  • Password same as or similar to server name
  • Password too simple
  • Password must contain at least one digit, one character
  • Password must contain at least one digit, and one character
  • Password should differ from the old password by at least 3 characters
  • Read more...

    14
    Jun

    How to Create a Read Only APPS Schema in Oracle E-Business Suite

    Create an APPS READONLY user

    There are 2 ways to achieve this:

    1) Create a user and grant select option to that user.

    This will have to be done individually for all users that you want to have as read only.

    2) Create a readonly role and assign users this role.

    This will have to be done once and then assign this role to the users.

    Read more...

    2
    Apr

    Monitoring Tablespace Size

    The following query helps us to check the total size and free space of individual tablespaces in a tabular format



    set linesize 1200
    set pagesize 1200
    column tablespace_name format a20 heading 'Tablespace'
    column sumb format 999,999,999
    column extents format 9999
    column bytes format 999,999,999,999
    column largest format 999,999,999,999
    column Tot_Size format 999,999 Heading 'Total| Size(Mb)'
    column Tot_Free format 999,999,999 heading 'Total Free(MB)'
    column Pct_Free format 999.99 heading '% Free'
    column Chunks_Free format 9999 heading 'No Of Ext.'
    column Max_Free format 999,999,999 heading 'Max Free(Kb)'
    set echo off
    PROMPT FREE SPACE AVAILABLE IN TABLESPACES
    select a.tablespace_name,sum(a.tots/1048576) Tot_Size,
    sum(a.sumb/1048576) Tot_Free,
    sum(a.sumb)*100/sum(a.tots) Pct_Free,
    sum(a.largest/1024) Max_Free,sum(a.chunks) Chunks_Free
    from
    (
    select tablespace_name,0 tots,sum(bytes) sumb,
    max(bytes) largest,count(*) chunks
    from dba_free_space a
    group by tablespace_name
    union
    select tablespace_name,sum(bytes) tots,0,0,0 from
    dba_data_files
    group by tablespace_name) a
    group by a.tablespace_name
    order by pct_free;

    Read more...

    15
    Oct

    Health Check of Oracle E-Business Suite Database

    List of tasks to be done as part of the Health Check

     

    1. Check database and application availability
    2. Check status of cluster services
    3. Monitor space availability in all tablespaces
    4. Check for errors in Database Alert log files and take appropriate action
    5. Check Concurrent Managers
    6. Check /tmp for space constraints
    7. Check invalid objects and compile if required
    8. ASM Grid Space Check
    9. Database and Application Mount points check
    10. Verify Backups
    11. Verify Gather Schema Statistics and Purge Concurrent Request and/or Manager Data Concurrent Requests are scheduled and are completing successfully

     

    Read more...

    17
    Aug

    Kill all FNDLIBR processes

    Kill all processes of FNDLIBR.

    ps -ef |grep FNDLIBR | grep -v grep | awk '{print $2}' | xargs kill -9

    Similarly, we can kill other processes as well by replacing 'FNDLIBR' with other process names.

    Kill all processes of java.

    ps -ef |grep java | grep -v grep | awk '{print $2}' | xargs kill -9

    Read more...

    Back to Top