Feed aggregator

APEX at the NYOUG Special Winter Meeting

Marc Sewtz - Mon, 2012-11-26 14:12

Just back from the DOAG conference (German Oracle User Group) in Nuremberg, it’s now time to get ready for an event closer to home: the annual NYOUG Special Winter Meeting at The New Yorker Hotel on December 12. If you’re interested in APEX and the Oracle Database, please stop by - you’ll have a busy day.

Willie Hardie, Vice President for Oracle Database Management will kick things off at 9:30am with his keynote on “What’s next for the Oracle Database". Right after that - at 10:30 - I’ll be talking about what’s new in Oracle Application Express 4.2. 

Later – at 2pm – you can hear about "Responsive Web Design in Oracle Application Express with HTML5 and CSS3" from Shakeeb Rahman and then finish the afternoon with Josh Millinger’s "The Maturity of Tabular Forms". 

Looking forward to seeing you at the NYOUG Special Winter Meeting. You can find the full agenda, including abstracts on all sessions here:

http://nyoug.org/upcoming_events.htm#General_Meeting1

A new career in a new town

Andrew Clarke - Sun, 2012-11-25 07:36
Well, I say "new career" but really it's the same thing: Oracle development. I'm working on some complex data matching routines for a data warehouse. But it is new, because I'm a contractor.

Going freelance has been a big step, as I was with Logica for over seventeen years. Actually, the company I joined was CMG, which through a chain of mergers, acquisitions and re-brandings became CMG Admiral, LogicaCMG, Logica and is now part of CGI. Contracting is something I have been considering for a while years but the actual decision almost took me by surprise. It's two weeks now, and I'm still enjoying it.

The "new town" part of the title is not quite accurate either, as Croydon is a town with a long and venerable history. But it's not a place I had been to before, although I have driven through it. This is not a crack at Croydon, it's just that sort of place; Wikipedia describes it as "a natural transport corridor between London and England's south coast".

Croydon is a bit odd, comprising zones of office blocks, shopping malls, car parks and entertainment complexes delineated by dual carriage ways and fly-overs. For me its chief virtue is a shortish commute. My last engagement for Logica entailed working away from home. After several months of living in a hotel room it's just nice to come back the family every evening.

Oracle eBS R12 customers can co-exist with Fusion Accounting Hub

Krishanu Bose - Fri, 2012-11-23 13:58
Existing Oracle eBS customers who are on R12 can leverage the features of Fusion General Ledger and extensive reporting capabilities of Oracle Fusion without re-implementing or upgrading the entire sub-ledger system to Fusion ecosystem through a co-existence configuration setup using Fusion Accounting Hub (FAH).
Oracle Fusion Accounting Hub, comes embedded with Essbase multidimensional cube that can be leveraged to derive business benefits through BI analytics, Smartview reporting, Financial Studio reporting, Account Monitor and Account Inspector and a very intuitive Allocation Manager for creating Allocation rules.
Using GoldenGate, a seamless integration between Oracle eBS and FAH has been provided. GL actual balances data can be transferred to FAH and drill-down back to eBS system is also possible.
The SaaS model of FAH deployment would provide faster time to deployment and lower TCO for customers as well while the existing eBS system can be an on-premise installation.

Application Migration - Part 3

Barry McGillin - Fri, 2012-11-23 12:09
Ok, Finally, we have got to part 3 of Application Migration.  In Part 1, we outlined a program which runs in Sybase through iSQL.  We then followed this, in part 2 with 2 important pieces.
  1. Recognizers to identify the file types of the source we post
  2. Rules to identify items within the files and report on the them
In this part, We will take the rules we used for the previous part, and add some replacement rules.  So, lets recap.  Our recogniser is set for shell files as below.

