Tag: Osama mustafa

Oracle Open World 2015 review

Posted on by Osama Mustafa in News
As all of you know Oracle open world 2015 finished before 2 days ago, and simply it’s was amazing, my trip started on OCT-21-2015 Wenseday and it’s was totally morning flight which mean i supposed to be in airport at 4:00 am because of to avoid miss my flight i didn’t sleep, the flight was from Jordan – Amman to Turkey – IST and then to SF, when i landed in IST i met my old friend Gurcan Orhan this man is awesome, he managed everything from our seats to waiting in the lounge but i have to say he spent 11 hours sleeping from IST- SF. meanwhile i was watching San Andres movie which i discovered later it was bad idea , in case you didn’t watch it’s movie talking about earthquake happened in San Francisco, actually i watched all the entertainment movie and i was thinking what i will go when i will be back home ? simply i watch San Andres again.

anyway we landed after 13 hours of flying and we met the great Tim Hall the great oracle guy i am sure this man is helping a lot of DBA with his amazing blog. so we took the shuttle “tim, Gurcan, Arup,cary , simon and me”.

Don’t forget this is was my first OOW15 as ACED :), so i attended ACED Breifing and meet my old friends there, during the two days i learnt alot of new things about Oracle that i can’t mention it here because the NDA, and i want to thanks Oracle ACE program to organizing all this and make it true so let’s skip this part.
OOW15 started on sunday with an amazing weather, attending session about RAC, Database just like arup said ” there is database and everything else” and sure the middleware sessions.
I had so much fun & learning, the funny thing that i met Deiby and nassyam for the first time and these guys are simply funny and crazy 🙂 i think we can be called the four musketeers “Me, Alex Zaballa, Deiby and Nassyam”
Let’s not forget the amazing friend all over the world such as : Bobby, Danny Bryant, Kellyn, Heli,  Steve , Kevin ,Mahir, kamran, sai ram, Joel and a lot of amazing people and friends but i can’t feel my fingers 🙂 
Also The ACE dinner on Sunday night was awesome,almost all the ACE’s in one place and we had so much there, in OOW I lost twice with F1 Simulation but i want one of these machine anyway.

and i noticed that i am not good at all when i am eating spicy food i spent my time like the following  one hand drink water the other one wiping my tears. thanks for Sai , Nassyam and Hariharaputhran.

there is so much to say about OOW15 but this is as quick review for it and if you have any more question about it you can ask me 🙂
Thanks 
Osama

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

Posted on by Osama Mustafa in Database
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 

System is in manitance mode. Please try again later OBIEE

Posted on by Osama Mustafa in Fusion Middleware
When trying to update any reports in OBIEE the below errors appears :-

to solve this issue just follow the screen :-

1- Access to OBIEE Link http://ip-hostname:9704/analytics
2- Choose Administration from the upper right corner.

3- Turn Maintenance mode to off by press the link.

Good Luck.

Cheers
Osama

Presentation will be

Posted on by Osama Mustafa in News
There is no much left for 2015 but there is too much work waiting me, presenting in different country means a lot of work and preparation, i am still waiting different events but till now this is confirmed:-

  • SIOUG2015 — Located In Slovenia.
  • HROUG2015 — Located in Croatia 
  • OOW15 — Located in SF, USA
  • UKOUG TECH15 — Located in UK.

So Excited.

Cheers
Osama Mustafa

create IPS repository in Solaris 11.2

Posted on by Osama Mustafa in Operating system
I discussed before how to create package repository on Linux here, the same could be happened on Solaris 11.2 when you install Database any version mandatory packages should be installed to make it easy repository helps you a lot and will be available any time you need, and Image packaging system(IPS) repository is one of the important things in Solaris 11 onwards.

You need to download the following files & upload them to the server :-

Once the file is ready upload them to the server under one file called Repo for example. it should looks like the below :-

#ls -lrt
total 14373947
-rwx——   1 root     root     1771800121 Aug  9 08:24 sol-11_2-repo-1of4.zip
-rwx——   1 root     root     1889867782 Aug  9 11:20 sol-11_2-repo-2of4.zip
-rwx——   1 root     root     1902167161 Aug  9 22:34 sol-11_2-repo-3of4.zip
-rwx——   1 root     root     1790358735 Aug 10 00:16 sol-11_2-repo-4of4.zip
-rwx——   1 root     root        5594 Aug 10 20:16 install-repo.ksh
-rwx——   1 root     root         228 Aug 10 20:17 sol-11_2-repo-md5sums.txt
drwxr-xr-x   2 root     root           2 Aug 10 20:40 repo

#pkg publisher
PUBLISHER TYPE STATUS URI
solaris origin online http://pkg.oracle.com/solaris/release/

 as you see from the above output package publisher still working under oracle Link. Let’s Start Working, Set the executable bit for install-repo.ksh and execute like below.

#./install-repo.ksh -d /export/oracle/repo/ -v -c
Comparing checksums of downloaded files…done. Checksums match.
Uncompressing sol-11_2-repo-1of4.zip…done.
Uncompressing sol-11_2-repo-2of4.zip…done.
Uncompressing sol-11_2-repo-3of4.zip…done.
Uncompressing sol-11_2-repo-4of4.zip…done.
Repository can be found in /export/oracle/repo/.
Initiating repository verification.

Again Check the current publisher.

#pkg publisher
PUBLISHER                   TYPE     STATUS P LOCATION
solaris                     origin   online F http://pkg.oracle.com/solaris/release/

