Gavin's Blog

OK, now's a good time to get back into the blogging.... Beehive 1.5.1 has been released on OTN.

Once again, here's the links:

Oracle Beehive Server Release 1 (1.5.1.0.0)

 Linux x86 (1,996,540,518 bytes) (cksum 3135990176)
Windows (32-bit) (1,914,833,669 bytes)
Solaris (SPARC 64-bit) (2,010,241,524 bytes) (cksum 1021980974)


Oracle Beekeeper Release 1 (1.5.1.0.0)

 Linux x86 (404,469,592 bytes) (cksum 2270341014)
 Windows (32-bit) (364,670,858 bytes)
 Solaris (SPARC 64-bit) (436,101,854 bytes) (cksum 1328235917)


I've just downloaded it, and firing up my OracleVM machine to get going.

If there's anything you'd like to see, let me know. I'm interested in the Workspaces aspect of the install personally. I've been involved with the beta versions so it'd be nice to see the final release of it.

Actually we could go through where the use of Workspaces could be used within a company. I know a few people have been wondering about Oracle's plethora of products in this space, and how ANOTHER portal/wiki product fits in.

By the way, you may notice that while you can download Beehive 1.5.1 from OTN, it's not on eDelivery yet... And the extra observant of you may have also noticed that OTN's references to documentation for Beehive still links to 1.4.3...

Be patient, I hear from a littler birdy that the documentation and release through eDelivery is imminent.. ie next 48 hours or so... (don't worry, I'll edit the numbers to line up later * )


Check back soon. I promise I'll post again in the next few days... once again, don't quote me :-)




Gavin


* read this as : I've been told this but don't quote me....

Edit: Beehive 1.5.1 is now available on eDelivery, and all documentation uploaded to OTN.

Now that Beehive 1.5.1 has been released, us techie type people are busy downloading, finding a fresh database to install it against and a spare mid tier with 1922MB memory to install on, but what can everyone else do while they wait...

How about spending some time to look at what we get in the 1.5.1 release. Taken from the New Features Section in the Oracle Beehive 1.5.1 Documentation on OTN.

• Oracle Beehive Extensions for Explorer - Now you're able to directly access workspaces and workspace content through Microsoft® Windows® Explorer, and now with the conferencing component, you can fire up a conference call based on the document you're looking at... like this:
  

• Oracle Beehive Workspaces Client - This is the bit I want to play with more later, but just a quick blurb... actually, let's take it straight from the documentation:

• Oracle Beehive Extensions for Outlook Enhancements - Further improvements to the OBEO, document management, serverside rules, profile migration, etc.
  

• Oracle Beehive Zimbra Enhancements - Zimbra 5.0.9 Web client is released with Beehive 1.5.1, which supports the latest browsers for Firefox, Safari and IE. Tasks have also been added, and there is now support for shared folders and workspace folders.

• Enhancements for Mobile Device Support - Pocket Outlook on Microsoft Windows Mobile enhancements.

• Oracle Beehive Conferencing Enhancements - Recording conferences and document sharing.

• Other Features and Enhancements - A bunch of other features and enhancements to find...including the new logo.
  

