EXACS: Creating an 11g Database Home
Chanaka-dbhelp Blog
by
1w ago
  Intro Oracle Exadata Cloud Service (ExaCS) historically supported Oracle Database 11g, but with recent updates, Oracle has phased out support for older database versions like 11g in ExaCS. While existing Oracle Database 11g instances may continue to run, it is no longer possible to provision new Oracle 11g databases on Exadata Cloud Service through the Oracle Cloud Infrastructure (OCI) console. Oracle encourages users to upgrade to more recent supported versions, such as Oracle Database 19c or 23ai, to leverage enhanced features, security, and performance improvements. Some customer ..read more
Visit website
EXACS: Resolving PDB Console Issue
Chanaka-dbhelp Blog
by
1w ago
  Intro  The roles of DBAs and architects are continually evolving, becoming more technical and requiring broader expertise. For Oracle DBAs, it's no longer just about managing databases; there's a growing need to understand and work with the OCI (Oracle Cloud Infrastructure) GUI as well. This is because many OCI services depend on the database being properly visible in the OCI console to function correctly. Recently, I faced an issue after migrating a database from on-premises to the cloud in an Exadata Cloud@Customer (ExaCS) deployment. The pluggable database (PDB) did not a ..read more
Visit website
Exacs database creation using dbaascli
Chanaka-dbhelp Blog
by
2M ago
  Intro OCI (Oracle Cloud Infrastructure) provides robust automation capabilities for routine maintenance tasks such as patching, creating database homes, and server OS updates. Oracle further simplifies these tasks by handling the staging process, reducing the administrative burden. Additionally, Oracle has introduced several tools to streamline maintenance and management tasks, including: dbaascli exacli dbcli exadbcpatchmulti dbaascli is a command-line utility for managing Oracle Database Cloud Services (DBaaS) instances. Mainly for Oracle Exadata cloud services. It provides ..read more
Visit website
Oracle world 2024 - AI
Chanaka-dbhelp Blog
by
6M ago
  Intro  The world is transitioning from the data era to the age of artificial intelligence. Many organizations are leveraging AI features to gain a competitive edge and expand their market share. Oracle 23c AI introduces a wide array of AI-driven features to support this shift. With Oracle CloudWorld just around the corner, the event will be a key platform to showcase the power and potential of AI in transforming businesses. Oracle CloudWorld 2024 is set to take place from September 9 to 12 in Las Vegas at the Caesars Forum Convention Center. This major event will bring togethe ..read more
Visit website
Oracle 23ai : True Cache
Chanaka-dbhelp Blog
by
6M ago
  Intro In today’s fast-paced digital landscape, speed is paramount. Users expect instant responses, and applications must seamlessly handle high traffic and demanding workloads. Oracle databases, often the backbone of critical systems, bear the weight of these performance demands. Fortunately, Oracle Database has a powerful solution: True Cache, an advanced in-memory caching technology designed to optimize database performance and enhance application efficiency. What is Oracle True Cache?  True Cache is a fast storage layer that temporarily holds frequently accessed data from ..read more
Visit website
Troubleshoot ODA Repo Issue
Chanaka-dbhelp Blog
by
6M ago
  Intro  If you found previous blog posts helpful for addressing ODA upgrade issues on virtualization platforms, the following article will ease your journey toward the 19.8 upgrade. Article on Upgrades and Issues: ODA upgrade 12.1.2.12 to 18.3.0.0 -- Journey to 19.9.0.0 - Part 1 Virtualized ODA upgrade 18.3.0.0 to 18.8.0.0 - Journey to 12.1.2.12 - 19.13.0.0 - Part 2 Virtualized ODA upgrade 18.8.0.0 to 19.8.0.0 - Journey to 12.1.2.12 - 19.13.0.0 - Part 3 ODA upgrade issues for - 12.1.2.6 to 12.1.2.10  ODA virtualized upgrades are always challenging, with unexpected i ..read more
Visit website
KVM Upgrade issue : 4.4.10.22– 4.4.10.30
Chanaka-dbhelp Blog
by
7M ago
  Intro Virtualization has significantly transformed the IT industry by enhancing the efficient utilization of server resources. Despite the rapid adoption of cloud technology, many organizations hesitate to migrate their workloads to the cloud due to concerns regarding data sensitivity and operational challenges. For such businesses, virtualization continues to be the preferred solution, offering substantial cost savings in capital expenditure (CapEx) and a secure operational environment. Ensuring the security of critical database workloads hosted in virtualized environments is p ..read more
Visit website
Oracle 23ai : SQL Firewall - Part 2
Chanaka-dbhelp Blog
by
7M ago
  Intro We live in the data era, where every organization invests significant resources in securing its IT infrastructure. Protecting data is crucial because modern businesses rely heavily on data analysis. Ensuring the security of sensitive data has become the primary responsibility of security engineers and database administrators. Due to the critical nature of this data, hackers often attempt to gain control through : SQL injection attacks  Compromised accounts.  Even though OCI introduced Web Application Firewalls (WAFs) to mitigate SQL injection attacks, attackers ca ..read more
Visit website
Measuring Storage Performance for Oracle DBs
Chanaka-dbhelp Blog
by
7M ago
  Intro Storage vendors often provide extensive product performance data, but this information may not accurately predict how the storage will perform with an Oracle database. This article offers practical methods to evaluate storage system performance, including Oracle-provided utilities. There are two main methods to analyze the performance of storage. Oracle Orion Oracle procedure: DBMS_RESOURCE_MANAGER.calibrate_io. I will show you how to measure IO using both methods in this article.  The easiest way to use procedure DBMS_RESOURCE_MANAGER.calibrate_io.  In Orac ..read more
Visit website
Data guard : RMAN-06571: datafile 1430 does not have recoverable copy
Chanaka-dbhelp Blog
by
7M ago
  Intro  In the current data-driven era, businesses leverage data analysis to seize opportunities and gain a competitive edge. This makes it crucial for organizations to have a robust disaster recovery (DR) plan. Oracle Data Guard offers significant flexibility for maintaining data synchronization with the primary database. Additionally, it allows opening the database in snapshot standby mode for testing purposes, ensuring the standby database is reliable and up-to-date. In this article, I will discuss the issues encountered while rebuilding a standby database. While attempt ..read more
Visit website

Follow Chanaka-dbhelp Blog on FeedSpot

Continue with Google
Continue with Apple
OR