Introduction In this content, you'll learn how to downIoad, install, and arranged up an Oracle database, therefore that you can begin running SQL queries on your personal pc. Why perform you require these directions?
Developer Downloads. All software downloads are free, and most come with a Developer License that allows you to use full versions of the products at no charge while developing and prototyping your applications, or for strictly self-educational purposes. How to Install Oracle Database 12c. If you're looking to install the Oracle Database 12c, start from step 1, below. Download Oracle Database 12c from the official website. The FlashStack Data Center with Oracle RAC database on Oracle Linux solution provides an end-to-end architecture with Cisco, Oracle, and Pure Storage technologies and demonstrates the FlashStack configuration benefits for running highly available Oracle RAC Database 12c R2 with Cisco VICs (Virtual Interface Cards). So if you want to set up Oracle on your Mac computer, you’ll love this guide. Let’s get right into it. Overall Process. Installing an Oracle database on a Mac computer is a bit different to installing it on a Windows or Linux computer. Oracle doesn’t support running an Oracle database directly on a Mac computer.
Isn'capital t it simply as easy as download, install, and run? Properly, it's not really that right ahead when setting up up an Oracle database. Even if you're also using Oracle Show, which is usually Oracle's edition of their databasé that you cán make use of yourself and the one that I'michael detailing in this information.
There are usually a several factors to watch out fór - which I'Il cover up. Furthermore, Oracle'h website can end up being very confusing. Specifically if you've never ever down loaded anything from generally there before. So, with these instructions, you should end up being capable to obtain Oracle Express running on your personal computer without as well much difficulty. At the period of composing, you can operate Oracle on Windows and Linux devices. There will be no Mac pc version accessible.
How to Download and Set Up Oracle Express 11g. Select 'Oracle Database 11g Express. This is because while you can't install the Oracle database on a Mac. Oracle 11g for mac free download - Apple Mac OS Update 8.6, Apple Mac OS Update 9.0.4, Apple DVD Player Update, and many more programs. Oracle Database 12c download. full free Crack: Oracle Database 12c Download (Oracle Database XE) is a small entry-level database based on Oracle Database 11g Release 2. Oracle 11g free download. SQLTools for Oracle SQLTools is a light weight and robust frontend for Oracle database development. This program is not.
The only method that I understand of to operate Oracle on a Macintosh can be to use a digital machine like as ParaIlels, but ás it's i9000 not really something I've performed, I received't consist of the methods here. Summary The steps we will protect in this tutorial are:. Download and install Oracle client (or Oracle Show, which is definitely the real database). Download and set up Coffee JDK (which is certainly required to operate the development tool). Download and install SQL Developer (which is definitely used to operate SQL concerns). Create a link in SQL Designer (to permit you to run concerns on your set up Oracle database) I gained't be covering how to understand SQL in this write-up, but that would become the following stage to get, if you wear't understand SQL.
Browse Downloads by Product. Java download for mac os x 10.4 11.
Allow's obtain started! Phase 1 - Download Oracle Customer (Oracle Show) The initial step is definitely to download the Oracle customer. This is the real database software program that runs and manages the database. Oracle Express can be a version produced by Oracle thát you can downIoad for free of charge for your own make use of. It will possess some limitations, but it should become more than enough for your own schooling and smaller sized projects.
To begin with, go to the Oracle internet site. Hover over the Downloads menu product at the top of the web page. Choose ' Oracle Database 11g Express Edition'. The download web page will appear. To be capable to download the hyperlink, you'll want to acknowledge the license agreement.
Read that by clicking on the hyperlink, and after that click Accept License Agreement. Select the relevant download for your operating program. If you're also working a 64-bit edition of Home windows, choose the 'Oracle Data source Express Copy 11g Launch 2 for Home windows back button64' document. If you're working a 32-bit edition of Windows, choose the 'Oracle Data source Express Edition 11g Launch 2 for Windows x32' file. If you're also operating Linux, then select the 'Oracle Data source Express Version 11g Discharge 2 for Linux times64' document. If you're not sure which version of Home windows you're running, move to the Begin button, right click on My Computer, and go for Attributes.
This will provide up the Program screen in the Control panel. You can furthermore right click on My Computer within Home windows Explorer and select Qualities to obtain to the exact same display.
In the middle of the display, you'll notice a Program Type tag, and following to it will say either 32-bit or 64-bit Operating Program. Once you click on the correct edition of the Oracle download file, you'll be motivated with a Sign in screen. If you possess an accounts, then get into your details.
If you wear't possess an account (which, if you're also setting up Oracle for the first period, you most likely wear't), click Create Accounts on the ideal. Fill out your details and click Create Account at the bottom level. You don't need to verify the 'Okay, send me emaiIs on Oracle Próducts, Services and Evénts' if you dón't want tó. Once you have got your accounts made, you should be presented with the file download box.
If not, you can record in with your new account details and stick to the tips above to move back again to the download hyperlink. Save the file (which is definitely called 'OracleXE112Win64' or equivalent. This can be the archive document that you draw out and install from. The file will then be downloaded. Now, we require to extract and install the file. Phase 2 - Install Oracle Express To set up Oracle Express from the downloaded file, proceed to the location where you've down loaded it.
Get the document to a place of your option. The procedure for doing this will rely on what acrhive plan you use (7zip, WinZip, WinRAR), but usually you begin by openning the Diddly file. Choose a area to get it to on your difficult travel, and click on Extract. As soon as the remove has finished, proceed to the place you removed to. Open up the Disc1 folder and run set up.exe It should end up being the just document in the foIder. An installer sorcerer will appear up and begin preparing.
Once it has prepared, click on Next. Read and acknowledge the Terms and Problems. On the Choose Destination Location page, guarantee you possess enough space to set up it to the default location. You put on't need to alter the place, but if you want to, you can here. Usually, click Next.
Today, this is usually an essential step. Here, you identify the database password, to end up being used for two system accounts - SYS and SYSTEM. You should choose a safe password, and one thát you'll rémember. You'll want to enter this password afterwards in this process when you log in to thé Oracle database - therefore don't overlook it. Enter the password double, and click Next. Click Install on the last display screen.
The set up will consider a several minutes. As soon as it's completed, click the Finish switch. Phase 3 - Download JDK The following step is usually to download thé JDK or Java JDK as it'h also recognized. JDK stands for Java Development Kit, and you'll need to operate SQL Designer, which is definitely the tool used to run SQL inquiries that we'll be installing next. To install the JDK, proceed back again to the Oracle web site.
Hover over the Downloads menu item and click Java for Designers. On the Coffee SE Downloads web page, click on the Java Platform JDK key. It should be the one on the left. Once once again, you'll need to learn and accept the license contract to continue. If you don't accept, a message will put up when you test to download the file and prvent yóu from downloading.
Aftér you've performed that, choose the right version for your operating system. Focus on the ' Coffee SE Development Package' area, not really on the 2nd section (which provides sample downloads that you put on't want). If you're running Home windows, you should select either the 32 little bit or 64 bit version. If you're also operating Linux, you possess several options here as well. Once you click on the hyperlink, you'll be asked to save the document.
Conserve it to your personal computer. Action 4 - Install the JDK Right now that you've downloaded the document, the following part is definitely to install it. This is definitely pretty straight ahead, but I'll run through the methods anyway. Open the JDK document you downloaded above. If a security warning seems, click Run. On the pleasant screen, click on Next. On the Functions page, click on Next simply because well.
The default settings are usually OK. The JDK will now be set up. This stage can take a few of mins as nicely.
As soon as that has finished, another set up route may be asked for for the JRE. This is definitely the Java Runtime Atmosphere, which can be another component of Coffee you'll need. Click Next on this display. The following component will after that be installed, which may consider a couple of moments. Once the set up has finished, click Close. Action 5 - Download Oracle SQL Builder Alright, we're right now up to the last piece of software program to download.
SQL Developer is definitely a tool developed by Oracle that enables you write SQL questions against the 0racle database. To downIoad it, move back again to the Oracle web site. Hover over the Downloads menu product and click SQL Builder. Once once again, you'll want to go through and acknowledge the license agreement to move forward. Select the appropriate file based on your operating system. You might notice that there is a Mac pc version shown here, even though Oracle is certainly not obtainable for Mac pc.
This can be because while yóu can't install the Oracle database on a Mac, you can still operate SQL Creator to link to directories on other computers or web servers using other operating techniques. It's not restricted to simply linking to your very own computer. Once you click on the document you need, choose a area for the file and click Save. Stage 6 - Fixed Up Oracle SQL Programmer After the SQL Programmer file offers finished downloading, open the file.
This action is various to the previous measures as you put on't need to set up SQL Developer, you simply need to unzip and operate it. So, now you've opened up the document, extract it to the area you would like. This can be where the file will become operate from, so you may want to remove it to Plan Data files or something to end up being consistent. As soon as it provides extracted, proceed to the foIder that you removed it to. Run ' sqldeveloper.exe'.
The system will inquire for the route to coffee.exe. This will be something you set up earlier in the procedure. To discover the path, click on Search, and go to the location it had been set up to. The location will be something like this: C: Plan Files Java jdk1.7.025 bin When you're in the right folder, the java.exe document should end up being visible. Click on on that to select it and click Okay. You might obtain a message saying that the Java version is usually not qualified. This can be usually due to the truth that the SQL Builder has not been up to date to match the most recent Java edition.
I've become this information before and had no troubles with making use of SQL Creator, therefore if you get it, simply click Yes to proceed. SQL Creator will then begin. The Document Type Associations dialog box will appear. You put on't need to choose any of thése, but if yóu wish to have these file types open in SQL Designer, then examine the containers.
SQL Creator is now set up and prepared to move. The last step is certainly to set up a link to your database.
Phase 7 - Produce a Connection in Oracle SQL Creator You've obtained SQL Programmer running, mainly because properly as your Oracle database. Today you just need to connect the two. Click on the natural plus icon on the top still left of the screen, under the Cable connections tabs in the sidébar. The New Database Connection window will appear.
Enter the following details into the home window: Link Name: Something that you can determine it. I generally use 'Regional' Username: program Password: The security password you joined during the install procedure (ideally you appreciated it!) Save Password: Checked Link Kind: Basic Part: Default Hostname: localhost Interface: 1521 SID: xe Once you've came into that info, click Test. The Status in the bottom level remaining should say Achievement. If it doesn't, ensure you've inserted the right details, and have Oracle running.
If it still doesn't function, restart your computer and try out again. Once the check is successful, click Connect. A link called Local (or whatever you called it) will show up in the sidébar, and a new SQL home window will appear in the main section. This is certainly where you enter your queries. To check it, enter a example question. You can test this one: SELECT ' A' FROM DUAL; Press N9, or click on on the natural Have fun with triangle in the home window, to run the concern.
The result will show up at the underside of the screen. You have got now installed Oracle Express and Oracle SQL Designer on your computer! Right now it's prepared to be utilized for your SQL concerns. Background 11/4/15 - Preliminary version.
Oracle Data source 12c Download Total Free Break: Oracle Data source 12c Download (Oracle Database XE) is definitely a little entry-level database centered on Oracle Database 11g Discharge 2. It is usually free of charge to create, set up and disperse; quick to download; and easy to administer With Oracle Data source 12c Split, you can now create and deploy programs with a confirmed high-performance infrastructure and, if essential, improve without complex and costly migrations. Oracle Data source 12c Serial Key can become set up on any CPU dimension (a database by personal computer), but XE stores up to 11 Gigabyte of consumer data, utilizes up to 1 GB of memory space and utilizes a web host computer processor chip.
Oracle Data source 12c Discharge 2 Evaluation: Oracle Data source Download will be a helpful and effective database designed to supply sources to develop, apply and deploy applications. The advancement and administration of directories are actions that are usually for experts. And for like tasks, professionals require a effective tool, such as Oracle Database 12c Total Break, which focuses on producing and directories and associated applications.
Oracle Database 12c Download for linux provides an intuitive user that allows the consumer to notice the status of the storage currently used, the database ánd the startup settings. To create the items in the database, a user is set up and set up. It is usually a job that is certainly performed from the control collection. In general, Oracle Download For home windows 7 will be a really specialized benchmark tool.You can furthermore download here. Oracle Database XE can be an fantastic begin database for:.
Programmers work on Node.js, Python, Java,NET, XML and open up source programs. Database managers who require a free of charge database for training and execution. Independent software program vendors (ISV) and hardware suppliers who want to share a free-bóot database. Educational organizations and college students who require a free database for their study program Key Functions of Oracle Database 12c: These are usually some of the great functions you will find after downloading Oracle Data source 12c Launch 2 for free of charge. The practical and effective database created to enable the co-development, distribution, and execution of programs. Have an intuitive user interface. It enables you to see the present status of the storage, the initialization settings, and the database classes.
System specifications for Oracle Database 12c Launch 2: Before starting Oracle Data source 12c Release 2, make certain your personal computer fulfills the minimal system requirements. Operating program: Windows XP / Vista / 7/8 / 8.1 / 10. Memory (RAM): 1 Gigabyte of Memory is required. Area on the difficult storage: 400 MB of free of charge space is usually required.
Processor: Intel dual-core processor chip or increased. How to DownIoad and Install?. DownIoad and Install thé Programme. Wear't run again if the setup is running.
After the installation run the break setup for a full version. Down load link is here.
Data source Oracle Database Online Paperwork 11 gary the gadget guy Launch 2 (11.2) Installing and Upgrading Installation manuals for Oracle Database 11 gary the gadget guy and accompanying items on numerous platforms are collected right here. Full Set up Guides describe a wider range of situations with more detail.
Customer Installation Instructions describe installing Oracle database customer software on owners where the database server is not installed. Supplementary Set up Guides describe installing items that are incorporated with the database but installed separately.
During a complete installation of your Oracle Database, the sample schemas can be installed automatically with the seed database. If the seed database is removed from the system, you will need to reinstall the sample schemas before you can perform the steps given in the examples that you find in Oracle documentation and training materials.
This chapter describes how to install Product_Name. It contains the following sections:
Caution:
By installing any of the Oracle Database sample schemas, you will destroy any previously installed schemas that use any of the following user names:HR, OE, PM, SH, IX, BI.Data contained in any of these schemas will be lost if you run any of the installation scripts described in this section. You should not use the sample schemas for your personal or business data and applications. They are meant to be used for demonstration purposes only.
Using the Database Configuration Assistant
When you install Oracle Database with the Oracle Universal Installer, the sample schemas are installed by default if you select the Basic Installation option. Selecting the sample schemas option installs all sample schemas (HR, OE, PM, SH, IX) in the database. If you choose not to install the sample schemas at that time, you can add them later by following the instructions in section 'Manually Installing Sample Schemas'.
At the end of the installation process, a dialog box displays the accounts that have been created and their lock status. By default, all sample schemas are locked and their passwords are expired. Before you can use a locked account, you must unlock it and reset its password. You can unlock the accounts at this point in the installation process. Alternatively, after the installation completes, you can unlock the schemas and reset their passwords by using the ALTER USER ... ACCOUNT UNLOCK statement. For example:
See Also:
'Guidelines for Securing Passwords' in Oracle Database Security Guide for guidelines related to creating secure passwordsThe sample schemas available to you depend on the edition of Oracle Database that you have installed and its configuration. Refer to the following table:
| Schema | Oracle Database Personal edition | Oracle Database Standard edition | Oracle Database Enterprise edition |
|---|---|---|---|
HR | OK | OK | OK |
OE | OK | OK | OK |
PM | OK | OK | OK |
IX | OK | OK | OK |
SH | Not available | Not available | Needs Partitioning Option installed |
Manually Installing Sample Schemas
If you decide not to install the sample schemas at the time of your initial database installation using DBCA, then you can also create the sample schemas manually by running SQL scripts. Install Oracle Database Examples (Companion CD, part of the media kit) to include these scripts in the demo directory under $ORACLE_HOME.
See Also:
Oracle Database Examples Installation Guide
for download and installation informationSchema Dependencies
Various dependencies have been established among the schemas. So, when you create the schemas manually, you must create them in the following order: HR, OE, PM, IX, and SH.
Use this sequence to create the schemas:
Create schema
HR.Create schema
OE. SchemaHRis already present, and you must know the password for schemaHRto grantHRobject privileges toOE. SomeHRtables are visible to userOEwith the use of private synonyms. In addition, someOEtables have foreign key relationships toHRtables.Create schema
PM: Foreign key relationships require that schemaOEalready exist when schemaPMis created. You must know the password forOE,to grant toPMthe right to establish and use these foreign keys.Note:
SchemaPMrequires that the database be enabled for the Java Virtual Machine (JVM) and interMedia. You can accomplish this during installation or later using the DBCA.Create schema
IX: The information exchange schema,IX, is based on order entry data in schemaOE. Again, foreign key relationships require that schemaOEalready be present when schemaIXis created. You must know the password forOEto grant toIX, the right to establish and use the foreign keys.Create schema
SH. SchemaSHlogically depends on schemaOE, but you can create schemaSHwithout creating the other four schemas.
Guidelines for Installing Sample Schemas
All scripts necessary to install sample schemas reside in $ORACLE_HOME/demo/schema directory. Before you install sample schemas by running these scripts, follow these guidelines:
You must connect as a system administrator using the
SYSDBAprivilege.When prompted to enter a password for the schema, enter a secure password that meets the requirements described in Oracle Database Security Guide.
When prompted for tablespace names while running scripts:
Enter an appropriate tablespace name, for example,
usersas the default tablespace for a schemaEnter
tempas the temporary tablespace for a schema
When prompted for the log directory name, enter
$ORACLE_HOME/demo/schema/log/or any other existing directory name.
Note:
Make sure that you end the log directory name with a trailing slash, for example,$ORACLE_HOME/demo/schema/log/Installing the HR Schema
All scripts necessary to create the Human Resource (HR) schema reside in $ORACLE_HOME/demo/schema/human_resources.
You need to call only one script, hr_main.sql, to create all the objects and load the data. The following steps provide a summary of the installation process:
Log on to SQL*Plus as
SYSandconnectusing theAS SYSDBAprivilege.To run the
hr_main.sqlscript, use the following command:Enter a secure password for
HRSee Also:
Oracle Database Security Guide for the minimum password requirementsEnter an appropriate tablespace, for example,
usersas the default tablespace forHREnter
tempas the temporary tablespace forHREnter your
SYSpasswordEnter the directory path, for example,
$ORACLE_HOME/demo/schema/log/, for your log directory
After script hr_main.sql runs successfully and schema HR is installed, you are connected as user HR. To verify that the schema was created, use the following command:
Running hr_main.sql accomplishes the following tasks:
Removes any previously installed
HRschemaCreates user
HRand grants the necessary privilegesConnects as
HRCalls the scripts that create and populate the schema objects
For a complete listing of the scripts and their functions, refer to Table 4-1.
A pair of optional scripts, hr_dn_c.sql and hr_dn_d.sql, is provided as a schema extension. To prepare schema HR for use with the directory capabilities of Oracle Internet Directory, run the hr_dn_c.sql script. If you want to return to the initial setup of schema HR, use script hr_dn_d.sql to undo the effects of script hr_dn_c.sql.
You can use script hr_drop.sql to drop schema HR.
Installing Schema OE and Subschema OC
All scripts necessary to create the Order Entry (OE) schema and its Online Catalog (OC) subschema reside in $ORACLE_HOME/demo/schema/order_entry.
See Also:
Guidelines for Installing Sample Schemas before you run oe_main.sqlYou need to call only one script, oe_main.sql, to create all the objects and load the data. Running oe_main.sql accomplishes the following tasks:
Removes any previously installed
OEschemaCreates schema (user)
OEand grants it the necessary privilegesConnects as
OECalls the scripts that create and populate the schema objects
After the oe_main.sql script runs successfully and schema OE is installed, you are connected as user OE. To verify that the schema was created, use the following command:
For a complete listing of the scripts and their functions, refer to Table 4-10.
You can use scripts oe_drop.sql and oc_drop.sql to drop schema OE and subschema OC, respectively.
Installing the PM Schema
All scripts necessary to create the Product Media (PM) schema reside in $ORACLE_HOME/demo/schema/product_media.
See Also:
Guidelines for Installing Sample Schemas before you runpm_main.sqlYou need to call only one script, pm_main.sql, to create all the objects and load the data. Running pm_main.sql accomplishes the following tasks:
Prompts for passwords and tablespace names used within the scripts as well as datafile and log file directories
Removes any previously installed
PMschemaCreates user
PMand grants it the necessary privilegesConnects as
PMCalls the scripts that create and populate the schema objects
After script pm_main.sql runs successfully and schema PM is installed, you are connected as user PM. To verify that the schema was created, use the following command:
Oracle 12c Create New Database
For a complete listing of the scripts and their functions, refer to Table 4-19 .
You can use script pm_drop.sql to drop schema PM.
Note:
The SQL*Loader data filepm_p_lob.dat contains hard-coded absolute path names that have been set during installation. Before attempting to load the data in a different environment, you should first edit the path names in this file.Installing the IX Schema
All scripts necessary to create the Information Exchange (IX) schema reside in $ORACLE_HOME/demo/schema/info_exchange.
See Also:
Guidelines for Installing Sample Schemas before you runix_main.sqlTo install schema IX, you need to call only one script, ix_main.sql, which creates all the objects and loads the data.
Running ix_main.sql accomplishes the following tasks:
Prompts for passwords and tablespace names used within the scripts
Removes any previously installed
IXschemaCreates user
IXand grants the necessary privilegesConnects as
IXCalls the scripts that create and populate the schema objects
After the ix_main.sql script runs successfully and schema IX is installed, you are connected as user IX. To verify that the schema was created, use the following command:
For a complete listing of the scripts and their functions, refer to Table 4-23.
You can use script dix_v3.sql to drop schema IX.
How To Download Oracle 12c
Installing the SH Schema
All scripts necessary to create the Sales History (SH) schema reside in $ORACLE_HOME/demo/schema/sales_history.
See Also:
Guidelines for Installing Sample Schemas before you runsh_main.sqlYou need to call only one script, sh_main.sql, to create all the objects and load the data. Running sh_main.sql accomplishes the following tasks:
Prompts for passwords and tablespace names used within the scripts as well as datafile and log file directories
Removes any previously installed
SHschemaCreates user
SHand grants the necessary privilegesConnects as
SHCalls the scripts that create and populate the schema objects
After script sh_main.sql runs successfully and schema SH is installed, you are connected as user SH. To verify that the schema was created, use the following command:
For a complete listing of the scripts and their functions, refer to Table 4-27.
Note:
The dimension tablesPROMOTIONS, CUSTOMERS, PRODUCTS and the fact table SALES are loaded by SQL*Loader, after which directory paths are created inside the database to point to the load and log file locations. This allows the loading of the COSTS table by using the external table sales_transactions_ext.A pair of optional scripts, sh_olp_c.sql and sh_olp_d.sql, is provided as a schema extension. To prepare schema SH for use with the advanced analytical capabilities of OLAP Services, run the sh_olp_c.sql create script. If you want to return to the initial setup of schema SH, then use script sh_olp_d.sql to undo the effects of sh_olp_c.sql and reinstate dimensions as they were before.
You can use script sh_drop.sql to drop schema SH.
Resetting Sample Schemas
To reset sample schemas to their initial state, use the following syntax from the SQL*Plus command-line interface:
The mksample script expects 11 parameters. Provide the password for SYSTEM and SYS, and for schemas HR, OE, PM, IX, and SH. Specify a temporary and a default tablespace, and make sure to end the name of the log file directory with a trailing slash.
The mksample script produces several log files:
mkverify.logis the Sample Schema creation log file.hr_main.logis theHRschema creation log file.oe_oc_main.logis theOEschema creation log file.pm_main.logis thePMschema creation log file.pm_p_lob.logis the SQL*Loader log file forPM.PRINT_MEDIA.ix_main.logis theIXschema creation log file.sh_main.logis theSHschema creation log file.cust.logis the SQL*Loader log file forSH.CUSTOMERS.prod.logis the SQL*Loader log file forSH.PRODUCTS.promo.logis the SQL*Loader log file forSH.PROMOTIONS.sales.logis the SQL*Loader log file forSH.SALES.sales_ext.logis the external table log file forSH.COSTS.
In most situations, there is no difference between installing a Sample Schema for the first time or reinstalling it over a previously installed version. The *_main.sql scripts drop the schema users and all of their objects.
In some cases, complex interobject relationships in schema OE or IX prevent DROPUSER ... CASCADE operations from completing normally. To correct these rare cases, use one of the following procedures:
For the OC catalog subschema of schema OE:
Connect as user
OE.Run script
oc_drop.sql.Connect as
SYSTEM.Ensure that user
OEis not connected:Drop user
OE:
For the IX schemas:
Connect as
SYSTEM.Ensure that no user is connected as an
IXuser:Drop the schemas by running script
dix.sql. You will be prompted for passwords for the individual users.
Uninstalling Sample Schemas
If you need to remove the sample schemas from the installation, run script drop_sch.sql on the SQL*Plus command line. This script ships with Oracle Database.
Script drop_sch.sql uses two parameters: systempwd is the password for SYSTEM user, and spool_file_name is the name of the spool file that captures the log of the operation.