A few people have mentioned creating a cheat sheet for the Beehive 1.5.1 installation, so I thought I'd help out.
(I've created the following so you can just cut and paste each section if you want...)


Installing Database and Beehive on a Single Oracle Enterprise Linux 5.1 32bit machine.


After having installed the base operating system and setting up storage and networking...

#1 Ensure the following rpms have been installed:
cd /mnt/stage/OEL51x32staged/Server
rpm -Uvh gcc-4.1.1-52.el5.i386.rpm gcc-c++-4.1.1-52.el5.i386.rpm setarch-2.0-1.1.i386.rpm ksh-20060214-1.4.i386.rpm sysstat-7.0.0-3.el5.i386.rpm gdbm-1.8.0-26.2.1.i386.rpm libstdc++-4.1.1-52.el5.i386.rpm libstdc++-devel-4.1.1-52.el5.i386.rpm compat-libstdc++-296-2.96-138.i386.rpm compat-db-4.2.52-5.1.i386.rpm control-center-2.16.0-14.el5.i386.rpm glibc-common-2.5-12.i386.rpm binutils-2.17.50.0.6-2.el5.i386.rpm make-3.81-1.1.i386.rpm

#2 Create the Oracle user and Group:
groupadd -g 500 dba
groupadd -g 501 oinstall
useradd -g 500 -G 501 -u 500 oracle

#3 Add security limits for Oracle:
echo "
oracle soft nproc 2047
oracle hard nproc 16384
oracle soft nofile 1024
oracle hard nofile 65536
" >> /etc/security/limits.conf

#4 Add in the session limits library file to PAM's login file:
echo "
session required /lib/security/pam_limits.so
" >> /etc/pam.d/login

#5 Add kernel parameters:
echo "
kernel.sem = 250        32000   100      128
net.ipv4.ip_local_port_range = 1024    65000
net.core.rmem_default = 4194304
net.core.rmem_max = 4194304
net.core.wmem_default = 262144
net.core.wmem_max = 262144
" >> /etc/sysctl.conf

#6 Turn a few things off:
chkconfig sendmail off
chkconfig cups off

#7 Fix a few other things:
ln -s /usr/lib/libgdbm.so /usr/lib/libdb.so.2

#8 Install Oracle RDBMS 11g (11.1.0.6):
xhost +
su - oracle
/mnt/stage/Database1106staged/database/runInstaller
Inventory         : /opt/oracle/oraInventory
Oracle Home     : /opt/oracle/product/11.1.0/db_1

#9a Download some patches (11.1.0.7++):
# This first one is 11.1.0.7 which is 1.5GB!!!
wget --ftp-user ${metalinkusername} --ftp-password=${metalinkpassword} ftp://updates.oracle.com/6890831/p6890831_111070_Linux-x86.zip 
wget --ftp-user ${metalinkusername} --ftp-password=${metalinkpassword} ftp://updates.oracle.com/6782437/p6782437_111070_Linux-x86.zip
wget --ftp-user ${metalinkusername} --ftp-password=${metalinkpassword} ftp://updates.oracle.com/7273988/p7273988_111070_Linux-x86.zip
wget --ftp-user ${metalinkusername} --ftp-password=${metalinkpassword} ftp://updates.oracle.com/6750049/p6750049_111070_Linux-x86.zip
wget --ftp-user ${metalinkusername} --ftp-password=${metalinkpassword} ftp://updates.oracle.com/6083201/p6083201_111070_Linux-x86.zip
wget --ftp-user ${metalinkusername} --ftp-password=${metalinkpassword} ftp://updates.oracle.com/6977167/p6977167_111070_Linux-x86.zip
wget --ftp-user ${metalinkusername} --ftp-password=${metalinkpassword} ftp://updates.oracle.com/7694979/p7694979_111070_Linux-x86.zip
wget --ftp-user ${metalinkusername} --ftp-password=${metalinkpassword} ftp://updates.oracle.com/7378322/p7378322_111070_Linux-x86.zip
wget --ftp-user ${metalinkusername} --ftp-password=${metalinkpassword} ftp://updates.oracle.com/8221425/p8221425_111070_Linux-x86.zip
wget --ftp-user ${metalinkusername} --ftp-password=${metalinkpassword} ftp://updates.oracle.com/7643188/p7643188_111070_Linux-x86.zip
wget --ftp-user ${metalinkusername} --ftp-password=${metalinkpassword} ftp://updates.oracle.com/7258928/p7258928_111070_Linux-x86.zip
wget --ftp-user ${metalinkusername} --ftp-password=${metalinkpassword} ftp://updates.oracle.com/7156912/p7156912_111070_Linux-x86.zip
wget --ftp-user ${metalinkusername} --ftp-password=${metalinkpassword} ftp://updates.oracle.com/8214576/p8214576_111070_Linux-x86.zip

#Note: Obviously the above command shows your username/password into Metalink, don't use this if you're on a shared machine or if you think people will look at your shell history, it'd be better to use the .wget hidden file. See here for how to do that.


#9b Apply database patches (11.1.0.7++):
Apply 11.1.0.7

Apply the rest of the patches, none of these patches require anything other than - $ cd ${patch_no} ; opatch apply -silent
But you should do the checking yourself.


#10 If you have SELinux running, allow text relocation:
 if [ "`sestatus |grep mode`" == "Current mode:                   enforcing" ]
then
chcon -t textrel_shlib_t /opt/oracle/product/11.1.0/db_1/lib/libclntsh.so.11.1
chcon -t textrel_shlib_t /opt/oracle/product/11.1.0/db_1/lib/libnnz11.so
chcon -t textrel_shlib_t /opt/oracle/product/11.1.0/db_1/lib/libsqlplus.so
chcon -t textrel_shlib_t /opt/oracle/product/11.1.0/db_1/lib/libnque11.so
fi

#10 Create and start default listener:

$ echo "
LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = `hostname`)(PORT = 1521))
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
    )
  )
