Oracle environment configure and test

Certify and Increase Opportunity.
Be
Govt. Certified PL SQL Developer

A PL/SQL environment, requires the following components:

• Database server: A running  Oracle database. Oracle runs in many popular computer environments. The most commonly used with Oracle are UNIX, Linux, or some version of Microsoft Windows.
• PL/SQL usually runs on the database server. But Oracle also has a number of products that can use PL/SQL (Forms Developer 10g, Reports Developer 10g, and so on).
• Database Management system (DBMS): This is the Oracle software itself. This software is installed on the database server. You must have this installed prior to creating a database.
• Database: A database is primarily a set of tables and data that constitute the persistent (permanent) information for your system. You will also store many other things in the database such as code, indexes (to help queries run faster), and so on. Most of the interesting things you can do with a database (for example, Java classes, snapshots, and links to other databases) are beyond the scope of this book.
• When you install the database software, Oracle gives you the option of installing a sample database. If you take advantage of this option, it can help you get started.
• Application server: This is the computer where your application code is stored and executed. Now that most application development is done for the Web, you need a place to store and execute these programs. Those programs are usually executed on an application server. They can also be run on any common operating system, but are usually run on Microsoft Windows or UNIX.
• Application server software: To make applications work on an application server, you need special software to manage and run those programs. The most commonly used products are Orion and Apache. In an Oracle environment, you often see Oracle’s own application server, called Internet Application Server (IAS), which is an extension of the Orion server software.
• Client computer and software: Batch routines are usually run directly on the database server, but client programs are run from a PC. Web applications are run on an Internet browser, and client/server programs execute directly on the client PC. Web applications mainly run on the application server and present the screen output to the client machine only through the browser.
• Network: The database server, application server and client computers have to be able to talk to each other through some kind of network or over the Internet.

If you’re setting up an environment just to figure out how PL/SQL works, you at least need access to a database server and a client PC. If you’re trying to learn from home, you can put everything on the same computer. (This assumes that you have a fairly powerful PC.)