Feed aggregator

Oracle INITCAP Function with Examples

Complete IT Professional - Thu, 2016-07-21 06:00
The Oracle INITCAP function is a handy string manipulation function. Learn what it does and see some examples in this article. Purpose of the Oracle INITCAP Function The Oracle INITCAP function translates a specified string into another string which has the first letter of each word capitalised, and all other letters in lower case. The […]
Categories: Development

BPEL 12.1.3 Certified for Prebuilt EBS 12.1.3 SOA Integrations

Steven Chan - Thu, 2016-07-21 02:07

Service Oriented Architecture (SOA) integrations with Oracle E-Business Suite can either be custom integrations that you build yourself or prebuilt integrations from Oracle.  For more information about the differences between the two options for SOA integrations, see this previously-published certification announcement.

The prebuilt BPEL business processes in Oracle E-Business Suite Release 12.1.3  are:

  • Oracle Price Protection (DPP)
  • Advanced Supply Chain Planning (MSC)
  • Oracle Transportation Management: Oracle Warehouse Management (WMS)
  • Oracle Transportation Management: Oracle Shipping Execution (WSH)
  • Oracle Transportation Management: Oracle Purchasing (PO)
  • Complex Maintenance, Repair & Overhaul (CMRO/AHL)

BPEL integration architecture diagram example

These prebuilt BPEL processes have now been certified with Oracle BPEL Process Manager 12c version 12.1.3 (in Oracle Fusion Middleware SOA Suite 12c) for Oracle E-Business Suite Release 12.1.3.

References

Certified Platforms

Oracle SOA Suite Release 12g 12.2.1 is certified to run on any operating system upon which Oracle WebLogic Server 12c is certified. Check the following for more details:

For information on operating systems supported by Oracle SOA Suite, refer to this document:

Integration with Oracle SOA Suite involves components spanning several different suites of Oracle products. There are no restrictions on which platform any particular component may be installed so long as the platform is supported for that component.

Getting Support

If you need support for the prebuilt EBS BPEL business processes, you can log Service Requests against the Applications Technology Group product family.

Related Articles

Categories: APPS Blogs

Keep big integers in Oracle RDBMS

Tom Kyte - Thu, 2016-07-21 02:06
Oracle has several datatypes that can keep numbers. LONGINTEGER can keep the biggest whole number - number in the range of (-2**63) to (2**63)-1 I need to keep bigger numbers so I can't use it. Keeping the numbers in decimals may affect precision. ...
Categories: DBA Blogs

Unable to open file even though given correct file path wile reading certificate from wallet

Tom Kyte - Thu, 2016-07-21 02:06
Hi Tom , We have requirement to communicate payment gateway through https from plsql. so we used SSL through wallets. But in 11.2.0.1.0 we are unable to read file from wallet even though correct file path provided. I gone through below link al...
Categories: DBA Blogs

Life cycle of a query

Tom Kyte - Thu, 2016-07-21 02:06
Can you please explain the full life cycle of a query like "select * from employees" ..Parsing and memory utilization..?
Categories: DBA Blogs

trigger execution order

Tom Kyte - Thu, 2016-07-21 02:06
Sir, I have 5 same functionality triggers on a single table, let's suppose t1,t2,t3,t4,t5. I want that trigger t3 should execute at first. Is this possible? If yes then how? Please give some explanation also. Thanks & Regards
Categories: DBA Blogs

Database restoration

Tom Kyte - Thu, 2016-07-21 02:06
Hi Tom, This is Gurupi from India. I am a newbie to Oracle but have fair working knowledge in Linux OS. One of my clients need to restore their Oracle 10g databases on their old IBM server running CentOS 5. Their server drives crashed and they ...
Categories: DBA Blogs

BPEL 12.2.1 Certified for Prebuilt EBS 12.1.3 SOA Integrations

Steven Chan - Thu, 2016-07-21 02:05

Service Oriented Architecture (SOA) integrations with Oracle E-Business Suite can either be custom integrations that you build yourself or prebuilt integrations from Oracle.  For more information about the differences between the two options for SOA integrations, see this previously-published certification announcement.

The prebuilt BPEL business processes in Oracle E-Business Suite Release 12.1.3  are:

  • Oracle Price Protection (DPP)
  • Advanced Supply Chain Planning (MSC)
  • Oracle Transportation Management: Oracle Warehouse Management (WMS)
  • Oracle Transportation Management: Oracle Shipping Execution (WSH)
  • Oracle Transportation Management: Oracle Purchasing (PO)
  • Complex Maintenance, Repair & Overhaul (CMRO/AHL)

