BGOUG Autumn Conference – Extraordinary trip

it’s 19-Nov-2015 and this day means that i should start packing and prepare myself for traveling to Bulgaria, at first everything was normal and i thought it will be like any other trip i did before.

since there is no direct flight to Bulgaria then i should landed in Frankfurt first then to Sofia as most of you know i don’t like early flight despite i am waking all the night working or replying some emails but it’s something i don’t like to do 🙂 anyway my flight was at 3:00 am from Jordan i did boarding thing and visa & security Check after 6 hours i landed in Germany,drink coffee in the airport and ran to my next flight Sofia.

When i landed in Sofia it was 1:30 pm exactly, so like any other airport i should pass by immigration officer & this is what happened :-

Me :- Hi, Good afternoon.
officer : Hi, your passport please.
Me ; Sure.
Officer “Scan the visa” and the System start rining.
Me: is there something wrong.
Officer: mmmm come with me please.
Me “in my mind” did i do anything bad before i came here.
Officer : Your visa valid from tomorrow.
Me: Kidding right ? So what ?
Officer : you have to wait till 12:00 am then you access to Sofia.
Me : it’s almost 12 hours man.
Officer : it’s Ok you can go upstairs and have some drink and food if you want.
Me : Sure, i am gonna have more than this.

So i wait in the airport and during this i sent an email to Milena to inform her that i will not be available till 12:00 am and told her what is happened to me.

I would like to thanks all of them actually Milena, Heli and Gurcan  these guys was checking on me :).

Wait my story not end here, When i went out of security check now i have to start search of my luggage which i found it in Lost & found Department for more information about this part contact me 🙂

anyway the conference was really good i had two presentation about middleware with live demo, i don’t know why the live demo before the presentation working fine but during the presentation it stop working for stupid reasons but live demo is always challenge

everything was well organized  and conference was really amazing.

Safe Trip my friends 🙂 and meet you soon Inchallah.

Cheers
Osama 

ORA-01502 index or partition of such index is in unusable state

The following error appeared on application side while trying to deploy the new SRF on the application, as you see from the above error it’s database error and to solve it follow the below steps :-

from database side :-

sqlplus /as sysdba

From the above picture check the index name and put it inside this query :-

select owner,index_name,table_name,status from dba_indexes where index_name=’index_name’;

OWNER    INDEX_NAME    TABLE_NAME    STATUS
—–    ———-    ———-    ——
owner    index_name     table_name    INVALID

alter index ndex_name rebuild;

Try again

Cheers
Osama 

ORA-00845: MEMORY_TARGET not supported on this system

SQL> alter system set memory_max_target=2GB scope=spfile;
System altered.
SQL> alter system set memory_target=2GB scope=spfile;
System altered.

 SQL> startup ;

ORA-00845: MEMORY_TARGET not supported on this system

Check the following Space :-

ECATSTDB oracle: :/home/oracle\>df -h
Filesystem            Size  Used Avail Use% Mounted on
/dev/mapper/Oracle-LogVol00
                       20G  3.3G   15G  18% /
/dev/mapper/Oracle-LogVol02
                       90G   45G   41G  53% /Oracle
/dev/sda1              99M   18M   77M  19% /boot
tmpfs                 3.0G     0  3.0G   0% /dev/shm

Increase the space

mount -t tmpfs shmfs -o size=6144m /dev/shm

now startup the database.

Cheers
Osama