Looking for a Tutor Near You?

Post Learning Requirement »
x

Choose Country Code

x

Direction

x

Ask a Question

x

x
x
For better view click here
x
Hire a Tutor
DISCOVER

ORACLE PLSQL - PL/SQL - Setup

Loading...

Published in: Oracle Training
968 Views

This document provides the Environment Setup of PL/SQL.

Debarun S / Kolkata

10 years of teaching experience

Qualification: B.Tech

Teaches: Computer, Mathematics, Science, Chemistry, Computer Science, Physics, School Level Computer, Defence Exams, IBPS, Insurance Exams, SSC Exams

Contact this Tutor
  1. In this chapter, we will discuss the Environment Setup of PL/SQL. PL/SQL is not a standalone programming language; it is a tool within the Oracle programming environment. SQL* Plus is an interactive tool that allows you to type SQL and PL/SQL statements at the command prompt. These commands are then sent to the database for processing. Once the statements are processed, the results are sent back and displayed on screen. To run PL/SQL programs, you should have the Oracle RDBMS Server installed in your machine. This will take care of the execution of the SQL commands. The most recent version of Oracle RDBMS is 1 lg. You can download a trial version of Oracle 1 lg from the following link Download Oracle 1 lg Express Edition You will have to download either the 32-bit or the 64-bit version of the installation as per your operating system. Usually there are two files. We have downloaded the 64-bit version. You will also use similar steps on your operating system, does not matter if it is Linux or Solaris. • win64_11gR2_database_10f2.zip • win64_11gR2_database_20f2.zip After downloading the above two files, you will need to unzip them in a single directory database and under that you will find the following sub-directories doc install response stage setup E) welcome Step 1 3/24/2010 12:15 AM 3/30/2010 8:05 AM 3/30/2010 9:31 AM 3/30/2010 9:31 AM 3/12/2010 1:11 AM 3/16/2010 1:42 PM File folder File folder File folder File folder Application HTML Document 334 KB Let us now launch the Oracle Database Installer using the setup file. Following is the first screen. You can provide your email ID and check the checkbox as shown in the following screenshot. Click the Next button.
  2. Ootabase 29 2 • Installing • Step of 9 Configure Security Updates Provøe yo..r Od&ess to be ot secuty the vocixt connoute ORACLE g DATABASE it use My 9.090d to tee-eve sect.'ty My C•ock S..øyt. My text Step 2 You will be directed to the following screen; uncheck the checkbox and click the Continue button to proceed. Connection Failed Specify proxy server information. Proxy Server: PrQXY Port: 80 Proxy Username: Proxy Password: I want to remain uninformed of critical security issues in my configuration. Step 3 Just select the first option Create and Configure Database using the radio button and click the Next button to proceed.
  3. Cr.cie Ootabase 119 Release 2 • Ine,talling databa•.e • Step 2 of 9 11 g Select Installation Option DATABASE UvstO•tion Option Step 4 my of coofø•e a o O existro Vext We assume you are installing Oracle for the basic purpose of learning and that you are installing it on your PC or Laptop. Thus, select the Desktop Class option and click the Next button to proceed.
  4. Crule Oatabase 119 Re'ea;e 2 • Installing databa•.e • Step 3 of 8 11 g System Class DATABASE @ Chas Class Crone tt•is it you ye a roxies o ttyter conto.N•cvv tri' it •e on system, use Crack toe more t±ext Step 5 Provide a location, where you will install the Oracle Server. Just modify the Oracle Base and the other locations will set automatically. You will also have to provide a password; this will be used by the system DBA. Once you provide the required information, click the Next button to proceed.
  5. Cr.cie Ootabase 119 Release 2 • Ine,talling databa•.e • Step 4 of 8 11 g Typical Install Configuration DATABASE Pert«ym wth basic tWcai É.staue•n Step 6 Crack baae Sonwye woose bcÜct Edtjcn (3 340B) 242) Vext Again, click the Next button to proceed.
  6. Database 119 P.&ase 2 • Installing databa•.e • Step 5 of 8 Perform Prerequisite Checks Veityrg meets sekcted. ms cm toe PÉo:e Prerequisite Checks Step 7 ormcl.-e• g DATABASE Click the Finish button to proceed; this will start the actual server installation.
  7. Otecfe Oat&baze P.eka;e 2 • InstalliP9 database • Step 6 of 8 11 g Summary DATABASE 110 R.&a.e 2 334 9 $5 bate GObS (50) 1558 Reepy•se Eh. w Cmcd Step 8 This will take a few moments, until Oracle starts performing the required configuration.
  8. Cr.cie Ootabase 119 Release 2 • Ine,talling databa•.e • Step 7 of 8 11 g Install Product Product Step 9 to t 2 • Copy Croc* Maximum Avadabiüty DATABASE Oiminat• Here, Oracle installation will copy the required configuration files. This should take a moment
  9. (0 Database Configuration Assistant Higher Availability • Rolling upgrades with Physical Standby • Reel-time reporting with Physical Standby Hot patchinøc Step 10 •e Copying database files Creating and starting Oracle instance Completing Database Creation Clone database creation in progress Log files for the current operation are located at: CIOracleicfgtoollogsidbcaiorcl Stop Once the database files are copied, you will have the following dialogue box. Just click the OK button and come out.
  10. Database Configuration Assistant Database creation complete. For details check the logfiles at: I C:lOraclelcfgtoollogsldbcalorcl. Database Information: Global Database Name: System Identifier(SlD): orcl orcl Server Parameter File name: fhe Database Control URL is https•Jlocalhost:11 581em Management Repository has been placed in secure mode wherein Enterprise Manager data will be encrypted. The encryption key has been placed in the file: C:fOraclefproducV11. Please ensure this file is backed up as the encrypted data will become unusable ifthis file is lost. Note: All database accounts except SYS, SYSTEM, DBSNMP, and SYSMAN are locked. Select the Password Management button to view a complete list of locked accounts or to manage the database accounts (except DBSNMP and SYSMAN). From the Password Management window, unlock only the accounts you will use. Oracle Corporation strongly recommends changing the default passwords immediately after unlocking the account. Password Management.. OK Step 11 Upon installation, you will have the following final window.
  11. Cr.cie Ootabase 119 Release 2 • Ine,talling databa•.e • Step 8 of 8 11 g Finish DATABASE of Croce was Cortrcl - («c:f) ; t t S8Ém Finish Final Step It is now time to verify your installation. At the command prompt, use the following command if you are using Windows sq I plus "/ as sysdba " You should have the SQL prompt where you will write your PL/SQL commands and scripts
  12. Administrator: - sqlplus as sysdba• Nicrosoft Windows tUers ion 6.1.?601 Copyright (c) 2009 Microsoft Corporation . All rights reserved. C: NtJsersNZARA>sq1p1us as sysdba•• Release 11.2.Ø.1.ø Production on Fri Aug 31 2012 Copyright (c) 1982. 2ØiØ* Oracle All rights reserved. Connected to: Oracle Database 11 Enter rise Edition Release ii.2.Ø.i.Ø 64bit Producti With the Partition!ng, OL\P, Data Mining and Real Application Testing opti SQL> Text Editor Running large programs from the command prompt may land you in inadvertently losing some of the work. It is always recommended to use the command files. To use the command files Type your code in a text editor, like Notepad, Notepad+, or EditPlus, etc. Save the file with the .sql extension in the home directory. Launch the SQL*Plus command prompt from the directory where you created your PL/SQL file. Type @file_name at the SQL* Plus command prompt to execute your program. If you are not using a file to execute the PL/SQL scripts, then simply copy your PL/SQL code and right-click on the black window that displays the SQL prompt; use the paste option to paste the complete code at the command prompt. Finally, just press Enter to execute the code, if it is not already executed.

Need a Tutor or Coaching Class?

Post an enquiry and get instant responses from qualified and experienced tutors.

Post Requirement

Related Study Notes

Upload Study Notes

If you have your own Study Notes which you think can benefit others, please upload on LearnPick. For each approved Study Note you will get 100 Credit Points and 100 Activity Score which will increase your profile visibility.

Upload Now
Home > Study Notes > ORACLE PLSQL - PL/SQL - Setup