Archive for

Standard Practice to build an Oracle 11g R2 Database Server (Keep Add on)

Standard Practice to build an Oracle Database Server 1) Re-locate the sys.aud$ to a dedicated tablespace 2) Using spfile instead of pfile 3) If the database use as production database, set the database to archivelog mode

Forcing user to re-set the password after the first login (SLES11)

Login to the Linux Server as root or super users Open another terminal screen and try to login with the login name and old password The Linux now will ask the user to change the password after the old password has been entered correctly.