BPEL integration architecture diagram example

These prebuilt BPEL processes have now been certified with Oracle BPEL Process Manager 12c version 12.2.1 (in Oracle Fusion Middleware SOA Suite 12c) for Oracle E-Business Suite Release 12.1.3.

References

Certified Platforms

Oracle SOA Suite Release 12g 12.2.1 is certified to run on any operating system upon which Oracle WebLogic Server 12c is certified. Check the following for more details:

For information on operating systems supported by Oracle SOA Suite, refer to this document:

Integration with Oracle SOA Suite involves components spanning several different suites of Oracle products. There are no restrictions on which platform any particular component may be installed so long as the platform is supported for that component.

Getting Support

If you need support for the prebuilt EBS BPEL business processes, you can log Service Requests against the Applications Technology Group product family.

Related Articles

Categories: APPS Blogs

Node-oracledb 1.10.1 Released to NPM

Christopher Jones - Wed, 2016-07-20 21:10

We've pushed out a patch release of node-oracledb to GitHub and NPM. It has a bind fix that didn't land in time for 1.10.0. A memory leak regression with REF CURSORs was also fixed, as was a pre-existing memory leak in the unexpected case of a REF CURSOR failure.

The changes in node-oracledb 1.10.1 are:
  • Fixed a bug that prevented a null value being passed from JavaScript into an IN OUT bind.

  • Fixed a memory leak introduced in 1.10 with REF CURSORs.

  • Fixed an existing memory leak problem if an error happens when fetching REF CURSORs.

  • Added a mocha configuration file for the test suite. The test suite README has updated instructions on how to add tests.

    As a side effect, the tests now run in numeric order.

A couple of other internal improvements are shown in the CHANGELOG.

Resources

Issues and questions about node-oracledb can be posted on GitHub. Your input helps us schedule work on the add-on. Drop us a line!

Node-oracledb installation instructions are here.

Node-oracledb API and user documentation is here.

Oracle LOWER Function with Examples

Complete IT Professional - Wed, 2016-07-20 16:41
In this article, I’ll take a look at the Oracle LOWER function, explain how it works, and see some examples. Purpose of the Oracle LOWER Function The LOWER function converts all letters within the specified string to lower case.   Syntax The syntax for the Oracle LOWER function is: LOWER ( input_string )   Parameters […]
Categories: Development

configure complex password (password verify function) in oracle database

Learn DB Concepts with me... - Wed, 2016-07-20 15:38

 configure password verify function in oracle database
We can enable the oracle provided "password verify function" to enforce strong password restrictions for our DB users. This function with other profile parameters can create a strong security for the database.To enable the oracle password verification function you need to execute the utlpwdmg.sql file from ORACLE_HOME/rdbms/admin as sysdba.
 

[oracle@Linux03 home]$ cd /u01/app/oracle/product/12.1.0.2/db_1/rdbms/admin/
[oracle@Linux03 admin]$ ls utlpwdmg.sql

[oracle@Linux03 admin]$ sqlplus / as sysdba
SQL> @/u01/app/oracle/product/12.1.0.2/db_1/rdbms/admin/utlpwdmg.sql

SQL> @/u01/app/oracle/product/12.1.0.2/db_1/rdbms/admin/utlpwdmg.sql

Function created.

Grant succeeded.

Function created.

Grant succeeded.

Function created.

Grant succeeded.

Profile altered.

Note : You can query current default profile settings using as below

select * from DBA_PROFILES where profile='DEFAULT';

Starting from 12c this file (utlpwdmg.sql) creates four functions under user SYS. Here we have an option to select one from four functions.

ORA12C_STRONG_VERIFY_FUNCTION
ORA12C_VERIFY_FUNCTION
VERIFY_FUNCTION
VERIFY_FUNCTION_11G

This function makes the minimum complexity checks like the minimum length of the password, password not same as the
username, etc. The user may enhance this function according to your need.

You can change the password verify function by using below sql :

ALTER PROFILE "DEFAULT" LIMIT PASSWORD_VERIFY_FUNCTION ORA12C_VERIFY_FUNCTION

IT SETS UP FOLOWING PARAMETERS IN DEFAULT PROFILE:

ALTER PROFILE DEFAULT LIMIT
PASSWORD_LIFE_TIME 180
PASSWORD_GRACE_TIME 7
PASSWORD_REUSE_TIME UNLIMITED
PASSWORD_REUSE_MAX  UNLIMITED
FAILED_LOGIN_ATTEMPTS 10
PASSWORD_LOCK_TIME 1

