Install gui to server

yum groupinstall "GNOME Desktop Environment" Works on Redhat, CentOS, Fedora

Oracle Enterprise Manager (EM)

Create EM at a later time
emca -config dbcontrol db -repos create -silent -ORACLE_HOSTNAME devdb1.com -PORT 1521 -SERVICE_NAME PRDB1.devdb1 -SYS_PWD pa55w0rd -SID PRDB1 -DBSNMP_PWD pa55w0rd -SYSMAN_PWD pa55w0rd -DBCONTROL_HTTP_PORT 1158 -AGENT_PORT 3938 -RMI_PORT 5521 -JMS_PORT 5541

Drop EM at a later time
emca -deconfig dbcontrol db -repos drop -silent -ORACLE_HOSTNAME devdb1.com -PORT 1521 -SERVICE_NAME PRDB1.devdb1 -SYS_PWD pa55w0rd -SID PRDB1 -DBSNMP_PWD pa55w0rd -SYSMAN_PWD pa55w0rd -DBCONTROL_HTTP_PORT 1158 -AGENT_PORT 3938 -RMI_PORT 5521 -JMS_PORT 5541

When the database host name or the IP address changes, deconfigure and then reconfigure the Database Console with the repository create command. Run the following command:
emca -deconfig dbcontrol db -repos drop emca -config dbcontrol db -repos create

On 17 Oct 2012, i had issues / errors createing the above, so finally found, I had to apply the patch since for db 10.2.0.5 certificate was out of date:

PATCH:8350262 - CREATE DBCONSOLE CERT WITH 10YEAR VALIDITY

Good read/doc on this topic in Metalink: Enterprise Manager Database Control Configuration - Recovering From Errors Due to CA Expiry on Oracle Database 10.2.0.4 or 10.2.0.5 [ID 1222603.1]

SQLPlus formating -without any fancy clients

Sqlplus output are a pain for end users (if too many columns), Here is a middle middle ground, without too much work and without a client, giving output with html tags. Here is quick step on formatting with html, I think we should offer, since little work for us, and gives some formatting.

1. Save the below sql as html.sql (taken from http://uhesse.com)
2. Run the users sql, it will output on screen
3. Run @html
4. HTML out put will go in myoutput.html

==

----------------------------------------
-- get the last SQL*Plus output in HTML
-- after Tanel Poder
----------------------------------------

set termout off

set markup HTML ON HEAD " -
 -
" -
BODY "" -
TABLE "border='1' align='center' summary='Script output'" -
SPOOL ON ENTMAP ON PREFORMAT OFF

spool myoutput.html

l
/

spool off
set markup html off spool off
host firefox myoutput.html
set termout on

next page

http://openelec.thestateofme.com/

Raspberry Pi

1. Pre Pi OS prep (install tool) I installed this 1st 'win32diskimager-binary.zip' 2. Install OS on Pi SD-Card Using the tool of step 1, copy the OS image to SD Card 3. Test OS Boot the machine worked fine. There is no ON button, connecting the power is ON 4. Java on Pi Installed Java, after having to regiser to download I have used: 'Java SE Embedded 6 - ARMv6/7 Linux - Headless' gunzip tar xvf The directory ejre1.6.0_34 will be created in your current directory and populated with the entire JRE release. This installation directory, /ejre1.6.0_34, will be hereafter referred to as . Add /bin to your PATH environment variable setting in order to run the Java binaries. This also worked for me on 23 Sep 2012 5. Testing of Sound To test sound, ref: http://raspberrypi.stackexchange.com/questions/44/why-is-my-audio-sound-output-not-working sudo apt-get install alsa-utils sudo modprobe snd_bcm2835 sudo aplay /usr/share/sounds/alsa/Front_Center.wav On 24 Sep 2012, this worked for my on my R.Pi

Excel notes for phone style

=IF(MID(AN54,1,2)="79",CONCATENATE("0",MID(AN54,1,2),"-",MID(AN54,3,3),"-",MID(AN54,6,10)),AN54)

Grant Materialized view

grant query rewrite to user1; grant create materialized view to user1; Make sure: SYSTEM> show parameter query NAME TYPE VALUE ------------------------------ ----------- ------------------ query_rewrite_enabled string TRUE