Twitter

Shortcuts

  • How to install a brand new Exadata (X2 to X7)
    		•  / the blog is here
  • How to Patch Exadata / Upgrade Exadata to 18c and 19c
    		•  / the blog is here
  • How to re-image an Exadata database server
    		•  / the blog is here
  • How to re-image an Exadata cell storage server
    		•  / the blog is here
  • asmdu.sh
    		•  : A clear output of the ASM diskgroups sizes and usage / the code is here
  • rac-status.sh
    		•  : A GI 12c resources status output in a glimpse / the code is here
  • rac-mon.sh
    		•  : a GI 12c/18c monitoring tool based on rac-status.sh / the code is here
  • yal.sh
    		•  : Yet Another Launcher ! / the code is here
  • exa-versions.sh
    		•  : Exadata components versions in a glimpse / the code is here
  • cell-status.sh
    		•  : An overview of your Exadata disks / the code is here
  • lspatches.sh
    		•  : An Oracle patch reporting tool / the code is here
  • exa-racklayout.sh
    		•  : Each component of an Exadata in a Rack Layout style / the code is here
  • rac-on_all_db.sh
    		•  : Execute a SQL on all databases running on a cluster / the code is here
  • . . . more to come . . .
    • at

    4 comments:

    1. RyalliJune 26, 2018 at 6:25 AM

      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?

      THe 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.

      ReplyDelete
    2. unknowndbaNovember 14, 2018 at 5:54 AM

      Hi Ryalli,

      Indeed, this one should be doing what you want : https://unknowndba.blogspot.com/2018/07/lspatchessh-oracle-patch-reporting-tool.html

      Let me know.

      Thanks,

      ReplyDelete
    3. AnonymousApril 4, 2024 at 6:17 AM

      Hi dear!

      Can 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

      ReplyDelete

    Subscribe to: Post Comments (Atom)

    OCI: Datapump between 23ai ADB and 19c ADB using database link

    Now that we know how to manually create a 23ai ADB in OCI , that we also know how to create a database link between a 23ai ADB and a 19C AD...