Showing posts with label Errors. Show all posts
Showing posts with label Errors. Show all posts
Friday, April 11, 2025

Solution to "ORA-12546: TNS:permission denied" when starting sqlplus

›
Problem: when trying to start sqlplus, the error below is thrown: ORA-12546: TNS:permission denied Cause: Incorrect permissions on the ora...
Friday, August 23, 2024

Our solution to ORA-00600: internal error, arguments: [kkmmctbf:bad intcoln]

›
We were facing a problem in one of our databases with jobs that stopped immediately after attempting to start, and then aborting their respe...
Tuesday, July 9, 2024

Stupid mistake that causes TNS-12533: TNS:illegal ADDRESS parameters during tns names resolution

›
Consider the following tnsnames.ora file: cdb = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = myserver1.oric.no)(PORT = 1521)) ...
Tuesday, June 4, 2024

Solution to ORA-29548: Java system class reported: release of Java system classes in the database (19.0.0.0.240116 1.8) does not match that of the oracle executable (19.0.0.0.240416 1.8)

›
When I was trying to drop and recreate a schema in my PDB, I received the following error: drop user myuser cascade * ERROR at line 1: ORA...
Monday, May 6, 2024

How to solve errors like "Interim patch num/num (DATAPUMP BUNDLE PATCH 19.21.0.0.0): Not installed in the CDB but installed in the PDB"

›
After running autoupgrade, I was left with the following message in the logfile $ORACLE_BASE/cfgtoollogs/upgrade/auto/status/status.log: [S...
Thursday, April 18, 2024

Solution to script warning: here-document at line < num > delimited by end-of-file (wanted `!')

›
In a script, I had formatted my code as follows: for l in $(cat file.txt|grep 'Status'| awk -F' ' '{print $2}')...
Wednesday, April 17, 2024

Solution to ORA-28547: connection to server failed, probable Oracle Net admin error

›
When trying to perform sqlplus actions against one of my databases, I received oracle@oric-dbserver01:[mydb01]# sqlplus / as sysdba SQL*P...

Solution to [FATAL] [DBT-05509] Failed to connect to the specified database (cdb) in dbca

›
I was attempting to create a container database using dbca like this: dbca -createDatabase -responsefile /home/oracle/scripts/cdb.rsp -sil...

My solution to ORA-12701: CREATE DATABASE character set is not known

›
Some of our Oracle servers are set up to accommodate EBS. During the provisioning process of a new oracle server, the Oracle database crea...
Friday, January 26, 2024

[DBT-50000] Unable to check available system memory when running dbca

›
dbca returned the following error upon launch: [FATAL] [DBT-50000] Unable to check available system memory. CAUSE: An exception occured...
Tuesday, August 22, 2023

Cause and solution to ORA-00058: DB_BLOCK_SIZE must be 8192 to mount this database (not 16384)

›
You attempt to execute dbca silently, using a response file, as shown below: dbca -createDatabase -responsefile mydb01.rsp -silent But i...
Friday, February 24, 2023

Getting ORA-01722 when running adstats.sql after an EBS database upgrade to 19c

›
An old error from 2015 surfaced today , when we were trying to upgrade a 12.1 EBS database to 19c. The problem occured during the running...
1 comment:
Tuesday, January 24, 2023

How to avoid error Perl lib version (5.28.1) doesn't match executable version (5.36.0)

›
When trying to use clone.pl to clone the latest version of the Oracle 19c database, the following error stopped me from proceeding: /sw/or...
Friday, December 9, 2022

How to solve "Can't locate TXK/ARGS.pm in @INC (you may need to install the TXK::ARGS module)" when running txkChkPDBCompatability.pl

›
Background: As a part of converting your non-CDB Oracle database to a pluggable database, you are supposed to run the perl script txkChkP...
Tuesday, November 8, 2022

Workaround for error ERROR: OCI Error DPI (status = 7-DPI-007: invalid OCI handle or descriptor) when starting Golden Gate replicate process

›
When trying to login to the golden gate cli interface, I got the following error: GGSCI (myserver1.oric.no) 7> dblogin useridalias mydb...
Tuesday, October 11, 2022

How to solve "Service name or network name of ... in the PDB is invalid or conflicts with an existing service name or network name in the CDB."

›
From the alert log during startup of the container database called "cdb": pdb1(3):**********************************************...
Thursday, June 30, 2022

How to solve ORA-01187: cannot read from file because it failed verification tests

›
After a successful clone, alert log reports: 022-06-30T04:04:17.542368+02:00 Errors in file /orainst/oracle/diag/rdbms/testdb01/testdb01/t...
Wednesday, June 29, 2022

ORA-01017: incorrect username/password, login denied when using a wallet

›
If you find yourself in the situation where you cannot make a connection using your wallet because of the error ORA-01017: incorrect us...
Friday, June 17, 2022

How to solve ORA-17628: Oracle error 1031 returned by remote Oracle server ORA-01031: insufficient privileges when cloning a non-cdb oracle instance to a PDB

›
When attempting to clone my database testdb01, a normal, non-cdb database, into a CDB and convert it to a PDB, I hit a permission error. I...
Tuesday, May 3, 2022

The cause for and solution to the error message "Database mount ID mismatch" in your previously configured standby database

›
If you have a previously configured standby database, and you have converted it to a free standing database, no longer a part of a data gu...