<?xml version="1.0" encoding="UTF-8"?>
<rulesfile version="1.0" name="Shell file recognizer" description="Recognize .sh files">
<recognizer name="sh" description="sh recognizer" enabled="true">
<fileExtension extension="sh" />
<expression><![CDATA[#!/bin/sh]]></expression>
</recognizer>
</rulesfile>


Our rules file is now extended to include replacement rules.  Looking at the rules file below, we have the two main sections
  1. The required section, which defines the expressions which are used to see if we should scan a file
  2. Rules section which can have 3 sections
    1. Example clause which contains the expression which shows what should be found by the rule.
    2. Expression clause which defines a regular expression which is used to identify the items to be change
    3. Replacement clause which can be configured in 3 different stances to cope with different replacements.
Review the file below:

<?xml version="1.0" encoding="UTF-8"?>
<?xml-stylesheet type="text/xsl" href="../schema/scanner.xsd"?>
<rulesfile version="1.0" name="Sample sh scanner rules"
description="Sample rules to show whats possible" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:noNamespaceSchemaLocation="../../schema/scanner.xsd">
<ruleset name="isql sample rules" enable="true" type="SYBASE"
description="" source="sh" codetype="isql">
<required>
<regex>
<expression><![CDATA[go|isql]]></expression>
</regex>
</required>
<rules>
<regex>
<expression><![CDATA[go *\n]]></expression>
<replacement type="text"><![CDATA[]]>
</replacement>
</regex>
<regex>
<expression><![CDATA[use.*\n]]></expression>
<replacement type="regex"><![CDATA[]]>
</replacement>
</regex>
<regex>
<expression><![CDATA[isql.*EOF]]></expression>
<replacement type="regex"><![CDATA[sqlplus barry/barry <<EOF]]></replacement>
</regex>
</rules>
</ruleset>
<ruleset name="sql sample rules" enable="true" type="SYBASE"
description="" source="sh" codetype="sql">
<required>
<regex>
<expression><![CDATA[select]]></expression>
</regex>
</required>
<rules>
<regex>
<expression><![CDATA[select.*\n]]></expression>
<replacement type="translator"/>
</regex>
</rules>
</ruleset>
</rulesfile>


The replacement tags are
  1. Text
    • This is the simplest type of replacement, taking the source strings found and replacing them with the string in the replacement tag.
  2. regex
    • The regular expression replacement can either simply replace text, or it can also use regular expressions to rearrange the string that was found.  For example,  function(a,b,c) can be switched to myfunction(c,a,b)
  3. Translator
    • The translator type allows the user to take the string found and pass it to a language translator denoted by the type.  In our example, the type is SYBASE, which will call our sybase translator and translate the source string.
In the rules file above, we have 2 rulesets defined, the first doing text and regex replacements, and the second doing translator replacements.  All these can be mixed together, though.  If you have a lot of rules, it makes sense to delineate them in rulesets so the tool can filter out what is not required.
Now, taking a look at the source we had in Part 1

bamcgill-macbook-pro:src bamcgill$ cat test.sh
#!/bin/sh
isql -UMYUSER -PMYPASS -SMYSERVER <<EOF
use pubs2
go
select count(*) from authors
go
select top 5 au_lname,au_fname,postalcode from authors
go
EOF
bamcgill-macbook-pro:src bamcgill$

we can now run the scanner and make the replacements.  Using a similar command to the that used in part 1, We can replace code in this script.

bamcgill-macbook-pro:demo bamcgill$ migration -actions=scan -dir=/Users/bamcgill/code/demo/src -rulesdir=/Users/bamcgill/code/demo/rules -inplace=true

Now, we when we look at the file, test.sh again, we have

#!/bin/sh
sqlplus barry/barry <<EOF
SELECT COUNT(*)
FROM authors ;

SELECT au_lname ,
au_fname ,
postalcode
FROM authors WHERE ROWNUM <= 5;

EOF

So, there we a translated file which was running iSQL on Sybase, but is now running SQL*Plus and Oracle specific SQL.

Now, if you are interested, heres what the scanner said as it was running.  It prints out individual statements as they are found and where in the source they were found. At the end, the tool summarises what was found and where.
bamcgill-macbook-pro:demo bamcgill$ migration -actions=scan -dir=/Users/bamcgill/code/demo/src -rulesdir=/Users/bamcgill/code/demo/rules -inplace=true

Oracle SQL Developer
Copyright (c) 1997, 2011, Oracle and/or its affiliates. All rights reserved.

Finding files....
Default Application Name

test.sh
3:go

5:go

7:go

2:use pubs2

1:isql -UMYUSER -PMYPASS -SMYSERVER <<EOF
2:select count(*) from authors

3:select top 5 au_lname,au_fname,postalcode from authors

------------------------ Application Results -----------------

Call Breakdown Summary by File
------------------------------
/Users/bamcgill/code/demo/src/test.sh
3: go

1: use pubs2

1: isql -UMYUSER -PMYPASS -SMYSERVER <<EOF
1: select count(*) from authors

1: select top 5 au_lname,au_fname,postalcode from authors


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

Call Breakdown Summary
----------------------
3: go

1: use pubs2

1: isql -UMYUSER -PMYPASS -SMYSERVER <<EOF
1: select count(*) from authors

1: select top 5 au_lname,au_fname,postalcode from authors


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

File Type Summary
----------------------
sh 1 file

-------------------------------------------------------------
------------------------ Summary -----------------------
High Level Overview
-------------------
7 total calls found
5 distinct calls found
1 files scanned
1 language types
2 total files in source
9 lines of code in scanned application
-------------------------------------------------------------
-------------------------------------------------------------
scan completed successfully
If you want to know more about this, drop me line on twitter @bamcgill, or by email on barry.mcgillin@oracle.com

You can download SQL Developer from OTN.

Reinstalling an Oracle Database Appliance Part 3

Fuad Arshad - Fri, 2012-11-23 10:47
An Oracle Database appliance is a set of standard hardware and software molded together to created a 2 node RAC cluster that is easy to deploy. In parts 1 & 2 i talked about what methods you can use to reformat or erase the Oracle Database Appliance and rebuild it. In this post  i will talk about 2 methods to complete a deployment on the Oracle Database Appliance (ODA).
You can use the GUI tool oakcli deploy that will walk you thru all the steps and let you add all the IP's and then do the deploy.
You can use the Oracle Appliance Kit offline configurator to generate the conf file and then either run  oakcli deploy to quickly validate all the information and runa graphical deploy.
The Oracle Appliance Kit Offline Configurator is available at the Oracle Technology Network ODA Page .  The Offline configurator is an exact replica of the oakcli deploy tool except it can be done on your laptop so you dont have to type all the info on the server. The Offline Configurator allows to save a text file in the below format.
#onecommand.params generated by GUI tool
# Confuration information
CONFIGVERSION=2.4.0.0.0

# CLUSTERINFO
DBMPREFIX=test1
DOMAIN=test.com
CLUSTERNAME=test1-c
REGION=America
TIMEZONE=America/Chicago

# DATABASE INFO
DbHomeArr=(test1)
OraHomeArr=(/u01/app/oracle/product/11.2.0/dbhome_1)
DbBlkSizArr=(8192)
DBBackupType=External
DataDgArr=(DATA)
RecoDgArr=(RECO)
RedoDgArr=(REDO)
RecoSizeArr=(2048)
DbTypeArr=(RAC)
DbNodeArr=(ALL )
DbCharset=AL32UTF8
DbTeritory=AMERICA
DbLang=AMERICAN
DbClass=VSmall
DbQOSTypArr=(ADMIN)
COMPONENT_LANGUAGES={en}


This text file contains a complete snapshot of the ODA being Built. Below is how the ODA configurator looks like.


Once the file is loaded you can go thru a standard GUI deployment.
The Second method which is very useful to deploy an ODA is the silent method. you can use the text file generated from the ODA offline configurator and copy the config file

./oakcli copy -conf /software/test11_12.txt
Successfully copied the config file!!!

Once the config file has been copied you list what the GridInst.pl steps are

[root@oak1 onecmd]# cd /opt/oracle/oak/onecmd
[root@oak1 onecmd]# ./GridInst.pl -l
INFO : Logging all actions in /dev/null and traces in /dev/null
INFO : Loading configuration file /opt/oracle/oak/onecmd/onecommand.params...
The steps in order are...
Step 0 = ValidateParamFile
Step 1 = SetupNetwork
Step 2 = WriteNodelists
Step 3 = SetupSSHroot
Step 4 = SetupDNS
Step 5 = UpdateEtcHosts
Step 6 = SetTimezone
Step 7 = SetupNTP
Step 8 = SetupILOM
Step 9 = ValidateEnv
Step 10 = CreateUsers
Step 11 = SetupStorage
Step 12 = SetupSSHusers
Step 13 = InstallGIClone
Step 14 = RunGIClonePl
Step 15 = RunRootScripts
Step 16 = GIConfigAssists
Step 17 = CreateASMDiskgroups
Step 18 = InstallDBClone
Step 19 = RunDBClonePl
Step 20 = DbcaDB
Step 21 = SetupEMDbControl
Step 22 = SetupACFS
Step 23 = SetupTFA
Step 24 = SetupASR
Step 25 = ResecureMachine
[root@oak1 onecmd]#
It is very important to validate how many steps are there since Oracle can change the number between the versions. The above is a snapshot of ODA 2.4 Steps. you can decide to break down the number of steps run this in debug mode in which case you will have interaction on some steps. or just execute GridInst.pl via a shell script
[root@oak1 onecmd]# ./GridInst.pl -r 1-25

This will execute the ODA deploy in non GUI mode with all logging happening as normal.
This concludes this 3 part series on how to reinstall an Oracle Database Appliance. Please feel free to ask any questions regarding the ODA and i will try to the best of my knowledge to answer them

Reinstalling an Oracle Database Appliance part 1Reinstalling an Oracle Database Appliance Part 2

Restoring a Database with Rman Controlfile Parameters

Fuad Arshad - Tue, 2012-11-20 19:08
There are occasions when you recieve a complete backup of a database from a  place different then yours and have to do a restore. normally a restore is simple . put the files in a directory run rman catalog on them and you are done. but what if you have rman configuration parameters stored in the controlfile and you are trying to duplicate the database. During a duplicate rman will restore the controlfile and then use the parameters associated in the controlfile for the next steps.
I hit this issue when the db i was trying to duplicate  has sbt_tape parameter and the host i was trying to duplicate on  has no MML configured to it.
After trying a couple of times with no luck. I opened an SR and got a response from a very helpful Oracle Support guy (even on Sev 3).
Below are the procedures i followed to solve my rather simple problem.
1. Startup the auxiliary database in nomount
2. Restore the controlfile from the autobackup piece
RESTORE CONTROLFILE FROM '.... location and name of the autobackup piece ...';
3. Mount the database:
ALTER DATABASE MOUNT;
4. Clear the SBT related configurations, CHANNEL and DEVICE - Do a show all and make sure there are no parameters that you might have an issue with
See the RMAN reference guide under CONFIGURE for details on how to do this.
5. In SQLPLUS backup the controlfile:
ALTER DATABASE BACKUP CONTROLFILE TO '/location/of/backups/control.dbf';
6. Startup the auxiliary database in nomount
7. Move the controlfile autoback piece out of the backup location
8. Run the Duplicate, which now will use the controlfile copy we created with correct RMAN configuration.

I was unaware of doing something this way and i guess its good to learn something new everyday.

JPA SQL and Fetching tuning ( EclipseLink )

Edwin Biemond - Mon, 2012-11-19 15:50
When you use JPA in your project and your model project contains many entities with some Eager fetching relation attributes then you probably notice that EclipseLink can fire a lot of SQL queries on the database. This works ok & fast on Dev or Test but in production these queries can lead to big problems ( higher load and more data). In our project we also use ADF DataControls, Web Services or

Fusion Applications Security

Krishanu Bose - Thu, 2012-11-15 22:56
The Fusion security architecture in Fusion is quite different from EBS and relates to real world scenarios better. Fusion security is externalized from Applications and moved to standardized Fusion Middleware, OPSS and LDAP.

Management of enterprise users and roles in fusion applications is done via Oracle Identity Manager (OIM). OIM manages this data in a database and keeps it in sync with the LDAP directory.

Management of enterprise users and roles in fusion applications is done via Oracle Identity Manager (OIM). OIM manages this data in a database and keeps it in sync with the LDAP directory. OAM is authentication, authorization, and auditing solution that provides centralized security administration. This includes functionality for access control, single sign-on (separate from Oracle Single Sign-On), personalization, and user profile management in heterogeneous application environments across a variety of application servers, legacy applications, and databases. OAM provides key features for creating, managing, and enforcing access policies. In Fusion v1, the LDAP server will hold both the Identity Store and the Policy Store. Identity store holds users and external roles. Policy store holds Application roles, Function and Data security policies.

Fusion ships with a full pre-seeded set of Job Roles. Separation of Jobs and Duty allows access control to be customized to a company’s particular organization

   • You can add/change jobs and their duties

   • You can add/change duties and their privileges

Below is a comparison of EBS security with Fusion Apps.

Job Role -> Top Level Menu

Data Role -> Responsibility

Duty Role -> Sub Menu

Privilege -> Form Function

Permission -> Executable

However, at times you may need to create a new set of policies, duties and job roles. I will try to demonstrate the steps necessary to setup this using an example in another article.

When is Video Better?

Cary Millsap - Thu, 2012-11-15 16:59
Ok, I’m stuck, and I need your help.

At my company, we sell software tools that help Oracle application developers and database administrators see exactly where their code spends their users’ time. I want to publish better information at our web page that will allow people who are interested to learn more about our software, and that will allow people who don’t even realize we exist to discover what we have. My theory is that the more people who understand exactly what we have, the more customers we’ll get, and we have some evidence that bears that out.

I’ve gotten so much help from YouTube in various of my endeavors that I’ve formed the grand idea in my head:
We need more videos showing our products.The first one I made is the 1:13 video on YouTube called “Method R Tools v3.0: Getting Started.” I’m interested to see how effective it is. I think this content is perfect for the video format because the whole point is to show you how easy it is to get going. Saying it’s easy just isn’t near as fun or convincing as showing it’s easy.

The next thing I need to share with people is a great demonstration that Jeff Holt has helped me pull together, which shows off all the tools in our suite, how they interact and solve an interesting and important common problem. But this one can’t be a 1-minute video; it’s a story that will take a lot longer to tell than that. It’s probably a 10- to 15-minute story, if I had to guess.

Here’s where I’m stuck. Should I make a video? Or write up a blog post for it? The reason this is a difficult question is that making a video costs me about 4 hours per minute of output I can create. That will get better over time, as I practice and accumulate experience. But right now, videos cost me a lot of time. On the other hand, I can whip together a blog post with plenty of detail in a fraction of the time.

Where I need your help is to figure out how much benefit there is, really, to creating a video instead of just a write-up. Some things I have to consider:
  • Would a 15-minute video capture the attention of people who Do people glaze over (TL;DR) on longish printed case studies on which they’d gladly watch about 15 minutes of video?
  • Or do people just pass on the prospect of watching a 15-minute case study about a problem they might not even realize they have yet? I ask this, because I find myself not clicking on any video that I know will take longer than a minute or two, unless I believe it’s going to help me solve a difficult problem that I know I have right now.
So, if you don’t mind giving me a hand, I’ve created a survey at SurveyMonkey that asks just three simple questions that will help me determine which direction to go next. I’m eager to see what you say.

Thank you for your time.

empreqkit error UNABLE_TO_START_NEW_SESSION_ON_NEW_DB #EM12c

Fuad Arshad - Thu, 2012-11-15 09:03
To install an new EM12c environment it is highly recommended you run the emprereqkit  utility . This utility is accessible thru the installation binaries  in the $SHARED_SOFT_PATH/12.1.0.2/install/requisites/bin directory. if you are running a prereq check via a shared mount point . you might hit an error like the one below. This error happens if you ran an emprereqkit   on another environment and never completed all the tasks.


Following exception occured in EMPrereqKit
Calling sequence (top to bottom)
--level 1--------------------------------------
Class/Method: EMPrereqKitManager/getInitialState
Id          : UNABLE_TO_START_NEW_SESSION_ON_NEW_DB
Message     :  Please end the session in last db (runPrereqs, runCorrectiveActions, runPostCorrectiveActions). Then only you can start a new session at a new db

         at oracle.sysman.emdrep.emprereqkit.emprerequisitemanager.EMPrereqKitManager.getInitialState(EMPrereqKitManager.java:353)
         at oracle.sysman.emdrep.emprereqkit.emprerequisitemanager.EMPrereqKitManager.processActionsList(EMPrereqKitManager.java:330)
         at oracle.sysman.emdrep.emprereqkit.emprerequisitemanager.EMPrereqKitManager.executeMainOperation(EMPrereqKitManager.java:171)
         at oracle.sysman.emSDK.emdrep.emprereqkit.EMPrerequisiteKit.executeMainOperation(EMPrerequisiteKit.java:83)
         at oracle.sysman.emdrep.emprereqkit.core.EMPrereqKit.main(EMPrereqKit.java:72)

 Caused by: null



empreqkit creates a state file that keep tab on the state of the job.
the Statefile is created in $SHARED_SOFT_PATH/12.1.0.2/install/requisites/bin/prerequisiteResults
a cat of the statefile will show something like this
(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=example-scan.example.com)(PORT=1521)))(CONNECT_DATA=(SID=demdb11))):DoneCorrectiveActions


