I am having an issue to connect my C++ application to my Oracle DB,I get an error
"[OracleException] errcode: 1804, desc: Error while trying to retrieve text for error ORA-01804".
J. Chomel
8,21315 gold badges41 silver badges69 bronze badges
asked Oct 11, 2012 at 10:46
0
I got the same error for cx_oracle (via python). For this specific case ORACLE_HOME was missing in environment variables.
Set Oracle_home with Windows Cli (use your oracle folder):
setx ORACLE_HOME "C:\oracle\oc121\"
On some of the DB connections TNS_ADMIN is required also set that as well:
setx TNS_ADMIN "%ORACLE HOME%\network\admin"
answered Feb 13, 2019 at 11:52
GorkemGorkem
7118 silver badges22 bronze badges
I use OCCI in CentOS 7, and encounter the same issue, just add libociicus.so to LD_LIBRARY_PATH to resolve the issue.
Pang
9,614146 gold badges81 silver badges122 bronze badges
answered Aug 22, 2018 at 1:58
Teddy ZhuTeddy Zhu
511 silver badge1 bronze badge
1
You are receiving ORA-01804 by the database, the description of ORA-01804 is:
failure to initialize timezone information
Cause: The timezone information file was not properly read.
answered Oct 11, 2012 at 10:48
AnshuAnshu
7,7835 gold badges31 silver badges41 bronze badges
2
I was experiencing such trouble with C++ OCCI application which caught oracle::occi::SQLException when it was trying to connect to oracle db.
ORA-01804:
failure to initialize timezone information
Cause: The timezone information file was not properly read.
The reason was that my linux oracle client was missing some timezone related files in its $ORACLE_HOME directory.
The solution was to simply copy those files from another instance of oracle client.
answered Apr 4, 2013 at 17:14
Alex InTechnoAlex InTechno
1,2011 gold badge8 silver badges9 bronze badges
1
Another possible reason: Binary have no permission to access the OCCI library …
I encounter such situation due to my mistakenly setting mode of folder in which OCCI library is.
answered Jan 18, 2013 at 4:21
LiJunjieLiJunjie
901 silver badge11 bronze badges
In my case, libociicus.so (can be found in the Oracle Instant Client) was missing.
answered Aug 20, 2018 at 12:23
SergiyKolesnikovSergiyKolesnikov
7,3792 gold badges26 silver badges47 bronze badges
1
Another trivial yet hard to determine cause for this might be that Oracle installation folder is incomplete. For me, a reason for this was that some process just (unsuccessfully) uninstalled Oracle client.
It was really tricky as bin folder from PATH env. var contained oci.dll (and lots of other DLL-s), but elsewhere under C:\oracle\11\ there were other files missing.
So: check that installation folder contains all required files!
answered Nov 18, 2019 at 15:41
KonradKonrad
3556 silver badges18 bronze badges
I know this is an old question, but there are no answers can fix my case (oracledb package of nodejs, macOS).
but, again, I found a solution for myself.
The solution is that move libociei.dylib into /usr/locale/lib folder. That’s it.
answered May 8, 2021 at 3:53
YanYan
8541 gold badge8 silver badges15 bronze badges
For me, it’s because the version of my instant client and the database server is using a different version. So I had to match their version to solve this error. Apparently, Oracle can’t read the DB timezone if their version is different.
answered May 28, 2021 at 2:06
The following isn’t really a good solution. I’m not sure myself what made the deal. But for me the solution was to:
- drop all other oracle clients from my PC
- clear ORACLE_HOME and PATH from paths to dropped clients
- restart the PC
After that the error was gone
answered Apr 28, 2022 at 12:28
I am having an issue to connect my C++ application to my Oracle DB,I get an error
"[OracleException] errcode: 1804, desc: Error while trying to retrieve text for error ORA-01804".
J. Chomel
8,21315 gold badges41 silver badges69 bronze badges
asked Oct 11, 2012 at 10:46
0
I got the same error for cx_oracle (via python). For this specific case ORACLE_HOME was missing in environment variables.
Set Oracle_home with Windows Cli (use your oracle folder):
setx ORACLE_HOME "C:\oracle\oc121\"
On some of the DB connections TNS_ADMIN is required also set that as well:
setx TNS_ADMIN "%ORACLE HOME%\network\admin"
answered Feb 13, 2019 at 11:52
GorkemGorkem
7118 silver badges22 bronze badges
I use OCCI in CentOS 7, and encounter the same issue, just add libociicus.so to LD_LIBRARY_PATH to resolve the issue.
Pang
9,614146 gold badges81 silver badges122 bronze badges
answered Aug 22, 2018 at 1:58
Teddy ZhuTeddy Zhu
511 silver badge1 bronze badge
1
You are receiving ORA-01804 by the database, the description of ORA-01804 is:
failure to initialize timezone information
Cause: The timezone information file was not properly read.
answered Oct 11, 2012 at 10:48
AnshuAnshu
7,7835 gold badges31 silver badges41 bronze badges
2
I was experiencing such trouble with C++ OCCI application which caught oracle::occi::SQLException when it was trying to connect to oracle db.
ORA-01804:
failure to initialize timezone information
Cause: The timezone information file was not properly read.
The reason was that my linux oracle client was missing some timezone related files in its $ORACLE_HOME directory.
The solution was to simply copy those files from another instance of oracle client.
answered Apr 4, 2013 at 17:14
Alex InTechnoAlex InTechno
1,2011 gold badge8 silver badges9 bronze badges
1
Another possible reason: Binary have no permission to access the OCCI library …
I encounter such situation due to my mistakenly setting mode of folder in which OCCI library is.
answered Jan 18, 2013 at 4:21
LiJunjieLiJunjie
901 silver badge11 bronze badges
In my case, libociicus.so (can be found in the Oracle Instant Client) was missing.
answered Aug 20, 2018 at 12:23
SergiyKolesnikovSergiyKolesnikov
7,3792 gold badges26 silver badges47 bronze badges
1
Another trivial yet hard to determine cause for this might be that Oracle installation folder is incomplete. For me, a reason for this was that some process just (unsuccessfully) uninstalled Oracle client.
It was really tricky as bin folder from PATH env. var contained oci.dll (and lots of other DLL-s), but elsewhere under C:\oracle\11\ there were other files missing.
So: check that installation folder contains all required files!
answered Nov 18, 2019 at 15:41
KonradKonrad
3556 silver badges18 bronze badges
I know this is an old question, but there are no answers can fix my case (oracledb package of nodejs, macOS).
but, again, I found a solution for myself.
The solution is that move libociei.dylib into /usr/locale/lib folder. That’s it.
answered May 8, 2021 at 3:53
YanYan
8541 gold badge8 silver badges15 bronze badges
For me, it’s because the version of my instant client and the database server is using a different version. So I had to match their version to solve this error. Apparently, Oracle can’t read the DB timezone if their version is different.
answered May 28, 2021 at 2:06
The following isn’t really a good solution. I’m not sure myself what made the deal. But for me the solution was to:
- drop all other oracle clients from my PC
- clear ORACLE_HOME and PATH from paths to dropped clients
- restart the PC
After that the error was gone
answered Apr 28, 2022 at 12:28
This article explains how to solve the Oracle database error “ORA-01804: failure to initialize timezone information” using the Oracle database version 12cR1 (12.1.0.2).
Table of Contents:
- ORA-01804: During the backup process.
- Check the existing Time Zone version.
- Set the ORA_TZFILE environment variable
1. ORA-01804: During the backup process:
We have received this error while making a full Oracle database backup
a. Full backup Offline :
[oracle@ol-7u4 ~]$ rman target / Recovery Manager: Release 12.1.0.2.0 - Production on Tue May 29 08:46:48 2018 Copyright (c) 1982, 2014, Oracle and/or its affiliates. All rights reserved. connected to target database: WADHAH (DBID=152152954, not open) RMAN> backup database; Starting backup at 29-MAY-18 using target database control file instead of recovery catalog allocated channel: ORA_DISK_1 channel ORA_DISK_1: SID=248 device type=DISK channel ORA_DISK_1: starting full datafile backup set channel ORA_DISK_1: specifying datafile(s) in backup set input datafile file number=00005 name=/home/oracle/app/oracle/oradata/WADHAH/datafile/o1_mf_example_fjsdj7rq_.dbf input datafile file number=00001 name=/home/oracle/app/oracle/oradata/WADHAH/datafile/o1_mf_system_fjsd8gwo_.dbf input datafile file number=00003 name=/home/oracle/app/oracle/oradata/WADHAH/datafile/o1_mf_sysaux_fjsd3wrb_.dbf input datafile file number=00004 name=/home/oracle/app/oracle/oradata/WADHAH/datafile/o1_mf_undotbs1_fjsdg2w5_.dbf input datafile file number=00006 name=/home/oracle/app/oracle/oradata/WADHAH/datafile/o1_mf_users_fjsdfz2d_.dbf channel ORA_DISK_1: starting piece 1 at 29-MAY-18 channel ORA_DISK_1: finished piece 1 at 29-MAY-18 piece handle=/home/oracle/app/oracle/fast_recovery_area/WADHAH/backupset/2018_05_29/o1_mf_nnndf_TAG20180529T084659_fjt1cms8_.bkp tag=TAG20180529T084659 comment=NONE channel ORA_DISK_1: backup set complete, elapsed time: 00:00:15 channel ORA_DISK_1: starting full datafile backup set channel ORA_DISK_1: specifying datafile(s) in backup set including current control file in backup set including current SPFILE in backup set channel ORA_DISK_1: starting piece 1 at 29-MAY-18 channel ORA_DISK_1: finished piece 1 at 29-MAY-18 piece handle=/home/oracle/app/oracle/fast_recovery_area/WADHAH/backupset/2018_05_29/o1_mf_ncsnf_TAG20180529T084659_fjt1d46f_.bkp tag=TAG20180529T084659 comment=NONE channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01 Finished backup at 29-MAY-18 RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03009: failure of REFAF command on default channel at 05/29/2018 08:47:18 ORA-01804: failure to initialize timezone information
b. The error: ORA-01804
At the end of our backup, we have received an error:
RMAN-03009: failure of REFAF command on default channel at 05/29/2018 08:47:18 ORA-01804: failure to initialize timezone information
2. Check the existing Time Zone version:
a. Check the Oracle database version:
$ sqlplus / as sysdba SQL*Plus: Release 12.1.0.2.0 Production on Tue May 29 08:37:59 2018 Copyright (c) 1982, 2014, Oracle. All rights reserved. Connected to: Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options SQL> select * from v$version; BANNER CON_ID -------------------------------------------------------------------------------- ---------- Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production 0 PL/SQL Release 12.1.0.2.0 - Production 0 CORE 12.1.0.2.0 Production 0 TNS for Linux: Version 12.1.0.2.0 - Production 0 NLSRTL Version 12.1.0.2.0 - Production 0 SQL>
b. Check the existing Time Zone version:
SQL> select value$ "Time Zone Version" from PROPS$ where name='DST_PRIMARY_TT_VERSION'; Time Zone Version -------------------------------------------------------------------------------- 18
Note: The Time zone version is 18
c. Check the existing Time Zone configuration file:
The configuration files of the time zone are located in $ORACLE_HOME/oracore/zoneinfo
$ ls -l /home/oracle/app/oracle/product/12.1.0/dbhome_1/oracore/zoneinfo/ total 17780 drwxr-xr-x. 2 oracle oinstall 4096 May 28 22:19 big drwxr-xr-x. 2 oracle oinstall 4096 May 28 22:19 little -rw-r--r--. 1 oracle oinstall 7179 Apr 16 2014 readme.txt -rw-r--r--. 1 oracle oinstall 34454 Apr 16 2014 timezdif.csv -rw-r--r--. 1 oracle oinstall 792894 Dec 3 2013 timezlrg_10.dat -rw-r--r--. 1 oracle oinstall 787272 Dec 3 2013 timezlrg_11.dat -rw-r--r--. 1 oracle oinstall 785621 Dec 3 2013 timezlrg_12.dat -rw-r--r--. 1 oracle oinstall 782475 Dec 3 2013 timezlrg_13.dat -rw-r--r--. 1 oracle oinstall 791430 Dec 3 2013 timezlrg_14.dat -rw-r--r--. 1 oracle oinstall 791476 Dec 3 2013 timezlrg_15.dat -rw-r--r--. 1 oracle oinstall 800913 Dec 3 2013 timezlrg_16.dat -rw-r--r--. 1 oracle oinstall 779003 Dec 3 2013 timezlrg_17.dat -rw-r--r--. 1 oracle oinstall 781669 Dec 3 2013 timezlrg_18.dat -rw-r--r--. 1 oracle oinstall 493675 Dec 3 2013 timezlrg_1.dat -rw-r--r--. 1 oracle oinstall 507957 Dec 3 2013 timezlrg_2.dat -rw-r--r--. 1 oracle oinstall 527717 Dec 3 2013 timezlrg_3.dat -rw-r--r--. 1 oracle oinstall 531137 Dec 3 2013 timezlrg_4.dat -rw-r--r--. 1 oracle oinstall 587487 Dec 3 2013 timezlrg_5.dat -rw-r--r--. 1 oracle oinstall 586750 Dec 3 2013 timezlrg_6.dat -rw-r--r--. 1 oracle oinstall 601242 Dec 3 2013 timezlrg_7.dat -rw-r--r--. 1 oracle oinstall 616723 Dec 3 2013 timezlrg_8.dat -rw-r--r--. 1 oracle oinstall 801410 Dec 3 2013 timezlrg_9.dat -rw-r--r--. 1 oracle oinstall 345637 Dec 3 2013 timezone_10.dat -rw-r--r--. 1 oracle oinstall 345356 Dec 3 2013 timezone_11.dat -rw-r--r--. 1 oracle oinstall 345024 Dec 3 2013 timezone_12.dat -rw-r--r--. 1 oracle oinstall 344425 Dec 3 2013 timezone_13.dat -rw-r--r--. 1 oracle oinstall 344448 Dec 3 2013 timezone_14.dat -rw-r--r--. 1 oracle oinstall 344448 Dec 3 2013 timezone_15.dat -rw-r--r--. 1 oracle oinstall 343044 Dec 3 2013 timezone_16.dat -rw-r--r--. 1 oracle oinstall 341718 Dec 3 2013 timezone_17.dat -rw-r--r--. 1 oracle oinstall 341718 Dec 3 2013 timezone_18.dat -rw-r--r--. 1 oracle oinstall 274427 Dec 3 2013 timezone_1.dat -rw-r--r--. 1 oracle oinstall 274900 Dec 3 2013 timezone_2.dat -rw-r--r--. 1 oracle oinstall 286651 Dec 3 2013 timezone_3.dat -rw-r--r--. 1 oracle oinstall 286264 Dec 3 2013 timezone_4.dat -rw-r--r--. 1 oracle oinstall 286310 Dec 3 2013 timezone_5.dat -rw-r--r--. 1 oracle oinstall 286217 Dec 3 2013 timezone_6.dat -rw-r--r--. 1 oracle oinstall 286815 Dec 3 2013 timezone_7.dat -rw-r--r--. 1 oracle oinstall 302100 Dec 3 2013 timezone_8.dat -rw-r--r--. 1 oracle oinstall 351525 Dec 3 2013 timezone_9.dat
3. Set the ORA_TZFILE environment variable:
a. Set environment variable ORA_TZFILE:
Note: My Oracle Home: /home/oracle/app/oracle/product/12.1.0/dbhome_1
$ export ORA_TZFILE=/home/oracle/app/oracle/product/12.1.0/dbhome_1/oracore/zoneinfo/timezlrg_18.dat
b. Make a RMAN backup:
[oracle@ol-7u4 ~]$ rman target / Recovery Manager: Release 12.1.0.2.0 - Production on Tue May 29 08:52:00 2018 Copyright (c) 1982, 2014, Oracle and/or its affiliates. All rights reserved. connected to target database: WADHAH (DBID=152152954, not open) RMAN> backup database; Starting backup at 29-MAY-18 using target database control file instead of recovery catalog allocated channel: ORA_DISK_1 channel ORA_DISK_1: SID=12 device type=DISK channel ORA_DISK_1: starting full datafile backup set channel ORA_DISK_1: specifying datafile(s) in backup set input datafile file number=00005 name=/home/oracle/app/oracle/oradata/WADHAH/datafile/o1_mf_example_fjsdj7rq_.dbf input datafile file number=00001 name=/home/oracle/app/oracle/oradata/WADHAH/datafile/o1_mf_system_fjsd8gwo_.dbf input datafile file number=00003 name=/home/oracle/app/oracle/oradata/WADHAH/datafile/o1_mf_sysaux_fjsd3wrb_.dbf input datafile file number=00004 name=/home/oracle/app/oracle/oradata/WADHAH/datafile/o1_mf_undotbs1_fjsdg2w5_.dbf input datafile file number=00006 name=/home/oracle/app/oracle/oradata/WADHAH/datafile/o1_mf_users_fjsdfz2d_.dbf channel ORA_DISK_1: starting piece 1 at 29-MAY-18 channel ORA_DISK_1: finished piece 1 at 29-MAY-18 piece handle=/home/oracle/app/oracle/fast_recovery_area/WADHAH/backupset/2018_05_29/o1_mf_nnndf_TAG20180529T085209_fjt1objs_.bkp tag=TAG20180529T085209 comment=NONE channel ORA_DISK_1: backup set complete, elapsed time: 00:00:15 channel ORA_DISK_1: starting full datafile backup set channel ORA_DISK_1: specifying datafile(s) in backup set including current control file in backup set including current SPFILE in backup set channel ORA_DISK_1: starting piece 1 at 29-MAY-18 channel ORA_DISK_1: finished piece 1 at 29-MAY-18 piece handle=/home/oracle/app/oracle/fast_recovery_area/WADHAH/backupset/2018_05_29/o1_mf_ncsnf_TAG20180529T085209_fjt1ov38_.bkp tag=TAG20180529T085209 comment=NONE channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01 Finished backup at 29-MAY-18 RMAN> exit Recovery Manager complete. [oracle@ol-7u4 ~]$
Conclusion:
The envirenment variable ORA_TZFILE solves the Oracle database error “ORA-01804: failure to initialize timezone information”.
- What is your version of Python? Is it 32-bit or 64-bit?
Python 64 bit - What is your cx_Oracle version?
7.1.3 - What exact command caused the problem (e.g. what command did you try to install with)? Who were you logged in as?
dsn_tns = cx_Oracle.makedsn(«localhost», PORT, sid=»SID»)
conn = cx_Oracle.connect(user=r’username’, password=’pass’, dsn=dsn_tns)
- What error(s) you are seeing?
Traceback (most recent call last):
File «<pyshell#4>», line 1, in
conn = cx_Oracle.connect(user=r’—‘, password=’—‘, dsn=dsn_tns)
cx_Oracle.DatabaseError: ORA-01804: failure to initialize timezone information
5. What OS (and version) is Python executing on?
Windows 7 64 bit
6. What is your version of the Oracle client (e.g. Instant Client)? How was it installed? Where is it installed?
Oracle Client 12.0.1 64 but
7. What is your Oracle Database version?
10.2
8. What is the PATH environment variable (on Windows) or LD_LIBRARY_PATH (on Linux) set to? On macOS, what is in ~/lib?
$ORACLE_HOME/bin:$PATH
-
What Oracle environment variables did you set? How exactly did you set them?
ORACLE_HOME =C:\FAST\Oracle_Base\product\12.1.0\client
TNS_ADMIN = $ORACLE_HOME/network/admin
LD_LIBRARY_PATH = $ORACLE_HOME/lib
ORA_TZFILE = $ORACLE_HOME/oracore/zoneinfo/timezdif.csv
PATH = $ORACLE_HOME/bin:$PATH
CLASSPATH = C:\FAST\Oracle_Base\product\12.1.0\client\jdk\bin\java -
Do you have a small, single Python script that immediately runs to show us the problem?
import cx_Oracle
dsn_tns = cx_Oracle.makedsn(«localhost», PORT, sid=»SID»)
conn = cx_Oracle.connect(user=r’username’, password=’pass’, dsn=dsn_tns)
I am trying to connect to database that is located in our server. I am having error about the initialization timezone information like below.
cx_Oracle.DatabaseError: ORA-01804: failure to initialize timezone information
This error encountered during 12c upgrade. My source database was running in 11.2.0.3 with DSTv17 and i was upgrading database to 12.1.0.2. I had to updgrade DST to v18 as part of the upgrade. AFter DST upgrade i was getting the error below while connecting to sqlplus and while running autoconfig as well.
Error :
ORA-01804: failure to initialize timezone information
SP2-0152: ORACLE may not be functioning properly
The first thing to do when you hit ORA-1804 is to check which timezone file Oracle attempts to use:
If the ORA_TZFILE environment variable is set then that points to the file that will be used.
If ORA_TZFILE is not set then until Oracle 9.2.0.5 $ORACLE_HOME/oracore/zoneinfo/timezone.dat is the default file that is used, since the 9.2.0.5 patchset (and all higher versions up to 11.1.0.7) the default file is $ORACLE_HOME/oracore/zoneinfo/timezlrg.dat
Since 11.2 the .dat files have a prefix indicating the DST version. Hence there are NO timezone.dat or timezlrg.dat in 11.2 and higher .
For example timezlrg_4.dat is the DSTv4 «large» file, timezlrg_11.dat is the DSTv11 «large» file.
The first thing to do is to check if ORA_TZFILE is set and if it is, remove it and restart the database and listener. Oracle will then try to load $ORACLE_HOME/oracore/zoneinfo/timezlrg.dat or, from 11.2 onwards, the $ORACLE_HOME/oracore/zoneinfo/timezlrg_XX.dat file with XX being the higher number available in the $ORACLE_HOME/oracore/zoneinfo/ directory.
If for some reason the file that Oracle wants to use is not available then this is the cause of the problem.
If the file is present then an alternative reason for the error could be that Oracle cannot load the file because of permission problems.
If all above is correct then it might be a .dat file that is corrupt.
In my scenario, timezlrg.dat file which is set to ORA_TZFILE was not present. From 11g onwards we have version introduced in file name. So i updated the file name as below in ad8idbux.env as mentioned below :
bash-3.2$ echo $ORA_TZFILE
/d02/DEV/oratest/12.1.0/oracore/zoneinfo/timezlrg.dat
bash-3.2$ ls -ltr /d02/DEV/oratest/12.1.0/oracore/zoneinfo/timezlrg.dat
/d02/DEV/oratest/12.1.0/oracore/zoneinfo/timezlrg.dat: No such file or directory
You can find timezone files present under the location /d02/DEV/oratest/12.1.0/oracore/zoneinfo. Update the highest version available. I updated timezlrg_17.dat
———————In ad8idbux.env file———————
if test «%s_database%» = «db112» -o «%s_database%» = «db121» ; then
ORA_TZFILE=»»
else
ORA_TZFILE=»$ORACLE_HOME/oracore/zoneinfo/timezlrg.dat»
fi
export ORA_TZFILE
1. This is resolved by editing the template ad8idbux.env in location …/oracle/db/tech_st/11.2.0/appsutil/template changing:
From:
set ORA_TZFILE=%s_db_oh%\oracore\zoneinfo\timezlrg.dat
To:
set ORA_TZFILE=%s_db_oh%\oracore\zoneinfo\timezlrg_17.dat
2. Running AutoConfig after this change means the environment file is created with the ORA_TZFILE value as timezlrg_14.dat and AutoConfig completes successfully
References :
Autoconfig Failed On 12c Database With «ORA-01804: failure to initialize timezone information» (Doc ID 1908836.1)
AutoConfig Encounters A ORA-1804 Error: Failure To Initialize Timezone Information (Doc ID 1917923.1)
AutoConfig Encounters A ORA-1804 Error: Failure To Initialize Timezone Information (Doc ID 1917923.1)
Note : these .dat files are only read by Oracle, never written to, so if these files become corrupt then the reason for they becoming corrupt is at OS level or I/O subsystem.
So while copying / reinstalling those files might solve the symptom (the ORA-1804) , the root cause is non-Oracle and a deep diagnostic of the filesystem/ I/O subsystem is strongly advised.
Also there is a big chance these .dat files are not the only files who became corrupt.
Because these timezone files are static and can only be updated by Oracle development the solution is the same in both cases:
Find a different database (same RDBMS and (!) DST version & platform) that does not have these problems (check for example by selecting from V$TIMEZONE_NAMES)
Copy the *.dat files from that system over to the failing system
Restart all Oracle processes
or Reinstall the Oracle software.