Update Oracle Patch

Before you start the upgrade installer (./runInstaller) you have to first stop collecting CDRs at NexOSS and also stop Oracle.

  • To stop pulling CDRs, you can just stop NexOSS altogether using stop_NexOSS.sh.
   $ cd $NexOSS_HOME/unix/run
   $ ./stop_NexOSS.sh
  • To stop Oracle you can change to the root user and execute the following:
   # /etc/init.d/dbora stop
  • Put the patch into the /ORA directory and then follow the steps below. Note: You will need an SSH client on your PC that will allow X11 tunneling to the server as well as an X server running in passive mode. This is the only way that you will be able to display the Oracle installer GUI unless you are working directly from the console of the server.

  • Patch Installation:

   $ unzip p6890831_111070_Linux-x86-64.zip
   $ cd Disk1
   $ ./runInstaller
   Starting Oracle Universal Installer...
   Preparing to launch Oracle Universal Installer from
   Oracle Universal Installer, Version 11.1.0.7.0 Production
   Copyright (C) 1999, 2008, Oracle. All rights reserved.

You will receive notice before the process is complete to do the step below.

  • Open another SSH window as root to perform this step at the appropriate time.
   $ su -
   root's password:
   # /u00/app/oracle/product/11.1/db_1/root.sh
   Running Oracle 11g root.sh script...
   # exit
  • Post Patch Procedures:
   $ sqlplus / as sysdba
   SQL*Plus: Release 11.1.0.7.0 - Production on Sat Sep 20 11:10:35 2008
   Copyright (c) 1982, 2008, Oracle. All rights reserved.
   Connected to an idle instance.
   SQL> startup quiet migrate
   ORACLE instance started.
   Database mounted.
   Database opened.
   SQL> set time on
   11:42:21 SQL> sho parameter sga_target
   NAME TYPE VALUE
   +++++++++++++++++++++++++++++++++++++++-
   sga_target big integer 200M
   11:42:25 SQL> alter system set sga_target=300m scope=spfile;
   System altered.
   11:42:28 SQL> shutdown immediate
   Database closed.
   Database dismounted.
   ORACLE instance shut down.
   11:42:43 SQL> startup quiet migrate
   ORACLE instance started.
   Database mounted.
   Database opened.
   11:43:01 SQL> @?/rdbms/admin/catupgrd (This will take some hours to complete)
   ...
   11:54:03 SQL> Rem END catupgrd.sql
   11:54:03 SQL> startup
   ORACLE instance started.
   Total System Global Area 313159680 bytes
   Fixed Size 2159272 bytes
   Variable Size 226495832 bytes
   Database Buffers 79691776 bytes
   Redo Buffers 4812800 bytes
   Database mounted.
   Database opened.
   11:56:28 SQL> select comp_name,status,version from dba_registry;
   COMP_NAME STATUS VERSION
   +++++++++++++++++++++++++++++++++++++++-
   Oracle Ultra Search VALID 11.1.0.7.0
   Oracle XML Database VALID 11.1.0.7.0
   Oracle Text VALID 11.1.0.7.0
   Oracle Expression Filter VALID 11.1.0.7.0
   Oracle Rules Manager VALID 11.1.0.7.0
   Oracle Workspace Manager VALID 11.1.0.7.0
   Oracle Database Catalog Views VALID 11.1.0.7.0
   Oracle Database Packages and Types VALID 11.1.0.7.0
   JServer JAVA Virtual Machine VALID 11.1.0.7.0
   Oracle XDK VALID 11.1.0.7.0
   Oracle Database Java Packages VALID 11.1.0.7.0
  • The dbstart and dbshut scripts will have to be edited upon completion to include the path for ORACLE_HOME_LISTNER. Navigate to the bin directory for Oracle and edit dbstart and dbshut.
   $ cd $ORACLE_HOME/bin
   $ vi dbstart
   $ vi dbshut
  • For both scripts change this:

      ORACLE_HOME_LISTNER=$1
    
  • To this:

      ORACLE_HOME_LISTNER=/ORA/oracle/product/11.1.0/db_1