Feed aggregator

鼻にできるニキビの原因と正しいケア方法

OraQA - Mon, 2016-03-07 02:35
鼻ニキビは目立つこともあり、できる限りできないでほしい存在です。 そのためにはケアや予防が必要となりますが、ま […]

お尻ニキビができてしまう原因と正しいケア方法

OraQA - Mon, 2016-03-07 02:33
お尻は刺激を受けやすい場所ですから、お尻ニキビができてしまうと痛いですし、なかなか治らないと悩まれる方は多いで […]

顎ニキビができてしまう原因と正しいケア方法

OraQA - Mon, 2016-03-07 02:31
顎ニキビは、男女ともに発症・問題化する可能性が高いものです。自分では効果的なケアを行っていると思っていても、実 […]

背中ニキビができてしまう原因と正しいケア方法

OraQA - Mon, 2016-03-07 02:29
はじめに自分では中々気づきにくい背中ニキビは出来てしまってからでは、中々治すのが難しい肌トラブルです。背中ニキ […]

The Anki Overdrive Car Project

Oracle AppsLab - Mon, 2016-03-07 02:07

At the end of 2015, our team was wrapping up projects that would be shown at the main Oracle conference, Oracle OpenWorld.

As with every OOW, we like to come up with a fun project that shows attendees our spirit of innovation by building cool projects within Oracle.

The team was thinking about building something cool with kids’ racetracks. We all were collectively in charge of looking for alternatives, so we visited a toy store to get ideas and see products that already existed out there.

We looked pretty cool racetracks but none of them suited our needs for functionality and of course, we didn’t have enough time to invest on modifying some of them.

So, searching through internet someone came up with Anki OVERDRIVE cars, yes, that product that was announced back in 2013 at Apple WWDC keynote. To sum up, Anki provides a racetrack that includes flexible plastic magnets tracks that can be chained together and to allow for any racetrack configuration, rechargeable cars that have an optical sensor underneath to keep the car on the track, a lot of fun features like all kinds of virtual weapons, cars upgrades, etc., a companion app for both Android and iOS platform to operate the cars and a software development kit (SDK).

thumb_IMG_1626_1024

For us, it was exactly what we were looking for. But now we needed to find a way to control the cars without using the companion app because, you know, that was boring and we wanted more action and go one step further.

So after discussing different approaches, I suggested to control cars with Myo gesture control armband that basically is a wireless touch-free, wearable gesture control and motion device. We had Myo armband already, but we hadn’t played with it much. Good thing that Myo band has an SDK too, so we had everything ready to build a cool demo

12c Clone DB_SWONLY Oracle Home

Michael Dinh - Sun, 2016-03-06 19:42

Just some notes on 12c Oracle Home Cloning.

I am too lazy to put step by step instructions in words, and if you have questions, please ask.

-defaultHomeName
<HOME NAME=”OraHome1” LOC=”/u01/app/oracle/product/12.2.0/dbhome_2″ TYPE=”O” IDX=”3″/>

oracle@arrow:hawlkas:/home/oracle
$ . oraenv <<< db12c
ORACLE_SID = [hawlkas] ? The Oracle base remains unchanged with value /u01/app/oracle
oracle@arrow:db12c:/home/oracle
$ echo $ORACLE_HOME
/u01/app/oracle/product/12.2.0/dbhome_1
oracle@arrow:db12c:/home/oracle
$ cd $ORACLE_HOME
oracle@arrow:db12c:/u01/app/oracle/product/12.2.0/dbhome_1
$ pwd
/u01/app/oracle/product/12.2.0/dbhome_1
oracle@arrow:db12c:/u01/app/oracle/product/12.2.0/dbhome_1
$ nohup tar -cvpf /tmp/db12cHome_${USER}_`hostname -s`_clone.tar . > /tmp/clone_${USER}_`hostname -s`_db12cHome.log 2>&1 &
[1] 13092

++++++++++

