From May 2017

Ravello or How Can You Speed Up Provissioning Environments for Acceptance Testing, Q&A, certification, R&D and more…


I’m involved in a project for a big financial company. The solution is technologically complex integrating a bunch of technologies such as business intelligence, business processes modeling, reporting, documents, ldap, single sign on, identity federation, relational database, html/javascript/kquery/knockout…

Initially, the solution was designed to be provisioned in Oracle Cloud because the timeline for the whole project was only 4 months. Imagine how to put toguether all the stuff I mentioned in such short TTM!! You’d better utilize an agile and cloud-oriented approach or basically you are died!!!

Untitled

For several reasons the project is going to be deployed on Customer premises, thus the Q&A environment was not ready in time. For that reason we decided to utilize Ravelo Systems to create a test environment just uploading the VirtualBox vm’s that we had in the developement environment. In less than 2 hours you can upload a 5Ogb vm and in our particular case in only 2 days we got up&running 5 VM’s with all security configurations to keep the environment safe.

Benefits:

  • End users can perform acceptance testing in time while on-premises environments are installed and deployed with the business as usual approach
  • The created environment can be cloned easily giving the ability to create Q&A, certification or R&D environments in minutes!
  • This approach give us an idea of the diferences between the real costs of cloud computing approaches (less than 3$/hour  in my particular use case) against the huge costs of traditional strategies. Just one meeting to decide how to execute a sql script on-premises may involve 10 people during 2 hours wich costs near 600$. With that money you can run the cloud environment during 200 hours…

More info

Enjoy 😉

Apache: Service Temporarily Unavailable The server is temporarily unable to service your request due to maintenance downtime or capacity problems. Please try again later.


You have this error and:

  • your backend servers work perfectly (they respond ok by their ip:port)
  • your firewall is open for http/s port/s

Then maybe this can help you:

/usr/sbin/setsebool -P httpd_can_network_connect 1

Enjoy 😉

Oracle Content & Experience Cloud Service: API REST Example


The following example shows how to make a REST API call to get folder information from ann HTML page:

<html>

<head>

function UserAction() {

    var xhttp = new XMLHttpRequest();

    xhttp.open("GET", "https://docs-xxxxxx.documents.us2.oraclecloud.com//documents/api/1.1/folders/FDE2F2015454AB1596AF3404090B9CFF7042366FBD9C", false);

    xhttp.setRequestHeader("Accept", "application/json, text/plain, */*");

    xhttp.setRequestHeader("Authorization", "Basic " + btoa(document.getElementById('u').value + ':' + document.getElementById('p').value ));

    xhttp.send();

    alert( document.getElementById('u').value );

    var response = JSON.parse(xhttp.responseText);

    alert(response.ownedBy.displayName);

}

</head>

<body>

     <form>

  User name:<br>

  <input type="text" name="username" id="u"><br>

  User password:<br>

  <input type="password" name="psw" id="p">

</form>

<button type="submit" onclick="UserAction()">Search</button>

</body>

</html>

Related post

Enjoy 😉

Oracle Developer Cloud Service Local Maven Repository and Oracle Maven Repository


If your project utilizes Oracle libraries you can configure Oracle Maven repository under Configure Buil Job|Environment with your OTN credentials.

devcs1.png

If your project utilizes other Oracle libraries you can upload them to the project’s local Maven reposository.

devcs2.png

In additio must update your pom with references to the local maven repo such as:

    <repositories>

        <repository>

            <id>maven.oracle.com</id>

            <releases>

                <enabled>true</enabled>

            </releases>

            <snapshots>

                <enabled>false</enabled>

            </snapshots>

            <url>https://maven.oracle.com</url>

            <layout>default</layout>

        </repository>

        <repository>

            <id>SCFCOT_repo</id>

            <name>SCFCOT Maven Repository</name>

            <url>https://developer.em2.oraclecloud.com/profile/developerxxxxx-a4xxxxx/s/developerxxxxx-axxxx_scfcot_xxxx/maven/</url>

        </repository>        

    </repositories>
This settings can help you solve issues such as:

[FATAL] Non-resolvable parent POM for com.xxx:yyy:0.0.1-SNAPSHOT: Could not find artifact com.oracle.weblogic.archetype:wls-common:pom:12.2.1-2-0 in central (https://repo.maven.apache.org/maven2) and ‘parent.relativePath’ points    at  no local POM @ line xxx, column yyy

 

Enjoy 😉

Oracle Identity Cloud Service: “You cannot bookmark and access the /signin URL directly”


This message happens because you are requesting the sigin page directly while it is supposed that this page comes up as a challenge when you request s resource protected by IdCS in wich you are not logged in yet.

Solution: Request a resource protected by IdCS such as an application or this url <youridentitydomainurl>/ui/v1/myconsole. If you don’t have an application already registered and have administrative privileges try with <youridentitydomainurl>/ui/v1/ adminconsole

Enjoy 😉

Integrate sqlDeveloper with Oracle Developer Cloud Service Git Repository


Oracle Developer Cloud Service comes with Git repository. If you want your SQL project integrated with you can achieve it as follows:

1- Open sqlDeveloper ans select a connection

sqldev-DevCS-1

2- Goto Team->Git->Clone

sqldev-DevCS-2

3- Clone a DevCS repository with the Clone Wizard. In one of the steps you inform the path where the repo will be cloned into

This slideshow requires JavaScript.

4- Go to the directory where the project was cloned into and add/create files inside it

sqldev-DevCS-8

5- Add selected/all files to the local git repo

6- Commit changes

This slideshow requires JavaScript.

7- Push local repo to remote git repo in DevCS

This slideshow requires JavaScript.

8- Verify changes in DevCS

sqldev-DevCS-19

More info about DevCS

Enjoy 😉