configure the new publisher, Path should be the same.

#pkg set-publisher -G ‘*’ -M ‘*’ -g file:///export/oracle/repo solaris

#pkg publisher
UBLISHER                   TYPE     STATUS P LOCATION
solaris                     origin   online F file:///export/oracle/repo

Configure the repository service to point to the new location by run the following command :-

# svccfg -s application/pkg/server setprop pkg/inst_root=/export/oracle/repo 


Check

# svcprop -p pkg/inst_root application/pkg/server

Reload the Services Just to confirm :-

# svcadm refresh application/pkg/server

Cheers
Osama Mustafa

Use "sudo" Command without password Prompt

Posted on by Osama Mustafa in Operating system
Sometimes you need to run Linux command without password prompt using sudo command.

to learn more about this command read the link here.

For Example i need to run the following command without password prompt, However there are three sudo commands I want to run without entering password:

  • sudo reboot
  • sudo shutdown -r now
  • sudo shutdown -P now
to do this follow the below steps :-
  • edit the following /etc/sudoers file.
  • you find the following lines depend on the username and hostname for the server.

user host = (root) NOPASSWD: /sbin/shutdown
user host = (root) NOPASSWD: /sbin/reboot

This will allow the user user to run the desired commands on host without entering a password. All other sudoed commands will still require a password.

Notes:

  • Always use the command visudo to edit the sudoers file to make sure you do not lock yourself out of the system for example 

sudo visudo -f /etc/sudoers.d/shutdown

  • Using /etc/sudoers.d instead of modifying /etc/sudoers, you could add the two lines to a new file in /etc/sudoers.d for example  /etc/sudoers.d/shutdown.
  • If you did not use visudo to edit your files and then accidentally messed up /etc/sudoers or messed up a file in /etc/sudoers.d then you will be locked out of sudo.to fix it use command pkexec.
Cheers
Osama Mustafa

/usr/ccs/bin/as: not found/No such file or directory on Solaris 11.2

Posted on by Osama Mustafa in Operating system
While trying to install Oracle Database 12c on Solaris 11.2 the i faced the following the errors in the logs and dbca was unable to start :-

INFO: sh[2]: /usr/ccs/bin/as: not found [No such file or directory]
INFO: make: Fatal error:
INFO: *** Error code 127

The package developer/assembler comes with default installation, But  Solaris 11 package developer/assembler is not installed.

To install it: –

pkg install developer/assembler

and try again.

Cheers
Osama 

Officially Fusion Middleware 11.1.1.9 Is Available to download

Posted on by Osama Mustafa in News
“Oracle Fusion Middleware is the leading business innovation platform for the enterprise and the cloud. It enables enterprises to create and run agile, intelligent business applications while maximizing IT efficiency through full utilization of modern hardware and software architectures. Solutions and products include Exalogic Elastic Cloud, data integration, business process management, business intelligence, identity management, Cloud application foundation, service-oriented architecture, WebCenter, and development tools.”

Oracle Fusion middleware 11.1.1.9 is now available to download :-

  • Oracle Business Intelligence Enterprise Edition
  • Oracle JDeveloper and Application Development Framework (ADF)
  • Oracle Business Process Management
  • Oracle SOA Suite
  • Oracle Data Integrator
  • Oracle User Messaging Service
  • Oracle Enterprise Scheduler
  • Oracle Event Processing
  • Oracle WebCenter Suite
  • Oracle Identity Management
  • Oracle Forms and Reports
  • Oracle WebTier
  • Oracle Application Architecture Foundation Pack
To download Documentation from here
To Install Products steps from here 
to Download products from here
Thank you 
Osama Mustafa

Configure RMAN Backup On Windows

Posted on by Osama Mustafa in Database
Database is supported on windows and some people using Windows As Production and RMAN need to be configured to ensure backup for Database in such failure or something to do this follow the below steps :-

  • Create first text file called backup and change the format to “bat”, inside the file add the following lines :-

C:
cd E:\app\ADM-BSS01\product\11.2.0\dbhome_1\BIN
rman @E:\RMAN\Scripts\backup.rman

  • Create 3 folders in E for example :-
    • backup
    • Archivelog
    • Controlfile
  • Create second file name it Backup.rman and add the Rman Script like below 

connect target /
run
{
ALLOCATE CHANNEL c1 DEVICE TYPE disk;
ALLOCATE CHANNEL c2 DEVICE TYPE disk;
ALLOCATE CHANNEL c3 DEVICE TYPE disk;
ALLOCATE CHANNEL c4 DEVICE TYPE disk;
backup AS COMPRESSED BACKUPSET tag Full_database_open format ‘E:\RMAN\backup\db_%t_%s_p%p.bkp’ database;
backup AS COMPRESSED BACKUPSET archivelog all format ‘E:\RMAN\backup\archivelog\al_%t_%s_p%p.arch’ delete all input;
backup AS COMPRESSED BACKUPSET current controlfile tag =cf1 format ‘E:\RMAN\backup\cf_%t_%s_p%p.bkp’;
backup tag ORCL_CONTROL current controlfile format ‘E:\RMAN\Controlfile\%d_%T_%s_%p_CONTROL’;
delete noprompt expired backup;
release channel c1;
release channel c2;
release channel c3;
release channel c4;
}

  • Follow the screen now :-

      • Add Task Name and Description :-
      • Add The Time for this Task in this tab 
      • Another Screen :-
      • In This Screen Add Bat File in our case backup.bat