Differences between revisions 1 and 3 (spanning 2 versions)
Revision 1 as of 2013-08-08 22:43:37
Size: 153
Editor: frank
Comment:
Revision 3 as of 2015-09-24 21:46:14
Size: 1576
Editor: frank
Comment:
Deletions are marked like this. Additions are marked like this.
Line 1: Line 1:
Describe Tech/Oracle here.
Line 7: Line 5:

 * 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]
}}}
  • 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]

Tech/Oracle (last edited 2015-09-24 21:46:14 by frank)