oracle@arrow:db12c:/u01/app/oracle/product/12.2.0/dbhome_1
$
[1]+  Done                    nohup tar -cvpf /tmp/db12cHome_${USER}_`hostname -s`_clone.tar . > /tmp/clone_${USER}_`hostname -s`_db12cHome.log 2>&1
oracle@arrow:db12c:/u01/app/oracle/product/12.2.0/dbhome_1
$ ll /tmp/*clone*
-rw-r--r--. 1 oracle oinstall    1381582 Mar  6 16:24 /tmp/clone_oracle_arrow_db12cHome.log
-rw-r--r--. 1 oracle oinstall 6581944320 Mar  6 16:24 /tmp/db12cHome_oracle_arrow_clone.tar
oracle@arrow:db12c:/u01/app/oracle/product/12.2.0/dbhome_1
$ tail /tmp/clone_oracle_arrow_db12cHome.log
./jdk/bin/xjc
./jdk/bin/javadoc
./jdk/bin/jarsigner
./jdk/bin/pack200
./jdk/bin/rmid
./jdk/bin/jrunscript
./jdk/bin/extcheck
./jdk/bin/keytool
./jdk/LICENSE
./jdk/.manifest
oracle@arrow:db12c:/u01/app/oracle/product/12.2.0/dbhome_1
$ du -sh /tmp/db12cHome_oracle_arrow_clone.tar
6.2G    /tmp/db12cHome_oracle_arrow_clone.tar
oracle@arrow:db12c:/u01/app/oracle/product/12.2.0/dbhome_1
$

++++++++++

oracle@arrow:test12c:/home/oracle
$ . oraenv <<< test12c
ORACLE_SID = [test12c] ? The Oracle base remains unchanged with value /u01/app/oracle
oracle@arrow:test12c:/home/oracle
$ cd $ORACLE_HOME
oracle@arrow:test12c:/u01/app/oracle/product/12.2.0/dbhome_2
$ pwd
/u01/app/oracle/product/12.2.0/dbhome_2
oracle@arrow:test12c:/u01/app/oracle/product/12.2.0/dbhome_2
$ ls
oracle@arrow:test12c:/u01/app/oracle/product/12.2.0/dbhome_2
$ nohup tar -xvf /tmp/db12cHome_oracle_arrow_clone.tar > /tmp/untar_${USER}_`hostname -s`_db12cHome.log 2>&1 &
[1] 13182
oracle@arrow:test12c:/u01/app/oracle/product/12.2.0/dbhome_2
$
[1]+  Done                    nohup tar -xvf /tmp/db12cHome_oracle_arrow_clone.tar > /tmp/untar_${USER}_`hostname -s`_db12cHome.log 2>&1
oracle@arrow:test12c:/u01/app/oracle/product/12.2.0/dbhome_2
$ ll /tmp/untar_oracle_arrow_db12cHome.log
-rw-r--r--. 1 oracle oinstall 1381582 Mar  6 16:44 /tmp/untar_oracle_arrow_db12cHome.log
oracle@arrow:test12c:/u01/app/oracle/product/12.2.0/dbhome_2
$ tail /tmp/untar_oracle_arrow_db12cHome.log
./jdk/bin/xjc
./jdk/bin/javadoc
./jdk/bin/jarsigner
./jdk/bin/pack200
./jdk/bin/rmid
./jdk/bin/jrunscript
./jdk/bin/extcheck
./jdk/bin/keytool
./jdk/LICENSE
./jdk/.manifest
oracle@arrow:test12c:/u01/app/oracle/product/12.2.0/dbhome_2
$ ls
addnode     ccr          crs  dbs        diagnostics  hs             javavm  ldap  mgw      odbc    oracore      owm      precomp  rdbms     scheduler     sqlpatch  sysman  wwg
apex        cdata        css  dc_ocm     dmu          install        jdbc    lib   network  olap    oraInst.loc  perl     QOpatch  relnotes  slax          sqlplus   ucp     xdk
assistants  cfgtoollogs  ctx  deinstall  dv           instantclient  jdk     log   nls      OPatch  ord          plsql    R        rest      sqldeveloper  srvm      usm
bin         clone        cv   demo       has          inventory      jlib    md   

++++++++++

$ cd $ORACLE_HOME/clone/bin
oracle@arrow:test12c:/u01/app/oracle/product/12.2.0/dbhome_2/clone/bin
$ perl clone.pl -silent -noconfig -defaultHomeName ORACLE_HOME="/u01/app/oracle/product/12.2.0/dbhome_2" ORACLE_BASE="/u01/app/oracle" OSDBA_GROUP=dba OSOPER_GROUP=dba
./runInstaller -clone -waitForCompletion  -noconfig  -defaultHomeName  "ORACLE_HOME=/u01/app/oracle/product/12.2.0/dbhome_2" 
"ORACLE_BASE=/u01/app/oracle" "oracle_install_OSDBA=dba" "oracle_install_OSOPER=dba" 
-silent -paramFile /u01/app/oracle/product/12.2.0/dbhome_2/clone/clone_oraparam.ini

Starting Oracle Universal Installer...

Checking Temp space: must be greater than 500 MB.   Actual 16049 MB    Passed
Checking swap space: must be greater than 500 MB.   Actual 3994 MB    Passed
Preparing to launch Oracle Universal Installer from /tmp/OraInstall2016-03-06_04-58-03PM. 

Please wait ...You can find the log of this install session at:
 /u01/app/oraInventory/logs/cloneActions2016-03-06_04-58-03PM.log
..................................................   5% Done.
..................................................   10% Done.
..................................................   15% Done.
..................................................   20% Done.
..................................................   25% Done.
..................................................   30% Done.
..................................................   35% Done.
..................................................   40% Done.
..................................................   45% Done.
..................................................   50% Done.
..................................................   55% Done.
..................................................   60% Done.
..................................................   65% Done.
..................................................   70% Done.
..................................................   75% Done.
..................................................   80% Done.
..................................................   85% Done.
..........
Copy files in progress.

Copy files successful.

Link binaries in progress.

Link binaries successful.

Setup files in progress.

Setup files successful.

Setup Inventory in progress.

Setup Inventory successful.

Finish Setup successful.
The cloning of OraHome1 was successful.
Please check '/u01/app/oraInventory/logs/cloneActions2016-03-06_04-58-03PM.log' for more details.

Setup Oracle Base in progress.

Setup Oracle Base successful.
..................................................   95% Done.

As a root user, execute the following script(s):
        1. /u01/app/oracle/product/12.2.0/dbhome_2/root.sh

..................................................   100% Done.
oracle@arrow:test12c:/u01/app/oracle/product/12.2.0/dbhome_2/clone/bin
$ su -
Password:
[root@arrow ~]# /u01/app/oracle/product/12.2.0/dbhome_2/root.sh
Check /u01/app/oracle/product/12.2.0/dbhome_2/install/root_arrow.localdomain_2016-03-06_17-03-49.log for the output of root script
[root@arrow ~]# exit
logout

oracle@arrow:test12c:/u01/app/oracle/product/12.2.0/dbhome_2/clone/bin
$ /u01/app/oracle/product/12.2.0/dbhome_2/OPatch/opatch lspatches
22139226;Database PSU 12.1.0.2.160119, Oracle JavaVM Component (Jan2016)
21948354;Database Patch Set Update : 12.1.0.2.160119 (21948354)

OPatch succeeded.
oracle@arrow:test12c:/u01/app/oracle/product/12.2.0/dbhome_2/clone/bin
$ /u01/app/oracle/product/12.2.0/dbhome_2/OPatch/opatch lsinventory
Oracle Interim Patch Installer version 12.1.0.1.10
Copyright (c) 2016, Oracle Corporation.  All rights reserved.


Oracle Home       : /u01/app/oracle/product/12.2.0/dbhome_2
Central Inventory : /u01/app/oraInventory
   from           : /u01/app/oracle/product/12.2.0/dbhome_2/oraInst.loc
OPatch version    : 12.1.0.1.10
OUI version       : 12.1.0.2.0
Log file location : /u01/app/oracle/product/12.2.0/dbhome_2/cfgtoollogs/opatch/opatch2016-03-06_17-29-28PM_1.log

Lsinventory Output file location : /u01/app/oracle/product/12.2.0/dbhome_2/cfgtoollogs/opatch/lsinv/lsinventory2016-03-06_17-29-28PM.txt

--------------------------------------------------------------------------------
Local Machine Information::
Hostname: localhost
ARU platform id: 226
ARU platform description:: Linux x86-64

Installed Top-level Products (1):

Oracle Database 12c                                                  12.1.0.2.0
There are 1 products installed in this Oracle Home.


Interim patches (2) :

Patch  22139226     : applied on Sun Mar 06 15:46:50 PST 2016
Unique Patch ID:  19729684
Patch description:  "Database PSU 12.1.0.2.160119, Oracle JavaVM Component (Jan2016)"
   Created on 4 Jan 2016, 01:41:46 hrs PST8PDT
   Bugs fixed:
     19699946, 19176885, 19623450, 22139226, 19909862, 21811517, 19223010
     21068507, 19895326, 19877336, 22118835, 22118851, 21566993, 19153980
     20408829, 21047766, 19231857, 19895362, 19855285, 20415564, 21555660
     19245191, 21047803, 20408866, 21566944

Patch  21948354     : applied on Sun Mar 06 15:35:02 PST 2016
Unique Patch ID:  19553095
Patch description:  "Database Patch Set Update : 12.1.0.2.160119 (21948354)"
   Created on 20 Dec 2015, 23:39:33 hrs PST8PDT
Sub-patch  21359755; "Database Patch Set Update : 12.1.0.2.5 (21359755)"
Sub-patch  20831110; "Database Patch Set Update : 12.1.0.2.4 (20831110)"
Sub-patch  20299023; "Database Patch Set Update : 12.1.0.2.3 (20299023)"
Sub-patch  19769480; "Database Patch Set Update : 12.1.0.2.2 (19769480)"
   Bugs fixed:
     19189525, 19075256, 19141838, 19865345, 19791273, 19280225, 18845653
     20951038, 19243521, 19248799, 21756699, 18988834, 19238590, 21281532
     20245930, 18921743, 18799063, 19134173, 19571367, 20476175, 20925795
     19018206, 20509482, 20387265, 20588502, 19149990, 18849537, 18886413
     17551063, 19183343, 19703301, 19001390, 18202441, 19189317, 19644859
     19358317, 19390567, 19279273, 19706965, 19068970, 19619732, 20348653
     18607546, 18940497, 19670108, 19649152, 18948177, 19315691, 19676905
     18964978, 19035573, 20165574, 19176326, 20413820, 20558005, 19176223
     19532017, 20134339, 19074147, 18411216, 20361671, 20425790, 18966843
     20294666, 19307662, 19371175, 19195895, 19154375, 19468991, 19174521
     19520602, 19382851, 21875360, 19326908, 19658708, 20093776, 20618595
     21787056, 17835294, 19791377, 19068610, 20048359, 20746251, 19143550
     19185876, 19627012, 20281121, 19577410, 22092979, 19001359, 19518079
     18610915, 19490948, 18674024, 18306996, 19309466, 19081128, 19915271
     20122715, 21188532, 20284155, 18791688, 20890311, 21442094, 18973548
     19303936, 19597439, 20235511, 18964939, 19430401, 19044962, 19409212
     19879746, 20657441, 19684504, 19024808, 18799993, 20877664, 19028800
     19065556, 19723336, 19077215, 19604659, 21421886, 19524384, 19048007
     18288842, 19689979, 20446883, 18952989, 16870214, 19928926, 21526048
     19180770, 19197175, 19902195, 20318889, 19730508, 19012119, 19067244
     20074391, 19512341, 19841800, 14643995, 20331945, 19587324, 19547370
     19065677, 19637186, 21225209, 20397490, 18967382, 19174430, 18674047
     19054077, 19536415, 19708632, 19289642, 20869721, 19335438, 17365043
     18856999, 19869255, 20471920, 19468347, 21620471, 16359751, 18990693
     17890099, 19439759, 19769480, 19272708, 19978542, 20101006, 21300341
     20402832, 19329654, 19873610, 21668627, 21517440, 19304354, 19052488
     20794034, 19291380, 18681056, 19896336, 19076343, 19561643, 18618122
     20440930, 18456643, 19699191, 18909599, 19487147, 18250893, 19016730
     18743542, 20347562, 16619249, 18354830, 19687159, 19174942, 20424899
     19989009, 20688221, 20441797, 19157754, 19032777, 19058490, 19399918
     18885870, 19434529, 19018447, 18417036, 20919320, 19022470, 19284031
     20474192, 20173897, 22062026, 19385656, 19501299, 17274537, 20899461
     19440586, 16887946, 19606174, 18436647, 17655240, 19023822, 19178851
     19124589, 19805359, 19597583, 19155797, 19393542, 19050649



--------------------------------------------------------------------------------

OPatch succeeded.
oracle@arrow:test12c:/u01/app/oracle/product/12.2.0/dbhome_2/clone/bin
$
++++++++++
oracle@arrow:tiger:/u01/app/oraInventory/logs
$ ls -alrt|tail
-rw-r-----. 1 oracle oinstall     239 Mar  6 16:54 installActions2016-03-06_04-54-57PM.log
-rw-r-----. 1 oracle oinstall       0 Mar  6 16:56 oraInstall2016-03-06_04-55-18PM.err
-rw-r-----. 1 oracle oinstall     200 Mar  6 16:56 oraInstall2016-03-06_04-55-18PM.out
-rw-r-----. 1 oracle oinstall   11221 Mar  6 16:56 cloneActions2016-03-06_04-55-18PM.log
-rw-r-----. 1 oracle oinstall       0 Mar  6 16:58 oraInstall2016-03-06_04-58-03PM.err
-rw-r-----. 1 oracle oinstall      79 Mar  6 17:01 silentInstall2016-03-06_04-58-03PM.log
-rw-r-----. 1 oracle oinstall    1868 Mar  6 17:01 oraInstall2016-03-06_04-58-03PM.out
drwxrwx---. 6 oracle oinstall    4096 Mar  6 17:01 ..
-rw-r-----. 1 oracle oinstall 7338332 Mar  6 17:01 cloneActions2016-03-06_04-58-03PM.log
drwxrwx---. 3 oracle oinstall    4096 Mar  8 07:51 .

oracle@arrow:tiger:/u01/app/oraInventory/logs
$ grep -e '[[:upper:]]: ' cloneActions2016-03-06_04-58-03PM.log|cut -d ":" -f1|sort -u
INFO
WARNING

oracle@arrow:tiger:/u01/app/oraInventory/logs
$ grep -e '[[:upper:]]: ' cloneActions2016-03-06_04-58-03PM.log |grep "^WARNING: "
WARNING: You have not provided an email address. If you do not want to receive security updates, set 'DECLINE_SECURITY_UPDATES' to 'true'.
oracle@arrow:tiger:/u01/app/oraInventory/logs
$
++++++++++
oracle@arrow:test12c:/u01/app/oraInventory/ContentsXML
$ grep -i "home name" inventory.xml
<HOME NAME="OraDb11g_home1" LOC="/u01/app/oracle/product/11.2.0/dbhome_1" TYPE="O" IDX="1"/>
<HOME NAME="OraDB12Home1" LOC="/u01/app/oracle/product/12.2.0/dbhome_1" TYPE="O" IDX="2"/>
<HOME NAME="OraHome1" LOC="/u01/app/oracle/product/12.2.0/dbhome_2" TYPE="O" IDX="3"/>

RANT PSU Naming

Michael Dinh - Sun, 2016-03-06 17:12

Do you know what PSU there are?

oracle@arrow:db12c:/media/sf_working/12c/psu
$ ll *.zip
-rwxrwx---. 1 root vboxsf 147028181 Mar  4 20:00 p21948354_121020_Linux-x86-64.zip
-rwxrwx---. 1 root vboxsf 101720296 Mar  4 19:58 p22139226_121020_Linux-x86-64.zip

Let me give you a hint – (12.1.0.1.160119)
Now do you know what they are?

Let me give you another hint.
21948354 (12.1.0.1.160119) – 12.1.0.1 JAN2016 PSU (Database assumed here)
22139226 (12.1.0.2.160119) – OJVM PSU Patches

160119 – what date format is this?

opatch lsinventory

Patch  22139226     : applied on Wed Feb 03 11:07:55 CST 2016
Unique Patch ID:  19729684
Patch description:  "Database PSU 12.1.0.2.160119, Oracle JavaVM Component (Jan2016)"
   Created on 4 Jan 2016, 01:41:46 hrs PST8PDT
   Bugs fixed:
     19699946, 19176885, 19623450, 22139226, 19909862, 21811517, 19223010
     21068507, 19895326, 19877336, 22118835, 22118851, 21566993, 19153980
     20408829, 21047766, 19231857, 19895362, 19855285, 20415564, 21555660
     19245191, 21047803, 20408866, 21566944

Patch  21948354     : applied on Wed Feb 03 11:03:24 CST 2016
Unique Patch ID:  19553095

Looks like the whole numbering system is screwed up now.

Patch description:  "Database Patch Set Update : 12.1.0.2.160119 (21948354)"
   Created on 20 Dec 2015, 23:39:33 hrs PST8PDT
Sub-patch  21359755; "Database Patch Set Update : 12.1.0.2.5 (21359755)"
Sub-patch  20831110; "Database Patch Set Update : 12.1.0.2.4 (20831110)"
Sub-patch  20299023; "Database Patch Set Update : 12.1.0.2.3 (20299023)"
Sub-patch  19769480; "Database Patch Set Update : 12.1.0.2.2 (19769480)"

12c Silent Install software-only BUG

Michael Dinh - Sun, 2016-03-06 16:35

12.1: Oracle Database Software Only Silent Installation Fails to Create configToolAllCommands (Doc ID 2037923.1)

The BUG is in RED BOLD below.

oracle@arrow:hawklas:/media/sf_working/12c/database/response
$ cat /etc/oraInst.loc
inventory_loc=/u01/app/oraInventory
inst_group=oinstall

++++++++++

oracle@arrow:hawklas:/media/sf_working/12c/database/response
$ cat db_swonly.rsp
oracle.install.responseFileVersion=/oracle/install/rspfmt_dbinstall_response_schema_v12.1.0
oracle.install.option=INSTALL_DB_SWONLY
# Specify the Unix group to be set for the inventory directory.
UNIX_GROUP_NAME=oinstall
INVENTORY_LOCATION=/etc/oraInst.loc
SELECTED_LANGUAGES=en
ORACLE_HOME=/u01/app/oracle/product/12.2.0/dbhome_1
ORACLE_BASE=/u01/app/oracle
oracle.install.db.InstallEdition=EE
oracle.install.db.DBA_GROUP=dba
oracle.install.db.OPER_GROUP=dba
oracle.install.db.BACKUPDBA_GROUP=dba
oracle.install.db.DGDBA_GROUP=dba
oracle.install.db.KMDBA_GROUP=dba
DECLINE_SECURITY_UPDATES=true
oracle.installer.autoupdates.option=SKIP_UPDATES

++++++++++

oracle@arrow:hawklas:/media/sf_working/12c/database
$ ./runInstaller -showProgress -waitforcompletion -silent -noconfig -force -responseFile /media/sf_working/12c/database/response/db_swonly.rsp

Starting Oracle Universal Installer...
Checking Temp space: must be greater than 500 MB.   Actual 29558 MB    Passed
Checking swap space: must be greater than 150 MB.   Actual 4080 MB    Passed
Preparing to launch Oracle Universal Installer from /tmp/OraInstall2016-03-06_01-53-21PM. 
Please wait ...KiTTY X11 proxy: MIT-MAGIC-COOKIE-1 data did not matchYou can find the log of this install session at:
/u01/app/oraInventory/logs/installActions2016-03-06_01-53-21PM.log

Prepare in progress.
..................................................   8% Done.

Prepare successful.

Copy files in progress.
..................................................   13% Done.
..................................................   18% Done.
..................................................   23% Done.
..................................................   28% Done.
..................................................   33% Done.
..................................................   39% Done.
..................................................   45% Done.
..................................................   50% Done.
..................................................   55% Done.
..................................................   60% Done.
..................................................   65% Done.
..................................................   70% Done.
..................................................   75% Done.

Copy files successful.

Link binaries in progress.

Link binaries successful.

Setup files in progress.
..............................
Setup files successful.
..........
Setup Inventory in progress.

Setup Inventory successful.
..................................................   80% Done.
..........
Finish Setup successful.

The installation of Oracle Database 12c was successful.

Please check '/u01/app/oraInventory/logs/silentInstall2016-03-06_01-53-21PM.log' for more details.

Setup Oracle Base in progress.

Setup Oracle Base successful.
..................................................   95% Done.

As a root user, execute the following script(s):
        1. /u01/app/oracle/product/12.2.0/dbhome_1/root.sh

..................................................   100% Done.

Successfully Setup Software.
As install user, execute the following script to complete the configuration.
        1. /u01/app/oracle/product/12.2.0/dbhome_1/cfgtoollogs/configToolAllCommands RESPONSE_FILE=

        Note:
        1. This script must be run on the same host from where installer was run.
        2. This script needs a small password properties file for configuration assistants that require passwords (refer to install guide documentation).


oracle@arrow:hawklas:/media/sf_working/12c/database
$ su -
Password:
[root@arrow ~]# /u01/app/oracle/product/12.2.0/dbhome_1/root.sh
Check /u01/app/oracle/product/12.2.0/dbhome_1/install/root_arrow.localdomain_2016-03-06_14-09-10.log for the output of root script
[root@arrow ~]# ll /u01/app/oracle/product/12.2.0/dbhome_1/cfgtoollogs/configToolAllCommands
ls: cannot access /u01/app/oracle/product/12.2.0/dbhome_1/cfgtoollogs/configToolAllCommands: No such file or directory
[root@arrow ~]#

nVision Performance Tuning: General Principles

David Kurtz - Sun, 2016-03-06 12:20
Over the years I have dealt with performance problems with nVision reporting on General Ledger on various Financials systems in various kinds of businesses.  Different businesses use nVision very differently, and have different challenges, but I have produced an approach that mostly works well at most customers.  I have collected that advice in to a document that I have recently published on my website (http://www.go-faster.co.uk/docs.htm#nVision Tuning.Generic.pdf).

The key points are
  • Indexing
    • Effective indexing of LEDGER and LEDGER_BUDG tables to match the analysis criteria of the reports.
    • Enhanced indexing of the PSTREESELECT tables, so that the indexes fully satisfy the queries without the need to visit the tables.
  • Collection of statistics and extended statistics on the PSTREESELECT tables.
  • Using the nVision performance options 
    • use static selectors instead of dynamic selectors.  It is difficult to maintain up-to-date optimizer statistics on the selector tables with dynamic selectors.
    • simplify SQL statements by replacing joins with literal criteria
    • updated 11.4.2016: reduce SQL parse time by coalescing leaves on trees.
  • I also suggest use of Oracle Fine Grained Auditing to 
    • enhance instrumentation,
    • detect the use of dynamic selectors.
  • Appropriate partitioning of the LEDGER and LEDGER_BUDG tables.
  • Archiving.
    • If the partitioning option is not available, then I strongly recommended that as much historical data as possible is purged from the LEDGER and LEDGER_BUDG tables.
Caveat: This is a general approach, and the document makes general statements.  Every customer is different, because their data is different and often their method of analysis differs.  There is always something that requires adjustment or an exception to the general approach.  Your mileage will vary!

    COMPRESSION -- 2 : Compressed Table Partitions

    Hemant K Chitale - Sun, 2016-03-06 09:38
    A Partitioned Table can choose to have a mix of COMPRESS and NOCOMPRESS Partitions.

    As in this case where the first 3 partitions are defined as COMPRESS and the last as NOCOMPRESS :  :

    [oracle@localhost Hemant]$ sqlplus hemant/hemant@orcl

    SQL*Plus: Release 12.1.0.2.0 Production on Sun Mar 6 23:20:19 2016

    Copyright (c) 1982, 2014, Oracle. All rights reserved.

    Last Successful login time: Sun Mar 06 2016 23:19:11 +08:00

    Connected to:
    Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
    With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

    SQL> @create_SALESHIST
    SQL> spool create_SALESHIST
    SQL>
    SQL> drop table SALESHIST;

    Table dropped.

    SQL>
    SQL> alter session set "_partition_large_extents"=FALSE;

    Session altered.

    SQL>
    SQL> create table SALESHIST
    2 (
    3 PROD_ID NUMBER NOT NULL ,
    4 CUST_ID NUMBER NOT NULL ,
    5 TIME_ID DATE NOT NULL ,
    6 CHANNEL_ID NUMBER NOT NULL ,
    7 PROMO_ID NUMBER NOT NULL ,
    8 QUANTITY_SOLD NUMBER(10,2) NOT NULL ,
    9 AMOUNT_SOLD NUMBER(10,2) NOT NULL
    10 )
    11 NOCOMPRESS LOGGING
    12 TABLESPACE USERS
    13 PARTITION BY RANGE (TIME_ID)
    14 (
    15 PARTITION SALES_1998
    16 VALUES LESS THAN (TO_DATE('1999-01-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS',
    17 'NLS_CALENDAR=GREGORIAN'))
    18 SEGMENT CREATION IMMEDIATE
    19 COMPRESS BASIC NOLOGGING
    20 TABLESPACE SALES_1998 ,
    21 PARTITION SALES_1999
    22 VALUES LESS THAN (TO_DATE('2000-01-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS',
    23 'NLS_CALENDAR=GREGORIAN'))
    24 SEGMENT CREATION IMMEDIATE
    25 COMPRESS BASIC NOLOGGING
    26 TABLESPACE SALES_1999 ,
    27 PARTITION SALES_2000
    28 VALUES LESS THAN (TO_DATE('2001-01-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS',
    29 'NLS_CALENDAR=GREGORIAN'))
    30 SEGMENT CREATION IMMEDIATE
    31 COMPRESS BASIC NOLOGGING
    32 TABLESPACE SALES_2000 ,
    33 PARTITION SALES_2001
    34 VALUES LESS THAN (TO_DATE('2002-01-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS',
    35 'NLS_CALENDAR=GREGORIAN'))
    36 SEGMENT CREATION IMMEDIATE
    37 NOCOMPRESS NOLOGGING
    38 TABLESPACE SALES_2001 )
    39 /

    Table created.

    SQL>
    SQL> spool off
    SQL>
    SQL> col partition_name format a30
    SQL> select partition_name, compression, compress_for
    2 from user_tab_partitions
    3 where table_name = 'SALESHIST'
    4 order by partition_position;

    PARTITION_NAME COMPRESS COMPRESS_FOR
    ------------------------------ -------- ------------------------------
    SALES_1998 ENABLED BASIC
    SALES_1999 ENABLED BASIC
    SALES_2000 ENABLED BASIC
    SALES_2001 DISABLED

    SQL>
    SQL> select compression, compress_for
    2 from user_tables
    3 where table_name = 'SALESHIST';

    COMPRESS COMPRESS_FOR
    -------- ------------------------------


    SQL>


    The Compression attributes actually apply to the Segments so the Partition Segments have the definition but the Table, being segmentless, does not show the definition.

    Note that I am still demonstrating BASIC Compression. So the compression is applied only on Direct Path INSERT.  As in :

    SQL> insert /*+ APPEND */ into saleshist select * from sh.sales;

    918843 rows created.

    SQL> commit;

    Commit complete.

    SQL>
    SQL> select partition_name, tablespace_name, bytes/1024
    2 from user_segments
    3 where segment_name = 'SALESHIST'
    4 and segment_type = 'TABLE PARTITION'
    5 order by 1;

    PARTITION_NAME TABLESPACE_NAME BYTES/1024
    ------------------------------ ------------------------------ ----------
    SALES_1998 SALES_1998 3072
    SALES_1999 SALES_1999 4096
    SALES_2000 SALES_2000 4096
    SALES_2001 SALES_2001 11264

    SQL>


    This demonstrates that it is possible to
    a) Have some Partitions defined as COMPRESSed and others as NOCOMPRESSed
    b) Create different Partitions in different Tablespaces

    Before the advent of (and still without using) the 12c ILM features, this was and is a method to manage historical data with compression and moving or placing data (i.e. the respective tablespace datafile(s)) in low-cost storage as desired.

    Note : For the purposes of this demo, I used the parameter "_partition_large_extents"=FALSE.  Oracle's default Partition size since 11.2.0.2 has been 8MB for Table Partitions and that would have been excessively large for this demo.  If you are using Hybrid Columnar Compression and/or Exadata, Oracle advises against this.
    .
    .
    .

    Categories: DBA Blogs

    VirtualBox 5.0.16

    Tim Hall - Sat, 2016-03-05 07:53

    VirtualBox 5.0.16 was released yesterday.

    Downloads and changelog are in the usual places.

    The installation went fine at work on Windows 7 and on Mac OS X (El Crapitan) at home.

    Cheers

    Tim…

    VirtualBox 5.0.16 was first posted on March 5, 2016 at 2:53 pm.
    ©2012 "The ORACLE-BASE Blog". Use of this feed is for personal non-commercial use only. If you are not reading this article in your feed reader, then the site is guilty of copyright infringement.

    Side by Side comparison: ParalleNew+CMS vs G1GC Java Garbage Collector

    Arun Bavera - Fri, 2016-03-04 17:31
    Side by Side comparison: Left ParalleNew+CMS Right:G1GC
    Verdict: With minimal intervention ParallelNew+ UseConcMarkSweepGC performs well ahead of G1GC.
    Note: This test was done on small Heap size of 90M with JDK 1.7.0.67 using Grinder and AuctionImage test application. This is small heap and application but still we see memory fragmentation with PralleNew+CMS and G1GC seems to work well in this area but performance has to improve.

    Here are test and result screens in ViisualVM and JMC.
    export USER_MEM_ARGS="-Xms90m -Xmx90m -XX:MaxPermSize=256m"
    JAVA_OPTIONS+=" -XX:+UseParNewGC"
    JAVA_OPTIONS+=" -XX:+UseConcMarkSweepGC"
    JAVA_OPTIONS+=" -XX:+UseG1GC"
    JAVA_OPTIONS+=" -XX:+UnlockCommercialFeatures"
    JAVA_OPTIONS+=" -XX:+FlightRecorder"
    Note: All other values default:
    3.3Sec Pause 11.4 Sec Pause
    clip_image002[6]










    Three Grinder Tests with:
    Left ParalleNew+CMS Right:G1Gc
    JAVA_OPTIONS+=" -XX:MaxGCPauseMillis=500"
    8.99Sec Pause 30.14Sec Pause
    clip_image002[10]

    Another three Grind Test:
    export USER_MEM_ARGS="-Xms90m -Xmx90m -XX:MaxPermSize=256m
    JAVA_OPTIONS+=" -XX:MaxGCPauseMillis=500"
    JAVA_OPTIONS+=" -XX:NewRatio=2"
    Left: JAVA_OPTIONS+=" -XX:+UseParNewGC"
    JAVA_OPTIONS+=" -XX:+UseConcMarkSweepGC"
    Right:
    JAVA_OPTIONS+=" -XX:+UseG1GC"
    clip_image002[12]
    Result:
    Left: 8.54 Sec Pause Right: 1m+ 19.9Sec
    JFR for 2 GrindTest:
    clip_image002[14]
    clip_image002[16]
    Memory Overview Left: PrallelNew_CMS Right:G1GC
    clip_image002[18]
    Garbage Collection
    clip_image002[20]
    gcPausetime:
    clip_image002[22]
    GC Configuration:
    clip_image002[24]
    Threads CPU Usage:
    clip_image002[26]
    Lock Instances:
    clip_image002[28]
    Socket Write:
    clip_image002[30]
    System:
    clip_image002[32]
    Code Exceptions:
    clip_image002[34]
    Verdict: With minimal intervention ParallelNew+ UseConcMarkSweepGC performs well ahead of G1GC.
    Note: This test was done on small Heap size of 90M with JDK 1.7.0.67 using Grinder and AuctionImage test application. This is small heap and application but still we see memory fragmentation with PralleNew+CMS and G1GC seems to work well in this area but performance has to improve.






























































    Categories: Development

    Oracle JET and ADF BC REST Basic Authentication

    Andrejus Baranovski - Fri, 2016-03-04 17:03
    You might be interested to check my previous sample about CRUD implementation in JET - Handling ADF BC 12.2.1 REST Validation in Oracle JET. I'm going to describe how to access secure ADF BC REST service from JET, based on the CRUD sample app. We need to pass authorization header on each REST request, this way server can authenticate user and authorize access to the REST resource. There are couple of other tips applied on ADF BC REST service side, all described below.

    Blog reader rjahn shared a link in this blog comment - Oracle JET - Rendering Table from ADF BC REST Service, he describes how to pass authorization header using oauth property, while executing GET and fetching collection in JET. I'm using same approach for GET, but for PATCH, POST and DELETE authorization header is set in slightly different way.

    First of all we need to take a look into ADF BC REST security implementation. Each time when custom header is attached in JET, it executes OPTIONS method without appending authorization header. I have disabled security check for OPTIONS in web.xml:


    Important tip - by default security operations granted to ADF BC resource are all assigned through single permission (in jazn-data.xml):


    I have found this doesn't work, even from Postman - only first operation from the list is authorized. This must be a bug in ADF BC REST security. Workaround is to separate each operation into different permission group manually:


    GET executed from JET is authorized and data is coming through:


    We can see in network monitor recorded GET execution from JET - authorization header is submitted along with request:


    Authorization header is encoded with JavaScript btoa function. Obviously it must run on HTTPS to be completely secure, otherwise someone can intercept and decode the password. Authorization header is being constructed in JET (you would fetch username/password from HTML form, etc.) and is attached to the collection (this way it gets included into request header executed by GET). It doesn't work to attach it to collection through header property (as it works for POST, PATCH and DELETE), but it works with oauth:


    Authorization header can be set for PATCH. Data can be updated through secure service:


    Authorization header is present in PATCH request:


    Authorization header is injected through property - headers (differently than for collection and GET). It didn't work to use oauth here:


    Create case is executed through POST, security is enforced through authorization header here also:


    We can see header is present in the request:


    Authorization header is attached in the same way as for PATCH:


    Delete case is executed through DELETE, same authorization header is applied:


    Header info:


    Authorization header is attached to JET destroy operation:


    Download sample application (JET and ADF BC code) - JETCRUDApp_v5.zip. You should include JET code into JET toolkit distribution.

    Welcome New Oracle ACE Program Participants!

    OTN TechBlog - Fri, 2016-03-04 15:41
    Normal 0 false false false EN-US X-NONE X-NONE MicrosoftInternetExplorer4

    Congratulations to our newest Oracle ACEs!  The Oracle ACE Program recognizes individuals for their outstanding contribution to the Oracle community.  With over 500 participants in more than 60 countries around the globe, the ACE program features three tiers: Associate, ACE and ACE Director, to support community advocates at all stages of their career. Read more about the program here.

    Oracle ACEs initiated in January and February:

    Oracle ACE Directors:

    Edelweiss Kammermann

    Yanwei Zhou

    Oracle ACEs:

    Anton Els

    Rodrigo Radtke de Souza

    Maja Veselica

    Arturo Viveros

    Oracle ACE Associates:

    Opal Alapat

    Tobias Arnhold

    Ivica Arsov

    Nimish Garg

    Abhinivesh Jain

    Lasse Jenssen

    Rodrigo Jorge

    Mohan Iyer

    Richard Atkins

    Yves Colin

    Sandra Flores

    Yong Jing

    Brian Marshall

    Marco Mischke

    Sabine Heimsath

    Rick Stehno

    /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-priority:99; mso-style-qformat:yes; mso-style-parent:""; mso-padding-alt:0in 5.4pt 0in 5.4pt; mso-para-margin:0in; mso-para-margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:10.0pt; font-family:"Times New Roman","serif"; mso-fareast-font-family:"Times New Roman";}

    March 23: Overhead Door Corporation—Oracle HCM Cloud Customer Forum

    Linda Fishman Hoyle - Fri, 2016-03-04 13:42

    Join us for an Oracle HCM Cloud Customer Forum on Wednesday, March 23, 2016, to hear Larry Freed, Chief Information Officer at Overhead Door Corporation and Rebecca Stalsby, Director HRIS and Payroll. They will explain how they were looking to implement a massive HR transformation by changing their Benefits, Payroll, Core HR, Employee Self-Service, and Manager Self-Service to provide their employees with a single source solution so that their HR field staff could become more strategic.

    Register now to attend the live Forum on Wednesday, March 23, 2016, at 9:00 a.m. PT and learn more about Overhead Door Corporation’s experience with Oracle HCM Cloud.

    Cloud and not to Cloud

    Anthony Shorten - Fri, 2016-03-04 12:21

    At the Oracle Utilities Edge Conference the word most said was "Cloud" and whilst I tried to avoid overusing the word in my sessions I think it is important to clarify and understand what this means to your implementation.

    • We announced our Software As A Service plans and capabilities at the Oracle Utilities Edge Conference. This is a full service offering from us.
    • We announced our support for Platform As A Service (a whitepaper will be out in a few weeks time on this) and support for Private Clouds.
    • We announced a series of capabilities across deploying, extending and managing our cloud implementations available now, soon and in the future.

    Even if you are not intending to use ANY cloud facilities now and in the future there are some key messages to remember:

    • EVERYTHING, that is applicable, we are introducing to make or cloud implementation easier and more efficient will be rolled into the products (either into the product or the Oracle Application Management Pack for Oracle Utilities) available for on-premise and Private Cloud implementations. This is a key thing to remember. Just because we are focusing some of our efforts on the cloud, we are not abandoning other implementation styles. Anything we make easier will make your implementations much easier.
    • We are not assuming all customers will use the cloud so we are offering flexible cloud offerings to cover as much of the spectrum as we can. For example, you can use PaaS for your non-production environments and retaining on-premise for production. This gives you full access as you would see on site with some of the cost moved away.
    • We are in fact duplicating some of our functionality for on-premise and cloud implementations. For example, I announced that all the cloud metrics we are exposing to the cloud will also be available in our Application Management Pack for Oracle Utilities as well for on-premise implementations. This is just an example of trying to give you what we use. Our Oracle Functional/Load Testing Advanced Pack for Oracle Utilities is another example. It contains the testing components we use in our QA cycles.

     

    Application Builder Cloud Service - Menus, Buttons and Validation

    Shay Shmeltzer - Fri, 2016-03-04 12:11

    Continuing with the exploration of Oracle Application Builder Cloud Service, I've picked up the application I created in the previous blog entry and added a few more things to demo how to:

    • Configure the logo and title
    • Modify and add menu items
    • Define field level validation
    • Add buttons and define their actions

    Check out this short demo:

    Categories: Development

    Extending the Product - Supporting technologies

    Anthony Shorten - Fri, 2016-03-04 12:05

    First of all I want to thank all the customers and partners who attended the technical stream at the annual Oracle Utilities Edge Conference in Phoenix Arizona. I hope those attended found the sessions helpful. It was a pleasure to meet and chat to many customers and partners during and after the sessions.

    We made a series of announcements at the sessions about the future directions of our products and our works program for the future. Customers and Partners who did not attend the conference will get this information as we publically release the facilities we discussed over the next few service packs and releases.

    One of the announcements has caused confusion amongst the attendees and I wanted to clarify a few points to make sure that everyone understands the announcement.

    We announced that we will be adding support for Groovy as an extension language in a future release. I want to point out a few things about this:

    • Groovy support for extensions was added primarily to support our Software As A Service (SaaS) offerings for our products. In SaaS we will lock down the facilities accessible for extensions to protect security and performance. As Java has access low level calls we will not allow Java based extensions in the SaaS cloud. As Groovy is used for a similar role in other Oracle Cloud offerings, we are extending the OUAF to support Groovy based extensions to allow extensions typically implemented in java to be implemented in the cloud. We will be supporting Scripting and Groovy based extensions in SaaS offerings.
    • To protect security and performance we will be whitelisting support upon parts of Groovy to prevent inappropriate access. We use a similar technique for scripting and other extension support.
    • Java and scripting based extension support will be continued to be supported in the OUAF. You will not be forced to migrate to Groovy for on-premise, Platform As A Service (PaaS) and Private Cloud implementations. We will continue to extend our Java, Groovy and scripting support over future releases. We are not dropping the existing technologies. 
    • You can use Groovy for on-premise, Platform As A Service (PaaS) and Private Cloud implementations if you desire to use that technology. Java programmers can migrate to Groovy skills pretty easily as Groovy is very similar to Java (at the end of the day Groovy code becomes Java byte code anyway).

    In summary, Groovy is being supported as an alternative to scripting and Java, it is not replacing them. It is primarily used to address the lack of access to Java for use in building extensions in Oracle Utilities SaaS offerings. It can be used by any style of implementation if you desire but if you are not using our SaaS offerings you can continue to use all the styles of extension we have available.

    Now that I clarified that, I want to clarify one other misconception and that is the performance profile of the different styles:

    • When loaded into memory, which what happens to all extensions regardless of technology, raw performance of Java, scripting and Groovy are similar. Java does have a slight edge as it compiled byte code and Groovy/Scripting are interpreted with a small initial overhead. There is not much difference in the performance once it ends up in memory. You have the flexibility of picking any of those technologies with confidence that the code will perform with efficient programming.
    • Each language has its facilities and there are some clauses that are unique to each. For example, Java has full flexibility especially with computational type and also has a wide API. Groovy has a very similar API to Java but in our implementation of Groovy, we will be whitelisting clauses to protect security and performance. Scripting has a generous set of programming clauses but it is smaller in scope. In the vast majority of most extensions, scripting is more than enough but you can choose to use Java or Groovy (in the future). The choice if language gets down to skills and what your scope is.
    • In most case it is recommended to use scripting first, if that is not appropriate then you can soon use Groovy and even if that is not appropriate then use Java. Java has overheads in deployment where scripting and Groovy will be stored in our metadata.

    I hope these clarifications will assist you in extending our products now and in the future. We are looking forward to providing a rich development experience no matter which style or technique you choose to use.

     

    Pages

    Subscribe to Oracle FAQ aggregator