What Oracle DBA is?

In newspaper I read some job vacancy for Oracle DBA. Then I want to find more about the Oracle and Oracle DBA.

What is Oracle?

Oracle is a relational database from Oracle Corporation. In a relational database, all data is stored in two-dimensional tables that are composed of rows and columns. The Oracle Database enables you to store data, update it, and efficiently retrieve it.

Oracle Database is the industry-leading database management system that you can use to store all types of business data, including relational, document, multimedia, XML, and location data. It is available on a wide range of platforms and scales from single processor systems to grids of interconnected servers. Oracle Database is the first database designed for Enterprise Grid Computing. It is easy to deploy and manage; can handle all data management workloads; and offers exceptional availability, scalability, reliability, and security.

Oracle provides software to create and manage the Oracle database. The database consists of physical and logical structures in which system, user, and control information is stored. The software that manages the database is called the Oracle database server. Collectively, the software that runs oracle and the physical database are called the Oracle database system.

What is Oracle DBA?

Oracle DBA is a job posisition title for person/team who is responsible for the environmental aspects of an oracle database. As an Oracle DBA, you can expect to be involved in the following tasks:

1. Installing Oracle software
2. Creating Oracle databases
3. Performing upgrades of the database and software to new release levels
4. Starting up and shutting down the database
5. Managing the database's storage structures
6. Managing users and security
7. Managing schema objects, such as tables, indexes, and views
8. Making database backups and performing recovery when necessary
9. Proactively monitoring the database's health and taking preventive or corrective action as required
10. Monitoring and tuning performance

In a small to midsize database environment, you might be the sole person performing these tasks. In large, enterprise environments, the job is often divided among several DBAs, each with their own area of specialty, such as the database security administrator or database tuning expert.

Tools for Administering the Database

The following are some of the products, tools, and utilities you can use in achieving your goals as a database administrator.

A. Oracle Universal Installer (OUI)

The Oracle Universal Installer installs your Oracle software and options. It can automatically launch the Database Configuration Assistant to install a database.

B. Database Configuration Assistant (DBCA)

The Database Configuration Assistant creates a database from templates that are Oracle supplied, or you can create your own. It enables you to copy a preconfigured seed database, thus saving the time and effort of customizing and generating a database from scratch.

C. Database Upgrade Assistant

This tools guides you through the upgrade of your existing database to a new Oracle release.

D. Oracle Net Manager

This tool guides you through your Oracle Net network configuration.

E. Oracle Enterprise Manager

The primary tool for managing your database is Oracle Enterprise Manager, a web-based interface. After you have installed the Oracle software, created or upgraded a database, and configured the network, you can use Oracle Enterprise Manager as the single interface for managing your database. In addition, Oracle Enterprise Manager also provides an interface for performance advisors and an interface for Oracle utilities such as SQL*Loader and Recovery Manager.

Hmm…m only that I can find and share now. I got all info above from Oracle® Database 2 Day DBA 10g Release 1 (10.1) Part Number B10742-02 and from wikipedia by asking uncle Google.

Getting started to say “Hello world…” with java

Now we already have JDK installed in our system. Before we get the party started, my lecturer says a short introduction about Java programming. He said that in the Java programming language, programs are built from classes. From a class definition, we can create any number of objects that are known as instances of that class. A class contains members, the primary kinds being fields and methods.

General format for java code:

import package;

class class_name

{

public static void main(String args[ ])

{

statement;

…………….;

…………….;

}

}

Example:

class HelloWorld

{

public static void main(String[] args)

{

System.out.println("Hello world…");

}

}

Use our favorite text editor to type this program source code above into a file. Attention!!! Java is a case sensitive language. Put the source for HelloWorld into a file named HelloWorld.java. Format for saving java source code: class_name.java. Open command prompt windows and go to our HelloWorld.java location. Then run the compiler to compile the source of this program.

To compile it type the command

javac HelloWorld.java

To run the program type the command

java HelloWorld

This executes the main method of HelloWorld. And ... WOW! I made it!

Hello world…

But what does the code mean?

The program declares a class called HelloWorld with a single member: a method called main. Class members appear between curly braces { and } following the class name.

The main method is a special method: the main method of a class, if declared exactly as shown, is executed when we run the class as an application. When run, a main method can create objects, evaluate expressions, invoke other methods, and do anything else needed to define an application's behavior.

