Development
“Refresh” a CSV File
In a previous post I discussed a PDF reader that allows you to refresh the PDF after changes are made. This is the same concept except it’s for CSV files. I’ve been using Perl to convert sqlplus spool output to CSV which is much easier to read into R. As I’m updating my code and […]
Categories: DBA Blogs, Development
“Refresh” a PDF
I’ve been working in R (wikipedia entry) a lot lately to graph performance data about Oracle systems. In general I output PDF files. The problem with most PDF readers (on Windows) is that they either get an exclusive lock on the file when it’s open (yes you, Adobe Acrobat), or you have to close and […]
Categories: DBA Blogs, Development
Formspider Day Istanbul is tomorrow
Quick reminder that, on January 31st starting on 13:30 we are hosting a Formspider Day at ITU Technopark. Click here for the program of the day and register.
Categories: Development
PL/SQL Event in Istanbul
If you'd like to find out how you can develop applications for the multi-device, multi-platform world of today with PL/SQL, you are invited to our event at the ITU Technopark on January 31st.
Click here to view the day's program and register.
Click here to view the day's program and register.
Categories: Development
How to Import thirdParty certificate to use Secured webServices into Oracle SOA Servers 11g
Creating the Custom Key Stores
./keytool -genkeypair -keyalg RSA -alias orakey -keypass welcome1 -keystore /d01/app/shared/admin/mycompany_domain/aserver/mycompany_domain/config/fmwconfig/mycompany-keystore.jks -storepass welcome1 -validity 3600
Assumption:
Custom Keystore for SOA-PROD:
/d01/app/shared/admin/mycompany_domain/aserver/mycompany_domain/config/fmwconfig/credMapKeystore.jks -storepass welcome1
ThirdCompany Certificate at:
/d01/app/shared/admin/mycompany_domain/aserver/mycompany_domain/config/fmwconfig/bsa.ThirdCompany.crt
/d01/app/oracle/product/fmw/wlserver_10.3/server/lib/bsa.ThirdCompany.crt
Importing ThirdCompany certificate for my Project:
cd /d01/app/oracle/product/fmw/wlserver_10.3
source /d01/app/oracle/product/fmw/wlserver_10.3/server/bin/setWLSEnv.sh
cd /d01/app/shared/admin/mycompany_domain/aserver/mycompany_domain/config/fmwconfig/
keytool -import -alias bsa.ThirdCompany -file bsa.ThirdCompany.crt -keystore /d01/app/shared/admin/mycompany_domain/aserver/mycompany_domain/config/fmwconfig/credMapKeystore.jks -storepass welcome1 -trustcacerts
keytool -list -keystore /d01/app/shared/admin/mycompany_domain/aserver/mycompany_domain/config/fmwconfig/credMapKeystore.jks -storepass welcome1
Verify Custom Keystore Location for SOA Domain
1) EM->Weblogic->SOA_Domain->Security Provider ->Keystore
For each server (Admin + MS) we have to change the KeyStore configuration.
So for each server go to: Configuration -> Keystores
/d01/app/shared/admin/mycompany_domain/aserver/mycompany_domain/config/fmwconfig/credMapKeystore.jks
Verify Custom Keystore Location for SOA Infra
2) Click SOA -> right-click soa-infra
Select SOA Administration -> Common Properties
Click More SOA Infra Advanced Properties->KeyStore:
/d01/app/shared/admin/mycompany_domain/aserver/mycompany_domain/config/fmwconfig/credMapKeystore.jks
Unset SSL Keystore from setDomainEnv:
vi /d01/app/shared/admin/mycompany_domain/aserver/mycompany_domain/bin/setDomainEnv.sh
Incase If we are using DemoTrust: Import the same ThirdCompany certificate:
keytool -list -keystore /d01/app/oracle/product/fmw/wlserver_10.3/server/lib/DemoTrust.jks -storepass DemoTrustKeyStorePassPhrase
keytool -import -alias bsa.ThirdCompany -file bsa.ThirdCompany.crt -keystore /d01/app/oracle/product/fmw/wlserver_10.3/server/lib/DemoTrust.jks -storepass DemoTrustKeyStorePassPhrase -trustcacerts
./keytool -genkeypair -keyalg RSA -alias orakey -keypass welcome1 -keystore /d01/app/shared/admin/mycompany_domain/aserver/mycompany_domain/config/fmwconfig/mycompany-keystore.jks -storepass welcome1 -validity 3600
Assumption:
Custom Keystore for SOA-PROD:
/d01/app/shared/admin/mycompany_domain/aserver/mycompany_domain/config/fmwconfig/credMapKeystore.jks -storepass welcome1
ThirdCompany Certificate at:
/d01/app/shared/admin/mycompany_domain/aserver/mycompany_domain/config/fmwconfig/bsa.ThirdCompany.crt
/d01/app/oracle/product/fmw/wlserver_10.3/server/lib/bsa.ThirdCompany.crt
Importing ThirdCompany certificate for my Project:
cd /d01/app/oracle/product/fmw/wlserver_10.3
source /d01/app/oracle/product/fmw/wlserver_10.3/server/bin/setWLSEnv.sh
cd /d01/app/shared/admin/mycompany_domain/aserver/mycompany_domain/config/fmwconfig/
keytool -import -alias bsa.ThirdCompany -file bsa.ThirdCompany.crt -keystore /d01/app/shared/admin/mycompany_domain/aserver/mycompany_domain/config/fmwconfig/credMapKeystore.jks -storepass welcome1 -trustcacerts
keytool -list -keystore /d01/app/shared/admin/mycompany_domain/aserver/mycompany_domain/config/fmwconfig/credMapKeystore.jks -storepass welcome1
Verify Custom Keystore Location for SOA Domain
1) EM->Weblogic->SOA_Domain->Security Provider ->Keystore
For each server (Admin + MS) we have to change the KeyStore configuration.
So for each server go to: Configuration -> Keystores
/d01/app/shared/admin/mycompany_domain/aserver/mycompany_domain/config/fmwconfig/credMapKeystore.jks
Verify Custom Keystore Location for SOA Infra
2) Click SOA -> right-click soa-infra
Select SOA Administration -> Common Properties
Click More SOA Infra Advanced Properties->KeyStore:
/d01/app/shared/admin/mycompany_domain/aserver/mycompany_domain/config/fmwconfig/credMapKeystore.jks
Unset SSL Keystore from setDomainEnv:
vi /d01/app/shared/admin/mycompany_domain/aserver/mycompany_domain/bin/setDomainEnv.sh
Incase If we are using DemoTrust: Import the same ThirdCompany certificate:
keytool -list -keystore /d01/app/oracle/product/fmw/wlserver_10.3/server/lib/DemoTrust.jks -storepass DemoTrustKeyStorePassPhrase
keytool -import -alias bsa.ThirdCompany -file bsa.ThirdCompany.crt -keystore /d01/app/oracle/product/fmw/wlserver_10.3/server/lib/DemoTrust.jks -storepass DemoTrustKeyStorePassPhrase -trustcacerts
Categories: Development
Recap of Formspider Day Denmark
On January 21st, we hosted the Formspider Day in Denmark at the Thansen Training Center in Copenhagen. We met with a very engaged crowd of PL/SQL developers who asked a lot of hard questions. It was really our kind of event with a lot of interaction. Continue reading the story on the Formspider web site...
Categories: Development
Formspider Day in Istanbul
On January 31st, we are hosting the Formspider Day Istanbul at ITU ARI Technopark in Maslak. Join us and find out how Formspider can help you to build first class applications for today's multi-device, multi-platform world.
Click here for the program of the day and to register for the event.
Looking forward to meeting you on January 31st.
The Formspider Team
Click here for the program of the day and to register for the event.
Looking forward to meeting you on January 31st.
The Formspider Team
Categories: Development
Interactive Reports with Formspider and No PL/SQL
We just published a new tutorial that shows how to use the Interactive Reporting features in the latest version of Formspider. You can read the tutorial here. You can view the demo application here.
Categories: Development
Oracle APEX 4.2.1 Patch Set released!
Oracle Application Express 4.2.1.00.08 has just been released and is available for download. The patch set can be downloaded from My Oracle Support (search for patch# 14732511) and the full distribution is available on Oracle Technology Network. In the APEX … Continue reading →
Categories: Development
Length Restriction of Textareas in APEX 4.2
Are you hitting the now enforced length restriction of Textareas in your existing applications after upgrading to APEX 4.2? Then you should read Joels blog posting APEX 4.2 and Textareas for additional information and a fix. If you want to … Continue reading →
Categories: Development
New Continuous Integration tutorial published
Hot off the press – a new continuous integration tutorial. It’s really not just about continuous integration, though! You’ll find it useful even if you aren’t using a continuous integration server like Hudson. It’s useful if you are doing any part of the scenario it documents: Setting up Team Productivity Center for your team and [...]
Categories: Development, Fusion Middleware
Advanced ADF eCourse, Part Deux
In February, we published the first in a series of FREE(!) online advanced ADF training: http://tinyurl.com/advadf-part1 The response to that course has been overwhelmingly positive as more and more people are moving past the evaluation/prototype stages with ADF and looking for more advanced topics. I’m pleased to relay the good news that the 2nd part [...]
Categories: Development, Fusion Middleware
Fun with Hudson, Part 1.1
Earlier I posted that I had used the following zip command in the ‘execute shell’ action for my Hudson build job: zip -r $WORKSPACE/builds/$JOB_NAME-$BUILD_NUMBER * -x ‘*/.svn/*’ -x ‘*builds/*’ This zips up the content of the exported source, so that I can send it on to team members who need the source of each build [...]
Categories: Development, Fusion Middleware
Hiring a Curriculum Developer
If you are an instructional designer with an eye for technologies like ADF, or if you are an ADF enthusiast and excel at creatively producing technical content, then ADF Product Management would like to hear from you. We’re looking for a curriculum developer to join our ADF Curriculum team, which is tasked with ensuring that [...]
Categories: Development, Fusion Middleware
Hiring a Curriculum Developer
If you are an instructional designer with an eye for technologies like ADF, or if you are an ADF enthusiast and excel at creatively producing technical content, then ADF Product Management would like to hear from you. We’re looking for a curriculum developer to join our ADF Curriculum team, which is tasked with ensuring that [...]
Categories: Development, Fusion Middleware
New ADF Insider on Layouts
I’ve published an ADF Insider session that helps de-mystify the ADF Faces components and how to work with them (and not against them), when building ADF applications. There’s also some great information on building ADF prototypes. Take a look here: http://download.oracle.com/otn_hosted_doc/jdeveloper/11gdemos/layouts/layouts.html
Categories: Development, Fusion Middleware
New ADF Insider on Layouts
I’ve published an ADF Insider session that helps de-mystify the ADF Faces components and how to work with them (and not against them), when building ADF applications. There’s also some great information on building ADF prototypes. Take a look here: http://download.oracle.com/otn_hosted_doc/jdeveloper/11gdemos/layouts/layouts.html
Categories: Development, Fusion Middleware
Getting a WebLogic Server supporting ADF Up and Running
When Jdeveloper 11G came out out I was excited! Excited at all the new features and innovations that were being put out by Oracle. Well that excitement has long wore off once I started trying to use the new Version.
Categories: Development


