Learn Database Concepts

Assumptions : You have a some flavor of Linux operating system installed (I have used centos 6 in this example). If you cant afford a separate machine you can use Virtual box or stemware software to visualize your desktop or laptop. Assuming that you have downloaded oracle 12 software onto linux machine. If not you can download from this link   Software-Download You have full/required privileges on you Linux host. Oracle Installation Prerequisites In order to perform the installtion of oracle 12c software on Linux box you need to perform some pre-reqs, which can be done automatically or through manual updates.Please follow below instructions. Automatic Setup If you plan to use the "oracle-rdbms-server-12cR1-preinstall" package to perform all your prerequisite setup, issue the following command. #   yum install oracle-rdbms-server-12cR1-preinstall -y It will be a good option to to do an update. # yum update ******...

Creation on a CDB (Container database) creates a service named is the CDB name. This is a side effect of creating a PDB (Pluggable Database) in the CDB, a service is created inside it with a property that identifies it as the initial current container. The service is also started as a side effect of creating the PDB. Although its metadata is recorded inside the PDB, the invariant is maintained so that a service name is unique within the entire CDB. Use the Easy Connect syntax to connect to the root unless a net service name is configured in the tnsnames for the root service. . oraenv [enter cdb1 at the prompt] sqlplus sys/oracle@localhost:1521/cdb1 as sysdba show con_name show con_id Connect to the...