We can connect to database servers in Oracle Cloud environment or other linux servers using ssh private key. After creating a server or database deployment, …
Read More »ORACLE
How To Create SSH Key Pair for Oracle Cloud
We connect to all servers that we create in Oracle Cloud environment with ssh public and private key. When creating our database server or normal …
Read More »How To Create an Oracle Cloud Database
Creating a new instance using Oracle Database Cloud Service on Oracle Cloud is called database deployment. It is possible to simply create a database and …
Read More »How To Check Archive Log Size Generated per day in Oracle
If the Oracle database is in archive log mode, the redo logs are copied as archive files. Archive files will be transferred to the directory …
Read More »Diagsnap in Oracle 12c
What is Diagsnap in Oracle 12c Diagsnap is a new feature introduced in 12.1.0.2 GI, which manages the diagsnap resource, which collects additional operating system …
Read More »How To List Applied Patches in Oracle
You can list applied patches in Oracle by query except for “opatch”. You can use DBA_REGISTRY_HISTORY for databases 11g and earlier, and DBA_REGISTRY_SQLPATCH for databases …
Read More »ORA-44787: Service cannot be switched into
If you have created and enabled a new service and then created a pluggable database, you may receive this error if you want to switch …
Read More »How To Reset ILOM SP(Service Processor) of Exadata Compute and Cell Node
We can reset the ILOM SP of compute nodes and cell nodes as follows: You can connect to the Ilom IP via ssh and run …
Read More »How To Connect to Container database (CDB) and Pluggable databases (PDB) in Oracle 12c
Connect to Root Container The connection to the root container is the same as connecting to the database instance in previous versions. Connection can be …
Read More »Exadata – Disk Scrubbing Feature
Disk scrubbing exists on Exadata cell nodes to automatically repair the failed sector of the disk when the system is idle without compromising system performance. …
Read More »