Oracle Commands

Following information was helpful when I was in trouble running Oralce Enteprise Manager. And few other issues.

Credit should be given who ever who made available this information on the internet.


#create password file when SYSDBA users running out=============

orapwd FILE=orapworcl ENTRIES=30
select * from V$PWFILE_USERS;
orapwd file=PWDSO75R2 password=test entries=50 FORCE=Y

**============time zone issues================================
1. Check your timezone in OS (Eg. Asia/Colombo)

2. Check agents timezone using "emctl config agent getTZ" (Eg:. Asia/Calcutta)

remember these timezones must be tally and values should be compatible with "app/oracle/product/11.2.0/db_1/sysman/admin/supportedtzs.lst";.

3. Reset the timezone using 'emctl resetTZ agent' and follow the instruction to run the script required, as sysman user

4. Update timezone using 'emctl config agent updateTZ'

5. Check the updated TZ using 'emctl config agent getTZ'

6. emctl reload agent

7. emctl status agent (Agent should be up and running)

8. emctl stop dbconsole

9. emctl start dbconsole

#to recreate repository================
emca -config dbcontrol db -repos recreate