The main method is declared public so that anyone can invoke it (in this case the Java virtual machine) and static, meaning that the method belongs to the class and is not associated with a particular instance of the class.

Preceding the method name is the return type of the method. The main method is declared void because it doesn't return a value and so has no return type.

In this example, the body of main contains a single statement that invokes the println method the semicolon ends the statement. A method is invoked by supplying an object reference (in this case System.out the out field of the System class) and a method name (println) separated by a dot (.).

HelloWorld uses the out object's println method to print a new line-terminated string on the standard output stream. The string printed is the string literal “Hello world…”

What if I don’t want to print a new line? Just replace println with print.

And the men say “congratulation!”

Say “Hello world…” with java (J2SE)

In the beginning of 2007 I just start to know java programming. Event only a quick tour, it was a valuable knowledge for me. What is java? How do I get it? How to install? How do I make “Hello world…” Appear in my computer. Those are the question in my mind.

After two hour sitting in a class room I got all the answers for those questions above. Java is a powerful programming language suitable for building a variety of applications that either do not depend on network features or want them for different reasons. With platform-independent ability, you can build in any platform and its runtime environment enables users to run compiled code anywhere and share code with anyone who has a Java runtime environment. Some common programming errors never occur because of features like garbage collection and type-safe references. Support for multithreading caters to modern network-based and graphical user interface based applications that must attend to multiple tasks simultaneously, and the mechanisms of exception handling ease the task of dealing with error conditions. While the built-in tools are powerful, it is a simple language in which programmers can quickly become proficient.

To built application using java, we have to install Java Development Kit (JDK) into your machine. When I start to java, JDK has reach version 2 (Java 2 Platform). Java 2 platform has three categories:

1. Java 2 Standard Edition (J2SE)

Used to develop and run PC base applications.

2. Java 2 Enterprise Edition (J2EE)

This category use to develop and run java applications in enterprise environment. It has Servlet, Java Server Page (JSP) and other functions.

3. Java 2 Micro Edition (J2ME)

This one use to develop and run java applications for handheld devices such as: Personal Data Assistant (PDA), Mobile Phone and Pocked PC.

In case we use operating system Microsoft Windows XP. We need to install JDK by download it from Sun Microsystem web site. After installation process finished, we have to modify Autoexec.bat file to set PATH and CLASSPATH. File Autoexec.bat common location is in drive c:\. Open it and type:

SET PATH = c:\j2sdk\bin;%PATH%

SET CLASSPATH = . ; c:\j2sdk;%CLASSPATH%

In example I install JDK version 1.4.2 (last time I check a new version than 1.4.2 is available) to drive C and JDK folder name I change from j2sdk.1.4.2_03 to j2sdk. Than save modification. At this point I ask a question to my mentor, what does it mean? The man who stand in front say that SET PATH will point to a drive and directory where java.exe, javac.exe and javadoc.exe location. And SET CLASSPATH will say to compiler where library class location is. If we didn’t change Autoexec.bat, we have to call java.exe, javac.exe, etc directly from it original location (c:\j2sdk\bin). By doing a little modification, we can call java.exe, javac.exe, etc from any directory in command prompt.

For how-to installing java in Ubuntu operating system available at id-ubuntu (lang: Bahasa Indonesia)

Now we already have JDK in our operating system and we are ready to develop java application on next posting.

Air Mendidih

Seorang anak mengeluh pada ayahnya mengenai kehidupannya dan menanyakan mengapa hidup ini terasa begitu berat baginya. Ia tidak tahu bagaimana menghadapinya dan hampir menyerah. Ia sudah lelah untuk berjuang. Sepertinya setiap kali satu masalah selesai, timbul masalah baru.