-- This script alters the default parameters for Password Management. This means that all the users on the system have Password Management enabled and set to the following values unless another profile is created with parameter values set to different value or UNLIMITED  is created and assigned to the user.

LETS TEST THE PASSWORD FUNCTION BY CREATING A NEW USER.

SQL> create user C##atest identified by atest11;

Error starting at line : 2 in command -
create user C##atest identified by atest11
Error report -
SQL Error: ORA-28003: password verification for the specified password failed
ORA-20001: Password length less than 8
28003. 00000 -  "password verification for the specified password failed"
*Cause:    The new password did not meet the necessary complexity
           specifications and the password_verify_function failed
*Action:   Enter a different password. Contact the DBA to know the rules for
           choosing the new password

          
While using length of 8 chars I was able to create user.

SQL> create user C##atest identified by atest113;

User C##ATEST created.

Categories: DBA Blogs

ORA-15418: Appliance Mode Not Supported For Compatible.asm 12.1.0.0.0

Pythian Group - Wed, 2016-07-20 09:45

The other day, I was upgrading a compatible.asm parameter to 12.1 on Exadata and I faced this error for the first time :

View the code on Gist.

Indeed, a diskgroup can have this parameter set to TRUE or FALSE :

View the code on Gist.

I then found this note on Metalink : EXADATA : What Is Oracle ASM appliance.mode Attribute (Doc ID 1664261.1) which explains that starting from Exadata 11.2.0.3.3, “The Oracle ASM appliance.mode attribute improves disk rebalance completion time  when dropping one or more Oracle ASM disks. This means that redundancy is restored faster after a failure.

Wow, that looks like a pretty cool feature! But it seems that (sadly) we cannot set a 12.1 compatible if this feature is enabled.

Let’s give it a try and deactivate it to set my compatible.asm to 12.1 :

View the code on Gist.

It works ! Now that this compatible.asm is set to 12.1, could we enable that appliance.mode feature again ?

View the code on Gist.

Sadly, no. I hit one of the restrictions; indeed, “The Oracle ASM disk group attribute compatible.asm is set to release 11.2.0.4, 12.1.0.2 and later. (Appliance mode is not valid with 12.1.0.1)” — then I guess that even of the documentation does not say so, Appliance mode is not valid with a compatible.asm set to 12.1.0.0.0 either.
Even if it is very weird that Oracle dev “forgot” (?) this cool feature when they released 12c on Exadata, they hopefully “released” it again with 12.1.0.2. I’ll follow up on that when moving this compatible.asm to 12.1.0.2 !

Categories: DBA Blogs

Conditional column linking in APEX

Tony Andrews - Wed, 2016-07-20 08:19
Sometimes there is a requirement to have a column in an APEX report that acts as a link to another page for some rows but not for others like this: Here, only when a program's status is 'VALID' can we link to another page by clicking on the program name. Until now I only knew a rather bad way of doing this, which would be to write code in the report query like: select case when Tony Andrewshttp://www.blogger.com/profile/16750945985361011515noreply@blogger.com0http://tonyandrews.blogspot.com/2016/07/conditional-column-linking-in-apex.html

ORA-04065 when calling a method of a NON-INSTANTIABLE superclass

Tom Kyte - Wed, 2016-07-20 08:06
Hi guys, I've come across an issue when calling a method of a NON-INSTANTIABLE superclass. You can find a sample script here: https://livesql.oracle.com/apex/livesql/file/content_DLRAPZYYKV51NA0FSUBU3RQ6W.html We've got: 1. A non-Instantiab...
Categories: DBA Blogs

maping columms and replace with another strings

Tom Kyte - Wed, 2016-07-20 08:06
Hi Tom, Any one would you assist me regarding my issue.. step1: I have two tables and data like below. table 1: create table component(id number , comptest varchar2(20) , apptext varchar2(20); insert into component values(1,'[pula]','v...
Categories: DBA Blogs

How to find out how much rollback a session has to do

Tom Kyte - Wed, 2016-07-20 08:06
Hello Tom, As always, thanks a lot for accepting this question. When a session rolls back for some error (typically, when the rollback segment or undo space cannot grow), what is the best way to determine if it is rolling back and how much is lef...
Categories: DBA Blogs

User entered date in the form to validation from another table before cursor moves to next field

Tom Kyte - Wed, 2016-07-20 08:06
Sir Hope you are doing well I have query, please suggest me solution I have two different tables Holidays (Holiday_ID,From_Date,To_Date) Emp_Attendance(Date,Emp_No,Attendance_Status) I would like that when user enter the date in the ...
Categories: DBA Blogs

Tons of archivelog files (.arc)

Tom Kyte - Wed, 2016-07-20 08:06
I'm currently running a oracle db for one of our printing machines and this db stores a ton of archivelog files. It looks like it generates around 15 a day, each between 37-50MB. I currently have under 1000 files totaling ~34GBs, and ranging from ...
Categories: DBA Blogs

Dynamic sql

Tom Kyte - Wed, 2016-07-20 08:06
HI TOM, 1)exactly in which situation we need to use these concepts in dynamic sql. i)"dbms_sql package" in dynamic sql ii)"Native dynamic sql" in dynamic sql .... .... show me with an example what is the vary in both the cases? ...
Categories: DBA Blogs

