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:
Download and install prior to installing Oracle Real Application Clusters, Oracle Real Application Clusters One Node, or other application software in a Grid Environment Oracle Database Global Service Manager (GSM/GDS) (12.1.0.2.0) for Microsoft Windows (x64). Download and install prior to installing Oracle Real Application Clusters, Oracle Real Application Clusters One Node, or other application software in a Grid Environment Oracle Database 12 c Release 2 Global Service Manager (12.2.0.1.0) for Microsoft Windows (x64). Feb 10, 2017.
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
Oracle Db 12c Download,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 passwords
The sample schemas available to you depend on the edition of Oracle Database that you have installed and its configuration. Refer to the following table:
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 information
Schema 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:
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:
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:
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:
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.sql
You 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:
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 run pm_main.sql
You 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:
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:
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 file pm_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 run ix_main.sql
To 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:
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 .
Installing the SH Schema
All scripts necessary to create the Sales History (
SH ) schema reside in $ORACLE_HOME /demo/schema/sales_history .
Smart mac address changer download. See Also:
Guidelines for Installing Sample Schemas before you run sh_main.sql
You 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:
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 tables PROMOTIONS , 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:
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 DROP USER .. CASCADE operations from completing normally. To correct these rare cases, use one of the following procedures:
For the
OC catalog subschema of schema OE :
For the
IX schemas:
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.
Installing and Upgrading
Installation guides for Oracle Database 12c and accompanying products on various platforms are collected here.Full Installation Guides describe a wider variety of scenarios with more detail.Client Installation Guides describe installing Oracle database client software on hosts where the database server is not installed.Supplementary Installation Guides describe installing products that are included with the database but installed separately.
Essentials
Describes last-minute features and changes not included in the Oracle Database Documentation Library for Oracle Database 12c Release 1 (12.1)
Describes Oracle Database licensing. If you have a question about your licensing needs, contact your Oracle sales representative, or refer to the resources listed in 'Related Documents' for more information.
Oracle Database New Features Guide is addressed to those of you familiar with previous releases of Oracle Database and who would like to become familiar with features, options, and enhancements that are new in this release of the database.
Guides you through the process of planning and performing upgrades for Oracle Database. This book also provides information about compatibility, upgrading applications, and changes in the new release that affect upgrading Oracle Database.
Describes the installation, configuration, and administration tasks for all activities related to migrating applications to Oracle Database from other databases, including DB2, MySQL, and Sybase.
Introduces you to the Oracle Database Migration Assistant for Unicode, discusses the database character set migration process, and verifies that there are no character set data problems in a current Unicode database.
Linux Installation Guides
Contains important information not included in the Oracle Database documentation for Linux.
Provides configuration information for network and system administrators, and database installation information for database administrators (DBAs) who install and configure Oracle Database and Oracle Grid Infrastructure for a standalone server on Linux.
Describes how to install and configure Oracle Database client on Linux.
Describes how to quickly install Oracle Database on Z/Linux systems.
Describes how to quickly install Oracle Database Client on Z/Linux systems.
Describes how to install Grid Infrastructure for a cluster software, which includes Oracle Clusterware and Oracle Automatic Storage Management (Oracle ASM), on systems running Linux.
Describes how to install and configure Oracle Real Application Clusters (Oracle RAC) on systems running Linux and UNIX.
Describes how to quickly install Oracle Database on Linux x86-64 systems.
Describes how to quickly install Oracle Database Client on Linux x86-64 systems.
This document contains important information that was not included in the platform-specific or product-specific documentation for this release.
This guide provides instructions about installing and configuring Oracle Database Client for Linux on POWER Systems.
This document contains important information that was not included in the platform-specific or product-specific documentation for this release.
This guide provides instructions about installing and configuring Oracle Database Client for Linux on POWER Systems.
Microsoft Windows Installation Guides
Contains important information not included in Oracle Database documentation for Windows.
Describes how to quickly install Oracle Database on Windows x64 systems.
Provides configuration information for network and system administrators, and database installation information for database administrators (DBAs) who install and configure Oracle Database and Oracle Grid Infrastructure for a standalone server on Windows.
Describes how to quickly install Oracle Database Client on Windows x64 systems.
Describes how to quickly install Oracle Database Client on Windows 32-bit systems.
Describes how to install and configure Oracle Database Client on Windows.
Describes how to install grid infrastructure for a cluster software, which includes Oracle Clusterware and Oracle Automatic Storage Management (Oracle ASM), on systems running Microsoft Windows.
Describes how to install Oracle Real Application Clusters on the Microsoft Windows platform.
Solaris Installation Guides
Contains important information not included in Oracle Database documentation for Solaris.
Provides configuration information for network and system administrators, and database installation information for database administrators (DBAs) who install and configure Oracle Database, and Oracle Grid Infrastructure for a standalone server on Oracle Solaris.
Describes how to install and configure Oracle Database Client on Oracle Solaris.
Describes how to install Oracle Grid Infrastructure for a cluster software, which includes Oracle Clusterware and Oracle Automatic Storage Management (Oracle ASM), on systems running Oracle Solaris.
Describes how to quickly install Oracle Database on Oracle Solaris on SPARC (64-Bit).
Describes how to quickly install Oracle Database on Oracle Solaris on x86-64 (64-Bit).
Describes how to quickly install Oracle Database Client on Oracle Solaris on SPARC (64-Bit).
Describes how to quickly install Oracle Database on Oracle Solaris on x86-64 (64-Bit).
HP-UX Installation Guides
Contains information that was not included in the platform-specific or product-specific documentation for this release.
Describes how to quickly install Oracle Database on HP-UX Itanium systems.
Provides configuration information for network and system administrators, and database installation information for database administrators (DBAs) who install and configure Oracle Database, and Oracle Grid Infrastructure for a standalone server on HP-UX systems.
Provides configuration information for network and system administrators, and database installation information for database administrators (DBAs) who install and configure Oracle Database, and Oracle Grid Infrastructure for a standalone server on HP-UX systems.
Describes how to quickly install Oracle Database Client on HP-UX Itanium.
Describes how to install Oracle Grid Infrastructure for a Cluster software, which includes Oracle Clusterware and Oracle Automatic Storage Management (Oracle ASM), on systems running HP-UX Itanium.
AIX Installation Guides
Contains important information not included in Oracle Database documentation for AIX.
Describes how to quickly install Oracle Database on IBM AIX on POWER Systems (64-Bit).
Provides configuration information for network and system administrators, and database installation information for database administrators (DBAs) who install and configure Oracle Database, and Oracle Grid Infrastructure for a standalone server on IBM AIX on POWER Systems (64-Bit).
Describes how to quickly install Oracle Database Client on IBM AIX on POWER Systems (64-Bit).
Describes how to install and configure Oracle Database Client on IBM AIX on POWER Systems (64-Bit).
Describes how to install Grid Infrastructure for a cluster software, which includes Oracle Clusterware and Oracle Automatic Storage Management (Oracle ASM), on systems running IBM AIX on POWER Systems (64-Bit).
Apple Mac OS X Installation Guides
This document contains important information about platform-specific documentation for this release.
This guide provides instructions about installing and configuring Oracle Database Instant Client for Apple Mac OS X (Intel).
Fujitsu BS2000/OSD Installation Guides
Contains important information not included in the Oracle Database documentation for Fujitsu.
Explains how to install, upgrade, and manage Oracle Database on Fujitsu BS2000/OSD systems.
Supplementary Installation Guides
Products installed separately from the database.
Describes how to install and configure the products available on the Oracle Database Examples installation media.
Provides Oracle applications with seamless access to IBM mainframe data and services through Remote Procedure Call (RPC) processing.
Provides Oracle applications with seamless access to IBM mainframe data and services through Remote Procedure Call (RPC) processing.
Describes how to install and configure Oracle Database Gateway for Sybase, Informix, Teradata, SQL Server, ODBC, and DRDA on UNIX-based platforms.
Describes how to install Oracle Database Gateway for Sybase, Informix, Teradata, SQL Server, ODBC, and DRDA on Microsoft Windows (32-bit) and Microsoft Windows (64-bit) platform.
Upgrade and Migration Scenario Virtual Books for Linux
Virtual books that organize information required to perform specific upgrade scenarios.
Download As..
Download Oracle Database Client 12cUpgrade and Migration Scenario Virtual Books for Solaris
Virtual books that organize information required to perform specific upgrade scenarios.
Download As..
Oracle 12c Create New Database
Download As..
Oracle Database 12c Download For MacOracle 12c Download Free
Scripting on this page causes alternating background colors for the list items in the portlets.
Comments are closed.
|
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
December 2020
Categories |