This Site Create for Help Tech guys in Issues and fixes in Linux SAP and Oracle.

Search This Blog

Powered by Blogger.

Create Client in SAP

First Create Client via SCC4 THEN COPY Client via SCCL profile SAP_CUST After copy login into Client 000 and export default users t...

Set Oracle user expiry unlimted


ALTER PROFILE "DEFAULT" LIMIT
  SESSIONS_PER_USER UNLIMITED
  CPU_PER_SESSION UNLIMITED
  CPU_PER_CALL UNLIMITED
  CONNECT_TIME UNLIMITED
  IDLE_TIME UNLIMITED
  LOGICAL_READS_PER_SESSION UNLIMITED
  LOGICAL_READS_PER_CALL UNLIMITED
  COMPOSITE_LIMIT UNLIMITED
  PRIVATE_SGA UNLIMITED
  FAILED_LOGIN_ATTEMPTS 10
  PASSWORD_LIFE_TIME UNLIMITED
 PASSWORD_REUSE_TIME UNLIMITED
  PASSWORD_REUSE_MAX UNLIMITED
  PASSWORD_LOCK_TIME 1
  PASSWORD_GRACE_TIME 7
  PASSWORD_VERIFY_FUNCTION NULL;

to verify


column limit format a20

select profile,resource_name,limit from dba_profiles where profile='DEFAULT';

0 comments:

Post a Comment