More Satellite Foo - Database Edition

This particular post should not be taken lightly, nor implemented without consideration.  I believe our situation might be a bit different than most in that we rely on the clients to "pull" from the Satellite (using rhnsd and rhn_check).  I believe a better solution is to use OSAD - but at this point I am uneducated on such magic. :-(

The goal here is to increase the number of Oracle DB connections.


/bin/sqlplus rhnsat/rhnsat@rhnsat

== Check number of Oracle Processes
[root@rhnsat01 ~]# su - oracle
-bash-3.2$  ORACLE_SID=rhnsat sqlplus /nolog

SQL*Plus: Release 10.2.0.4.0 - Production on Tue Jul 16 12:03:19 2013

Copyright (c) 1982, 2007, Oracle.  All Rights Reserved.

SQL> connect
Enter user-name: XXXYYY
Enter password:
Connected.
SQL> show parameter process;

NAME                     TYPE     VALUE
------------------------------------ ----------- ------------------------------
aq_tm_processes              integer     0
db_writer_processes             integer     2
gcs_server_processes             integer     0
job_queue_processes             integer     10
log_archive_max_processes         integer     2
processes                 integer     400
SQL> show parameter sessions;

NAME                     TYPE     VALUE
------------------------------------ ----------- ------------------------------
java_max_sessionspace_size         integer     0
java_soft_sessionspace_limit         integer     0
license_max_sessions             integer     0
license_sessions_warning         integer     0
logmnr_max_persistent_sessions         integer     1
sessions                 integer     445
shared_server_sessions             integer

== Update the number of processes 

# su - oracle

$ ORACLE_SID=rhnsat sqlplus /nolog

SQL*Plus: Release 10.2.0.4.0 - Production on Tue Jul 16 11:53:38 2013

Copyright (c) 1982, 2007, Oracle.  All Rights Reserved. 

SQL> alter system set processes=300 scope=spfile;

SQL> commit; 

$ exit

# /usr/sbin/rhn-satellite restart