All posts

  1. Home
  2. All posts
    3. (
  3. Page 24
    4. )
by krishivar.tech

A-Test Post-Text format

Where does it come from? Contrary to popular belief, Lorem Ipsum is not simply random text. It has roots in a piece of classical Latin literature from 45 BC, making
by Team Ajara

Step by step TDE Backout or rollback plan

Step by Step Transparent Data Encryption Backout or rollback plan To disable enryption of  TDE on tablespaces To decrypt the TDE on tablespaces   Step 1) set the environment .
by Team Ajara

To change oda-admin password in Oracle DB Appliance

How to change oda-admin password in Oracle Database Appliance. ODA  is short form of  Oracle Database Appliance. username: oda-admin This user is created while deploying the ODA during initial setup.
by Team Ajara

curl command in oracle

Curl command in oracle. Syntax: curl -v -T “Zip file” -o output -u “mailid of DBA” “path of OracleSR” Actual Command: curl -v -T “/u01/logs/oms_dump_29.06.06.02:48:29.zip” -o output -u “dba@Ajara.com” “https://transport.oracle.com/upload/issue/3-2379232419
by Team Ajara

How to verify DR lag ?

To verify Disaster Recovery lag Connect to DR / standby server select NAME, OPEN_MODE, LOG_MODE, FORCE_LOGGing, DATABASE_ROLE, INSTANCE_name, HOST_NAME, STARTUP_TIME from v$database,v$instance; NAME OPEN_MODE LOG_MODE FOR DATABASE_ROLE INSTANCE_NAME HOST_NAME STARTUP_T———
by Team Ajara

Java Patching on ORACLE_HOME.

Java Patching on ORACLE_HOME… Apply Java Patch Quarterly on ORACLE_HOME /GRID_HOME  to fix vulnerabilities Same patch number will be applied on GRID_HOME  link < Error while applying java patch on
by Team Ajara

Script for DB Services and ASM Disk info

Automation Solution for DB Services and ASM Disk info. Capturing Database Services details and Automatic storage Management (ASM) Disk info  has been automated to minimize startup and  post maintenance issues.100%
by Team Ajara

Report generation with Database user details.

Report generation with Database user details. Requirement: Report should contain below fields, in the last field all privileges and roles are separated by comma(,) S.No USERNAME CREATED_DATE STATUS PRIVILIGES/Roles Requirement
by Team Ajara

Downgrade GI from 19c to 12.1 in an Oracle RAC

Downgrade Grid Infrastructure from 19c Grid to 12.1 on Oracle RAC environment. 1) run below 2 commands on both the nodes using grid user — crsctl query crs activeversion— crsctl