Month: January 2022

ORA-12516 TNS:listener could not find available handler with matching protocol stack

We have a test system which is mainly used for workflow tests. Recently we have started to increase the load such as data volume and client connections. Then we saw the error below: 2022/01/10 00:41:44.610 +0000 WARNING [com.jboss.start.modules.DatabaseConnectionModule] Could not connect: Listener refused the connection with the following error: ORA-12516, TNS:listener could not find available … Continue reading ORA-12516 TNS:listener could not find available handler with matching protocol stack →

Advertisement

IMP-00403: Warning: This import generated a separate SQL file “logfilename_sys” which contains DDL that failed due to a privilege issue.

With Oracle Datapump, traditional export and import tools has faded out because Datapump has better performance and rich features. Still, exp/imp is supported and used for small tasks. I've run into the following error when using imp to moving a SQL baseline between two 19c databases: IMP-00403: Warning: This import generated a separate SQL file … Continue reading IMP-00403: Warning: This import generated a separate SQL file “logfilename_sys” which contains DDL that failed due to a privilege issue. →

RMAN-05158: WARNING: Auxiliary (datafile / tempfile) file name conflicts with a file used by the target database

When use RMAN duplicate command to create a copy of source database on a different host or a physical standby database, usually we specify the option "NOFILENAMECHECK" to avoid error messages. However an interesting thing is that starting from Oracle 19c - 19.2.0.0.0, you will see a warning message RMAN-05158: WARNING: auxiliary (datafile) file name … Continue reading RMAN-05158: WARNING: Auxiliary (datafile / tempfile) file name conflicts with a file used by the target database →