If the setting “password must meet complexity requirements” is greyed outand you don’t have privileges on the domain to change the group policy,you can change the setting for the local server only as follows: Go to a command prompt and… Continue Reading
SQL> DECLARE jobno number; instno number;BEGIN SELECT instance_number INTO instno FROM v$instance; DBMS_JOB.SUBMIT(jobno, ‘statspack.snap(i_snap_level => 7);’, trunc(sysdate,’HH24′)+((floor(to_number(to_char(sysdate,’MI’))/30)+1)*30)/(24*60), ‘trunc(sysdate,”HH24”)+((floor(to_number(to_char(sysdate,”MI”))/30)+1)*30)/(24*60)’, TRUE, instno); COMMIT;END;/
Unlike older releases, Oracle 11g and later sets password expiry by default. So let’s get rid of the annoyance with: ALTER PROFILE DEFAULT LIMITFAILED_LOGIN_ATTEMPTS UNLIMITEDPASSWORD_LIFE_TIME UNLIMITED; And, optionally, let’s turn off the default auditing: NOAUDIT ALL;DELETE FROM SYS.AUD$;
Welcome to my new blog. I will be posting stuff here that amuses me. Probably. If it’s 2023 already and this is the only post, then you will know I’ve abandoned this project……… (update: 04-January-2023: The blog is empty. Let’s… Continue Reading