If this state file is there it will not  allow you to run a seperate session until either the old session on the old database server  is completed or the statefile is removed or renamed.

SaaS Platform Webcast

Anshu Sharma - Wed, 2012-11-14 10:24

Oracle SaaS Platform Webcast recording in available here

http://download.oracle.com/opndocs/americas/120908_50510/index.htm

White Paper is available here

http://www.oracle.com/us/technologies/cloud/026989.pdf 

APEX at DOAG 2012

Marc Sewtz - Mon, 2012-11-12 20:19
Only one week to DOAG 2012 - the most important conference for Oracle users in Germany. The event takes place in Nuremberg, Nov 20th – 22nd. This year there will be 26 presentation on Oracle Application Express alone! 

Make sure to attend the sessions presented by Patrick Wolf, Christian Neumüller, Carsten Czarski, Peter Raganitsch, Dietmar Aust, Niels de Bruijn and other members of the APEX community. 



I'll be presenting Oracle Application Express 4.2 during my keynote on Tuesday: 

Keynote Development: Oracle Application Express (APEX) 4.2 New Features 

Tue 20. November 
10:00am - 10:45am 
Room 12-Istanbul 

Then - if you want to dig a little bit deeper and learn all about developing mobile application with APEX - stop by my session on Wednesday: 

