| / the blog is here | ||
| / the blog is here | ||
| / the blog is here | ||
| / the blog is here | ||
| : A clear output of the ASM diskgroups sizes and usage | / the code is here | |
| : A GI 12c resources status output in a glimpse | / the code is here | |
| : a GI 12c/18c monitoring tool based on rac-status.sh | / the code is here | |
| : Yet Another Launcher ! | / the code is here | |
| : Exadata components versions in a glimpse | / the code is here | |
| : An overview of your Exadata disks | / the code is here | |
| : An Oracle patch reporting tool | / the code is here | |
| : Each component of an Exadata in a Rack Layout style | / the code is here | |
| : Execute a SQL on all databases running on a cluster | / the code is here | |
- Home
- Exadata
-
Scripts
- awk Tutorial An awk Tutorial - bash tips Tips to get better at Shell Scripting - asmdu.sh ASM diskgroups sizes and usage download - cell-status.sh An overview of your Exadata disks download - exa-racklayout.sh Exadata components in a Rack Layout style download - exa-versions.sh Exadata components versions in a glimpse download - list-ohpatches.sh A better Oracle patch reporting tool download - lspatches.sh [Deprecated]An Oracle patch reporting tool download - nfs-status.sh quickly check and fix NFS download - oraenv++ A powerful tool to set up your Oracle environment download - rac-mon.sh A GI monitoring tool based on rac-status.sh download - rac-on_all_db.sh Execute a SQL on all databases across a GI download - rac-status.sh A GI resources status output in a glimpse download - rac-status_rh6.sh rac-status.sh for RH6/OEL6 download - svc-failback-yes.sh failback for Oracle services download - svc-show-config.sh Show Oracle services config download - swid.sh Schedule WIth Dependencies and // download - yal.sh A dcli for non-Exadata and the Cloud download You can also clone my git repo to get all the scripts at once
- Ansible
- Clouds
-
Oracle
- - Load 2 billion rows with SQL Loader
- - crsctl stat res: syntax and optimization
- - Shared memory segments cleanup
- - I finally found my top Orace 12c-19c database feature !
- - Grid Infrastructure Out of Place Patching
- - A systemd service to stop/start Oracle databases
- - So you have removed a trace file and your FS is still filling (very fast)
- - Out of place rolling patching aka mitigate the DB downtime when patching like a pro
- - dbca: ORA-20001: Statistics Advisor: Invalid task name for the current user
- - srvctl add oraclehome
- - Upgrade Grid Infrastructure to 18c
- - dbca: Error in Process: /u01/app/oracle/product/12.2.0.1/dbhome_1/bin/orapwd
- - ASM: Why you must use HIGH redundancy in production
- - Lost entries in oratab after GI 12.2 upgrade or patch
- - Efficiently purge / rotate all the Oracle logfiles
- - Upgrade Grid Infrastructure to 12.2
- - Deprecation of OPatch Command Option "-all_nodes"
- - gridSetup.sh : ERROR: The home is not clean. This home cannot be used.
- - RMAN 11g : How To Restore / Duplicate To A More Recent Patchset
- AI
- Social
-
Consolidation has been a fancy word and concept for years in IT resulting for us DBAs with more and more databases and instances running ... -
Almost every time I connect on a new client server, I find that the Oracle logfiles are not properly and/or not totally purged which, one d...
Hey Fred - Do you have any script in mind to check applied patches across RAC nodes are identical or not? We have an 4 node RAC and wanted to see if applied patches are identical on each node and print the report back on screen just like your rac-status.sh does?
ReplyDeleteTHe requirement is to see a script that calls across all 4 nodes and report it as a single output on the patches applied to see if they are same on each node.
Any help is greatly appreciated.
Hi Ryalli,
ReplyDeleteIndeed, this one should be doing what you want : https://unknowndba.blogspot.com/2018/07/lspatchessh-oracle-patch-reporting-tool.html
Let me know.
Thanks,
Hi dear!
ReplyDeleteCan you, please help me?
I'm missing a way to include on oraenv++ the EBS set of variables that we need to run...
Example of EBS_DB.env generated by Oracle EBS Autoconfig:
#!/bin/sh
# $Header: ad8idbux.env 115.31 2013/02/08 10:44:03 mmanku ship $
# =============================================================================
# NAME
# EBS_DB.env
#
# DESCRIPTION
# Setup environment for Oracle
#
# NOTES
#
# HISTORY
# Created by AutoConfig
# =============================================================================
#
# ###############################################################
#
# This file is automatically generated by AutoConfig. It will be read and
# overwritten. If you were instructed to edit this file, or if you are not
# able to use the settings created by AutoConfig, refer to Metalink document
# 165195.1 for assistance.
#
# ###############################################################
#
# Source the custom file if it exists
customfile=/u01/app/oracle/product/12.1.0.2/dbhome_3/customEBS_DB1_ssrexadb01.env
if [ -f $customfile ]; then
. /u01/app/oracle/product/12.1.0.2/dbhome_3/customEBS_DB1_ssrexadb01.env
fi
ORACLE_HOME="/u01/app/oracle/product/12.1.0.2/dbhome_3"
export ORACLE_HOME
#
# The CONTEXT_FILE variable stores the location of the context file.
#
CONTEXT_FILE="/u01/app/oracle/product/12.1.0.2/dbhome_3/appsutil/EBS_DB1_ssrexadb01.xml"
export CONTEXT_FILE
#
# The CONTEXT_NAME variable stores the value for the current context
#
.
.
.
#
# Specific to 9i and higher ORACLE_HOME Settings
#
if test "db121" != "db817" ; then
if test "db121" = "db112" -o "db121" = "db121" ; then
#
# Set time zone file location to empty string for 11gR2 and 12C
#
ORA_TZFILE=""
export ORA_TZFILE
else
#
# Timezone Specification file
#
ORA_TZFILE="$ORACLE_HOME/oracore/zoneinfo/timezlrg.dat"
export ORA_TZFILE
fi
fi
#
# Add perl to the PATH and set PERL5LIB
#
PERLBIN=`dirname /u01/app/oracle/product/12.1.0.2/dbhome_3/perl/bin/perl`
PATH=${PERLBIN}:${PATH}
PERL5LIB=/u01/app/oracle/product/12.1.0.2/dbhome_3/perl/lib/5.14.1:/u01/app/oracle/product/12.1.0.2/dbhome_3/perl/lib/site_perl/5.14.1:/u01/app/oracle/product/12.1.0.2/dbhome_3/appsutil/perl
ADPERLPRG=/u01/app/oracle/product/12.1.0.2/dbhome_3/perl/bin/perl
export PATH
export PERL5LIB
export ADPERLPRG
if test "db121" = "db101" -o "db121" = "db102" -o "db121" = "db111" -o "db121" = "db112" -o "db121" = "db121" ; then
#
# Define the ORA_NLS10 environment variable
#
.
.
.
...
....
Thank you
Regards from Brazil.
Ricardo de Aquino Borges
Hi,
DeleteExecute it ?
. /path/EBS_DB.env