- Oracle Patch download link
https://updates.oracle.com/Orion/PatchDetails/process_form?patch_num=<patch ID>
- RAC
- Start/stop
Start a rac database (order: nodeapps – asm – database) srvctl start nodeapps -n nodename srvctl start asm -n nodename srvctl start database -d dbname options are: srvctl start database -d dbname -o open | -o mount | -o nomount Stop a rac database (order: database – asm – nodeapps) srvctl stop database -d dbname -o immediate options are: srvctl stop database -d dbname -o normal | -o transactional | -o immediate | -o abort srvctl stop asm -n nodename options are: srvctl stop asm -n nodename -o immediate srvctl stop nodeapps -n nodename To check status and configurations Nodeapps: srvctl status nodeapps -n nodename srvctl config nodeapps -n nodename ASM: srvctl status asm -n nodename srvctl config asm -n nodename Database: srvctl status database -d dbname srvctl config database -d dbname (shows instances name, node and oracle home) Instance: srvctl status instance -d dbname -i instancename Services: srvctl status service -d dbname To start and stop instances srvctl start instance -d dbname -i instancename srvctl stop instance -d dbname -i instancename To start, stop and manage services srvctl status service -d dbname srvctl config service -d dbname srvctl start service -d dbname -s servicename srvctl stop service -d dbname -s servicename srvctl relocate service -d dbname -s servicename -i instancename -t newinstancename [-f]
- Start/stop