Dear All, In this post im going to share the difference between Oracle DBA and Oracle Apps DBA . Oracle DBA: >> Oracle DBAs focus on install, configure, management and maintaining the Oracle db servers. Oracle Core DBA Roles:  -------------------- database software installation,  database configuration, user , tablespace and db security management, database backup and recovery,  database clone & DR activites  database performance tuning & troubleshooting performance issues. >> Basic Skills Required :   SQL / PL SQL  language basics ..read more

 Dear All, In this post i will show you how to Create Oracle 19C Dataguard Primary and Physical Standby Database configuration step by step Process. Part 3 : Data guard configuration (Both primary and physical standby configuration) ( part 3 check next post ) Ø  Primary side configuration steps Ø  Standby server side configuration steps Ø  DG configuration. check for Part 1 and 2  ANJANI APPS DBA: How to Create Oracle 19C Dataguard Primary and Physical Standby Database step by step process part 1 Part 3 : Data guard configuration (Both primary and phy ..read more

 Dear All, In this post i will show you how to Create Oracle 19C Dataguard Primary and Physical Standby Database configuration step by step Process. Part 1 :  Oracle 19C database install and configurate (primary node setup) Part 2 : Oracle 19C database install (standby server setup) Part 3 : Data guard configuration (Both primary and physical standby configuration) ( part 3 check next post ) Ø  Primary side configuration steps Ø  Standby server side configuration steps Ø  DG configuration. Pre-requisites: configure the primary database with 19C db and install the stan ..read more

 Dear All, How to enable database vault in oracle 19C Multitenant database. Configuring and Enable Database Vault for CDB?( On prime database servers ).   1.      How to Verify if Label Security and Database Vault are Configured and installed. col DESCRIPTION format a40 set lines 500 SELECT * FROM SYS.DBA_DV_STATUS;  ( db vault status ) SELECT * FROM DBA_OLS_STATUS; ( db labled status ) We have to create 2 user one for db vault user and another for account manager user .. it will create new users for you. 2.      How ..read more

 Dear All, How to apply Jul-2024 RU patches on Oracle 19C :   1.    We need to check existing opatch patch version & last applied RU patches  and database versions.   2.    Download the latest RU patch from metal ink/ support.oracle.com Oracle Database 19c Proactive Patch Information (Doc ID 2521164.1) >> downloaded latest Jul 2024 RU patch  (36582781 ) >> downloaded latest Opath utility .( 6880688)   How to install the utility: Opatch utility install/ upgrade ..read more

 Dear All, In this post i am going to share few RAC database admin commands (ASM & Listener) > Connect to RAC server and user below commands from User session level. srvctl add asm -n node_name -i asminstance -o ORACLE_HOME [-p spfile] srvctl remove asm -n node_name [-i asminstance] [-f] srvctl remove asm -n db6 srvctl start asm -n node_name [-i asminstance] [-o start_options] [-c connect_str|-q] srvctl start asm -n node_name [-i asminstance] [-o open] srvctl start asm -n node_name [-i asminstance] -o nomount srvctl start asm -n node_name [-i asminstance ..read more

 Dear All, In this post i am going to share post JWS enablement browser setup steps. Post JWS enable All Browsers setup steps for EBS R12.2  :   JWS post steps on  Google Chrome Google Chrome has not supported the Java Plug-in since release 45. Therefore, the Forms application and regular Java applets as part of the EBS can only run with JWS.  Google Chrome for Windows Users  Recommended browser configuration using Chrome policies on Windows Operating System Google Chrome version 84 and later supports automatic opening of the Forms application and regular Java a ..read more

 Dear All, RacsInfoTech stating new Oracle 19C DBA online Training from 1st Aug 2024 . Oracle 19C DBA Course: Duration 40 hours 1st Aug 2024 - 7:30PM to 9:00 PM IST ... (Only on Weekdays) Contact us:    racsinfotech@gmail.com   / +91 9392634440 (direct call / WhatsApp calls available) Course Index:   Oracle 19C DBA Training with Live Labs. 1. 12c and 19c Architecture. 2. DBA Roles and Responsibilities  3. Required tools and Prerequisites for DBA Training. 4. VirtualBox , Linux OS and Database Installation . 5. How to connect to dat ..read more

 Dear All, In this post will share couple of Workflow mailer related information as part of Oracle Apps DBA Job. 1 Set Override Address  Set the Override Address to the required address: Run the following script @$FND_TOP/sql/afsvcpup.sql from sqlplus as apps user   SQL> @$FND_TOP/sql/afsvcpup.sql   Component Id Component Name                 Component Status Type            Containe ..read more

  Dear All,  In this post i am going to share Oracle Apps Post clone checks and steps . 1 Check Custom Top   1.1 Recreate soft links in custom top   Remove and recreate custom links in XXRACSINFOTECH_TOP: NOTE: On both PATCH and RUN filesystem   cd $XXRACSINFOTECH_TOP/bin ls -l | grep "fndcpesr" | awk '{print "ln -fs $FND_TOP/bin/fndcpesr " $9}'   Run the output from the above command.   1.2 dba_directories   Update direcotires – check all of them! Use this sql to help generate sql and run as sysdba:   select 'create or replace dir ..read more