NMIN-Oracle DBA Blog

To find the Oracle System Identifier (SID) using the service name, you can use the following steps: 1) Check the listener status:lsnrctl status This will display a list of all the Oracle services that are registered with the listener, along with their service names and SIDs. Look for the service name in the list of … Συνέχεια ανάγνωσης Finding the ORACLE SID using the service name →

In an upgrade of the database of one of my clients I encountered a very interesting and frustrating issue. The database was version 12.2 Standard Edition 2 and needed to be upgraded to 19c Standard Edition 2 (19.16 along with the latest patch).It was Non-CDB, in a Windows server machine. I checked to find the … Συνέχεια ανάγνωσης Oracle Database 12c Upgrade to 19c windows – Error in listener – ORA-00609: could not attach to incoming connection →

I was running an Oracle Database Upgrade of version 12.2.0.0 to 19c (patched up to 19.16) using the DBUA, in a Windows server machine. In the process of the upgrade, in the post-upgrade steps, the upgrade failed because it could not start the new Listener service (though it was correctly configured). There was no specific … Συνέχεια ανάγνωσης Oracle Database 12c Upgrade to 19c – Error in listener migration →

I was running an Oracle Database Upgrade of version 11.2.0.4 to 19c (patched up to 19.15) using the DBUA. While running the upgrade, the log showed the below errors: ORA-00904: "CURRENT_USER": invalid identifierandORA-00904: "RLS_INFO": invalid identifier After a lot of searching online and in the metalink (Doc ID 2557794.1), I found that the columns are … Συνέχεια ανάγνωσης Oracle Database 11g Upgrade to 19c – Error: ORA-00904 →

I was trying to upgrade an older oracle database version 12.1.0.2.0 (Enterprise edition - Non CDB) to a 19c version. The OS was Oracle Linux 7. After proceeding with the first steps, I then ran the preupgrade tool to check for any conflicts and problems. $ORACLE_HOME/jdk/bin/java -jar /u01/app/oracle/product/19.0.0/dbhome_1/rdbms/admin/preupgrade.jar TERMINAL TEXT One of the required actions … Συνέχεια ανάγνωσης ERROR: ORA-29548 ORA-29548 in oracle database upgrade from 12.1 to 19c →

In a client's test database, we encountered this error in an test attempt of patching the Oracle Grid Home. The environment was configured with ASM and an Oracle Database (Single Instance). When the Opatch apply command ran, the below error occurred: $ORACLE_HOME/OPatch/opatch apply Verifying environment and performing prerequisite checks…Prerequisite check "CheckActiveFilesAndExecutables" failed. /u01/app/19c/grid/lib/libasmclntsh19.so OPatch failed … Συνέχεια ανάγνωσης ORACLE GRID home patch failure -OPatch failed with error code 73 →

An incident occurred with a customer of mine during running 3 Oracle Patches in a single node database (19.13 version). The customer had automated scripts to run patches in Oracle databases. So, he entered as input three Oracle Patches and let the script run automatically to deploy those patches. Unfortunately, this script was not running … Συνέχεια ανάγνωσης ORACLE home restore after patch failures →

There was a need for a customer, to have a deconfigured Oracle Restart Standalone template (removed IP and configuration and be ready to configured with a new one). This can be done by following the guidelines of deconfiguring - configuring IP based on the Oracle document: Document 1552810.1 The problem occurred when trying to run … Συνέχεια ανάγνωσης CHANGE IP FOR ASM-ORACLE RESTART STANDALONE – CRS-2799 FAILED TO SHUTDOWN RESOURCE →

This is the case of facing the two errors above during an Oracle APEX installation. I wanted to install Oracle APEX 21.1 along with the ORDS to test some applications.Since I did not need it for anything major, I installed an Oracle Database Express Edition (XE) in my Virtual Machine. One of the steps before … Συνέχεια ανάγνωσης ORA-56752 & ORA-01078 for ORACLE DATABASE EXPRESS EDITION →

During a usual import process, I noticed that it was taking more time than usual. In fact it was stuck in the INDEX part of the import. Both the import logfile and the Oracle alert log were not showing any kind of errors.I tend to read them both dynamically during any import:tail -f nohup.out (for … Συνέχεια ανάγνωσης FAST RECOVERY AREA (FRA) FULL DURING IMPORTING DMP →

Sometimes, after some wrong deployment in the DB, I have encountered the error: ORA-12034: materialized view log younger than last refresh This error means that the table of the materialized view is not synchronized correctly. The solutions to this are to either force a Complete refresh of the materialized view or to drop it and … Συνέχεια ανάγνωσης ORA-12034: materialized view log younger than last refresh →

This is the case of an incident that occurred to me after installing a new Oracle Database. I installed a new database and the SQLPLUS was working normally for a couple days. Suddenly one day, I tried to run SQLPLUS but I got the usual error Command Not Found. At first I checked the Oracle … Συνέχεια ανάγνωσης sqlplus command not found – AVAST INCIDENT →

This is an Oracle database performance issue that appeared in a client of mine. In the client's server, there were application flows running successfully everyday in a matter of minutes. One day, the customer reported that these flows where running for too long and they were stuck, so they were terminated. The same thing happened … Συνέχεια ανάγνωσης Oracle AWR Analysis – Database performance issue →

While trying to import a DMP at a customer's database, I came across the below error: ORA-56938: no secondary time zone data file being loaded by on-demand or a datapump job After checking the datapump jobs: SELECT PROPERTY_NAME, SUBSTR (property_value, 1, 30) valueFROM DATABASE_PROPERTIESWHERE PROPERTY_NAME LIKE 'DST_%'ORDER BY PROPERTY_NAME; It returned -> DST_UPGRADE_STATE DATAPUMP(2) Then … Συνέχεια ανάγνωσης Import Datapump Error: ORA-56938 →

This is the case of a interesting error I encountered regarding PL/SQL Developer connectivity. I had both SQL Developer and PL/SQL Developer installed in my computer.Oracle client 12c with its TNSNAMES.ora file were working fine. One day without any change, the connection to the databases via PL/SQL Developer stopped working with the error ORA-12154 TNS: … Συνέχεια ανάγνωσης PL/SQL Developer Rare ORA-12154 Error →

An interesting Oracle-Error case I encountered was about losing all redo log files.The whole investigation and restore process took 12 hours. Our server was restored from a Windows backup, but no redo log files were restored.So redo log files do not exist, and no database archived logs backup were available either.The database version was 11gR2.Our … Συνέχεια ανάγνωσης Oracle Database Recovery after losing all redo logfiles (ORA-00313) →