Ayahnya, seorang koki, membawanya ke dapur. Iamengisi 3 panci dengan air dan menaruhnya di atas api. Setelah air di panci-panci tersebut mendidih. Ia menaruh wortel di dalam panci pertama, telur di panci kedua dan ia menaruh kopi bubuk di panci terakhir. Ia membiarkannya mendidih tanpa berkata-kata. Si anak membungkam dan menunggu dengan tidak sabar, memikirkan apa yang sedang dikerjakan sang ayah. Setelah 20 menit, sang ayah mematikan api. Ia menyisihkan wortel dan menaruhnya di mangkuk, mengangkat telur dan meletakkannya di mangkuk yang lain, dan menuangkan kopi di mangkuk lainnya. Lalu ia bertanya kepada anaknya, "Apa yang kau lihat, nak?" "Wortel, telur, dan kopi" jawab si anak. Ayahnya mengajaknya mendekat dan memintanya merasakan wortel itu. Ia melakukannya dan merasakan bahwa wortel itu terasa lunak. Ayahnya lalu memintanya mengambil telur dan memecahkannya. Setelah membuang kulitnya, ia mendapati sebuah telur rebus yang mengeras. Terakhir, ayahnya memintanya untuk mencicipi kopi. Ia tersenyum ketika mencicipi kopi dengan aromanya yang khas. Setelah itu, si anak bertanya, "Apa arti semua ini, Ayah?" Ayahnya menerangkan bahwa ketiganya telah menghadapi kesulitan yang sama, perebusan, tetapi masing-masing menunjukkan reaksi yang berbeda.

Wortel sebelum direbus kuat, keras dan sukar dipatahkan. Tetapi setelah direbus, wortel menjadi lembut dan lunak. Telur sebelumnya mudah pecah. Cangkang tipisnya melindungi isinya yang berupa cairan. Tetapi setelah direbus, isinya menjadi keras. Bubuk kopi mengalami perubahan yang unik. Setelah berada di dalam rebusan air, bubuk kopi merubah air tersebut. "Kamu termasuk yang mana?," tanya ayahnya. "Ketika kesulitan mendatangimu, bagaimana kau menghadapinya? Apakah kamu wortel, telur atau kopi?" Bagaimana dengan kamu?

Apakah kamu adalah wortel yang kelihatannya keras, tapi dengan adanya penderitaan dan kesulitan, kamu menyerah, menjadi lunak dan kehilangan kekuatanmu.

Apakah kamu adalah telur, yang awalnya memiliki hati lembut? Dengan jiwa yang dinamis, namun setelah adanya kematian, patah hati, perceraian atau pemecatan menjadi keras dan kaku. Dari luar kelihatan sama, tetapi apakah kamu menjadi pahit dan keras dengan jiwa dan hati yang kaku?

Ataukah kamu adalah bubuk kopi? Bubuk kopi merubah air panas, sesuatu yang menimbulkan kesakitan, untuk mencapai rasanya yang maksimal pada suhu 100 derajat Celcius. Ketika air mencapai suhu terpanas, kopi terasa semakin nikmat. Jika kamu seperti bubuk kopi, ketika keadaan menjadi semakin buruk, kamu akan menjadi semakin baik dan membuat keadaan di sekitarmu juga membaik.
Sumber: pondokrenungan

Hello World…

This first post about page has “Hello World…” as title. I chose it because that the most common words to announce the first thing had been made (usually in programming). And here I use it too, off course to announcing that my first blog has born to day (Saturday, July 7, 2007). Lucky number 7 isn’t it. This blog will use two different languages: Indonesian and English. Because I am Indonesia citizen and came from Minangkabau ethnic that start learning English.

My name is Gema Fatra. I was born on July, 1983 in Padang, West Sumatra, Indonesia. I call this blog gegem'studio. Gegem is my nick name when I am a college student; it doesn’t mean and don’t have a connection with a woredas in the oromia region of Ethiopia. An excerpt from wikipedia about gegem:

Gegem is one of the 180 woredas in the Oromia Region of Ethiopia. Part of the Semien Shewa Zone, Gegem is bordered on the south by the Muger River which separates it from the Misraq Welega Zone, on the west by Kuyu, on the northwest by Hidabu Abote, on the north by the Jimma River which separates it from the Amhara Region, on the northeast by Gerar Jarso, and on the east by Yaya Gulelena Debre Liban. Towns in Gegem include Alidoro and Anbiso.

I am a freelance programmer. My specialist is visual basic programming (not certify yet). Now I made my move to self learning about Bussiness Inteligent, .NET, SSIS and SSAS. Here I’ll share to you what I read, learn and experiences not just about computer but anything.

If you like this blog please stay in touch with what gegem’studio is up trough one of our subscription methods; subscribe in a reader or subscribe by e-mail.

I hope you enjoy gegem'studio and sorry for my terrible English. :)