Oracle

  1. Home
  2. Oracle
    3. (
  3. Page 8
    4. )
by Team Ajara

Scripts for Data Patch in Oracle

Scripts for Data Patch in Oracle   pre_patch.sh for db in ORCLD  ORCLT  ORCLSIT  ORCLUAT do export ORACLE_SID=$db export ORAENV_ASK=NO . oraenv >>/dev/null $ORACLE_HOME/bin/sqlplus -s  “/as sysdba”<<EOF spool pre_patch_${db}.log @pre_patch.sql
by Team Ajara

Oracle alert log monitoring by using ADRCI

Oracle alert log monitoring by using ADRCI   set -x ################################################# ###### ALERT LOG CHECKING VIA ADRCI ############# ################################################# export ORACLE_SID=ORADW4 export ORACLE_HOME=/u01/app/oracle/product/12.1.0.2/dbhome_1 export PATH=$PATH:/u01/app/oracle/product/12.1.0.2/dbhome_1/bin export ERROR_LOG=/home/oracle/admin/common/scripts/logs/alert_log_error.txt export EMAIL_ERROR_LOG=/home/oracle/admin/common/scripts/logs/alert_log_ORADW4_email_error.txt export
by Team Ajara

Oracle Artificial Intelligence Services Overview

Oracle Cloud Infrastructure(OCI) Artificial Intelligence (AI) Services Overview In this article , we will focus on OCI AI services. Business applications consume AI and ML services. The foundation of AI
by Team Ajara

Script to monitor Alert log in Oracle

 Alert log monitoring in Oracle Shell script to monitor alertlog file in Oracle databases on a server .  for example if there are 10 databases running on the server ,this
by Team Ajara

Oracle 19c Client Installation on Windows

Oracle 19c Client Installation on Windows. Download the Software from https://www.oracle.com/database/technologies/oracle19c-windows-downloads.html Client Version: 19c Step 1: First go to client software path C:\software\WINDOWS.X64_193000_client\client Step 2: Open the Setup Application and click
by Team Ajara

DB Installation and Configuration best practices 3

DB Installation and Configuration best practices. 1.Separate oracle binaries owner Description: This can be considered if the databases are managed by different DBA groups Benefits: It provides more security. Any
by Team Ajara

DB Installation and Configuration best practices 2

DB Installation and Configuration best practices. 1. export NLS_DATE_FORMAT=”MM-DD-YYYY HH24:MI:SS” Description: Environment variable to get the date value upto seconds.This variable we can set in the .profile or .bash_profile. Benefits:
by Team Ajara

DB Installation and Configuration best practices 1

DB Installation and Configuration best practices 1.Disable Transparent hugepages Description: Transparent HugePages memory is enabled by default with Red Hat Enterprise Linux , Red Hat Enterprise Linux , SUSE , 
by Team Ajara

Purge database recycle bin in oracle database

Purge database recycle bin in oracle database   export ORACLE_BASE=/u00/app/oracle export ORACLE_HOME=/u00/app/oracle/product/19000/db_1 export PATH=${ORACLE_HOME}:${ORACLE_HOME}/bin:$PATH:. export LOG_FILE=/u00/app/oracle/scripts/purge_recyclebin.logecho “Purge database recycle bin” echo ORADW   sqlplus -s /nolog << eof connect /