Building Mobile Web Applications with Oracle Application Express  

Wed 21. November 
10:00am - 10:45am 
Room 12-Istanbul 

And if you have any question about APEX, new features, technical details, stuff you've been struggling with, APEX's future, features planed for the next release and beyond – or if you just want to stop by to let us know how much you love APEX, here's you chance: Patrick Wolf, Carsten Czarski, Peter Raganitsch and I will be doing our best answering all you question during the expert panel on Tuesday: 

APEX Expert-Panel 

Tue 20. November 16:00 - 16:45 Uhr 
Room 17-Hongkong 

… of course for your more difficult questions, we'd appreciate it if you could post your questions ahead of time, so we can do our homework in advance, just visit Carsten's panel app here: 

http://tiny.cc/apexpanel 

Thanks and see you all next week in Germany!

Ciber knowledge session November 28

Rob van Wijk - Sun, 2012-11-11 17:27
On Wednesday evening November 28, my colleague Marcel Hoefs and I will both do a one-hour knowledge session at Ciber Nieuwegein. What's new about it, is that the knowledge session is not only for Ciber colleagues, but for anybody who would like to attend. Both sessions will be in Dutch, so for the remainder of this post, I'll switch to Dutch and copy Marcel's invitation text: Graag nodig ik Rob van Wijkhttp://www.blogger.com/profile/00499478359372903250noreply@blogger.com0

