Archive for August, 2013

Data File Rename/Move in Oracle Active Data Guard Environment

Data File rename or move activity is not applied automatically to standby Database even if STANDBY_FILE_ MANAGEMENT is set to AUTO. When STANDBY_FILE_MANAGEMENT initialization parameter to AUTO, use of the following SQL statements is not allowed:


ALTER DATABASE RENAME .. 
ALTER DATABASE ADD/DROP LOGFILE ..
ALTER DATABASE ADD/DROP STANDBY LOGFILE MEMBER ..
ALTER DATABASE CREATE DATAFILE AS ..

Continue reading

Advertisements

Enable Password Never Expire feature in Oracle

First of all, detect profile name of the target user to set password never expire.


SQL> select profile from DBA_USERS where upper(username) = upper('rman');

PROFILE
------------------------------
DEFAULT

Modify target user profile using this .


SQL> alter profile DEFAULT limit password_life_time UNLIMITED;

Profile altered.

Now, check out user expiry_date.


SQL> select username,expiry_date,account_status from dba_users where upper(username) = upper('rman');

USERNAME                       EXPIRY_DA ACCOUNT_STATUS
------------------------------ --------- --------------------------------
RMAN                                     OPEN


Thanks
A Rahim Khan