Gettin Ansible up and running on a SLES 12 SP1 host

Yann Neuhaus - Wed, 2016-07-20 06:38

Recently at a customer we had to setup Ansible on a SLES 12 SP1 host. In comparison to RedHat or Ubuntu based distributions there are some more steps to do as Ansible is not included in the standard SLES repositories. Here we go …

Start with the user, group, directories and permissions:

host:~ # groupadd ansible
host:~ # useradd -g ansible -m ansible
host:~ # passwd ansible
host:~ # mkdir /opt/ansible
host:~ # chown ansible:ansible /opt/ansible
host:~ # mkdir /etc/ansible
host:~ # chown ansible:ansible /etc/ansible
host:~ # touch /etc/ansible/hosts
host:~ # chown ansible:ansible /etc/ansible/hosts
host:~ # chmod 600 /etc/ansible/hosts

In our case we wanted to install Ansible directly from the git repository on github so we needed to install git:

host:~ # zypper install git

As pip was not available in the os repositories we had to install manually:

host:~ # cd /var/tmp
host:~ # export http_proxy=proxy:port    # if a proxy is used
host:~ # export https_proxy=proxy:port   # if a proxy is used
host:~ # wget https://bootstrap.pypa.io/get-pip.py
host:~ # python get-pip.py
host:~ # pip install paramiko PyYAML Jinja2 httplib2 six

Installing Ansible from here on is straight forward:

host:/var/tmp # su - ansible
ansible@host:~> cd /opt/ansible/
ansible@host:/opt/ansible> export http_proxy=webproxy.amag.car.web:8080
ansible@host:/opt/ansible> export https_proxy=webproxy.amag.car.web:8080
ansible@host:/opt/ansible> git config --global http.proxy $http_proxy
ansible@host:/opt/ansible> git config --global https.proxy $http_proxy
ansible@host:/opt/ansible>git clone https://github.com/ansible/ansible.git --recursive
ansible@host:/opt/ansible/ansible> git pull --rebase
Current branch devel is up to date.
ansible@host:/opt/ansible/ansible> ansible@s1100tap460:/opt/ansible/ansible> git submodule update --init --recursive

Ansible provides a script which makes it easy to setup the environment:

ansible@host:/opt/ansible/ansible>cd ansible
ansible@host:/opt/ansible/ansible>. hacking/env-setup

This does the initial stuff required for running Ansible out of a git repository and does set all the environment variables. It is good idea to do this automatically once you login as ansible user:

ansible@host:/opt/ansible/ansible> echo ". /opt/ansible/ansible/hacking/env-setup -q" >> ~/.bash_profile

Now you can execute ansible without adjusting your environment or switching to the installation directory:

ansible@host:/opt/ansible/ansible> which ansible
/opt/ansible/ansible/bin/ansible
ansible@host:/opt/ansible/ansible> ansible --version
ansible 2.2.0 (devel 4cc4dc6793) last updated 2016/07/19 13:51:23 (GMT +200)
  lib/ansible/modules/core: (detached HEAD 7de287237f) last updated 2016/07/19 13:51:40 (GMT +200)
  lib/ansible/modules/extras: (detached HEAD 68ca157f3b) last updated 2016/07/19 13:51:53 (GMT +200)
  config file =

To test we can add the localhost to the Ansible inventory:

ansible@host:/opt/ansible/ansible> echo "127.0.0.1" >> /etc/ansible/hosts

… and then exchange the public ssh key of the ansible user:

ansible@host:~> ssh-keygen -t dsa
ansible@host:~> ssh-copy-id -i ~/.ssh/id_dsa.pub ansible@127.0.0.1

Do a functional test:

ansible@s1100tap460:~>  ansible all -m ping
127.0.0.1 | SUCCESS => {
    "changed": false,
    "ping": "pong"
}

… and your done. Happy deploying …

 

Cet article Gettin Ansible up and running on a SLES 12 SP1 host est apparu en premier sur Blog dbi services.

Pages

Subscribe to Oracle FAQ aggregator