Running Oracle on Docker

I must thank my fellow DBA Franky Weber Faust for his publication in his blog. If you want to know about Basic about Docker in the Oracle Hi everyone, here in a very brief post I will show you how to upload Oracle in a Docker container. Following the DevOps wave, this week I’m doing a course and knowing […]

Read More

Storage Volumes and File System Layout in Oracle Cloud

This section provides information about the storage volumes and file system layout of a newly created database deployment on Oracle Database Cloud Service. Compute Cloud Service Storage Volumes When a Database Cloud Service deployment is created using the Oracle Database Cloud Service service level, the following storage volumes are created. Storage Volume Description bits 60 GB volume completely […]

Read More

Explain usage of different users in Oracle Cloud

This article provides information about Linux user accounts that are provisioned on Oracle Database Cloud Service. Every Database Cloud Service compute node is provisioned with the following operating system user accounts. Both compute nodes are provisioned with the following operating system user accounts. opc: The system administrator account you use with the sudo command to perform operations that […]

Read More

List of other Certification earned

Skant Gupta is certified for: Microsoft Microsoft® Certified Technology Specialist: SQL Server® 2005 Microsoft® Certified Solutions Associate: Office 365 (MCSA) Microsoft® Specialist: Server Virtualization with Windows Server Hyper-V and System Center Specialist Microsoft® Certified Professional IBM IBM Certified Deployment Professional – Tivoli Directory Server V6.1 IBM Certified Associate Developer — Rational Application Developer for WebSphere Software […]

Read More

Oracle Exadata 18c and Database Machine X7-2

Oracle Exadata Database Machine consists of Oracle Database servers, Exadata Storage Servers, and the network components to connect to your network. Oracle Exadata Database Machine is available as a full rack, half rack, quarter rack or eighth rack. The following table lists the components included for each type of Oracle Exadata Database Machine. Components of […]

Read More

ARCH wait on SENDREQ

PROBLEM: ARCHIVE process get hang on Primary Database The problem has been that the standby hardware have some faulty backpane. This has caused processes in the standby to go into what is called as “D” state where the processes gets stuck in a kernel call. So the RFS processes on the standby are getting hung […]

Read More

Oracle 18c: How to load data in Oracle Autonomous Data Warehouse Cloud

This article was written by Skant Gupta and Joel Perez in Oracle OTN. Full Index of Oracle Cloud Articles: Sir.CloudDBaaSjoelperez If you want to be updated with all our articles send us the Invitation or Follow us: Joel Perez’s LinkedIn: www.linkedin.com/in/SirDBaaSJoelPerez Skant Gupta’s LinkedIn: www.linkedin.com/in/skantali/ or Join our LinkedIn group: Oracle Cloud DBaaS Loading Data into Autonomous Data Warehouse Cloud Database   Data […]

Read More

Read the Trace file from SQL Plus

Find trace file in Oracle The following script returns the path to the trace file that the current session writes. It returns the path whether or not tracing is enabled.

Check the value for user_dump_dest

Create a directory

Create a function

Now just the select the trace file name.

Thank you for giving your valuable […]

Read More