oracle log location

Release 11gR2
$ORACLE_HOME=/u01/app/oracle/product/11.2.0/grid_n
$ORACLE_BASE=/u01/app/oracle
$ORACLE_SID=tt

export HOST=`hostname -s`

ocssd
tail -f $ORACLE_HOME/log/$HOST/cssd/ocssd.log
tail -f  $ORACLE_HOME/log/$HOST/alert$HOST.log

ohasd
tail -f  $ORACLE_HOME/log/$HOST/ohasd/ohasd.log

oraagent

tail -f $ORACLE_HOME/log/$HOST/agent/ohasd/oraagent_oracle/oraagent_oracleOUT.log
tail -f $ORACLE_HOME/log/$HOST/agent/ohasd/oraagent_oracle/oraagent_oracle.log

cssdagent 
tail -f $ORACLE_HOME/log/$HOST/agent/ohasd/oracssdagent_oracle/oracssdagent_oracle.log

orarootagent

$ORACLE_HOME/log/$HOST/agent/ohasd/orarootagent_oracle/orarootagent_oracle.log

diskmon
$ORACLE_HOME/log/$HOST/diskmon/client.log

evmlogger 

tail -f $ORACLE_HOME/evm/log/$HOST_evmlogger.log

ALERT rdbms

tail -f $ORACLE_BASE/diag/rdbms/$ORACLE_SID/$ORACLE_SID/trace/alert_$ORACLE_SID.log

ALERT ASM 

tail -f $ORACLE_BASE/diag/asm/+asm/$ORACLE_SID/trace/alert_$ORACLE_SID.log

Fix 'Error connecting to jabber server: Unable to connect to the host and port specified'

