Error while trying to retrieve text for error ORA-01804

by

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"

More Related Contents:

  1. Printing the value of a variable in SQL Developer
  2. Oracle Equivalent to MySQL INSERT IGNORE?
  3. null vs empty string in Oracle [duplicate]
  4. Convert comma separated string to array in PL/SQL
  5. UTL_FILE.FOPEN() procedure not accepting path for directory?
  6. Oracle stored procedure with parameters for IN clause
  7. PL/SQL ORA-01422: exact fetch returns more than requested number of rows
  8. NLS_NUMERIC_CHARACTERS setting for decimal
  9. Formatting DATE in oracle
  10. What is the minimal setup required to deploy a .NET application with Oracle client 11?
  11. Oracle: How to find out if there is a transaction pending?
  12. Best practice for pagination in Oracle?
  13. check if “it’s a number” function in Oracle
  14. Sql*plus always returns exit code 0?
  15. Difference between VARCHAR2(10 CHAR) and NVARCHAR2(10)
  16. HIbernate issue with Oracle Trigger for generating id from a sequence
  17. Why cannot I use bind variables in DDL/SCL statements in dynamic SQL?
  18. error: ORA-65096: invalid common user or role name in Oracle database
  19. Using Alias in query resulting in “command not properly ended”
  20. Spring boot Hibernate error “Access to DialectResolutionInfo cannot be null when ‘hibernate.dialect’ not set” when working with multiple data sources
  21. How to insert a column in a specific position in oracle without dropping and recreating the table?
  22. Is it possible to kill a single query in oracle without killing the session?
  23. Get the LENGTH of a LONG RAW
  24. MySQL equivalent of ORACLES rank()
  25. Reading clob line by line with pl\sql
  26. Oracle: Days between two date and Exclude weekdays how to handle negative numbers
  27. Why cannot I create triggers on objects owned by SYS?
  28. automating rollback script oracle
  29. How do I get column datatype in Oracle with PL-SQL with low privileges?
  30. How to View Oracle Stored Procedure using SQLPlus?

Leave a Comment