Search This Blog

Oracle articles

Administration:

- Move datafile
- Flashback archive (Oracle 11g)

- Manage your tablespaces, useful queries
- Archivelog activity
- Monitoring indexes

- Create a new Oracle database from cold backup
- Drop an Oracle database

- Oracle DB ratios explained


RMAN:

- Restore datafile with RMAN
- Restore database skip tablespace
- Restore controlfile from autobackup
- Restore missing archivelog

Install / setup:

- Configure Oracle Enterprise Linux for an Oracle 11g install
- Install 11g on RHEL 6

- Oracle 10g dbconsole setup
- Install Oracle Grid Control 11g
- Reinstall datapump on 10g

- PHP with oci8 support on centos


Ora errors:

- TNS-12535: TNS:operation timed out:
- TNS-03505: Failed to resolve name

- ORA-00059: maximum number of DB_FILES exceeded
- ORA-01031: Insufficient privileges

- SHUTDOWN: waiting for active calls to complete


Packages help:

- DBMS_CRYPTO
- DBMS_LOGMNR







No comments:

Post a Comment