" > $ORACLE_HOME/network/admin/listener.ora
$ echo "
PBH =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = `hostname`)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = ${ORACLE_SID}`hostname |awk -F`hostname -a` ' { print $NF } '`)
    )
  )
" > $ORACLE_HOME/network/admin/tnsnames.ora

lsnrctl start

 
#11 Create the database
#
su - oracle
#ORACLE_SID=PBH.bh151dm.com  -  ( Production BeeHive - couldn't think of anything better...)

/opt/oracle/product/11.1.0/db_1/bin/dbca -silent -createDatabase -templateName General_Purpose.dbc -gdbName PBH.bh151dm.com -sysPassword syspass -systemPassword systpass -characterSet AL32UTF8 -storageType FS -automaticMemoryManagement -initParams java_pool_size=52428800,undo_retention=3600

#tip: If you go through DBCA GUI, ensure the NLS Lang is AL32UTF8 (Unicode) - the error that gets produced if you get this wrong does not help, something about {0}...


After that's finished and up and running...

#12 Change a few init.ora parameters
# if you didn't use the above silent dbca command, you might not have seen the init.ora parameters I've added... here they are.

sqlplus / as sysdba <<_EOF
alter system set java_pool_size=52428800 scope=both;
alter system set undo_retention=3600 scope=both;
exit;
_EOF

#13 Verify Database Vault is disabled...

If running sqlplus returns

Connected to:
Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - Production
With the Partitioning, Oracle Label Security, OLAP, Data Mining,
Oracle Database Vault and Real Application Testing options

Then turn it off via

cd $ORACLE_HOME/rdbms/lib ; make -f ins_rdbms.mk dv_off lbac_off ; relink oracle


#14 You're now ready to install Oracle Beehive 1.5.1

/mnt/stage/Beehive151staged/runInstaller



Let me know if I've missed something, or you want me to add some different platforms.



Gavin

While I was over on Sergio's blog looking at the oracle-validated-rpm from a comment by Avi on my last blog entry, I saw another post that I think needs more publicity :-)

New Oracle Public Yum Server

If you're like me and have a bunch of machines that you muck around on and don't want to clutter up your ULN Systems page with servers you don't care about keeping up-to-date on security/bug fixes, why not take advantage of Oracle's newly released (OK, march 2009 but still...) public yum server.

Fantastically easy. Just go here to get started.

My Oracle Beehive test server I've just done the cheat sheet on was OEL 5.1, purely because I didn't have a DVD of the latest 5.3 OEL (I know, I'm slack...) But, now, thanks to this public-yum server and the simplest of commands:

# yum upgrade

I'm now running Oracle Enterprise Linux 5.3 (Carthage).

(FYI, for those following the cheat sheet from the other post, I had to rerun the SELinux text relocation mod after the upgrade.)



Gavin