Presentation and visual documents of Oracle 12C Database Administration

Guys below are the very good materials  to learn many new features of oracle 12 C....Walk around it and I'm sure you will love it.......



click here
to access the presentation material.

Below are some important links relevant to this subject:

Installing Oracle Database Software and Creating a Database :https://apex.oracle.com/pls/apex/f?p=44785:24:110997252215321:::24:P24_CONTENT_ID,P24_
PROD_SECTION_GRP_ID,P24_PREV_PAGE:6281,,24

Tutorials:-
  1. Managing Pluggable Databases using SQL Developer


https://apex.oracle.com/pls/apex/f?p=44785:24:0::NO:24:P24_CONTENT_ID,
P24_PREV_PAGE:7649,1
  • Redaction Management in Oracle SQL Developer
    • https://apex.oracle.com/pls/apex/f?p=44785:24:0::NO::P24_CONTENT_ID,P24
    _PREV_PAGE:7650,2
  • Monitoring and Tuning the Database
    • https://apex.oracle.com/pls/apex/f?p=44785:24:0::NO::P24_CONTENT_ID,P24
    _PREV_PAGE:6283,2
    https://apex.oracle.com/pls/apex/f?p=44785:24:0::NO::P24_CONTENT_ID,P24
    _PREV_PAGE:6290,2

    You can also download the Oracle Database 12c software and install it on your machines directly from the following link before you practice the HOLs.    http://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html?ssSourceSiteId=ocomen

    Comments

    Post a Comment

    Popular posts from this blog

    Image
     USER TYPES in SNOWFLAKE   "Securing is better than sorry"  It's always wiser to take precautions and secure something properly, even if it seems unnecessary, rather than risk potential problems or regret later by not being careful enough;  Snowflake have TYPE property for the USER object. This is one of the long-awaited no-brainer features we all wanted! Make sure to secure your data by securing your user first. Key things to remember  Never rely on one factor authentication(Always enroll at least in 2nd factor authentication) Old-fashioned password logins are vulnerable in today's digital world, so configure strong authentication, such as OAuth, Key pair, and federated authentications. In snowflake there are 4 properties of the user that can be set PERSON | SERVICE | LEGACY_SERVICE | NULL PERSON: Users do not have restrictions when the TYPE property is set to PERSON, NULL, or when TYPE is unset. NULL: See PERSON. SERVICE: To improve the security posture of ...
    Read more

    DATA MOVEMENT: CHALLENGE OR STRENGTH ?

      Organizations in highly regulated industries go through many business events that trigger the need for a data migration. The typical “lift and shift” approach to data migration, however, results in a considerable amount of time and resource allocation—without any concrete business value to show for it. Adlib goes beyond just automating the process of moving your data between repositories. We add value to your content before, during, and after migration, for enriched content that’s easier to find and easier to use. Oracle Data Pump  is a newer, faster and more flexible alternative to the "exp" and "imp" utilities used in previous Oracle versions. In addition to basic import and export functionality data pump provides a PL/SQL API and support for external tables. In order to use Data Pump, the database administrator must create a directory object and grant privileges to the user on that directory object. You would login to SQL*Plus as system and enter the following ...
    Read more

    Oracle RAC Split Brain/ Node Eviction

    Many people asks this question why and how nodes are evicted from cluster... Here is the simple answer.. It occurs when the instance members in a RAC fail to ping/connect to each other via this private interconnect, but the servers are all pysically up and running and the database instance on each of these servers is also running. These individual nodes are running fine and can conceptually accept user connections and work independently. So basically due to lack of commincation the instance thinks that the other instance that it is not able to connect is down and it needs to do something about the situation. The problem is if we leave these instance running, the sane block might get read, updated in these individual instances and there would be data integrity issue, as the blocks changed in one instance, will not be locked and could be over-written by another instance. Oracle has efficiently implemented check for the split brain syndrome. In RAC if any node becomes inactive, or if ot...
    Read more