OGG-03542 Failed to connect to the database. Verify that the connection string and following environment variables are correct

Error Summary:- When tried to login with golden gate user in Oracle Golden gate 21.3 GGSCI (oracledatabase19c.com) 3> dblogin userid ggtarget@XXXX, password XXXXX2024-05-13 17:01:49 INFO OGG-03542 Failed to connect to the database. Verify that the connection string and following environment variables are correct:TNS_ADMIN = /oem/db/app/oracle/19c/db_home_2/network/adminLD_LIBRARY_PATH = /oem/db/app/oracle/19c/db_home_2/lib.Error: OCI Error ORA (status = 12514-ORA-12514: TNS:listener does …

Installation of Oracle Golden Gate 21.3 in OEL 7

Assumption: - Oracle Database is up and running Certification matrix is checked and verified for which Oracle Golden gate is being installed for Oracle Database Note :- I am installing Oracle Golden Gate 21.3 for Oracle Database 11204 1. . Login as an Oracle operating system database user and create required HOME directory for Oracle …

Reduce Transportable Tablespace Downtime using Cross Platform Incremental Backup 11gR2 to 19c – Non CDB

Assumption Source: -Oracle Database version: - 11.2.0.3Operating system version: - Little EndianTarget: -Oracle Database version: - 19.20.0Operating system version: - Little Endian Phase 1 - Initial Setup 1.1 –Verify the source and install the destination Oracle database software Source – Oracle Database Version - 11.2.0.3.0 Target – Oracle Database Version - 19.20.0.0.0 (Non-CDB) Verify Endian …

Recovery manager compiler component, initialization of internal recovery manager and recovery manager – 19c

Error :- [oracle@oracledatabase19c ~]$ rman target / Recovery Manager: Release 19.0.0.0.0 - Production on Sun Mar 31 22:17:11 2024Version 19.3.0.0.0 Copyright (c) 1982, 2019, Oracle and/or its affiliates.  All rights reserved. RMAN-00571: ====================================RMAN-00569: ===ERROR MESSAGE STACK FOLLOWS =====RMAN-00571: ================================================RMAN-00554: initialization of internal recovery manager package failedRMAN-03000: recovery manager compiler component initialization failedRMAN-06035: wrong version of recover.bsq, expecting 19.03.00.00, …

Upgrade and Migrate Oracle Database 11gR2 to 19c – Non CDB using TTS

Moving data using transportable tablespaces can be faster than performing either a full export/import or unload/load of the same data. Reason is the datafiles containing all of the actual data are just copied to the destination location, and use the datapump export/import utility to transfer only the metadata of the tablespace objects to the new …

Changing Oracle Database Character Set in Oracle Database 11203

[oracle@12cOCP backup]$ sqlplus / as sysdbaSQL*Plus: Release 11.2.0.3.0 Production on Tue Mar 19 15:00:02 2024Copyright (c) 1982, 2011, Oracle. All rights reserved.Connected to:Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit ProductionWith the Partitioning, OLAP, Data Mining and Real Application Testing optionsSQL> select VALUE from NLS_DATABASE_PARAMETERS where parameter='NLS_CHARACTERSET';VALUEWE8MSWIN12521.. shutdown immediate;2.. alter system enable restricted session;3.. …

Monitoring Oracle databases with Checkmk

Checkmk is a software developed in Python and C++ for IT Infrastructure monitoring. It is used for the monitoring of servers, applications, networks, cloud infrastructures (public, private, hybrid), containers, storage, databases and environment sensors. 1 Configuring access accounts for Oracle monitoring Login to Oracle Database as sysdba user and create user Note: - In case …

Applying Oracle Database 19c Release Update patch – Non CDB

Prerequisites Back up of ORACLE_HOME binaries and central Inventory should be taken before applying Database Release Update patch Oracle Database Release Update 19.20.0.0.230718 patches are cumulative. So all previous Database bundles is included in the latest Database bundle patch. To install the Database Release Update 19.20.0.0.230718 patch the Oracle home must have Oracle Database release …

Open Physical Standby Database When Primary Database is inaccessible

Assumptions let say one fine day you lost your primarydatabase and you are left with opening Physical standby database. 1.. Check the protection mode and database role of the physical stand by database set lines 200;select name,open_mode,protection_mode,database_role,db_unique_name from v$database; Note: - If Protection mode is other than max performance then modify it alter database set …

Upgrade 2 Node RAC Oracle Database from 12c to 19c using DBUA

Pre-Upgrade Tasks 1. Execute preupgrade script and resolve error and perform all actions mentioned in log /u101/app/oracle/12cR1/product/db_12c/jdk/bin/java -jar /u101/app/oracle/19CH/product/db_home/rdbms/admin/preupgrade.jar TERMINAL TEXT select object_name, original_name, type, can_undrop as "UND", can_purge as "PUR", droptime from recyclebin; PURGE DBA_RECYCLEBIN; select count(*) from recyclebin; rman target /list archivelog all;delete archivelog all;crosscheck archivelog all; set linesize 500col NAME for a50select name, ROUND(SPACE_LIMIT/1024/1024/1024,2) "Allocated Space(GB)",round(SPACE_USED/1024/1024/1024,2) …