ALTER PROFILE DEFAULT LIMIT
FAILED_LOGIN_ATTEMPTS UNLIMITED
PASSWORD_LIFE_TIME UNLIMITED;
To turn off the default auditing:
NOAUDIT ALL;
DELETE FROM SYS.AUD$;
posted by gurnaik at 3:25 pm
Comments Off on Password Expiry in Oracle 11g
Run SQL*Plus as system and then do:
alter system set processes=150 scope=spfile;
Then restart XE.
posted by gurnaik at 1:26 pm
Comments Off on Oracle XE ORA-12519 Error
If you have a script containing “&” characters in SQL*Plus:
set define off
posted by gurnaik at 1:57 pm
Comments Off on Oracle Script Execution and Ampersand