Unified Auditing in Oracle 12c

Unified Auditing is new audit feature came with Oracle 12c version. You have to do enable Unified Auditing to use after install database. Unified Auditing come as disabled by default. In previous releases of Oracle Database, there were separate audit trails for individual components: SYS.AUD$ for the database audit trail, SYS.FGA_LOG$ for fine-grained auditing, DVSYS.AUDIT_TRAIL$ […]

5,800 total views, 8 views today

Oracle 12c R2 (12.2.0.1) Real Time Apply Data Guard Installation on Oracle Linux 7.3

Oracle Data Guard ensures high availability, data protection, and disaster recovery for enterprise data. Oracle Data Guard provides a comprehensive set of services that create, maintain, manage, and monitor one or more standby databases to enable production Oracle databases to survive disasters and data corruptions. Oracle Data Guard maintains these standby databases as copies of […]

10,156 total views, 12 views today

TNS-12547: TNS:lost contact and Linux Error: 32: Broken pipe While Connect Oracle 12c Data Guard

I installed Oracle 12c Data Guard, everything was okey. But, I got an error like below when I wanted to connect data guard database with Toad or SQL Developer. tnsping was okey. Error SQL Developer : Status : Failure -Test failed: IO Error: Got minus one from a read call Listener.log 10-OCT-2017 15:01:16 * (CONNECT_DATA=(CID=(PROGRAM=SQL […]

17,855 total views, 20 views today

Oracle 12c R2 Downloadable Now

You can download Oracle 12c R2 database now. Only Linux x64 and Solaris Operation Systems supported for now. You can download with below link; http://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html Also you can find new features about of Oracle 12c R2 with below links; https://docs.oracle.com/database/122/ https://blogs.oracle.com/sql/entry/12_things_developers_will_love 2,467 total views, 4 views today

2,467 total views, 4 views today

ORA-65096: invalid common user or role name Oracle 12c

Error Oracle gives error when user creation Oracle 12c version. SQL Error: ORA-65096: invalid common user or role name 65096. 00000 –  “invalid common user or role name” *Cause: An attempt was made to create a common user or role with a name that was not valid for common users or roles.  In addition to […]

760 total views, 15 views today

Oracle 12c : RMAN New Features and Enhancements

 1. Fine Grained Recovery With Oracle Database 12c, you can use a simple RECOVER TABLE command to perform a point-in-time recovery of a table/partition without having to go through a manual point-in-time recovery process. This command automatically performs the following steps: creation of the auxiliary instance, table recovery, exporting of the object, and importing it […]

6,675 total views, 10 views today