spacewalk-service stop
rm -rf /var/lib/jabberd/db/*
spacewalk-service start

https://fedorahosted.org/spacewalk/wiki/OsadHowTo
https://fedorahosted.org/spacewalk/wiki/JabberAndOSAD

Remove Spacewalk from CentOS 6.4

Insert this list to space.txt
nmap-5.51-3.0.1.el6.x86_64
glusterfs-libs-3.4.0.57rhs-1.0.1.el6_5.x86_64
glusterfs-api-3.4.0.57rhs-1.0.1.el6_5.x86_64
usbredir-0.5.1-1.el6.x86_64
qemu-img-0.12.1.2-2.415.el6_5.3.x86_64
ipmitool-1.8.11-16.el6.x86_64
lm_sensors-libs-3.1.1-17.el6.x86_64
net-snmp-libs-5.5-49.0.1.el6.x86_64
OpenIPMI-libs-2.0.16-14.el6.x86_64
OpenIPMI-2.0.16-14.el6.x86_64
postgresql-libs-8.4.20-1.el6_5.x86_64
postgresql-8.4.20-1.el6_5.x86_64
postgresql-server-8.4.20-1.el6_5.x86_64
uuid-1.6.1-10.el6.x86_64
postgresql-contrib-8.4.20-1.el6_5.x86_64
tcl-8.5.7-6.el6.x86_64
postgresql-pltcl-8.4.20-1.el6_5.x86_64
spacewalk-setup-postgresql-2.2.2-1.el6.noarch
pgtune-0.9.3-3.el6.noarch
jakarta-commons-logging-1.1-8.jpp5.noarch
jakarta-commons-collections-3.2.1-3.4.el6.noarch
jakarta-commons-lang-2.4-1.1.el6.noarch
junit-3.8.2-7.jpp5.noarch
perl-Error-0.17015-4.el6.noarch
perl-NOCpulse-Utils-1.14.12-1.el6.noarch
apr-1.3.9-5.el6_2.x86_64
apr-util-1.3.9-3.el6_0.1.x86_64
perl-Params-Validate-0.92-3.el6.x86_64
servletapi4-4.0.4-6.jpp5.noarch
perl-TimeDate-1.16-11.1.el6.noarch
perl-MailTools-2.04-4.el6.noarch
perl-Class-MethodMaker-2.16-4.el6.x86_64
perl-NOCpulse-SetID-1.7.2-1.el6.noarch
perl-FreezeThaw-0.45-5.el6.noarch
tomcat5-servlet-2.4-api-5.5.27-7.jpp5.noarch
perl-IO-stringy-2.110-10.1.el6.noarch
tomcat6-servlet-2.5-api-6.0.24-78.el6_5.noarch
geronimo-specs-poms-1.2-13.jpp5.noarch
geronimo-j2ee-1.4-apis-1.2-13.jpp5.noarch
perl-Digest-SHA1-2.12-2.el6.x86_64
antlr-2.7.7-6.5.el6.x86_64
jakarta-commons-fileupload-1.2.1-1.jpp5.noarch
spacewalk-backend-libs-2.2.43-1.el6.noarch
asm-1.5.3-7.jpp5.noarch
cglib-2.1.3-4.jpp5.noarch
java-1.6.0-openjdk-devel-1.6.0.0-7.1.13.4.el6_5.x86_64
simple-core-3.1.3-5.el6.x86_64
relaxngDatatype-1.0-3.jpp5.noarch
perl-Mail-RFC822-Address-0.3-12.el6.noarch
c3p0-0.9.1.2-2.jpp5.noarch
perl-Net-SSLeay-1.35-9.el6.x86_64
excalibur-1.0-0.r508111.13.jpp5.noarch
perl-Satcon-1.20-1.el6.noarch
msv-xsdlib-1.2-0.20050722.6.jpp5.noarch
spacewalk-jpp-workaround-2.2.3-1.el6.noarch
perl-Digest-HMAC-1.01-22.el6.noarch
spacewalk-base-minimal-2.2.33-1.el6.noarch
nocpulse-db-perl-3.6.5-1.el6.noarch
geronimo-stax-1.0-api-1.2-13.jpp5.noarch
redstone-xmlrpc-1.1_20071120-15.el6.noarch
jakarta-commons-discovery-0.4-6.jpp5.noarch
oscache-2.4.1-1.jpp5.noarch
javassist-3.9.0-6.el6.noarch
aopalliance-1.0-6.jpp5.noarch
spacewalk-slf4j-1.6.1-6.el6.noarch
quartz-1.8.4-5.el6.noarch
jakarta-commons-io-1.4-3.el6.noarch
perl-BerkeleyDB-0.43-3.el6.x86_64
easymock-1.2-3.jpp5.noarch
spacewalk-java-config-2.2.123-1.el6.noarch
perl-Net-LibIDN-0.12-3.el6.x86_64
perl-List-MoreUtils-0.22-10.el6.x86_64
perl-Config-IniFiles-2.72-2.el6.noarch
tomcat6-el-2.1-api-6.0.24-78.el6_5.noarch
perl-XML-NamespaceSupport-1.10-3.el6.noarch
perl-XML-SAX-0.96-7.el6.noarch
perl-XML-LibXML-1.70-5.el6.x86_64
asm2-2.2.3-7.jpp5.noarch
spacewalk-java-lib-2.2.123-1.el6.noarch
libyaml-0.1.6-1.el6.x86_64
PyYAML-3.10-3.el6.x86_64
perl-BSD-Resource-1.29.03-3.el6.x86_64
perl-IO-Socket-SSL-1.31-2.el6.noarch
easymock-classextension-1.2-3.jpp5.noarch
mysql-connector-java-5.1.17-6.el6.noarch
audit-libs-python-2.2-4.el6_5.x86_64
perl-Apache-DBI-1.09-1.el6.noarch
geronimo-ejb-2.1-api-1.2-13.jpp5.noarch
tomcat6-jsp-2.1-api-6.0.24-78.el6_5.noarch
tomcat5-jsp-2.0-api-5.5.27-7.jpp5.noarch
rpm-build-4.8.0-37.el6.x86_64
deltarpm-3.5-0.5.20090913git.el6.x86_64
python-deltarpm-3.5-0.5.20090913git.el6.x86_64
createrepo-0.9.9-18.0.1.el6.noarch
apr-util-ldap-1.3.9-3.el6_0.1.x86_64
httpd-tools-2.2.15-31.0.1.el6_5.x86_64
httpd-2.2.15-31.0.1.el6_5.x86_64
nocpulse-common-2.2.9-1.el6.noarch
perl-NOCpulse-Debug-1.23.17-1.el6.noarch
perl-NOCpulse-Gritch-2.2.1-1.el6.noarch
perl-NOCpulse-Object-1.26.12-1.el6.noarch
perl-NOCpulse-OracleDB-1.28.27-1.el6.noarch
mod_perl-2.0.4-11.el6_5.x86_64
ProgAGoGo-1.11.6-1.el6.noarch
perl-NOCpulse-CLAC-1.9.9-1.el6.noarch
perl-NOCpulse-ProcessPool-1.6.1-1.el6.noarch
perl-NOCpulse-PersistentConnection-1.10.1-1.el6.noarch
spacewalk-config-2.2.2-1.el6.noarch
scdb-1.15.8-1.el6.noarch
SatConfig-generator-2.29.14-1.el6.noarch
SNMPAlerts-0.5.7-1.el6.noarch
SatConfig-bootstrap-server-1.13.5-1.el6.noarch
ssl_bridge-1.9.3-1.el6.noarch
mod_wsgi-3.2-6.el6_5.x86_64
dojo-1.8.1-1.el6.noarch
libapreq2-2.13-1.el6.x86_64
perl-libapreq2-2.13-1.el6.x86_64
eventReceivers-2.20.18-1.el6.noarch
spacewalk-base-minimal-config-2.2.33-1.el6.noarch
mod_ssl-2.2.15-31.0.1.el6_5.x86_64
mockobjects-0.09-17.jpp5.noarch
libsemanage-python-2.0.43-4.2.el6.x86_64
python-psycopg2-2.0.14-2.el6.x86_64
spacewalk-backend-sql-postgresql-2.2.43-1.el6.noarch
python-simplejson-2.0.9-3.1.el6.x86_64
PyPAM-0.5.0-12.el6.x86_64
python-devel-2.6.6-52.el6.x86_64
python-hwdata-1.7.3-1.el6.noarch
spacewalk-certs-tools-2.2.1-1.el6.noarch
rhnpush-5.5.81-1.el6.noarch
python-six-1.7.3-1.el6.noarch
python-chardet-2.0.1-1.el6.noarch
python-debian-0.1.21-10.el6.noarch
spacewalk-backend-2.2.43-1.el6.noarch
spacewalk-backend-sql-2.2.43-1.el6.noarch
spacewalk-backend-server-2.2.43-1.el6.noarch
spacewalk-backend-config-files-common-2.2.43-1.el6.noarch
spacewalk-backend-xml-export-libs-2.2.43-1.el6.noarch
spacewalk-backend-app-2.2.43-1.el6.noarch
spacewalk-backend-xmlrpc-2.2.43-1.el6.noarch
spacewalk-backend-iss-export-2.2.43-1.el6.noarch
spacewalk-backend-config-files-tool-2.2.43-1.el6.noarch
spacewalk-backend-config-files-2.2.43-1.el6.noarch
spacewalk-backend-package-push-server-2.2.43-1.el6.noarch
spacewalk-backend-applet-2.2.43-1.el6.noarch
spacewalk-backend-iss-2.2.43-1.el6.noarch
libselinux-python-2.0.94-5.3.el6_4.1.x86_64
jabberpy-0.5-0.21.el6.noarch
osa-dispatcher-5.11.43-1.el6.noarch
python-markdown-2.0.1-3.1.el6.noarch
python-gzipstream-1.10.2-1.el6.noarch
python-pygments-1.1.1-1.el6.noarch
python-cheetah-2.4.1-1.el6.x86_64
icu4j-4.2.1-5.el6.x86_64
ognl-2.6.9-3.jpp5.noarch
dwr-3.0rc2-6.el6.noarch
joda-time-1.5.2-1jpp.noarch
nutch-1.0-0.16.20081201040121nightly.el6.noarch
spacewalk-doc-indexes-2.2.2-1.el6.noarch
portals-pluto10-portlet-1.0-api-1.0.1-2jpp.noarch
jettison-1.3.1-2.el6.noarch
postgresql-jdbc-8.4.701-8.el6.noarch
spring-1.2.9-3.jpp5.noarch
spring-all-1.2.9-3.jpp5.noarch
setools-libs-3.3.7-4.el6.x86_64
setools-libs-python-3.3.7-4.el6.x86_64
policycoreutils-python-2.0.83-19.39.0.1.el6.x86_64
bootstrap-3.0.0-4.el6.noarch
glassfish-jaxb-2.1.4-7.jpp5.noarch
roboto-1.2-2.el6.noarch
udns-0.0.9-5.el6.x86_64
select2-3.4.5-2.el6.noarch
perl-Authen-PAM-0.16-8.el6.x86_64
perl-DBD-Pg-2.15.1-4.el6_3.x86_64
xml-commons-1.3.04-5.jpp5.noarch
xml-commons-jaxp-1.2-apis-1.3.04-5.jpp5.noarch
libntlm-1.0-3.el6.x86_64
libgsasl-1.4.0-4.el6.x86_64
libart_lgpl-2.3.20-5.1.el6.x86_64
libgcj-4.4.7-4.el6.x86_64
jakarta-commons-beanutils-1.7.0-12.5.el6.x86_64
jakarta-commons-digester-1.8-1jpp.noarch
perl-Convert-BinHex-1.119-10.1.el6.noarch
perl-MIME-tools-5.427-4.el6.noarch
concurrent-1.3.4-9.jpp5.noarch
perl-Net-IPv4Addr-0.10-6.el6.noarch
genisoimage-1.1.9-12.el6.x86_64
jakarta-commons-el-1.0-18.4.el6.noarch
glassfish-jaf-1.1.0-5.jpp5.noarch
classpathx-mail-1.1.2-1.jpp5.noarch
perl-Email-Date-Format-1.002-5.el6.noarch
java-cup-0.11-0.a.2.jpp5.noarch
java-1.5.0-gcj-1.5.0.0-29.1.el6.x86_64
sinjdoc-0.5-9.1.el6.x86_64
xml-commons-apis-1.3.04-3.6.el6.x86_64
xml-commons-resolver-1.1-4.18.el6.x86_64
xerces-j2-2.7.1-12.6.el6_0.x86_64
xalan-j2-2.7.0-10.jpp5.noarch
jakarta-oro-2.0.8-6.6.el6.x86_64
jdom-1.1.1-1.el6.noarch
ant-1.7.1-13.el6.x86_64
jakarta-commons-codec-1.3-11.7.el6.x86_64
jakarta-commons-cli-1.1-5.el6.x86_64
jakarta-taglibs-standard-1.1.2-7.jpp5.noarch
bea-stax-api-1.2.0-0.5.rc1.2.el6.x86_64
jcommon-1.0.16-2.el6.x86_64
jakarta-commons-pool-1.3-12.7.el6.x86_64
jakarta-commons-dbcp-1.2.2-2.jpp5.noarch
jfreechart-1.0.9-4.jpp5.noarch
ant-nodeps-1.7.1-13.el6.x86_64
werken-xpath-0.9.4-4.beta.12.6.el6.noarch
jakarta-commons-validator-1.3.1-8.jpp5.noarch
xom-1.2.1-1.jpp5.noarch
xpp3-1.1.3.8-3.4.el6.noarch
tanukiwrapper-3.2.3-14.el6.x86_64
regexp-1.5-4.4.el6.x86_64
bcel-5.2-7.2.el6.x86_64
jpam-0.4-27.el6.x86_64
jakarta-commons-httpclient-3.1-0.9.el6_5.x86_64
ant-junit-1.7.1-13.el6.x86_64
ant-trax-1.7.1-13.el6.x86_64
wstx-3.1.1-3.jpp5.noarch
bea-stax-1.2.0-0.5.rc1.2.el6.x86_64
myfaces-core11-api-1.1.5-2.jpp5.noarch
struts-1.3.8-2.jpp5.noarch
jakarta-commons-chain-1.2-2.jpp5.noarch
struts-taglib-1.3.8-2.jpp5.noarch
struts-tiles-1.3.8-2.jpp5.noarch
saxpath-1.0-3.jpp5.noarch
bsf-2.4.0-4.1.el6.noarch
isorelax-0-0.5.release20050331.el6.1.noarch
ws-jaxme-0.5.1-10.jpp5.noarch
wsdl4j-1.6.2-6.jpp5.noarch
mx4j-3.0.1-9.13.el6.noarch
log4j-1.2.14-15.jpp5.noarch
axis-1.4-4.jpp5.noarch
excalibur-avalon-logkit-2.2.1-0.r508111.13.jpp5.noarch
velocity-1.5-4.jpp5.noarch
hivemind-1.1.1-3.jpp5.noarch
excalibur-avalon-framework-api-4.3.1-0.r508111.13.jpp5.noarch
excalibur-avalon-framework-impl-4.3.1-0.r508111.13.jpp5.noarch
spacewalk-search-2.2.8-1.el6.noarch
xpp2-2.1.10-6.jpp5.noarch
jaxen-1.1-3.jpp5.noarch
dom4j-1.6.1-10.jpp5.noarch
hibernate3-3.2.4-1.SP1_CP01.9.jpp5.noarch
xstream-1.3.1-1.jpp5.noarch
velocity-dvsl-1.0-2.jpp5.noarch
velocity-tools-1.4-1.jpp5.noarch
xpp3-minimal-1.1.3.8-3.4.el6.noarch
ecj-3.4.2-6.el6.x86_64
tomcat6-lib-6.0.24-78.el6_5.noarch
libreadline-java-0.8.0-24.3.el6.x86_64
jakarta-commons-daemon-1.0.1-8.9.el6.x86_64
tomcat6-6.0.24-78.el6_5.noarch
spacewalk-java-postgresql-2.2.123-1.el6.noarch
perl-Frontier-RPC-doc-0.07b4p1-9.el6.noarch
perl-Frontier-RPC-0.07b4p1-9.el6.noarch
bootstrap-datepicker-1.3.0-2.el6.noarch
select2-bootstrap-css-1.3.0-4.el6.noarch
perl-HTML-TableExtract-2.10-7.el6.noarch
perl-Newt-1.08-26.el6.x86_64
SatConfig-cluster-2.2.2-1.el6.noarch
SatConfig-bootstrap-1.11.5-1.el6.noarch
SatConfig-spread-1.1.3-1.el6.noarch
perl-MIME-Types-1.28-2.el6.noarch
perl-MIME-Lite-3.027-2.el6.noarch
perl-SOAP-Lite-0.710.10-3.el6.noarch
perl-Crypt-GeneratePassword-0.03-16.el6.noarch
compat-readline5-5.2-17.1.el6.x86_64
ruby-libs-1.8.7.352-13.el6.x86_64
ruby-1.8.7.352-13.el6.x86_64
jabberd-2.2.14-5.el6.x86_64
jquery-timepicker-1.3.3-1.el6.noarch
ace-editor-1.1.3-2.el6.noarch
xinetd-2.3.14-39.el6_4.x86_64
tftp-server-0.49-7.el6.x86_64
cobbler20-2.0.11-29.el6.noarch
spacewalk-taskomatic-2.2.123-1.el6.noarch
cobbler2-2.0.11-29.el6.noarch
simple-xml-2.6.7-3.el6.noarch
gnu-regexp-1.1.4-13.jpp5.noarch
jarjar-0.9-2.jpp5.noarch
groovy15-1.5.6-2.jpp5.noarch
hivemind-lib-1.1.1-3.jpp5.noarch
font-awesome-4.0.3-1.el6.noarch
pwstrength-bootstrap-1.0.2-3.el6.noarch
perl-IPC-ShareLite-0.13-4.el6.x86_64
perl-Cache-Cache-1.06-2.el6.noarch
apache-portlet-1.0-api-1.0-7.jpp5.noarch
tapestry-4.0.2-3.jpp5.noarch
perl-XML-RegExp-0.03-7.el6.noarch
perl-XML-DOM-1.44-7.el6.noarch
perl-XML-Generator-1.01-5.el6.noarch
SatConfig-general-1.216.31-1.el6.noarch
status_log_acceptor-0.12.11-1.el6.noarch
apache-tomcat-apis-0.1-1.el6.noarch
jython-2.2.1-4.8.el6.x86_64
freemarker-2.3.15-1.jpp5.noarch
sitemesh-2.4.1-1.jpp5.noarch
jquery-ui-1.10.4.custom-2.el6.noarch
momentjs-2.6.0-2.el6.noarch
spacewalk-branding-2.2.5-1.el6.noarch
spacewalk-html-2.2.33-1.el6.noarch
spacewalk-setup-jabberd-2.0.1-1.el6.noarch
perl-YAML-Syck-1.07-4.el6.x86_64
perl-Date-Manip-6.24-1.el6.noarch
tsdb-1.27.29-1.el6.noarch
stringtree-json-2.0.9-10.el6.noarch
perl-Crypt-DES-2.05-9.el6.x86_64
perl-Net-SNMP-5.2.0-4.el6.noarch
MessageQueue-3.26.10-1.el6.noarch
perl-NOCpulse-Probe-1.184.18-1.el6.noarch
perl-NOCpulse-Scheduler-1.58.12-1.el6.noarch
SatConfig-installer-3.24.6-1.el6.noarch
NOCpulsePlugins-2.209.7-1.el6.noarch
NPalert-1.127.12-1.el6.noarch
SputLite-client-1.10.1-1.el6.noarch
perl-Class-Singleton-1.4-6.el6.noarch
perl-DateTime-0.5300-2.el6.x86_64
spacewalk-base-2.2.33-1.el6.noarch
spacewalk-pxt-2.2.33-1.el6.noarch
spacewalk-admin-2.2.5-1.el6.noarch
spacewalk-backend-tools-2.2.43-1.el6.noarch
spacewalk-schema-2.2.33-1.el6.noarch
spacewalk-setup-2.2.13-1.el6.noarch
spacewalk-selinux-2.2.1-1.el6.noarch
SputLite-server-1.10.1-1.el6.noarch
spacewalk-monitoring-selinux-2.2.1-1.el6.noarch
spacewalk-monitoring-2.2.1-1.el6.noarch
osa-dispatcher-selinux-5.11.43-1.el6.noarch
spacewalk-sniglets-2.2.33-1.el6.noarch
spacewalk-grail-2.2.33-1.el6.noarch
susestudio-java-client-0.1.4-3.el6.noarch
spacewalk-java-2.2.123-1.el6.noarch
spacewalk-common-2.2.2-1.el6.noarch
spacewalk-postgresql-2.2.2-1.el6.noarch
velocity14-1.4-8.jpp5.noarch
geronimo-jta-1.1-api-1.2-13.jpp5.noarch

#yum  remove $(cat space.txt)

Update subversion from 1.5 to 1.6 on Centos 5.x

Stop service
# service svnserve stop

Update subversion using yum
# yum update subversion

Check the configuration svnserve daemon (/home/svn - repo home)
# cat /etc/sysconfig/svnserve
OPTIONS="-r /home/svn"

Upgrade svn repo
# svnadmin upgrade /home/svn/rep

Stat svnserve
# service svnserve start

You can compact repo to reduce the size
# svnadmin pack /home/svn/rep

Upgrade Oracle 10.2.0 to 11.2.0 Tips

While installing you got:
BEGIN wmsys.owm_mig_pkg.moveWMMetaData; END;
*
ERROR at line 1:
ORA-00942: table or view does not exist
ORA-06512: at "WMSYS.OWM_MIG_PKG", line 1579
ORA-06512: at "WMSYS.OWM_MIG_PKG", line 1596
ORA-06512: at line 1

ignore this accoding to
ORA-00942 during database upgrade of Oracle Workspace Manager (Doc ID 1399508.1)

public synonym X$KGLLK and invalid view SYS.X_$KGLLK can be dropped in 11G.
So drop the views and any synonyms related to $kslei as they are not used in 11g.
see Invalid X_$ Views & Synonyms After Upgrading to 11g (Doc ID 878623.1)

permit deploy nagios conf using nconf

/etc/sudoers
apache  ALL =(ALL) NOPASSWD:/sbin/service
#Default requiretty

/var/www/html/nconf/config/deployment.ini
;; LOCAL deployment ;;

[extract config]
type        = local
source_file = "/var/www/html/nconf/output/NagiosConfig.tgz"
target_file = "/tmp/"
action      = extract

[copy collector config]
type        = local
source_file = "/tmp/Default_collector/"
target_file = "/etc/nagios/conf.d/Default_collector/"
action      = copy

[copy global config]
type        = local
source_file = "/tmp/global/"
target_file = "/etc/nagios/conf.d/global/"
action      = copy
reload_command = "sudo /sbin/service nagios reload"

create linux user with password in one line

#!/bin/bash
# Script to add a user to Linux system
if [ $(id -u) -eq 0 ]; then
    if [ "$#" -eq 2 ]; then
        egrep "^$username" /etc/passwd >/dev/null
        if [ $? -eq 0 ]; then
            echo "$username exists!"
            exit 1
        else
            pass=$(perl -e 'print crypt($ARGV[0], "password")' $password)
            useradd -m -p $pass $username
            [ $? -eq 0 ] && echo "User has been added to system!" || echo "Failed to add a user!"
        fi
    else
    echo "Need two parameters"
    exit 3
    fi
else
    echo "Only root may add a user to the system"
    exit 2
fi

Create oracle full access user

create role OIM_Admin;
-- usualy it is bad practices grant dba role
grant dba to OIM_ADMIN;

-- alternative way 
grant all privileges to OIM_ADMIN;
-- or 
set pagesize 0
spool grant_rw.sql
select 'grant all privileges on '||owner||'.'||table_name||' to OIM_ADMIN;' from all_tables;
select 'grant select on '||owner||'.'||view_name||' to OIM_ADMIN;' from all_views;
spool off
@grant_rw.sql

CREATE USER admin_user  PROFILE "DEFAULT"
    IDENTIFIED BY "somepassword" DEFAULT TABLESPACE "USERS"
    TEMPORARY TABLESPACE "TEMP"
    ACCOUNT UNLOCK;

GRANT CREATE SESSION, ALTER SESSION TO admin_user;

grant OIM_ADMIN to admin_user;

Create oracle readonly user for all schemas (including system)

sqlplus "/as sysdba"

create role OIM_REPORTER;

-- Assigning Privileges to role
set pagesize 0
spool grant_ro.sql
select 'grant select on '||owner||'.'||table_name||' to OIM_REPORTER;' from all_tables;
select 'grant select on '||owner||'.'||view_name||' to OIM_REPORTER;' from all_views;
spool off
-- Execute it
@grant_ro.sql

CREATE USER ro_user  PROFILE "DEFAULT"
    IDENTIFIED BY "somepassword" DEFAULT TABLESPACE "USERS"
    TEMPORARY TABLESPACE "TEMP"
    ACCOUNT UNLOCK;
-- Permit the user connect to database
GRANT CREATE SESSION, ALTER SESSION TO ro_user;
-- Assigning role to user
GRANT OIM_REPORTER TO ro_user;

Note:
If you create some new tables you have to grant the permission to role.

ORA-12008 ORA-00904 ORA-06512 Oracle bug 10259677

Bug in Oracle 11.2.0.3

Workaround:

Set _replace_virtual_columns=FALSE for the refresh.

Troubleshooting connectivity issues to an NFS for VMWare

1. Check ESXi Firewall
2. Get vmknic by esxcfg-vmknic -l
3. Ping vmkping -I vmkN -s nnnn xxx.xxx.xxx.xxx
(nnnn - MTU size minus 28 bytes)
4. nc -zv IP 2049
or
rpcinfo -p ip (for ESX)

Note: The netcat command is available with ESX 4.x and ESXi 4.1 and later.
http://kb.vmware.com/selfservice/microsites/search.do?language=en_US&cmd=displayKC&externalId=1005948
http://kb.vmware.com/selfservice/microsites/search.do?language=en_US&cmd=displayKC&externalId=1003967

Change UUID VM image

$ VBoxManage showhdinfo E1_ENT_DSK_9133.vdi
UUID:                 51b69367-29aa-44ce-be69-028426efe938
Accessible:           no
Access Error:         UUID {826542ed-c388-4180-9332-29da73e52b66} of the medium '/home/xxx/E1_ENT_DSK_9133.vdi' does not match the value {51b69367-29aa-44ce-be69-028426efe938} stored in the media registry ('/home/xxx/.VirtualBox/VirtualBox.xml')
Logical size:         0 MBytes
Current size on disk: 0 MBytes
Type:                 immutable
Storage format:       VDI
Format variant:       dynamic default
Location:             /home/xxx/E1_ENT_DSK_9133.vdi

$ VBoxManage internalcommands sethduuid E1_ENT_DSK_9133.vdi 51b69367-29aa-44ce-be69-028426efe938
UUID changed to: 51b69367-29aa-44ce-be69-028426efe938

$ VBoxManage showhdinfo E1_ENT_DSK_9133.vdi
UUID:                 51b69367-29aa-44ce-be69-028426efe938
Accessible:           yes
Logical size:         20480 MBytes
Current size on disk: 10158 MBytes
Type:                 immutable
Storage format:       VDI
Format variant:       dynamic default
Location:             /home/xxx/E1_ENT_DSK_9133.vdi

Windows Server 2008 R2 Terminal Services Logout problem

Hive
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Contro l\Terminal Server\SysProcs 

Create Key DWORD 32 
Name SPLWOW64.exe 
Value 0