Skip to Main Content
  • Questions
  • After recovering a RMAN backup from linux to windows os we get ORA-01804 error on connect

Breadcrumb

Question and Answer

Connor McDonald

Thanks for the question, Hans.

Asked: October 20, 2023 - 6:19 am UTC

Last updated: October 22, 2023 - 11:47 pm UTC

Version: 12c

Viewed 100+ times

You Asked

When I try to connect to the restored database through SQLdeveloper with a valid username I get the following error.


An error was encountered performing the requested operation:

ORA-00604: Fout opgetreden bij recursief SQL-niveau 1.
ORA-01804: Initialiseren van de tijdzonegegevens is mislukt.
00604. 00000 - "error occurred at recursive SQL level %s"
*Cause: An error occurred while processing a recursive SQL statement
(a statement applying to internal dictionary tables).
*Action: If the situation described in the next error on the stack
can be corrected, do so; otherwise contact Oracle Support.
Vendor code 604

When I try to make a temp tablespace I get a message that looks quite familiar with this.
SQL> create temporary tablespace TEMP01 TEMPFILE 'D:\Oracle\db_home\database\nbgp\temp01.dbf' SIZE 200M;
create temporary tablespace TEMP01 TEMPFILE 'D:\Oracle\db_home\database\nbgp\temp01.dbf' SIZE 200M
*
FOUT in regel 1:
.ORA-04088: Fout bij uitvoering van trigger 'MDSYS.SDO_GEOR_BDDL_TRIGGER'.
ORA-00604: Fout opgetreden bij recursief SQL-niveau 1.
ORA-01804: Initialiseren van de tijdzonegegevens is mislukt.

What could be wrong

and Connor said...

Check MOS notes 1562424.1 and 365558.1

Looks like the timezone from the source database does not match the timezone data available in the new ORACLE_HOME you have restored into.

Rating

  (1 rating)

We're not taking comments currently, so please try again later if you want to add a comment.

More to Explore

PL/SQL demos

Check out more PL/SQL tutorials on our LiveSQL tool.

PL/SQL docs

PL/SQL reference manual from the Oracle documentation library