Error while trying to retrieve text for error ora 01804 pl sql developer

I need delete the slqnet.ora on my oracle home. And I obtain this error when I try connect in any database. Information: PL/SQL Developer Version 9.0.1.1613 156.75334 - 10 user license Windows 6.2 Build 9200 Language: Brazilian (Allround Automations) Physical memory : 2.097....

Infor:
PL/SQL Developer
Version 9.0.1.1613
156.75334 — 10 user license
Windows 6.2 Build 9200
Language: Brazilian (Allround Automations)

Physical memory : 2.097.152 kB (2.097.152 available)
Paging file : 4.194.304 kB (3.215.556 available)
Virtual memory : 2.097.024 kB (1.919.824 available)

Parameters
C:Program FilesPLSQL Developerplsqldev.exe

Preferences
Session mode: Multi
OCI Library:
Use OCI7: False
Allow Multiple Connections: True

Preference Files
C:UsersgesifAppDataRoamingPLSQL DeveloperPreferencesdefaultDefault.ini
C:UsersgesifAppDataRoamingPLSQL DeveloperPreferencesgesifdefault.ini

Plug-Ins

Aliases
AGRALE_PROD
SYNPRD
SYNPRD_nova
SYNTST

Homes
OraClient11g_SYNCHRO (C:Program FilesSynchrooracleclient11)
OraClient12Home3 (C:oracle12.1.0client)

DLLs
C:oracle12.1.0clientbinoci.dll

TNS File
C:Program FilesSynchrooracleclient11networkadmintnsnames.ora

Using
Home: OraClient12Home3
DLL: C:oracle12.1.0clientbinoci.dll
OCI: version 11.1

Registry:
SOFTWAREORACLE
inst_loc = C:Program FilesOracleInventory
NLS_LANG = BRAZILIAN PORTUGUESE_BRAZIL.WE8MSWIN1252

SOFTWAREORACLEJavaDeploy

SOFTWAREORACLEKEY_OraClient11g_SYNCHRO
ORACLE_HOME = C:Program FilesSynchrooracleclient11
ORACLE_HOME_NAME = OraClient11g_SYNCHRO
ORACLE_GROUP_NAME = Oracle — OraClient11g_SYNCHRO
NLS_LANG = AMERICAN_AMERICA.WE8MSWIN1252
OLEDB = C:Program FilesSynchrooracleclient11oledbmesg
OO4O = C:Program FilesSynchrooracleclient11oo4omesg

SOFTWAREORACLEKEY_OraClient11g_SYNCHROOLEDB
CacheType = Memory
ChunkSize = 100
DistribTX = 1
FetchSize = 100
OSAuthent = 0
PLSQLRset = 0
PwdChgDlg = 1
SchRstLng = 10000
UserDefFn = 0
DisableRetClause = 1
VCharNull = 1
TraceCategory = 0
TraceFileName = c:OraOLEDB.trc
TraceLevel = 0
TraceOption = 0
SPPrmDefVal = 0
StmtCacheSize = 10
MetaDataCacheSize = 0
DBNotifications = 0
DeferUpdChk = 0

SOFTWAREORACLEKEY_OraClient11g_SYNCHROOO4O
CacheBlocks = 20
FetchLimit = 100
FetchSize = 4096
PerBlock = 16
SliceSize = 256
TempFileDirectory = c:temp
OO4O_HOME = C:Program FilesSynchrooracleclient11oo4o

SOFTWAREORACLEKEY_OraClient12Home3
ORACLE_HOME = C:oracle12.1.0client
ORACLE_HOME_NAME = OraClient12Home3
ORACLE_GROUP_NAME = Oracle — OraClient12Home3
NLS_LANG = BRAZILIAN PORTUGUESE_BRAZIL.WE8MSWIN1252
ORACLE_BUNDLE_NAME = Enterprise
OLEDB = C:oracle12.1.0clientoledbmesg
ORACLE_HOME_TYPE = 2
ORACLE_SVCUSER = AUTORIDADE NTSERVI

Источник

Delete unnecessary parts of this template.

For security issues:

See https://www.oracle.com/support/assurance/vulnerability-remediation/reporting-security-vulnerabilities.html for how to report security issues.

For general questions:

