Oracle Auto Start Script

#!/bin/sh

#
# chkconfig: 2345 99 99

#
export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=$ORACLE_BASE/product/version/db_1
export ORACLE_HOME_LISTENER=$ORACLE_HOME
export LD_LIBRARY_PATH=$ORACLE_HOME/lib
#export JAVA_HOME=$ORACLE_HOME/jdk
export PATH=$PATH:$ORACLE_HOME/bin:$JAVA_HOME/bin
export ORACLE_SID=orclcdb
#export ORACLE_TRACE=Y

export PATH=$JAVA_HOME/bin:$ORACLE_HOME/bin:$PATH

# See how we were called.
case “$1″ in
start)

su oracle -c “$ORACLE_HOME/bin/lsnrctl start"
su oracle -c “$ORACLE_HOME/bin/dbstart $ORACLE_HOME"
# su oracle -c “echo alter pluggable database all open’;’|$ORACLE_HOME/bin/sqlplus / as sysdba"
;;
stop)
su oracle -c “$ORACLE_HOME/bin/dbshut $ORACLE_HOME"
su oracle -c “$ORACLE_HOME/bin/lsnrctl stop"
;;
restart|reload)
su oracle -c “$ORACLE_HOME/bin/dbshut $ORACLE_HOME"
su oracle -c “$ORACLE_HOME/bin/lsnrctl stop"
su oracle -c “$ORACLE_HOME/bin/lsnrctl start"
su oracle -c “$ORACLE_HOME/bin/dbstart $ORACLE_HOME"
# su oracle -c “echo alter pluggable database all open’;’|$ORACLE_HOME/bin/sqlplus / as sysdba"
status)
$ORACLE_HOME/bin/lsnrctl status
;;
*)
echo $"Usage: $0 {start|stop|restart|reload}"
exit 1
esac

exit 0

 

***

Automatic DB Startup: The Linux Part (OEL 6 and 7)

***

Oracle Auto-Startup Script for Linux

How to Auto Start Oracle Database on Linux

http://www.bigdatalyn.com/2019/08/20/Oracle_Enable_AutoStart_Tips/

https://dba.stackexchange.com/questions/82260/oracle-database-12c-on-oracle-linux-7-autostart-enabling-connection-as-sysdba

https://hadafq8.wordpress.com/2016/03/05/rhel-7oel-7centos-7-configuring-automatic-startup-of-oracle-db-under-systemd/

How to Automate Startup/Shutdown of Oracle Database and Listener on Linux

 

Powercli add RDM to different nodes

http://www.dscentral.in/2016/04/11/map-shared-rdms-using-powercli/

https://kb.vmware.com/s/article/1005937

VMware PowerCLI – Adding RDM Disk’s

VMware PowerCLI script to get VM’s virtual and RDM disk information

https://www.v-front.de/2014/07/useful-powercli-scripts-for-storage.html

PowerCLI script to list VMFS,RDM and Free LUNs in a cluster

Searching for RDM Disks using PowerCLI

PowerCLI to get information about RDM connected to VM.

https://vmwareaddicted.blogspot.com/2017/05/raw-device-mapping-rdm-in-detail.html

https://virtuallyhyper.com/2012/06/powercli-script-identify-which-vm-using-rdm-lun-identified-naa-id-lun/

Finding Raw Device Mappings (RDMs) used in your VMware vSphere Environment

PowerCLI Functions – Get Raw Device Mappings and Set Perennial Reservations

http://www.enterprisedaddy.com/category/powershell/

https://www.google.com/search?client=firefox-b-d&q=Map+Shared+RDMs+using+PowerCLI

 

 

 

 

 

 

Oracle Golden Image

http://christian-gohmann.de/2017/10/27/create-golden-image-of-your-current-grid-infrastructure-12-2-installation/

https://gotodba.com/2019/10/01/using-oracle-gold-images/

http://www.ludovicocaldara.net/dba/gi-18c-gridsetup-goldimage/

https://www.markusdba.net/?p=294

https://www.bobbydurrettdba.com/2019/08/08/rolling-out-patched-19c-home-using-gold-image/

http://www.ludovicocaldara.net/dba/oh-mgmt-7/

https://www.markusdba.net/?p=294

 

Oracle alert – scripts

How to check Oracle Alert log by a crontab-ready script

Grepping Entries from Alert.log

https://connectbyoracle.wordpress.com/2015/08/28/awk-script-to-scan-alertlog-file/

https://coskan.wordpress.com/2010/12/06/alert-log-monitoring-script-via-adrci/

 

MONITORING ALERT LOG

https://dbaclass.com/article/shell-script-for-monitoring-alert-log/

https://odbablog.wordpress.com/2019/01/04/oracle-alertlog-monitoring-with-elasticsearch-and-kibana/

https://dba.stackexchange.com/questions/54512/monitoring-of-alert-log-file