Category: Oracle

  • Deleting DBA Jobs

    Just because I always forget how to do this. To delete jobs from Oracle dba_jobs use the following package dbms_job.remove(xxx) where xxx is the job number. Don’t forget to stick execute in from of the command.

  • Oracle Clusterware ( CRS ) Adding and Removing Nodes

    This is a useful link for adding and removing nodes in Oracle Clusterware. It also contains details of various commands to administar and troubleshoot Clusterware problems. http://download.oracle.com/docs/cd/B14117_01/rac.101/b10765/adddel.htm

  • Oracle Clusterware ( CRS ) Install – Uninstall

    I sometimes wonder what an organisation the size of Oracle actually does sometimes. There software over the last couple of years seems to have got worse and worse. Trying to install Oracle Clusterware (CRS) seems to randomly work when attempting to create the VIP’s etc using the normal runInstaller. But when running vipca after the…