informationagenation.wordpress.com

A reference journal on interesting IT topics

Archive for June 2013

Quick settings, Oracle 11.1 db, kernel parameters and other, for Solaris 11 and OI 11 x86-64

leave a comment »

WARNING, USE AT YOUR OWN RISK !

groupadd dba
groupadd oinstall
groupadd asmdba
groupadd asmadmin
echo "oracle localhost:/export/home/&" >> /etc/auto_home
useradd -g oinstall -G dba,asmdba,asmadmin -m -d /home/oracle -s /bin/bash oracle
passwd oracle
projadd -U oracle -K "project.max-shm-memory=(priv,5g,deny)" user.oracle
projmod -sK "project.max-sem-nsems=(priv,512,deny)" user.oracle
projmod -sK "project.max-sem-ids=(priv,128,deny)" user.oracle
projmod -sK "project.max-shm-ids=(priv,128,deny)" user.oracle
ipadm set-prop -p smallest_anon_port=9000 tcp
ipadm set-prop -p largest_anon_port=65500 tcp
ipadm set-prop -p smallest_anon_port=9000 udp
ipadm set-prop -p largest_anon_port=65500 udp
ipadm show-prop|grep anon|egrep 'tcp|udp'
echo "set maxuprc=16384" >> /etc/system
echo "set max_nprocs=30000" >> /etc/system
echo "set shmsys:shminfo_shmmax=4294967295" >> /etc/system
pkginfo -i SUNWarc SUNWbtool SUNWhea SUNWlibm SUNWlibms SUNWpool SUNWpoolr SUNWsprot SUNWtoo SUNWuiu8 SUNWfont-xorg-core SUNWfont-xorg-iso8859-1 SUNWmfrun SUNWxorg-client-programs SUNWxorg-clientlibs SUNWxwfsw SUNWxwplt
pkg install compatibility/packages/SUNWxwplt SUNWmfrun SUNWarc SUNWhea SUNWlibm

You may have to review MEMORY_TARGET, on the Oracle Solaris install it was not needed, the installer picked it up and set it to proper values, but on the OI install I had a too low MEMORY_MAX_TARGET , would make the machine responding very slow, I had to raise that one, 75% of physical RAM is safe, with a swap of 150% of RAM.

Advertisements

Written by dibi58

June 15, 2013 at 7:50 am

Adempiere on Oracle 11 on OI 5.11 151.7 x64, unusable on x64

leave a comment »

Unusable on an x64, you may have better luck with a T5, just don’t have the resources to run this thing, too heavy.

adempiere-starting

Written by dibi58

June 15, 2013 at 7:43 am

Posted in DB, oracle, solaris, WEB

Adminer on oi64 5.11, really nice and fast

leave a comment »

adminer-oi64

Written by dibi58

June 14, 2013 at 5:40 am

Posted in mysql, WEB

Oracle 11R2 x64 running on both boxes now

leave a comment »

Here on Solaris 11.11 and OI 151 x64

ora11R2-sol11-x64

ora11R2-sol11-x64

ora11R2-on-oi64-151

ora11R2-on-oi64-151

Written by dibi58

June 10, 2013 at 4:08 pm

Posted in DB, oracle, OS, solaris, unix

Now running oi on amd64, really nice

leave a comment »

More work to do, such as all the usual Oracle stuff, but getting there.

newyak

Written by dibi58

June 6, 2013 at 4:49 pm

Posted in esoteric, OS, solaris, unix