Describe exactly what you did and what you want to happen.
Use the questions at the bottom of this template as a guide.

Use Markdown syntax, particularly for code blocks: see https://help.github.com/articles/basic-writing-and-formatting-syntax/#quoting-code

For installation issues:

Use a gist for screen output and logs: see https://gist.github.com/
Do not paste long output into this issue

Review your output and logs. Google any errors
Try to install in a different way. Try some potential solutions.

Review the install instructions at
http://cx-oracle.readthedocs.io/en/latest/installation.html

Answer the following questions:

  1. What is your version of Python? Is it 32-bit or 64-bit?
    64

  2. What is your cx_Oracle version?
    7.3.1

  3. What exact command caused the problem (e.g. what command did you try to install with)? Who were you logged in as?
    connstr = cx_Oracle.makedsn(‘host’,’port’,’sid’)
    connection = cx_Oracle.connect(user = ‘user’, password=’pass’, dsn=connstr)

  4. What error(s) you are seeing?
    cx_Oracle.DatabaseError: Error while trying to retrieve text for error ORA-01804

  5. What OS (and version) is Python executing on?
    windows 10

  6. What is your version of the Oracle client (e.g. Instant Client)? How was it installed? Where is it installed?
    11.2.0 in the c drive

  7. What is your Oracle Database version?

  8. What is the PATH environment variable (on Windows) or LD_LIBRARY_PATH (on Linux) set to? On macOS, what is in ~/lib?

  9. What Oracle environment variables did you set? How exactly did you set them?

  10. Do you have a small, single Python script that immediately runs to show us the problem?

I can’t create anymore a connection. It always return :
cx_Oracle.DatabaseError: Error while trying to retrieve text for error ORA-01804.

My other oracle applications are working though.

Источник

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:

  1. ORA-01804: During the backup process.
  2. Check the existing Time Zone version.
  3. 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”.

Источник

У меня возникла проблема с подключением моего приложения C++ к моей БД Oracle, я получаю сообщение об ошибке

"[OracleException] errcode: 1804, desc: Error while trying to retrieve text for error ORA-01804".

10 ответы

Я получил ту же ошибку для cx_oracle (через python). Для этого конкретного случая ORACLE_HOME отсутствовал в переменных среды. Установите Oracle_home с помощью Windows Cli (используйте папку оракула):

setx ORACLE_HOME  "C:oracleoc121"

Для некоторых соединений с БД также требуется TNS_ADMIN:

setx TNS_ADMIN "%ORACLE HOME%networkadmin"

Создан 13 фев.

Я использую OCCI в CentOS 7 и сталкиваюсь с той же проблемой, просто добавьте libociicus.so в LD_LIBRARY_PATH, чтобы решить эту проблему.

ответ дан 22 авг.

Вы получаете ORA-01804 по базе данных, описание ORA-01804 это:

failure to initialize timezone information
Cause:   The timezone information file was not properly read.

ответ дан 11 окт ’12, 11:10

У меня были такие проблемы с приложением C++ OCCI, которое поймало oracle::occi::SQLException когда он пытался подключиться к oracle db.

ORA-01804:
failure to initialize timezone information
Cause:  The timezone information file was not properly read.

Причина заключалась в том, что в моем Linux-клиенте Oracle отсутствовали некоторые файлы, связанные с часовым поясом. $ORACLE_HOME каталог. Решение состояло в том, чтобы просто скопировать эти файлы из другого экземпляра клиента оракула.

ответ дан 04 апр.

Другая возможная причина: Binary не имеет права доступа к библиотеке OCCI… Я сталкиваюсь с такой ситуацией из-за того, что ошибочно установил режим папки, в которой находится библиотека OCCI.

Создан 18 янв.

ответ дан 20 авг.

Другой тривиальной, но трудно определяемой причиной этого может быть неполная папка установки Oracle. Для меня причиной этого было то, что какой-то процесс просто (неудачно) удалил клиент Oracle.

Это было действительно сложно, так как папка bin из PATH env. var содержал oci.dll (и множество других DLL-файлов), но в другом месте под C:oracle11 отсутствовали другие файлы.

Итак: убедитесь, что в папке установки есть все необходимые файлы!

Создан 18 ноя.

