MoinMoin Logo
Login

Tech/Oracle

  • XiheWiki
  • RecentChanges
  • FindPage
  • HelpContents
  • Tech/Oracle

Revision 3 as of 2015-09-24 21:46:14

Clear message
  • Immutable Page
  • Comments
  • Info
  • Attachments
  • 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]
  • Immutable Page
  • Comments
  • Info
  • Attachments
  • MoinMoin Powered
  • Python Powered
  • GPL licensed
  • Valid HTML 4.01