das akuelle Script gestartet:
<code bash>
# Home of the scrips
SCRIPTPATH=$(cd ${0%/*} && echo $PWD/$... y found)"
echo " "
exit 6
fi
##check Version of Database
VERVIEW=\$version
ISENTERISE=`echo "se... ndt.
<code bash>
# Run Script to generate Trace of Controlfile
# Run Script to generate Copy of pfile
${ORACLE_HOME}/bin/sqlplus / as sysdba << EOScipt
D damit die Rechte auch stimmen!
dd if=/dev/zero of=/opt/oracle/VOTNFSDISK/vote_nfs_disk01 bs=1M coun... SD(3302)]CRS-1615: No I/O has completed after 50% of the maximum interval. Voting file /dev/oracleasm/... 12 21:35:27.455 [OCSSD(3302)]CRS-1672: The number of voting files currently available 2 has fallen to the minimum number of voting files required 2.
....
2016-09-12 21:35:
"
=== Anzahl der Huge Pages ermitteln ===
Rule of thumb:
Byte Wert von "show SGA + 1%" / 2MB = <An... ages verwenden, falls zuwenige => ora-27102 : out of memory beim start der Instance
* auto = ab 11.2... ages_Surp: 0
HugePages_Total is the size of the pool of huge pages.
HugePages_Free is the number of huge pages in the pool that are not yet
group id
* %s: signal number
* %t: UNIX time of dump
* %h: hostname
* %e: executable filename
* %E: pathname of executable
* %h: hostname
==testen==
Als Ora... e Node Reboots or Evictions or Unexpected Recycle of CRS
vm.min_free_kbytes=524288
# Controls the maximum size of a message, in bytes
kernel.msgmnb = 65536
# Cont
en " .. The IMM is set initially with a user name of USERID and password ofPASSW0RD (with a zero, not ... d 10G auf das Storage schreiben:
dd if=/dev/zero of=/dev/mapper/mpathd bs=1M count=10000
#
hdparm -t... iver.
This will configure the on-boot properties of the Oracle ASM library
driver. The following que... t, kann eine ASM Platte auch mit "dd if=/dev/zero of=/dev/dm-x bs=8192 count=2" wieder "gelöscht" wer
group id
* %s: signal number
* %t: UNIX time of dump
* %h: hostname
* %e: executable filename
* %E: pathname of executable
* %h: hostname
==testen==
Als Ora... e Node Reboots or Evictions or Unexpected Recycle of CRS
vm.min_free_kbytes=524288
# Controls the maximum size of a message, in bytes
kernel.msgmnb = 65536
# Cont
e bash>
$ cat /etc/ntp.conf
…
restrict <ip_adress_of_your_time_server> mask 255.255.255.255 nomodify n... tightened as well, but to do so would effect some of
# the administrative functions.
restrict 127.0.0.... bash>
$ service ntpd stop
$ ntpdate -s <ip_adress_of_your_time_server>
$ service ntpd restart
</code>... tomatic Server Discovery“);
# when: number of seconds passed since last response
# poll:
ER = user owning the process
* PID = process ID of the process
* %CPU = It is the CPU time used di... me the process has been running.
* %MEM = ratio of the process’s resident set size to the physical m... ory on the machine
* VSZ = virtual memory usage of entire process
* RSS = resident set size, the n... r process state
* START = starting time or date of the process
* TIME = cumulative CPU time
* CO
ew prod
#
# crontab example
# Minute Hour Day of Month Month Day of Week Command
# (0-59) (0-23) (1-31) (1-12 or Jan-Dec... PYTEST
########## Enviroment ##############
DAY_OF_WEEK=`date +%w`
export DAY_OF_WEEK
DAY=`date +"%m_%d_%y_%H_%M"`
export DAY
########################
MOPM=100, SEMMNI=128
* 250 = SEMMSL = number of semaphores total per array / set
* 32000 = SEMMNS = maximum total number of semaphores available
* 100 = SEMOPM = Defines the maximum number of operations for each semaphore call
* 128 = SEMMNI = number of arrays available system wide = total semaphore se
fs.file-max = 6815744
# Controls the maximum size of a message, in bytes
kernel.msgmnb = 65536
# Controls the default maxmimum size of a mesage queue
kernel.msgmax = 65536
# Controls ... e maximum shared segment size, in bytes
# max 50% of total memory
# Adjust this to your setting for yo... mmax = 68719476736
# Controls the maximum number of shared memory segments, in pages
kernel.shmall =
file
#
########## Environment ##############
DAY_OF_WEEK="`date +%w`"
export DAY_OF_WEEK
DAY="`date +%d`"
export DAY
# Home of the scrips
SCRIPTPATH=$(cd ${0%/*} && echo $PWD/${0##*/... ]; then
OVERWRITE="true"
else
# check the age of the file
# if older then one day overwrite
FI
05 15:37:00 racdb01 abrt[83534]: Saved core dump of pid 83533 (/opt/oracle/product/11.2.0.4/db_home1/... group id
* %s: signal number
* %t: UNIX time of dump
* %h: hostname
* %e: executable filename
* %E: pathname of executable
* %h: hostname
fs.suid_dumpable
s set to {{ ORACLE_HOME }}"
- name : get Size of the oracle Folder
command: "du -sk {{ ORACLE... s set to /app/oracle/19c"
]
}
TASK [get Size of the oracle Folder]
********************
changed:... bash>
#!/bin/bash
#
# get the local configuration of all oracle products on this server
#
# Version: g