Я знаю, что это старый вопрос, но нет ответов, которые могли бы исправить мой случай (оракулб пакет nodejs, macOS).

но, опять же, я нашел решение для себя.

Решение в том, что двигаться libociei.dylib в /usr/locale/lib папка. Вот и все.

ответ дан 08 мая ’21, 04:05

Для меня это связано с тем, что версии моего мгновенного клиента и сервера базы данных используют другую версию. Поэтому мне пришлось сопоставить их версию, чтобы решить эту ошибку. Судя по всему, Oracle не может прочитать часовой пояс БД, если их версия отличается.

ответ дан 28 мая ’21, 03:05

Следующее не очень хорошее решение. Я сам не уверен, что сделало сделку. Но для меня решение было:

  • удалить все другие клиенты оракула с моего ПК
  • очистить ORACLE_HOME и PATH от путей к удаленным клиентам
  • перезагрузите компьютер

После этого ошибка исчезла

ответ дан 28 апр.

Не тот ответ, который вы ищете? Просмотрите другие вопросы с метками

oracle

or задайте свой вопрос.

Источник

Я использую ROracle и выполняю следующие команды в R :

Sys.getenv()
drv <- dbDriver("Oracle")

И вот ошибка, которую я получаю после этой последней строки:

Error in .oci.Driver(.oci.drv(), interruptible = interruptible, unicode_as_utf8 = unicode_as_utf8,  :
  Error while trying to retrieve text for error ORA-01804

Я на сервере RStudio работаю на сервере RHEL 5.

Как я мог избежать этой ошибки?

2 ответа

Лучший ответ

Вы должны проверить эти 2 пункта:

  • ORACLE_HOME переменная окружения должна быть определена
  • Путь $ORACLE_HOME/lib должен быть в значении переменной среды LD_LIBRARY_PATH

Например, если ваш ORACLE_HOME равен /usr/lib/oracle/12.1/client64 (который используется по умолчанию при установке Oracle Instant Client с официальным .rpm), выполните следующие команды R:

Sys.setenv("ORACLE_HOME" = "/usr/lib/oracle/12.1/client64")
Sys.getenv("LD_LIBRARY_PATH")
# Here check if /usr/lib/oracle/12.1/client64/lib is a part (separated by ":" of the result)
# else, append ":/usr/lib/oracle/12.1/client64/lib" to the result and set the environment variable using:
# Sys.setenv("LD_LIBRARY_PATH" = "/all/the/result:/of/getenv/command:/usr/lib/oracle/12.1/client64/lib")


2

Anthony O.
20 Янв 2017 в 10:49

ORA-01804: сбой при инициализации информации о часовом поясе Причина: файл информации о часовом поясе не был правильно прочитан.

Причина была в том, что у моего клиента Linux Linux-оракула отсутствовали некоторые файлы, связанные с часовым поясом, в каталоге $ ORACLE_HOME. Решением было просто скопировать эти файлы из другого экземпляра клиента oracle.

Это общее сообщение об ошибке из базы данных Oracle, указывающее, что файл информации о часовом поясе не был правильно прочитан. Ниже приведены наиболее распространенные решения:

1) Ваш клиент oracle может пропустить некоторые файлы, связанные с часовым поясом, в своем каталоге $ ORACLE_HOME. Вы можете попробовать просто скопировать эти файлы из другого экземпляра клиента Oracle.

2) Двоичный файл может не иметь разрешения на доступ к библиотеке OCCI. Пожалуйста, убедитесь, что разрешения на месте.

3) Убедитесь, что в вашей среде правильно заданы следующие пути: LD_LIBRARY_PATH ORACLE_HOME NLS_LANG


0

Anup Dey
20 Янв 2017 в 13:28

Источник

score:4

Accepted answer

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.

Read More

  • Error while trying to retrieve text for error ORA-01804
  • Error while trying to retrieve text for error ORA-01019 in VB6
  • pdo_oci_handle_factory: Error while trying to retrieve text for error ORA-01804
  • Oracle with node-oracle: Error while trying to retrieve text for error ORA-01804
  • Connecting python to oracle — DatabaseError: Error while trying to retrieve text for error ORA-01804
  • DatabaseError: Error while trying to retrieve text for error ORA-12154 — Google Colab

