Category: Uncategorized

Database Net Services Administrator’s Guide -> 2 Creating and Configuring an Oracle Database (to get the parameter file 2.6.1.1 Sample Initialization Parameter File) Database Net Services Administrator’s Guide -> 9 Configuring and Administering Oracle Net Listener Database Net Services Administrator’s Guide -> 9 Configuring and Administering Oracle Net Listener -> Configuring Listening Protocol Addresses Using Oracle Enterprise Manager Cloud Control Database Net Services Reference -> 7 Oracle Net Listener Parameters in the listener.ora File (There are some listener examples in this page) Database Net Services Reference -> 6 Local Naming…

What you must to have in mind: – How to create an user; – Conceive grants for the created user; – Manage those grants through roles; – Query the information regarding the created user using views; – Understanding about local and common users also local and common profiles; – Manage tablespaces for the created user. — Users: “Common users perform administrative tasks for a CDB.” Local users exists only in the PDBs. “The root has its own data files, and each PDB has its own data files.” “There is a…

1- Create a CDB with/without DBCA: The specific methods for creating a CDB are: – With the CREATE DATABASE SQL statement. (There is a slight difference between the script to create a database with/without CDB) – You must enable PDBs (ENABLE PLUGGABLE DATABASE clause must be set to TRUE in Pfile/Spfile) ; – You must specify the names and locations of the root’s files and the seed’s files. – Seed’s files (1 of the 3 options): 1- The SEED FILE_NAME_CONVERT clause 2- Oracle Managed Files 3- The PDB_FILE_NAME_CONVERT initialization parameter…

So here we are! OCM is a goal for many Oracle DBAs but when we start wondering about the path to get there we see how difficult it is and this may do many people give up. However, with this post explaining each topic covered in the exam using my own self-study I hope to help many people to see that the secret of this exam it is nothing more than study study study … so, are you going to join me in this journey? 1. General Database and Network…