Oracle ORA-28000 Account is locked

Hi All,

This was the solution for me

su - oracle

sqlplus "/ as sysdba"

sql> alter user system account unlock;

--> System was my locked user, in your case replace system with you locked account user name. 

Hope it helped,

Dor

The BPEL process deployment session is already active.

Hi All,

Happens with Oracle Service Bus and Eclipse.

I have found, that stopping coherence and osb and then starting coherence and starting osb solved for me the issue.


Hoped it helped,
Dor

Set up gradle to build with alternative java

I am using ubuntu 14.04 LTS

Having java 7 and 8 installed from oracle.

Using alternative and working with java 7 but one of my projects use java 8.

gradle build --version

returns that it works with java 7 -> since most of my projects use this version, i don't want to change this.

Solution: creating in the java 8 project, in the root directory, file named gradle.properties

inside it for example in my case :
org.gradle.java.home=/usr/lib/jvm/java-8-oracle/


this way, when you will do gradle build in this project, gradle will use this version instead of the one defined for him.


Hoped it helped,

Dor

Oracle Sql Developer Recyclebin

I wondered yesterday what does this means and why do i have there many “objects” (tables mostly).

Well, it’s simple.

Oracle keeps in the recycle bin information about all dropped objects. 

What ? what's for ?

Oracle keeps this information for “just in case” we will need to recover the table the index whatever.

Which is actually means that the quote space won’t be decreased as result of a drop and will still be count until we will specifically do purge to this data for the recycle bin.

You can see what’s inside your recycle bin using “select * from recyclebin”;

If you want you can read more about it here http://docs.oracle.com/cd/B28359_01/server.111/b28310/tables011.htm.

Since most of don’t have DBA privileges, this “PURGE RECYCLEBIN;” will delete only our recyclebin.

If you ask me, I think that this option should be enabled (the recycle bin) only in production, other places like development shouldn’t have this kind of fallback backup.

Hoped it helped understanding.

Dor

EmptyResultDataAccessException: Incorrect result size: expected 1, actual 0

Hi,
Lately i had this exception in my spring jdbc part of code. What it
actually means is that your query probably doesn't return any value while you are trying to assign the query result into let's say 'int'.

Change the query from queryForInt to regular query that returns a list. Use row mapper also.
Check the list, if it's empty, nothing returned from the query, decide what to do, else if the list isn't empty
and contain data, also, decide what to do.
It then will work for you.



Hoped i helped,
Dor

insert ampersand in oracle table

Hi,
This solution will work everywhere, no matter if you are using TOAD,sql plus, pl sql developer.
let's say we want to insert this "hello&world" inside a table that includes key's and values.
And our key, let's say is "title"
For example :
insert into table_name (keys,values) values ('title','hello'||chr(38)||'world');
That's the whole story.
Hoped i helped,
Dor