score:0

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:oracle11 there were other files missing.

So: check that installation folder contains all required files!

score:0

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.

Similar Question and Answer

  • Connect Oracle12c using python(Error while trying to retrieve text for error ORA-01804)
  • «Index was outside the bounds of the array» error while trying to retrieve return value from an insert statement
  • Error while trying to create a package for authentication in oracle apex
  • Getting Oracle Error While trying to convert varchar2 column and retrieve data using BIP report
  • Getting error while trying to alter table in an sql block
  • Error while exporting clob field from oracle to text field on Azure DB
  • Getting «Invalid Operation. The Connection is closed» error while trying to update oracle from visual c# program
  • Cannot modify a column which maps to a non key-preserved table error while trying to insert into a view

score:0

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.

score:0

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

Related questions and answers

  • Oracle TNS: No Listener error while tnsping for my service
  • Syntax error while creating view for oracle
  • Oracle database 12c Error while trying to connect: The Network Adapter could not establish the connection
  • Why do I error out when trying to retrieve a result set with DotConnect components?
  • PLS-00103: Encountered the symbol «EXCEPTION» error while checking for a value in the bind variable
  • ORA 00936 error while using left outer join + syntax
  • Error while trying to delete rows from table
  • Error : This feature is not available for the database you are using when trying to return insert_id
  • Syntax error while trying to call an Oracle package using ODBC in C#
  • Getting the error cx_Oracle.DatabaseError: ORA-01008: not all variables bound while trying to bind the value of a list in a merge statement
  • ORA-12899 value too large error while trying to drop a NUMBER column
  • Oracle: error while trying to use formulas
  • In PHP getting «Class ‘PDO’ not found» error while trying to connect to Oracle DB
  • Getting Invalid Identifier error while passing the rowid to a ref cursor for data deletion
  • Error while trying to execute pl/sql that loops through a cursor containing only ROWID’s

score:2

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.

score:3

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.

score:5

I use OCCI in CentOS 7, and encounter the same issue, just add libociicus.so to LD_LIBRARY_PATH to resolve the issue.

score:6

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:oracleoc121"

On some of the DB connections TNS_ADMIN is required also set that as well:

setx TNS_ADMIN "%ORACLE HOME%networkadmin"

More questions with similar tag

  • Oracle SQL: how to call created columns (alias) for pivot tables in a subquery
  • oracle data from one db to another db by using toad
  • ORA-01830 Oracle Exception from .net Stored Proc Call
  • 2020-02-29 minus one year caused error ORA-01839: date not valid for month specified
  • Can I request previous sample time more efficiently in this Oracle SQL statement?
  • once a branch executed other branches after it won’t execute in oracle apex 20.1
  • Working with WebLogic in Eclipse Juno
  • To_number fails to convert varchar to number in update statement
  • How to pass more parametrers than used in an oracle query in ODP.NET without getting exception?
  • plsql get particular sub string from givin string
  • Install cx_Oracle Library with dependencies on Azure function app
  • get dbms output message from oracle in php
  • Compressing a string and storing it on a database as string for later decompression
  • How to count number of months of row in Oracle
  • I keep getting error ORA-01422, ORA-06512
  • ORA-00911: invalid character error while executing a query
  • Run an SQL Query With a DateTime Parameter from Excel 2010
  • how do I apply MINUS on listagg and substr?
  • Allow muliple values in Oracle for an SSRS report

  • JPA Cast Exception
  • how to concatenate query results in the same column in oracle?
  • Insert data in clob column and varchar column in a single insert statement using PHP Oci8
  • Oracle query all_tab_columns.data_default (type LONG)
  • Creating views from tables that have types in Oracle SQL Developer
  • Hibernate not returning correct value for auto increment column with Oracle 12c
  • Calculating availability on Oracle DB
  • Oracle SQL — Free Text Search
  • Obtain count for duplicates in two tables oracle sql
  • JDBC performance tuning — setFetchSize
  • error ORA-00907: missing right parenthesis?

Ezoic

Ezoic

oracle

sql-server

Источник

Понравилась статья? Поделить с друзьями:
  • Error while trying to open file перевод
  • Error while trying to open file firebird
  • Error write failed fasm
  • Error write eof
  • Error write econnreset