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 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 - 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
   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;
   Oracle Ultra Search VALID
   Oracle XML Database VALID
   Oracle Text VALID
   Oracle Expression Filter VALID
   Oracle Rules Manager VALID
   Oracle Workspace Manager VALID
   Oracle Database Catalog Views VALID
   Oracle Database Packages and Types VALID
   JServer JAVA Virtual Machine VALID
   Oracle XDK VALID
   Oracle Database Java Packages VALID
  • 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:

  • To this: