Feed aggregator

LPAR and Oracle Database

Pakistan's First Oracle Blog - Tue, 2015-04-07 20:30
What is LPAR?

LPAR stands for Logical Partitioning and it's a feature of IBM's operating system AIX (Also available in Linux). By abstracting all the physical devices in a system, LPAR creates a virtualized computing environment.

In a server; the processor, memory, and storage are divided into multiple sets. Each set in a server consist of resources like processor, memory and storage. Each set is called as LPAR.

One server can have many LPARs operating at the same time. These LPARs communicate with each other as if they are on separate machines.

What is DLPAR?

DLPAR stands for Dynamic Logical Partitioning and with DLPAR the LPARs can be configured dynamically without restart. With DLPAR, memory, CPU and storage can be moved between LPARs on the fly.

What is HMC?

HMC stands for Hardware Management Console. The Hardware Management Console (HMC) is interface which is used to manage the LPARs. Its Java based and can be used to manage many systems.

If LPAR is in shared processor mode, without the following fix, LPAR may see excessive CPu usage: 


APARs for WAITPROC IDLE LOOPING CONSUMES CPU:
IV01111 AIX 6.1 TL05 if before SP08 (fixed in SP08)
IV06197 AIX 6.1 TL06 if before SP07 (fixed in SP07)
IV10172 AIX 6.1 TL07 if before SP02 (fixed in SP02)
IV09133 AIX 7.1 TL00 if before SP05 (fixed in SP05)
IV10484 AIX 7.1 TL01 if before SP02 (fixed in SP02)

This problem can effect POWER7 systems running any level of Ax720 firmware prior to Ax720_101. But it is recommended to update to the latest available firmware. If required, AIX and Firmware fixes can be obtained from IBM Support Fix Central:
http://www-933.ibm.com/support/fixcentral/main/System+p/AIX
Categories: DBA Blogs

Get Recognition for your Knowledge of My Oracle Support by Becoming a My Oracle Support Accredited User

Joshua Solomin - Tue, 2015-04-07 09:55
.xContainer { width:99%; margin-left:auto; margin-right:auto; font-family:inherit; } .xContainer img { display:block; margin:0; padding:0; border:0; width:100%; } .xContainer .imgBox { margin:32px 0; width:100%; } .xContainer .imgStyle { border:1px solid #999; box-shadow:2px 2px 3px #bababa; } .xContainer .floatLeft { float:left; margin-right:20px; margin-bottom:12px; } .xContainer .floatRight { float:right; margin-left:20px; margin-bottom:12px; } .xContainer .oRed { color:#ff0000; } .xContainer .darkRed { color:#c00000; } .xContainer .bold { font-weight:bold; } .xContainer .italic { font-weight:italic; } .xContainer .underline { text-decoration:underline; } .xContainer .strikethrough { text-decoration:line-through; }
Join us as part of our live Collaborate15 event.

If you are attending the Oracle Application User's Group (OAUG) Collaborate15, use the event Scheduler to locate Accreditation sessions.

Sessions are available for Oracle DB, Oracle E-Business Suite, JD Edwards, PeopleSoft and Primavera. Take the opportunity to attend expert Q&A sessions to learn more about the accreditation and ask questions; you can also attend the exam session to take your accreditation

(Expert sessions are not replacements for the pre-training refresher videos. Oracle Support staff will be on hand to assist in the exam session—but they will not answer the questions in the exam.)

Add sessions to your planner by entering the term Accreditation and click Search to locate them. You can refine your search further by selecting a date.

Session Scheduler
What happens if I am not going to Collaborate15?

Don't miss out—Join us virtually by doing the pre work and watching the Accreditation Series for My Oracle Support and the Level 2 Products you use. If anything is new to you, take time to deep dive by reviewing the online help or taking the additional how to training modules listed in Document 603505.1

Share your experience—via Twitter and include @myoraclesupport to share your success story.

Join Us in the Accreditation Community—At times we will deconstruct questions similar to those in the exam, breaking down the purpose of the question and the answers the exam is looking for. Please note that posting exam questions in public forum is a violation of the Accreditation Program terms of use.

The community is the place to post your questions about the exam itself—share us what you thought about the exam experience:

  • Did you learn new Best Practices?
  • Any issues printing your certificate?
  • Did you vote in the Poll to have an Accreditation Community Badge?

Adding Log Groups on Oracle DataGuard Database

VitalSoftTech - Mon, 2015-04-06 15:12
When adding Redo logs to a database which has a DataGuard associated with it, the log files have to manually be added to the destination. Below are the steps on how to add them to both the source and the DataGuard databases. Adding Log Groups on Oracle DataGuard Database On the source first determine the […]
Categories: DBA Blogs

Consumer Reports guide on which fruits and veggies to always buy organic

FeuerThoughts - Mon, 2015-04-06 10:32
First, I encourage everyone reading this (and beyond) to subscribe to Consumer Reports and make use of their unbiased, science-based reviews of products and services.

It is the best antidote to advertising you will ever find.

In their May 2015 issue, they analyze the "perils of pesticides" and offer a guide to fruits and vegetables. When you should buy organic? When might conventional be OK for you?

[or, as CR puts it, "Though we believe that organic is always the best choice because it promotes sustainable agriculture, getting plenty of fruits and vegetables - even if you can't obtain organic - takes precedence when it comes to your health.]

Here are the most important findings:

ALWAYS BUY ORGANIC

CR found that for these fruits and vegetables, you should always buy organic - the pesticide risk in conventional is too high.

Fruit

Peaches
Tangerines
Nectarines
Strawberries
Cranberries

Vegetables

Green Beans
Sweet Bell Peppers
Hot Peppers
Sweet Potatoes
Carrors
Categories: Development

EBS 12.2 do not ignore the database patches on top of AD Delta 5 and TXK Delta 5

Senthil Rajendran - Sun, 2015-04-05 09:13

Make sure all the recommended patches are in place as a part of the bundle patch. Your EBS 12.2 ADOP cycle could go unstable with out the database patches.

A world of confusion

Gary Myers - Sat, 2015-04-04 03:00
It has got to the stage where I often don't even know what day it is. No, not premature senility (although some may disagree). But time zones.

Mostly I've had it fairly easy in my career. When I worked in the UK, I just had the one time zone to work with. The only time things got complicated was when I was working at one of the power generation companies, and we had to make provision for the 23-hour and 25-hour days that go with Daylight Savings.

And in Australia we only have a handful of timezones, and when I start and finish work, it is the same day for any part of Australia. I did work on one system where the database clock was set to UTC, but dates weren't important on that application.

Now it is different. I'm dealing with events that happen all over the world. Again the database clock is UTC, with the odd effect that TRUNC(SYSDATE) 'flips over' around lunchtime. Now when I want to look at 'recent' entries (eg a log table) I've got into the habit of asking WHERE LOG_DATE > SYSDATE - INTERVAL '9' HOUR

And we also have columns that are TIMESTAMP WITH TIMEZONE. So I'm getting into the habit of selecting COL_TS AT TIME ZONE DBTIMEZONE . I could use sessiontimezone, but then the time component of DATE columns would be inconsistent.  This becomes just a little more confusing this time of year as various places slip in and out of Daylight Savings.

Now things are getting even more complicated for me.

Again, during my career, I've been lucky enough to be pretty oblivious to character set issues. Most things have squeezed in to my databases without any significant trouble. Occasionally I've had to look for some accented characters in people's names, but that's been it.

In the past few months, I've been working with some European data where the issues have been more pronounced. Aside from a few issues in emails, I've been coping quite well (with a lot of help from Google Translate). 

Now I get to work with some Japanese data. And things get complicated.

"The modern Japanese writing system is a combination of two character types: logographic kanji, which are adopted Chinese characters, and syllabic kana. Kana itself consists of a pair of syllabarieshiragana, used for native or naturalised Japanese words and grammatical elements, and katakana, used for foreign words and names, loanwordsonomatopoeia, scientific names, and sometimes for emphasis. Almost all Japanese sentences contain a mixture of kanji and kana. Because of this mixture of scripts, in addition to a large inventory of kanji characters, the Japanese writing system is often considered to be the most complicated in use anywhere in the world.[1][2]"Japanese writing system

Firstly I hit katakana. With some tables, I can get syllables corresponding to the characters and work out something that I can eyeball and match up to some English data. As an extra complication, there are also half-width characters which are semantically equivalent but occupy different codepoints in Unicode. That has parallels to upper/lower case in English, but is a modern development that came about from trying to fit the previously squarish forms into print, typewriters and computer screens.

Kanji is a different order of shock. Primary school children in Japan learn the first 1000 or so characters. Another thousand plus get taught in high school. The character set is significantly larger in total.

I will have to see if the next few months cause my head to explode. In the mean time, I can recommend reading this article about the politics involved in getting characters (glyphs ? letters ?) into Unicode.  I Can Text You A Pile of Poo, But I Can’t Write My Name

Oh, and I'm still trying to find the most useful character/font set I can have on my PC and  use practically in SQL Developer. My current choice shows the Japanese characters when I click in the field in the dataset, but only little rectangles when I'm not in the field. The only one I've found that does show up all the time is really UGLY. 

adoafmctl.sh hangs

Vikram Das - Fri, 2015-04-03 20:26
Rajesh and Shahed called me about this error where after a reboot of the servers, adoafmctl.sh wouldn't start.  It gave errors like these:

You are running adoafmctl.sh version 120.6.12000000.3 
Starting OPMN managed OAFM OC4J instance ... 
adoafmctl.sh: exiting with status 152 
adoafmctl.sh: check the logfile 
$INST_TOP/logs/appl/admin/log/adoafmctl.txt for more information

adoafmctl.txt showing:
ias-component/process-type/process-set:
default_group/oafm/default_group/
Error
--> Process (index=1,uid=349189076,pid=15039)
time out while waiting for a managed process to start
Log:
$INST_TOP/logs/ora/10.1.3/opmn/default_group~oafm~default_group~1
07/31/09-09:14:28 :: adoafmctl.sh: exiting with status 152
================================================================================
07/31/09-09:14:40 :: adoafmctl.sh version 120.6.12000000.3
07/31/09-09:14:40 :: adoafmctl.sh: Checking the status of OPMN managed OAFM OC4J instance
Processes in Instance: SID_machine.machine.domain
-------------------+--------------------+---------+---------
ias-component | process-type | pid | status
-------------------+--------------------+---------+---------
default_group | oafm | N/A | Down

Solution:

1. Shutdown all Middle tier services and ensure no defunct processes exist running the following from the operating system:
# ps -ef | grep

If one finds any, kill these processes.
2. Navigate to $INST_TOP/ora/10.1.3/opmn/logs/states directory. It contains hidden file .opmndat:
# ls -lrt .opmndat
3. Delete this file .opmndat after making a backup of it:
# rm .opmndat
4. Restart the services.

5. Re-test the issue.

This resolved the issue.
Categories: APPS Blogs

Data Mining Scoring Development Process

Dylan Wan - Fri, 2015-04-03 00:39

I think that the process of building a data mining scoring engine is similar to develop an application.

We have the requirement analysis, functional design, technical design, coding, testing, deployment, etc. phases.

Categories: BI & Warehousing

Data Mining Scoring Development Process

Dylan Wan - Fri, 2015-04-03 00:39

I think that the process of building a data mining scoring engine is similar to develop an application.


We have the requirement analysis, functional design, technical design, coding, testing, deployment, etc. phases.



Categories: BI & Warehousing

SQLcl, a revolution for SQL*Plus users

DBA Scripts and Articles - Thu, 2015-04-02 09:34

What is SQLcl ? SQLcl is a new command line interface like SQL*PLUS coming along with SQL Developper 4.1 Early Adopter. It is a lightweight tool (only 11MB) developed by the SQL Developer team fully compatible with Windows and Unix/Linux. You don’t need to install it so it is totally portable. The tool does not need … Continue reading SQLcl, a revolution for SQL*Plus users

The post SQLcl, a revolution for SQL*Plus users appeared first on Oracle DBA Scripts and Articles (Montreal).

Categories: DBA Blogs

SQLcl, a revolution for SQL*Plus users

DBA Scripts and Articles - Thu, 2015-04-02 09:34

What is SQLcl ? SQLcl is a new command line interface like SQL*PLUS coming along with SQL Developper 4.1 Early Adopter. It is a lightweight tool (only 11MB) developed by the SQL Developer team fully compatible with Windows and Unix/Linux. You don’t need to install it so it is totally portable. The tool does not need … Continue reading SQLcl, a revolution for SQL*Plus users

The post SQLcl, a revolution for SQL*Plus users appeared first on Oracle DBA Scripts and Articles (Montreal).

Categories: DBA Blogs

Finally, My PaaS4SaaS Workshop Blog

Usable Apps - Wed, 2015-04-01 19:12

By Debra Lilley, guest contributor

Debra Lilley (@debralilley), Oracle ACE Director and Vice President of Certus Cloud Services at Certus Solutions, offers her reflections on the PaaS4SaaS workshop that took place in January 2015 in London*.

I know this posting is a bit late, but at the end of January I took part in a proof of concept workshop for PaaS4SaaS, and it’s been a rollercoaster ride ever since.

When I was thinking about moving to Certus, one of the things that attracted me was their intent to write extensions for Oracle Cloud Applications using the just announced PaaS4SaaS solution.

I attended Oracle Open World with an open mind and tried to learn as much as I could about the solutions. The Larry Ellison (Oracle Executive Chairman and Chief Technology Officer) demo was really impressive but then Oracle has always been a brilliant marketing company.

I came back to the UK and set about validating what was available, some of the components Database and Java Cloud had been available for a while but I wanted or would want to also use the Process and Integration Cloud offerings.

As regular readers of my blog will know, I am an Oracle Applications User Experience advocate and am very committed to the user experience work that goes into Oracle Cloud Applications. Extensions delivered by Certus will have this same user experience, and I made this video on behalf of Certus.

 Debra Lilley, Certus Solutions

Click here to watch Debra's YouTube video.

The user experience team has been given funding by Thomas Kurian, Oracle President, Product Development, who is personally committed to making PaaS4SaaS work, to carry out a number of proof of concept workshops with Oracle partners. The Oracle Applications UX team asked Certus to be part of this. Certus has not been a development company, and so in the same way customers come to us because we are the best at implementing cloud applications, we looked for a partner to help us with development. We selected eProseed who have the same commitment to UX as we do.

The workshop took place in London at the end of January with four people from each of Oracle Applications UX, eProseed, and Certus taking part. We worked through a use case taken from an existing application from one of our customers who is considering modernizing this and moving it to the cloud. In three days we were able to build a working application and prove to ourselves that when the customer says “go,” we will be able to deliver what they need.

Oracle Applications UX team have in their blog already covered the workshop and I have also written about it in the Oracle Fusion Middleware blog I am a guest author for. The following month I took part in the Partner SOA Community Forum in Budapest when we had the opportunity to work with product management teams of both the Process and Integration Cloud offerings and further validate our approach, understanding the possibilities and the constraints. The Oracle Applications UX team also had a stand there.

Lonneke Dikmans of eProseed and Debra Lilley of Certus Solutions

Lonneke Dikmans (@lonnekedikmans) Managing Partner eProseed Nederland and Debra Lilley of Certus Solutions

I was very pleased on behalf of both Certus and eProseed to accept the first Community Cloud award. These awards are a bit like the Oscars and awarded to individuals Lonneke Dikmans from eProseed and myself, however we had a similar thank you to all those involved in our acceptance speech.

The Community Leader Jürgen Kress (@soacommunity) said:

“I awarded my first SOA Community Outstanding Contribution for Cloud to Debra Lilley of Certus Solutions and Lonneke Dikmans of eProseed because they not only took on board the messaging of PaaS4SaaS from the last Oracle Open World, but also their collaboration between an Applications partner and a Middleware partner, sought out answers and training and with Oracle Development giving feedback and validating their approach in this area. All good things but bringing that back to the community and sharing is the outstanding contribution.”

I have written a White Paper, which will be published for Collaborate in a few weeks and Certus along with Oracle Applications UX will be presenting this twice both for OAUG and Quest. I’ve also had an article published in this month’s Profit Magazine.

Thank you to the Oracle Applications UX team and the SOA Community. I’m still not technical enough to do this but I am technical enough to understand that PaaS4SaaS is a game changer and will continue to be seeing more and more in our community.

* This article was originally published here

Smart watches in the enterprise?

Angelo Santagata - Wed, 2015-04-01 09:17

Although smart watches have been around for a couple of years (Sony had a v1 2+yrs ago, Pebble, Samsung gear, Google wear etc) now that Apple is poised to deliver its iWatch the worlds gone crazy about them.. or has it?? Personally I'm still struggling to identify the “killer” SmartWatch App where I would start to wear a watch again (I stopped wearing watches the day I discovered my Nokia mobile had a clock).. One area which I totally “get” is Healthcare.. In that the watch/wearable device can monitor my steps, heart-rate, stress levels (skin resistance) etc… but what about the enterprise???

Anyway, some friends of mine at Oracle HQ (Jeremy & Ultan) have done some awesome R&D in this area, gotten hold of some watches, prototyped some ideas and come up with some compelling ideas.. ..

Is “glancing” and “glance-able” apps the game changer?? You decide..

https://blogs.oracle.com/usableapps/entry/a_glance_at_smartwatches_in

Rumors about Oracle Reports 12c

Gerd Volberg - Tue, 2015-03-31 01:53
For nearly six weeks, it is rumored that Oracle Reports will not appear in the version 12c.

Since then, I tried to get information on this topic. After a few emails I got the info I needed.


The rumors are definitely wrong and no one at Oracle wants to cancel Reports 12c.


I hope that this cools down the rumor mill a little bit.

Gerd

Getting inaccessible URL when executing REST calls within JCSSX????

Angelo Santagata - Mon, 2015-03-30 17:16

Recently I was coding up a REST client for use with Oracle Documents Cloud, using Jersey REST client, and it needed to be deployed to Oracle Java Cloud SX (aka JCSSX). The client code worked perfectly on a local Weblogic 11g but when deployed to the JCSSX instance it would give the following error :

Normal 0 false false false EN-GB X-NONE X-NONE MicrosoftInternetExplorer4

java.lang.RuntimeException: java.security.AccessControlException: access denied ("java.net.SocketPermission" "partners-pts.documents.us2.somecloud.com:443", "connect,resolve")

/* 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:0cm 5.4pt 0cm 5.4pt; mso-para-margin:0cm; mso-para-margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:11.0pt; font-family:"Calibri","sans-serif"; mso-ascii-font-family:Calibri; mso-ascii-theme-font:minor-latin; mso-fareast-font-family:"Times New Roman"; mso-fareast-theme-font:minor-fareast; mso-hansi-font-family:Calibri; mso-hansi-theme-font:minor-latin; mso-bidi-font-family:"Times New Roman"; mso-bidi-theme-font:minor-bidi;}

Initially I was convinced that this was some sort of networking issue in JCSSX, I.e. it couldn't connect to the documents cloud server via the network.. I even tried manually setting the proxy in the Java Code all to no avail..

After quite a while looking I discovered the problem...

This is the detailed error message I got :

Normal 0 false false false EN-GB X-NONE X-NONE MicrosoftInternetExplorer4 Caused by: java.security.AccessControlException: access denied ("java.net.SocketPermission" "partners-pts.documents.us2.somecloud.com:443" "connect,resolve")
at java.security.AccessControlContext.checkPermission(AccessControlContext.java:372)
at java.security.AccessController.checkPermission(AccessController.java:559)
at java.lang.SecurityManager.checkPermission(SecurityManager.java:549)
at java.lang.SecurityManager.checkConnect(SecurityManager.java:1051)
at sun.net.www.http.HttpClient.openServer(HttpClient.java:510)
at sun.net.www.protocol.https.HttpsClient.<init>(HttpsClient.java:275)

at sun.net.www.protocol.https.HttpsClient.New(HttpsClient.java:371)
at sun.net.www.protocol.https.AbstractDelegateHttpsURLConnection.getNewHttpClient(AbstractDelegateHttpsURLConnection.java:191)
at sun.net.www.protocol.http.HttpURLConnection.plainConnect(HttpURLConnection.java:932)
at sun.net.www.protocol.https.AbstractDelegateHttpsURLConnection.connect(AbstractDelegateHttpsURLConnection.java:177)
at sun.net.www.protocol.http.HttpURLConnection.getInputStream(HttpURLConnection.java:1300)
at java.net.HttpURLConnection.getResponseCode(HttpURLConnection.java:468)
... 81 more

/* 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:0cm 5.4pt 0cm 5.4pt; mso-para-margin:0cm; mso-para-margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:11.0pt; font-family:"Calibri","sans-serif"; mso-ascii-font-family:Calibri; mso-ascii-theme-font:minor-latin; mso-fareast-font-family:"Times New Roman"; mso-fareast-theme-font:minor-fareast; mso-hansi-font-family:Calibri; mso-hansi-theme-font:minor-latin; mso-bidi-font-family:"Times New Roman"; mso-bidi-theme-font:minor-bidi;}


The bold bits hint at the issue.. For some reason my code was using the Sun HTTP Handler which isn't supported on the JCSSX stack but I hadnt configured it to use the Sun Http Handler...You can get your code to use the Sun Http Handler by either setting the system property "UseSunHttpHandler=true" in code or by using Oracle Cloud SDK to set it as a system property.

To check if you have the UseSunHttpHandler set, issue the following command (changing your JCSSX details)

 javacloud list-system-properties -user <username> -p <password> -id <identityDomain>-si  <serverInstance> -httpproxy <httpProxy:port> -datacenter <dataCenterName>

If you have the UseSunHttpHander set to true, or even present, then remove it! Someone had set it in my instance but none of my team members would admit to it.....

 javacloud delete-system-property -user <username> -p <password> -id <identityDomain>-si  <serverInstance> -httpproxy <httpProxy:port> -datacenter <dataCenterName> -name UseSunHttpHandler

Restart your instance and all should then be well.

We've logged an enhancement request to get JCSSX to ignore this specific system property but just incase you hit it before the ER hits the JCSSX servers.



DOAG Expertenseminar "Parallel Execution Masterclass" (German)

Randolf Geist - Mon, 2015-03-30 16:34
In zwei Wochen findet das Expertenseminar "Parallel Execution Masterclass" in Berlin statt, das ich gemeinsam mit der DOAG veranstalte.

Es sind noch ein paar Plätze frei - sollten Sie also Lust und Zeit haben, nach Berlin zu kommen und exklusives Wissen (nicht nur) über das Parallel Execution Feature der Oracle Datenbank zu erfahren, würde ich mich sehr freuen, Sie dort mit den anderen Teilnehmern begrüßen zu dürfen, um gemeinsam mit Ihnen eine gute und produktive Zeit zu verbringen!

Bei Interesse wenden Sie sich bitte an die Ansprechpartner der DOAG, die im Link angegeben sind - dort finden Sie auch eine genauere Beschreibung des Seminars.

New blog to handle the PJC/Bean articles

Francois Degrelle - Mon, 2015-03-30 13:06
Here is the link to another place that stores the PJCs/Beans article without adds. http://forms.pjc.bean.blog.free.fr/ Francois

A command-line alternative to PeopleSoft SendMaster

Javier Delgado - Mon, 2015-03-30 11:05
If you are familiar with PeopleSoft Integration Broker, I'm sure you have dealt with SendMaster to some degree. This is a very simple but yet useful tool to perform unit tests of the Integration Broker incoming service operations using plain XML (if I'm dealing with SOAP Web Services, I normally use SoapUI, for which there is a very good article on PeopleSoft Wiki).

Most of the time it's enough with SendMaster, but today I came through a problem that required an alternative. While testing an XML message with this tool against an HTTPS PeopleSoft installation, I got the following error message:

Error communicating with server: sun.security.validator.ValidatorException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target

After checking in My Oracle Support, I've found the following resolution (doc 1634045.1):

The following steps will resolve the error:

1) Import the appropriate SSL certificate to the java kestore PS_HOME\jre\lib\security\cacerts or Integration Broker's keystore location i.e pskey file
2) Set sendmaster's preferences  ( via File-Preferences-HTTP tab )  to point to the keystore with the appropriate SSL certificate
3) Test

Unfortunately, I didn't have access to the appropriate SSL certificate, so I've decided to use curl, a pretty old (dating back to 1997 according to all knowing wikipedia) but still useful command line tool.



curl is a command line tool that can be used to test HTTP and HTTPS operations, including GET, PUT, POST and so on. One of the features of this tool is that it can run in "insecure" mode, eliminating the need of a client certificate to test URLs on HTTPS. Both in Linux and Mac OS, the option to run in insecure mode is -k. The command line to test my service operation then looked like:

curl -X POST -d @test.xml -k https://<server>/PSIGW/HttpListeningConnector 

Please note that the @ option actually requests curl to take the data from the file following it. Instead of doing so, you can specify the data in the command line, but it is a bit more cumbersome.

Also, keep in mind that curl is not delivered with Windows out of the box, but you can download similar tools from several sources (for instance, this one).







PTS Sample code now available on GitHub

Angelo Santagata - Mon, 2015-03-30 09:43

Not sure many people know about this, but sometime ago my team created a whole collection of sample code. This code is available on OTN at this location  but it is now also available in github here!

 We'll be updating this repository with some new code soon, when we do I'll make sure to update this blog entry

Pages

Subscribe to Oracle FAQ aggregator