Skip to main content

run unix command on multiple servers using ssh in mobaxTerm

I get a request to check ldap.ora on all $ORACLE_HOME on 300 Unix servers. I do not want to logon to each server and check each oracle_home, I use the following method to check, it took a few hours to build this solution, and then I can run it again and again, and each time it only took a few minutes to complete!

Step1: find out all the ORACLE_HOME registered in Grid Control. I use this query:

with oraclehomevw as
(
SELECT mgmt$target.host_name
 , mgmt$target.target_name
 , mgmt$target.target_type
 , mgmt$target_properties.property_name
 , mgmt$target_properties.property_value
 FROM mgmt$target , mgmt$target_properties
 WHERE ( mgmt$target.target_name = mgmt$target_properties.target_name )
 AND ( mgmt$target.target_type = mgmt$target_properties.target_type )
 and ( lower(mgmt$target_properties.property_name) like '%%home%')
 and  mgmt$target_properties.property_value is not null
and lower(mgmt$target_properties.property_name) not in ('domain_home','home_guid','adrhome','javahome')
and (mgmt$target_properties.property_value like '%/%/%' or mgmt$target_properties.property_value like '%\\%')
and mgmt$target.host_name not like '%http%'
)
select distinct 'echo "Checking '||host_name||':'||property_value ||'/network/admin/ldap.ora:" >> /drives/c/dropit/d.txt; sshpass -p $PASSWORD ssh oracleunixuser@'||host_name||' grep -i ldap '||property_value||'/network/admin/ldap.ora >>/drives/c/dropit/d.txt' from oraclehomevw order by 1
/
Save the query output to c:\dropit\ldap.bat, 300+ lines like this...

echo "Checking servername.domain.com:$oracle_home/network/admin/ldap.ora:" >> /drives/c/dropit/d.txt; sshpass -p $PASSWORD ssh oracleunixuser@ servername.domain.com grep -i _SERVERS $oracle_home/network/admin/ldap.ora >>/drives/c/dropit/d.txt                                                                                          
...




Step 2: run this generated query in mobaxterm.
export $PASSWORD=oracleunixaccountpassword
cd /cygdrive/c/dropit/
sh ./ldap.bat

The output t.txt has many lines like this:

Checking servername.domain.com:$oracle_home/network/admin/ldap.ora:
DIRECTORY_SERVERS= (ldapservername1.domain:port:ssl port, ldapservername2.domain:port:ssl port)
...

Step 3: Examine the output file and check the setting.

Comments

Post a Comment

Popular posts from this blog

non-existent process lock port on windows server

I have a database link created between oracle and sqlserver using oracle tg4odbc, the product is installed on windows server and run as service "OracleOraGtw11g_home1TNSListener", but sometime the service cannot started, the root cause of this problem is that the port number 1521 is used by an non-existent process. The first step is to use netstat -bano|find "1521" to get the process id, in my case it's 5844, which shows the connection is from my oracle server 10.8.0.169 H:\>netstat -bano|find "1521"   TCP    0.0.0.0:1521           0.0.0.0:0              LISTENING       5844   TCP    10.14.45.33:1521       10.8.0.169:42987       ESTABLISHED     5844 however the process id does not show in either task manager or process explorer. The next step is to run tcpview, which shows non-existent under process column, there are three rows, two show status as "listening", the other one shows status "established", right click and k
3 comments
Read more

Opatch apply/lsinventory error: oneoff is corrupted or does not exist

I am applying the quarterly patch for 19c RDBMS, I tried using napply but failed, but somehow it corrupted the inventory though nothing applied. further apply and lsinventory command ran into error like this: $ ./OPatch/opatch lsinventory Oracle Interim Patch Installer version 12.2.0.1.21 Copyright (c) 2020, Oracle Corporation.  All rights reserved. Oracle Home       : /u02/app/oracle/19.0.0 Central Inventory : /u01/app/oraInventory    from           : /u02/app/oracle/19.0.0/oraInst.loc OPatch version    : 12.2.0.1.21 OUI version       : 12.2.0.7.0 Log file location : /u02/app/oracle/19.0.0/cfgtoollogs/opatch/opatch2020-09-08_13-35-59PM_1.log Lsinventory Output file location : /u02/app/oracle/19.0.0/cfgtoollogs/opatch/lsinv/lsinventory2020-09-08_13-35-59PM.txt -------------------------------------------------------------------------------- Inventory load failed... OPatch cannot load inventory for the given Oracle Home. LsInventorySession failed: Unable to create patchObject Possible ca
Post a Comment
Read more

shell script to clean up oracle dumpfile

https://github.com/iacosta/personal/blob/master/shells/cleanhouse.sh #!/bin/ksh # # Script used to cleanup any Oracle environment. # # Cleans:      audit_file_dest #              background_dump_dest #              core_dump_dest #              user_dump_dest #              Clusterware logs # # Rotates:     Alert Logs #              Listener Logs # # Scheduling:  00 00 * * * /networkdrive/dba/scripts/purge/cleanup.sh -d 7 > /u01/dba/bin/cleanup.log 2>&1 # # Created By:  Lei Dao # # # RM="rm -f" RMDIR="rm -rf" LS="ls -l" MV="mv" TOUCH="touch" TESTTOUCH="echo touch" TESTMV="echo mv" TESTRM=$LS TESTRMDIR=$LS SUCCESS=0 FAILURE=1 TEST=0 HOSTNAME=`hostname` ORAENV="oraenv" TODAY=`date +%Y%m%d` ORIGPATH=/usr/local/bin:$PATH ORIGLD=$LD_LIBRARY_PATH export PATH=$ORIGPATH # Usage function. f_usage(){   echo "Usage: `basename $0` -d DAYS [-a DAYS] [-b DAYS] [
Post a Comment
Read more