Feeds:
Posts
Comments

Posts Tagged ‘db’

You might get the bellow erros during Oracle DB installation, or, when trying to connect Oracle DB:

ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist

One of the main causes of this error is due to a wrong setting in the hosts file under /etc folder.

To solve this error, first check what is the server IP address, by running the command:

# ifconfig

From the output, copy the value of the “inet addr” parameter (for example: 10.0.0.1).

Edit the hosts file under /etc folder. Add a new line, and set the host and IP, for example:

arik 10.0.0.1

Save and try again.

 

Good Luck

Read Full Post »

Oracle Database 11g Express Edition is free and can be download from here:

http://www.oracle.com/technetwork/products/express-edition/downloads/index.html

I’ve installed the DB on Oracle linux 6, but the explanation is good for other Linux x86-64 platform as well.

After you’ve downloaded the DB’s .rpm file, follow the next steps, in order to install the DB:

(more…)

Read Full Post »

When you are using one of the following Adapters – Database/Oracle Application/AQ, sometimes (randomly) you might get an error like:

“Exception occured when binding was invoked. Exception occured during invocation of JCA binding: “JCA Binding execute of Reference operation ‘GetData’ failed due to: Stored procedure invocation error. Error while trying to prepare and execute the BPEL_GETDATA.PROCEDURE$GET_ DATA API. An error occurred while preparing and executing the BPEL_GETDATA.PROCEDURE$GET_ DATA API. Cause: java.sql.SQLTimeoutException: ORA-03111: break received on communication channel Check to ensure that the API is defined in the database and that the parameters match the signature of the API. This exception is considered retriable, likely due to a communication failure. Because the global transaction is rolling back the invoke must be retried in a new transaction, restarting from the place of the last transaction commit. To classify it as non-retriable instead add property nonRetriableErrorCodes with value “1013” to your deployment descriptor (i.e. weblogic-ra.xml). “. The invoked JCA adapter raised a resource exception. Please examine the above error message carefully to determine a resolution.”

(more…)

Read Full Post »

DbAdapter provides all kind of operations that helps you interact with the DB.
I saw more than few times, questions, about how to use dynamic parameters when executing the ‘Execute Pure SQL‘ operation.
In the following step I will explain how to do it.

(more…)

Read Full Post »

I must say that I’ve predicted this error….
One of my customer’s requirements is to run a simple query on Oracle 10g Database.
I’ve developed a simple process in Bpel 10g that uses ‘select’ operation from a DbAdapter.
I ran the process from the BPELConsole,  and got the following error:

WSIF JCA Execute of operation ‘GetDataSelect’ failed due to: DBReadInteractionSpec Execute Failed Exception.
Query name: [GetDataSelect], Descriptor name: [GetData.PlwProject1]. [Caused by: ORA-00911: invalid character
]
; nested exception is:
ORABPEL-11614
DBReadInteractionSpec Execute Failed Exception.
Query name: [GetDataSelect], Descriptor name: [GetData.PlwProject1]. [Caused by: ORA-00911: invalid character

(more…)

Read Full Post »

Oracle Database 11g Express Edition is free and can be download from here:
http://www.oracle.com/technetwork/products/express-edition/downloads/index.html

Please follow the next steps in order to install the DB:

(more…)

Read Full Post »

When calling a stored procedure from SOA Suite 11g (Bpel/OSB/BPM ….) , you might get the following error:

….

java.sql.SQLSyntaxErrorException: ORA-02089: COMMIT is not allowed in a subordinate session

….

(more…)

Read Full Post »

Older Posts »