EMCLI Enterprise Manager 12c/13c : Ajout d'une base de données avec mot de passe avec des caractères spéciau

Pour exécuter la commande « emcli add_target », il est nécessaire de se connecter :

1 2 3

sysman_password="<mot de passe SYSMAN>" emcli login -username=SYSMAN -password=${sysman_password} emcli sync

La définition des propriétés est réalisée via des variables :

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19

instance_name=<db_name> host_name=<full_hostname> dbhome_path=/opt/oracle/product/12.1/dbhome_1 instance_resname=${instance_name}_${host_name} user_name=DBSNMP user_role=Normal listener_name=LISTENER_${instance_name} listener_resname=LISTENER_${instance_name}_${host_name} listener_port=1521 db_properties="SID:${instance_name}" db_properties="${db_properties};Port:${listener_port}" db_properties="${db_properties};OracleHome:${dbhome_path}" db_properties="${db_properties};MachineName:${host_name}" db_credentials="UserName:${user_name};password:<mot de passe DBSNMP>;Role:${user_role}" lsnr_properties="LsnrName:${listener_name}" lsnr_properties="${lsnr_properties};ListenerOraDir:${dbhome_path}/network/admin" lsnr_properties="${lsnr_properties};Port:${listener_port}" lsnr_properties="${lsnr_properties};OracleHome:${dbhome_path}" lsnr_properties="${lsnr_properties};Machine:${host_name}"

source : 

https://easyteam.fr/emcli-enterprise-manager-12c13c-ajout-dune-base-de-donnees-avec-mot-de-passe-avec-des-caracteres-speciaux/

Useful emcli commands in EM Cloud Control 12c

Des commandes vraiment utiles ici :)

https://laurent-leturgez.com/2012/06/11/useful-emcli-commands-in-em-cloud-control-12c/

Script python avec emcli

setproperty.py :

 

#  

# Sample EMCLI Python script file for mass update a property value  

#  

  

# check number of arguments

 

if len(sys.argv) <> 3:

  print 'Usage: emcli @setproperty.py hostname "propertyname" propertyvalue'

  exit()

 

# assign the arguments to variables (for readability)

 

hostname = sys.argv[0]

propertyname = sys.argv[1]

propertyvalue = sys.argv[2]

 

# login to the OMS

 

login( username="SYSMAN", password="welcome1" )

 

# find the targets running on a given host

 

targets = list( sql="select target_name  || '@' || target_type as target from MGMT$TARGET where host_name = '" + hostname + "' and target_name <> host_name" )

 

# set the target property for each target

 

for t in targets.out()['data']:

  print "Setting property " + propertyname + " for " + t['TARGET'].split(':')[0]

  set_target_property_value( property_records= t['TARGET'] + "@" + propertyname + "@" + propertyvalue, subseparator="property_records=@" )

Source :

https://gokhanatil.com/2017/04/using-emcli-for-mass-update-a-property-value.html

[ORCL] Gestion des passw

http://www.peasland.net/2016/02/18/oracle-12c-identified-by-values/

Store Images in BLOB in Oracle

https://www.youtube.com/watch?v=r37B7_bpMRk

Doc ID 1917895.1 Changing the Database Oracle Home File Path Value in Enterprise Manager 12c Cloud Control using emcli

1. /bin/emcli login -username=sysman
   
   2. /bin/emcli sync
   
   3. OMS_HOME>/bin/emcli modify_target -name="" -type="" -properties="OracleHome:" -on_agent
   
   Example for Oracle database target:
   
   emcli modify_target -name="*" -type="oracle_database" -properties="OracleHome:/oracle/12.2.0.1" -on_agent

Doc ID 1917895.1 Changing the Database Oracle Home File Path Value in Enterprise Manager 12c Cloud Control using emcli

[SQLTUNE] Tuning un sqlid

Script sqlhc.txt

permet de tuner un sqlid . On obtient plusieurs fichiers au format html en sortie et des points sql.

 

Autres scripts de tuning :

sqldx.txt

sqlhcxec.txt

[AIX] list FS disk

listdiskFS.txt

Upgrade standby database

http://www.br8dba.com/upgrade-database-to-12-2-with-physical-standby/#7

[ORCL] Dataguard - Résoudre un gap avec la clause "FROM SERVICE"

Wow c'est chaud, mais c'est super. On peut maintenant résoudre un gap avec la méthode de LAMI ... Son blog : http://www.lami-dba.com/2018/02/dataguard-resolve-gap-revover-from-service.html Merci Lami !!!