Monthly Archives: May 2017

ORA-08004: sequence TEST_SEQ.NEXTVAL exceeds MAXVALUE and cannot be instantiated

SQL> CREATE SEQUENCE test_seq START WITH 1 INCREMENT BY 1 MAXVALUE 10;  Sequence created. SQL> select test_seq.currval from dual; select test_seq.currval from dual * ERROR at line 1: ORA-08002: sequence TEST_SEQ.CURRVAL is not yet defined in this session SQL> select … Continue reading

Posted in ORA- ERRORS, SQL Scripts For DBA | Tagged , , , , , , , , , | Leave a comment

Oracle Database Time Zone

1) dbtimezone only shows the database creation time TZ offset from OS environment. For AEST, it could be either of the below depending on OS environment variable: 00:00 +10:00 ( non DST ) +11:00 ( DST ) SQL> select dbtimezone … Continue reading

Posted in Configuration, Globalization | Tagged , , , , , , , , , , , , | Leave a comment

Change the ADR retention

The default retention for SHORTP_POLICY is 720 ( HOURS ) /30 days, LONGP_POLICY is 8760 ( HOURS ) or 1 year.  The details are described below: Attribute Name Description SHORTP_POLICY Number of hours after which to purge ADR contents that have a short life. Default is … Continue reading

Posted in ADR | Tagged , , , , , , , , | Leave a comment

Tablespace Usage History Report

Please make sure you are licensed to run sqls against DBA_HIST_*, like  dba_hist_tbspc_space_usage tblusage. The length of the report depends on  AWR retention. Please refer to  “Change AWR Retention & Interval” for how to change AWR retention. SQL> show parameter CONTROL_MANAGEMENT_PACK_ACCESS … Continue reading

Posted in AWR, SQL Scripts For DBA | Tagged , , , , , , , | Leave a comment

Change the ORMB DB User Password

After the DB user password is changed by DBA, or after the ORMB schema is refreshed from other environment and need keep the password of old one. The DB user password needs to be changed as per Oracle Doc. For … Continue reading

Posted in ORMB | Tagged , , , , , | Leave a comment