Linux and Shell Scripting Part 2

There are several series I couldn’t get into as much as I wanted last year. BIS, Security, Linux, Apex and Information Integration are some of these, let’s say maybe next year, of course if time remains from 11g new features stuff :) So this one goes to Linux category.

One of my colleagues needed my help on some shell scripting, since I love this I gave a break on my Apex project I mentioned earlier in a post and helped her.

Request was to clone a remote 9i oracle schema into local 10g database and make it read only, a periodically unix cron runnable script is needed. So script should involve four main parts at least;
A. sqlplus to drop and recreate local clone user,
B. export remote schema to local dump file,
C. import remote schema from local dump file,
D. sqlplus to revoke all unwanted grants on the schema, just the SELECT type of privileges may remain.

Here are the scripts we used, you may check them, comment on them and maybe you might want to use these as templates for your needs, because I do so when I start any kind of Oracle shell script need, time is saved :)

clone_user.ksh
step1.sql
step4.sql

Since there are some attractions used, here you will also find my comments on the scripts mentioned above.

comments.txt

During my Apex work last several weeks I benefited so much from OTN Apex forum, very active and effective forum, whenever I faced a problem there I found the exact detailed solution easily. So a bunch of thanks from me goes to below experts for putting their valuable time into all OTN forums, several times they saved me;

Scott Spadafore
Hans Forbrich
Vikas
Nicolas Gasparotto
Hector Rivera Madrid
Rob van Wijk

It is great to feel your support behind guys, take care! :)

Lately I learned that Steven Feuerstein will be in Istanbul for a two days seminar, he subscribed and announced his seminar to OracleTURK group members, it was really fun to monitor the feedbacks of the group members. Including me Steven has lots of fans here in Turkey, so I guess he may have a similar crowd waiting which Roberto Carlos experienced during his first arrival to Atatürk Airport after his transfer from Real Madrid to my team Fenerbahçe this year :)

ps : lately two important names Jonathan Lewis and Howard Rogers are also active at OTN forums, I hinted this one because you also might want to watch their posts over OTN forums rss feeds since usually each post of them is like an article to study(but be warned, if Burleson is included within the thread then things may get a little complicated:).

Another additional hint goes for Dizwell, he has his own way of sharing his experiences, which may help you to extra enjoy reading his long feedbacks:)

Oracle, Linux and Shell Scripting Part 1

Ok here starts another series, this road is targeted “power”, power here which I may summaries as Oracle on Linux. Linux refers to any Unix-like computer operating system that uses the Linux kernel.

Finnish university student Linus Torvalds originally used Minix on his own computer in 1991 as a hobby while attending the University of Helsinki. Minix is a simplified Unix-like system written by Andrew S. Tanenbaum for teaching operating system design. However, Tanenbaum did not permit others to extend his operating system, leading Torvalds to create a replacement for Minix.

Oracle released the first commercial database on Linux in 1998. Today, Oracle is the only major software vendor to collaborate with and provide first-line support for Red Hat, Novell, and Asianux. And all Oracle products are available on Linux.

Oracle Announced Enterprise-Class Support for Linux at Openworld 2006

Oracle Unbreakable Linux is a support program of Oracle that provides enterprises with industry-leading global support for Linux. Oracle also now offers Enterprise Linux software as a free download. It is all currently explained in more detail on the Unbreakable Linux Network.

Oracle Maintains Top Spot in RDBMS Market, Increases Share in Linux Segment

According to this Forbes article, Gartner’s 2005 RDBMS marketshare study showed Oracle has the biggest share in this market. Oracle enjoys about 50% of the total RDBMS market and 55% on distributed systems. Both IBM and Oracle posted similar year-over-year growth in their database businesses in 2005, with Oracle growing slightly faster than IBM.

Also, Oracle extended its lead in the RDBMS on Linux market. While Oracle seems to have lost share on the Windows platform, it remains the leader on the fastest-growing Linux platform where the market grew by 84% and Oracle consolidated its top spot by increasing its share to 81% from 76%.

Here are my favorite resources on Linux and Oracle

You must read these articles before we proceed, really beautifull please check them

So lets take some time for these resources :)