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

The ORA-03135 error is common when 1) Server unexpectedly terminated or was forced to terminate. or 2) Server timed out the connection. Solution–: 1) Check if the server session was terminated. 2) Check if the timeout parameters are set properly in sqlnet.ora file. In my Case i set these 2 parameters in the SQLNET.ora file ($ORACLE_HOME/network/admin/sqlnet.ora) & issue was resolved. SQLNET.EXPIRE_TIME=0 SQLNET.INBOUND_CONNECT_TIMEOUT=0 Please do the Like, Comments & Share in your circle. Thanks With Best Wishes!!!! Ahmad ACE Associate Cloud Architect Oracle Database Consultant Certifi ..read more

When we Grant the Select privilege on a V$ view we will get an ora-02030 error. As ORA-02030 says, that we can only select from fixed tables/views, which means V$INSTANCE is not a table or view. We know that actual view created on the dynamic performance table that is V_$. The V$ is only a synonym and not an actual fixed table or a view. Thus, When we try to grant select on the object we will receive the error: ORA-02030: can only select from fixed tables/views. How to resolve ORA-02030–: We need to replace V$ with V_$. It should be V_$INSTANCE. Because we can grant directly t ..read more

The Oracle wait event model was originally introduced in Oracle7. Wait event information is gathered by the Oracle MMON background process, stored in intermediate x$ structures in a circular SGA buffer, and later transferred to Oracle10g dba_hist tables. Oracle 10g introduced the Active Session History (ASH) as part of the Diagnostics and Tuning Pack.  The new Automated Session History (ASH) tables revolutionized Oracle wait event tuning.  ASH gathers sampled data at the session level rather than at the instance level.  The ASH, AWR, and ADDM are separate componen ..read more