Thursday, July 30, 2015

Presentation will be

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
  • HROUG2015
  • OOW15
  • UKOUG TECH15

So Excited.


Cheers
Osama Mustafa

Database 12.1.0.2 Certified with EBS 12.2

After Waiting too long finally I can upgrade my Oracle EBS Database ,Regarding to Oracle Blog "Database 12.1.0.2 Certified with EBS 12.2".

You can Read more about this here

Cheers
Osama

Saturday, July 18, 2015

sorting algorithm


I have to share this Picture which is really amazing and include all the sorting algorithm in one picture 



video

Cheers
Osama 

Tuesday, July 14, 2015

create IPS repository in Solaris 11.2

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

Sunday, July 12, 2015

Use "sudo" Command without password Prompt

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

Tuesday, July 7, 2015

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

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 

Friday, June 26, 2015

OTech Magazine – Summer 2015


OTech Magazine - Summer 2015 OTech Magazine issue Summer 2015 is the eighth issue of OTech Magazine – the independent Oracle technology magazine – . Our contributors are the best of the best of the Oracle atmosphere.



Osama Mustafa – Database Link From Oracle to MySQL

Read the full version of magazine here.

Thanks Douwe Pieter  for this amazing efforts.


Cheers
Osama Mustafa