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