OraEasy

Introduction: Oracle APEX is a low-code development platform that helps you build scalable, secure enterprise apps. To access the APEX, we need ADMIN credential.This guide will walk you through to change Apex Admin Password. Prerequisites: Oracle Apex should be installed. Environment Used: Hostname : apex IP : 192.168.101.10 ORACLE_SID : APEXDB PDB : APEXPDB Apex : 24.1 ORDS : 24.2 Now let's change the ADMIN password. 1. You will get below error if ADMIN password is incorrect. 2. Stop running ORDS services by killing its PID. 3. Now change the password using below steps: [oracle@apex ~]$ cd /u02/app/oracle/apex24_1/apex/ [oracle@apex apex]$ ls apexins1.sql apex_rest_config_nocdb.sql apxdvins_nocdb.sql apxremov_nocdb.sql builder devins.sql apxrtins_nocdb.sql apexins2.sql apex_rest_config.sql apxdvins.sql apexins3.sql appins.sql apxdwngrd.sql apexins_adb.sql apxappcon.sql apxpatch_cdb.sql ...

Introduction: In Oracle, the timezone_file refers to the time zone data file that Oracle Database uses to store and manage time zone information. This file contains rules for daylight saving time and standard time for various regions. This guide will walk you through to update the timezone_file step-by-step. Time Zone Files Location: o Oracle stores time zone files in the $ORACLE_HOME/oracore/zoneinfo/ directory. o The files are named as timezlrg_XX.dat (large time zone file) and timezone_XX.dat (small time zone file), where XX represents the version number. Prerequisites: o Downtime required at Database end for 45 mins. Environment: Hostname: test IP: 192.168.101.15 ORACLE_SID : orcl Now let's upgrade the timezone_file step by step: 1. First check the current timezone file and also the available timezone file to be upgraded: SQL> SELECT version FROM v$timezone_file; VERSION ---------- 32 SQL> SQL> show pdbs CON_ID ...

Introduction: DBNEWID is a database utility that can change the internal database identifier (DBID) and the database name (DBNAME) for an operational database. This guide will walk you through the DBNEWID utility step-by-step. Ramifications of Changing the DBID and DBNAME: Before you change the DBID and DBNAME of a database with the DBNEWID utility, review these guidelines . Also post changing the DBID/DBNAME previous backups and archivelogs will not be useful. Syntax: o To change both DBID & DBNAME: nid TARGET=sys/password@orcl DBNAME=orcl2 o To change only DBNAME: nid TARGET=sys/password@orcl DBNAME=orcl2 SETNAME=YES o To change only DBID: nid TARGET=sys/password@orcl Prerequisites: o Downtime required at Database end for 30 mins. o Full RMAN DB backup to rollback in case of any issue. Environment: Hostname: apex IP: 192.168.101.7 ORACLE_SID : APEXDB DB NAME: APEX Now let's use DBNEWID utility to change DBNAME only st...

Introduction: In Oracle, a switchover is a role transition operation between the primary and standby databases in a Data Guard environment. A switchover allows you to switch roles between the primary and standby databases in a planned manner, without data loss. This is typically done for maintenance, testing, or load balancing. Here we will do switchover activity using DG broker step-by-step. Prerequisites: o Downtime required at Database end for 30 mins. o Application and Database connectivity for Standby site. o Primary and Standby databases should be in sync. o DG Broker should be configured between Primary and Standby. Environment: Server Primary Standby Hostname Source Target IP 192.168.80.51 192.168.80.111 OS OEL 9 OEL 9 SID ORCLDC ORCLDR Service Name ORCLDC ORCLD...

Introduction: Data Guard Broker is a management tool for Oracle Data Guard, which simplifies the configuration, monitoring, and administration of Data Guard environments. It provides a centralized, automated interface to manage primary and standby databases. Command-Line (DGMGRL) & GUI (Enterprise Manager) – Can be managed using DGMGRL (Data Guard Broker command-line) or Oracle Enterprise Manager Cloud Control. This guide will walk you through the Data Guard Broker step-by-step. Prerequisites: Below are the requirements for Data Guard Broker. 1. Oracle Database Enterprise Edition (Standard Edition does not support Data Guard). 2. Same Database Version & Patch Level on both primary and standby. 3. Oracle Data Guard Feature Installed on both systems. Environment: Server Primary Standby Hostname Source Target IP 192.168.80.51 192.168.80.111 OS OEL ...