Unlock user command for Oracle Database

Sometime a user gets locked and can not log in to database. To unlock it we need to run following command.

SQL> alter user username identified by Password account unlock;
User altered.
SQL>

Read More

Oracle Database 12C and some of its features. Database 12c and Cloud Computing

Oracle Database 12c released with new and interesting features. Oracle is saying that it is a multitenant database for the cloud. Oracle continuously improving and enhancing its products and technologies to fulfill the customer requirements. Oracle provide a new architecture for its database for cloud called Oracle multitenant.
    According to  Oracle President Mark Hurd
                     “Just as virtualization lets you turn a physical
                      server into a collection of virtual machines,
                      Oracle Multitenant lets you turn a physical
                      Oracle database into a collection of pluggable
                     databases, each of which looks and feels like
                     a physical Oracle database to the applications
                    with which it is associated,” .
 Application can run in a secure isolated environment. Oracle added more than 500 feature to transform how organizations store, manage and use information's. following are some prominent features

1) Automatic data optimization
2) Defence in-depth security
3) High availability for database cloud
4) Aministrative effeciencies for DBAs
5) Robust analysis of Big data

Read More