Reinstalling an Oracle Database Appliance Part 2

Fuad Arshad - Tue, 2012-11-06 08:33
This is the second post in the series for Reinstalling the Oracle Database Appliance. In the last post i discussed using Bare matal install to reimage the ODA and perform a new deployment. In this post i will talk about  cleanupDeploy.pl

Cleanupdeploy.pl is a utility provided by Oracle as Part of the Oracle Appliance Kit (OAK). This utility performs the following


The Cleanup Steps are the following:

    1. uninstall ASR
    2. de-install All Oracle Software except the Oracle applicance Kit and the OS
    3. Cleanup Disk
    4. drop all users
    5. rollback various system configs
    6. remove public and private IP info
The CleanupDeploy.pl script is available in /opt/oracle/oak/onecmd directory and will  ask you to confirm 
[root@oak1 ]# ./cleanupDeploy.pl

Please enter the root password for performing cleanup:
Re-enter root password:
About to clear up OAK deployment,public network connectivity will be lost,root password will be set to default and both nodes will be rebooted
Do you want to continue(yes/no):
  
This will cleanup all the software on both the nodes. Please note while the OAK software will remain. you will lose access to the box since the public IP will be wiped out. you will need to access the ILOM and remote console in to reconfig the IP's on both nodes 

./oakcli configure firstnet
 
