Cost-Effective Solution: Cloud computing eliminates the need for expensive physical infrastructure like server rooms, saving significant capital expenditure for IT companies. Scalability on Demand: With cloud computing, businesses can easily scale their resources up or down based on demand, ensuring optimal performance without over-provisioning. Streamlined Operations: Say goodbye to the hassle of maintaining hardware and managing complex IT setups. Cloud platforms offer simplified management interfaces and automated maintenance, freeing up valuable time and resources. Enhanced Security: Leadi ..read more

– The term “cloud” refers to a network or the internet. – It’s a technology utilizing remote servers on the internet for data storage, management, and access. – Cloud computing eliminates the need for local drives, enabling seamless access to data online. – Say goodbye to managing physical servers or running software applications on individual machines! Key Points: – Access files and applications from any device with internet connectivity. – Computing and storage happen on servers in data centers, not locally. – No need for hefty upfront investments in infrastructure. Examples of Cloud Service ..read more

Announcing Oracle Database 23ai: Unleashing the Power of AI for Next-Gen Data Management After years of dedicated development, Oracle is thrilled to unveil the latest milestone in database technology: Oracle Database 23ai. This release marks a significant leap forward, marrying the robust capabilities of Oracle Database with cutting-edge AI technologies, tailored for enhanced developer productivity and mission-critical data management. The focus on AI in this release of the database, that’s why Oracle decided to change the database’s name from Oracle Database 23c to Oracle Database 23ai.  ..read more

Cause: None of the known and available service handlers for requested type of server (dedicated or shared) are appropriate for the client connection. Action: Run "lsnrctl services" to ensure that the instance(s) have registered with the listener and that the appropriate handlers are accepting connections. TNS listener could not find available handler for requested type of server. This error is related with out of available Oracle processes. Then Increase the value of the PROCESSES initialization parameter. Solution: Step-1 SQL> select current_utilization, limit_value ,resource_name Fro ..read more

What’s New in OGG 21c(21.3.0) All Databases–Heartbeat TARGETONLY is supported for heterogeneous database targets. Parallel Replicat is supported for Heterogeneous Databases Integration with External Identity Management (IdM) system using OpenID/OAuth2.0 DB2 LUW–Capture and delivery for DB2 LUW 11.5 is supported DB2 for iSeries–Remote capture and delivery is supported from DB2 iSeries IBM iSeries version 7.4 is now available MySQL–MySQL Database Service (MDS) Remote Capture and Delivery Support PostgreSQL–Oracle GoldenGate Microservices Architecture supports PostgreSQL PostgreSQL 13 is support ..read more

The non-CDB architecture was deprecated in Oracle Database 12c (12.10.2). It is desupported in Oracle Database 20c. Oracle Database 20c was the first CDB-PDB release. Now there is no Oracle Database 20c. Hence, Oracle 21c will be now the first CDB-PDB only release. Oracle Database 21c is the first Oracle database release with CDB-PDB only architecture. You can’t have a non-CDB in Oracle 21c anymore. Oracle Universal Installer can no longer be used to create non-CDB Oracle Database instances in Oracle 21c. Starting with Oracle Database 21c, installation of non-CDB Oracle Database arc ..read more

Oracle 21c is out for use! DBA should focus on 19c!! -August 2021: Oracle Database 21c (21.3) released on Linux https://www.oracle.com/database/technologies/oracle21c-linux-downloads.html Oracle 21c is an innovation release so dba’s don’t get panic. DBA should be trying to get all your databases to 19c. As we know 19c support end in 2027 and 23c will be the next long-term release. Let me clear you if you don’t know what Long Term Releases & Innovation Releases. Oracle Database Release Roadmap There are two types of Oracle Database releases Long Term Release and Innovation Release. Long Ter ..read more

[INS-35950] Installer has detected an invalid entry in the central inventory Cause -: On existing server 11g database installed. I clean the things from OS. That’s why 11g entry was there in central inventory. If ORACLE_BASE is not set, and you are not using OFA, then the path to oraInventory is in the home directory of the user performing the installation: Solution -: 1-cat /etc/oraInst.loc inventory_loc=/oracle/11g/home/oraInventory inst_group=oinstall 2-vi /etc/oraInst.loc Now edit the file and save it. inventory_loc=/oracle/19c/home/oraInventory inst_group=oinstall After doing this Install ..read more

Cause: Connections to the database have caused the current number of operating system processes associated with the Oracle Instance to exceed the PROCESSES database parameter (All process state objects are in use). Action: Increase the value of the PROCESSES initialization parameter. Solution: This is a temporary solution. If Prod is using spfile then do these steps. SQL>show parameter processes NAME TYPE VALUE ——————————– processes integer 150 SQL>alter system set processes=300 scope=spfile; SQL>shut immediate SQL>startup SQL>show parameter processes NAME TYPE VALUE ..read more

Hi My DBA Family, Today I want to share my Oracle Journey Secret. These are my 4 people in my life who inspired me. They are my Role Model. All are the best person. I want to thank all of them. I thought to share my Oracle journey through my blog. I have mentioned their blogs please visit you will learn many things. 1-My 1st Role model in the Oracle Database industry is Aman Sharma. He is my Brother from India. He got the First ACE award from India in 2009. (http://blog.aristadba.com) 2-My 2nd Role Model in the Oracle Database industry is Kamran Agayev A. I met him in 2017 in Hyderabad. He is ..read more