This will allow you to either further patch the system or run a deployment .
The difference between the CleanupDeploy.pl vs Baremetal can be attributed to 2 main things and while both must be used with caution and provide loss of data. Cleanupdeploy will not format the root filesystems so anything not on shared disk is preserved but will keep the old version of the OAK software in tact. Bare Metal restore on the other hand will wipe out everything but will also give you the software version you need. For new deployments if your intention is to go to 2.4 and your ODA is running version 2.1 my recommendation would be to do a Bare metal prior to deployment. The CleanupDeploy.pl will help in redploy an ODA for cases like moving from HIGH redundancy to NORMAL redundancy if you have not yet deployed an ODA or of you want the additional space and have something like Dataguard to failover you database . rebuild the ODA and fail it back.

In the 3rd Part of this series i will walk thru the deployment process and how to do deployment manually or via the OAK Configuration Assistant.


Reinstalling an Oracle Database Appliance part 1Reinstalling an Oracle Database Appliance Part 3

Reinstalling an Oracle Database Appliance Part 1

Fuad Arshad - Sun, 2012-11-04 15:01
Oracle Database Appliance comes with factory installed software. If you need to reinstall or reimage the ODA you can do that using a couple of methods. I'm going to have  series of posts talking about reinstalling and redeploying an ODA using various methods
A reinstall needs to start with cleaning up
There are 2 methods for cleanup..
  1. Using a Bare Metal Install
  2. Using cleandeploy.pl
A Bare metal Install is done by downloading an ISO from the MOS. The latest 2.4 ISO can be downloaded Here.
While there is a complete document available via Note. 1373599.1. 
I will give a brief synopsis of what is needed. A Bare install needs to be done per node and the instructions are the same. Please note a bare metal install will format all disks. All data will be lost. All instructions here will cause loss of data and should be done with extreme caution.
  1. . Download the 2.4(or version you need) ISO.
  2.  Login to the ILOM 
  3.  Go to the Remote Control tab and launch remote control.
  4.  In the java window that opens Select Devices --> Cdrom Image
  5. Select where the image resides on your laptop and click ok. This will map the cdrom image to your device
  6. Once the mapping is confirmed . go to the ILOM Remote control tab - >Host Control  and Select Cdrom as the next boot device
  7. In the Remote Control -->Remote Host Control  Select Power Cycle and OK
  8. This will reboot the node and start the install process. 
  9. If you are installing over a network. Please make sure not to disconnect until the install is completed.
  10. The reimage process can take between 1 to 2 hrs  to complete.
  11. After the reimage is complete.  the node is now akin to a factory installed node for the version you just imaged on.
  12. Follow the same steps to image the second node . Both nodes can be imaged in parallel.
  13. The ILOM and Bios are not impacted and a deploy/patch will need to be run to get the ILOM/BIOS to update.
  14. Run a ./oakcli configure firstnet to IP and bring the node on the public network
  15. Follow the steps in the read-me of the End user bundle to deploy the ODA.
 In the next post I'll talk about cleandploy.pl and how you can run a cleanupdeploy to reinstall the ODA.



    Reinstalling an Oracle Database Appliance part 2Reinstalling an Oracle Database Appliance Part 3

    Oracle Database Appliance (ODA) Patch 2.4 is out

    Fuad Arshad - Fri, 2012-11-02 21:22
    This is just a post ot point out that ODA Patch 2.4 is out. ODA Patch 2.4 requires 2.2 or above to install.
    A couple of Highlights of this release seem to be
    1. Enhanced odachk 2.16
    2. A trace file analyzer 
    3. The ability to now use normal redundancy for DATA and RECO diskgroups
    The ability to double mirror instead of triple mirror move the ODA's capacity from 4Tb to 6TB and is a choice in the offline configurator
    if you have an old deploy file you can load it in the 2.4 Offline configurator by changing
    CONFIGVERSION=2.4.0.0.0
    I will play around with the trace file analyzer to see what it brings to the table.



    Scripted Collection of OS Watcher Files on Exadata

    Tyler Muth - Fri, 2012-11-02 13:51
    I’ve been working a lot with graphing DB and OS metrics in R. I find it especially useful in Exadata POVs (proof of value) to gather and graph the oswatcher vmstat files for the compute nodes and iostat for the cells. For an example, take a look at this graph (PDF, 168 KB) of what […]
    Categories: DBA Blogs, Development

    eDVD - From Concept to Implementation

    Bradley Brown - Thu, 2012-11-01 21:07
    I love the process of starting a new venture.  It's an iterative process where you come up with a concept, take it to the market for feedback, develop a minimally viable product, take that to the market for feedback and the loop continues until you have customers - or you're dead (i.e. out of time, out of money, etc.).  We're very focused on the former - lots and lots of customers!

    InteliVideo start around the concept of delivering educational courses online...and allowing people to charge whatever they want to charge for a course and getting to keep 70% of it for themselves (i.e. an education and training monetization marketplace).  After talking to the market (i.e. training people like myself), I learned that many trainers enjoy traveling the world doing their training.  Unlike me, they aren't so interested in making money while they sleep.  My class is available on the InteliVideo site and if you know any trainers who want to make money while they sleep, direct them my way!  Everything is self service!

    We then changed our focus to those who had existing video content they were selling (or not selling) - i.e. those people/companies selling DVDs.  After a number of discussions, we then learned that people who produce videos and then want to sell them typically go to a distributor to fulfill their sale needs.  These distributors make their customers (i.e. the producers) pre-pay for about 1000 DVDs to be distributed on average.  If they produce 30 DVDs, at any one time, they will have at least 30,000 DVDs in stock.  Those up-front costs are considerable.  These distributors also require that the producer signs a contract that says they (the distributors) have exclusivity for distribution.  That makes sense, but there is a small catch in that exclusivity.  It typically states that they can't sell their video content in ANY media - i.e. even media that hasn't been invented yet.  Specifically, if they are selling DVDs for them when they signed the contracts in 2008 and then the iPad was invented, changed the world and everyone starts moving to the digital world, these video producers are stuck!  They can't move to the digital world because of their contracts.  In other words, they no longer really own their content.  So we quickly learned that this "long tail" market wasn't a good market to focus on.  All of the "self-service" functionality (to upload, categorize, index, search engine optimize, etc.100s of videos) we built for this market works great however!

    Now...this isn't true for everyone who produced video content, but it's true for a large majority of them (i.e. we'll call them the "long tailers."  It was certainly the industry norm of 2008.  Those who had a bit more leverage, actually read the contract and likely disputed that clause.  Or...they simply went to a DVD duplicator (with no handcuffs) and used or built their own sales engine.

    As I've said before, good start-ups pivot (and twist and turn) to find their market.  DVD duplicators have a number of customers.  Finding customers who bring you customers is a great thing!  At the same time, most DVD duplicators have not moved into the digital world just yet.  Many that we've met with have seen their sales drop to as little as 10% of what they once were!

    Here enters InteliVideo pivot #2.  Sure, we still have a platform that will work for educational training purposes AND we still have a platform that works for those video producers who actually own their content.  We also have built an excellent CRM (customer relationship management) email campaign management system into InteliVideo.  This allows those with video content to email (after all, email still rules the world) a video sampler (or trial subscription) to a prospective customer, to know how much video every prospect watched and take actions based on this information.

    DVD duplicators needed an additional piece of functionality, which we've now added to InteliVideo.  This is what we call the eDVD functionality.  DVD duplicators are used to authoring DVDs for their customers.  They want to make the DVD look exactly the way they want it to look.  We quickly learned that many of them saw this as clear differentiation for them.  They not only duplicate the DVD, but they create the look and feel for their customers before doing the duplication.  The (physical) DVD review process alone requires shipping or delivering a physical product today.  Not with an eDVD!  They can of course continue to deliver a physical DVD for any or all of their customers.  But with a simple email, their customers can review an eDVD AND they can now offer an eDVD solution to their customers - transparently through InteliVideo.

    For a company like Schooled Film.com that has a physical DVD for their customers, the standard InteliVideo look and feel is something like this:


    You can see that the video is at the top, chapters to the right, pricing below, social media below, etc.  However, as we learned from the DVD duplicators, each producer may have their own way that they wish to display the look and feel for their eDVD.  So we created an eDVD authoring tool (through the browser).  This allows schooled to have a page that looks exactly as they want it to look.  For example:


    This is powerful functionality for our customers!  Try it out here!

    We're seeing some real traction with the DVD duplicators.  If you know someone in that business, point them our way!  We would love to help them move into 2013 with many differentiators over iTunes, Amazon, etc. marketplaces - here's a shortened list of functionality over the iTunes market:

    1. Cross platform - iTunes is for iPhone/iPad only.  Versus InteliVideo, which is available on iPhone, iPad, Android phones, Android Tablets, Google TVs, Yahoo TVs, Roku, your browser, etc.  In other words, it’s truly cross platform.  We also offer “in app purchases” on Android, Roku, iPhones and iPads, but there’s a cost of doing that.
    2. Pricing - We have a LOT of flexibility on pricing.  We can gladly charge the same fee that iTunes (and Android and Amazon) market does – which is 30% of the gross fees.  But we can offer a variety of pricing offerings.  We tell our customers that “if you can dream up a way to charge people, we can implement it.”  In other words, a company like Subway could use our platform for training…and we could charge per employee rather than per “customer.”
    3. White labeled offering - InteliVideo is a white labeled offering – in other words, you can put some HTML code on your website and sell your videos through your site.  It looks like your site, but everything goes through InteliVideo - payment to delivery.  Think of the InteliVideo platform just like you think of  Google Analytics - plug and play.
    4. eDVDs – as mentioned above, we allow you to design your own “skin” for your videos – just like you can author a physical DVD, we allow you to do the same for an eDVD.
    5. Social marketing – we offer a social component to videos – you can post a comment and people can then view a sample of the video before they buy.
    6. Bookmarks and Chapters – we allow you to have any number of videos that you group into an eDVD and you can break up a video into any number of chapters.  Customers can bookmark their own sections in the videos too.
    7. Referral / Affiliate network – we allow you to allow your customers to put some HTML code on their website and they get a referral fee – you set the fee they get (i.e. could be 5% or could be 95%).
    8. Email campaigns / CRM – we have a built-in CRM system that allows you to send out any number of emails to people.  When they click on the unique link in the email, we create an InteliVideo account, send them the details for that account and track everything about that person.  We know what they watched, how long, etc.
    9. Virtual classrooms – you can set up a course through InteliVideo and you can monitor any number of students.  You can watch their progress.
    10. SEO – We integrated with Google Analytics, so you can track your clicks, etc. through them, but we also log every click, etc.


    We'll certainly keep you posted on our progress as we continue to pivot, twist and turn and we would love to hear your feedback, comments, questions, and thoughts.

    Event Processed

    Antony Reynolds - Wed, 2012-10-31 19:24
    Installing Oracle Event Processing 11g

    Earlier this month I was involved in organizing the Monument Family History Day.  It was certainly a complex event, with dozens of presenters, guides and 100s of visitors.  So with that experience of a complex event under my belt I decided to refresh my acquaintance with Oracle Event Processing (CEP).

    CEP has a developer side based on Eclipse and a runtime environment.

    Server install

    The server install is very straightforward (documentation).  It is recommended to use the JRockit JDK with CEP so the steps to set up a working CEP server environment are:

    1. Download required software
      • JRockit – I used Oracle “JRockit 6 - R28.2.5” which includes “JRockit Mission Control 4.1” and “JRockit Real Time 4.1”.
      • Oracle Event Processor – I used “Complex Event Processing Release 11gR1 (11.1.1.6.0)”
    2. Install JRockit
      • Run the JRockit installer, the download is an executable binary that just needs to be marked as executable.
    3. Install CEP
      • Unzip the downloaded file
      • Run the CEP installer,  the unzipped file is an executable binary that may need to be marked as executable.
      • Choose a custom install and add the examples if needed.
        • It is not recommended to add the examples to a production environment but they can be helpful in development.
    Developer Install

    The developer install requires several steps (documentation).  A developer install needs access to the software for the server install, although JRockit isn’t necessary for development use.

    1. Download required software
      • Eclipse  (Linux) – It is recommended to use version 3.6.2 (Helios)
    2. Install Eclipse
      • Unzip the download into the desired directory
    3. Start Eclipse
    4. Add Oracle CEP Repository in Eclipse
      • http://download.oracle.com/technology/software/cep-ide/11/
    5. Install Oracle CEP Tools for Eclipse 3.6
      • You may need to set the proxy if behind a firewall.
    6. Modify eclipse.ini
      • If using Windows edit with wordpad rather than notepad
      • Point to 1.6 JVM
        • Insert following lines before –vmargs
          • -vm
          • \PATH_TO_1.6_JDK\jre\bin\javaw.exe
      • Increase PermGen Memory
        • Insert following line at end of file
          • -XX:MaxPermSize=256M

    Restart eclipse and verify that everything is installed as expected.

    Voila The Deed Is Done

    With CEP installed you are now ready to start a server, if you didn’t install the demoes then you will need to create a domain before starting the server.

    Once the server is up and running (using startwlevs.sh) you can verify that the visualizer is available on http://hostname:port/wlevs, the default port for the demo domain is 9002.

    With the server running you can test the IDE by creating a new “Oracle CEP Application Project” and creating a new target environment pointing at your CEP installation.

    Much easier than organizing a Family History Day!

    Pages

    Subscribe to Oracle FAQ aggregator