How to install Oracle11gR2 database example user

If you want to install the sample user in oracle11gR2, you can use the example provided in the oracle official documentation. You can create an instance at the same time. You can also

If you want to install the sample user in oracle11gR2, you can use the example provided in the oracle official documentation. You can create an instance at the same time. You can also

If you want to install the sample user in Oracle11gR2, you can use the example provided in the oracle official documentation. You can create an instance at the same time. You can also create a database after installing the database software database.
The original storage location of the sample file in linux: $ ORACLE_HOME/demo/schema

[Oracle @ ~] $ Cd $ ORACLE_HOME/demo/schema // the script for creating an example in oracle10g and oracle11gR1 is stored here.
[Oracle @ schema] $ ll
Total 80
Drwxr-xr-x. 2 oracle oinstall 4096 Feb 5 bus_intelligence
-Rw-r --. 1 oracle oinstall 2322 Apr 3 2009 drop_sch. SQL
Drwxr-xr-x. 2 oracle oinstall 4096 Feb 5 human_resources
Drwxr-xr-x. 2 oracle oinstall 4096 Feb 5 log
-Rw-r --. 1 oracle oinstall 1754 Feb 5 mk_dir. SQL
-Rw-r --. 1 oracle oinstall 1754 Feb 5 mk_dir. SQL .ouibak
-Rw-r --. 1 oracle oinstall 1600 Aug 16 2006 mk_dir. SQL .sbs
-Rw-r --. 1 oracle oinstall 27373 Jun 30 2007 mkplug. SQL
Drwxr-xr-x. 3 oracle oinstall 4096 Feb 5 order_entry
Drwxr-xr-x. 2 oracle oinstall 4096 Feb 5 sales_history
-Rw-r --. 1 oracle oinstall 15246 May 10 2005 sted_mkplug. SQL .dbl

However, there is no mksample. SQL script, and none of the scripts can be used to create an oracle demo.

Oracle provides an independent 500 multi-MB Installation File in oracle11gR2 for installation example:

The installation package to be downloaded is named Oracle Database 11g Release 2 Examples.

Oracle interprets the installation package as follows:

Contains examples of how to use the Oracle Database. Download if you are new

To Oracle and want to try some of the examples presented in the Documentation.

If you only need hr users, you can download them from this link for Demonstration:

Decompress the downloaded file to the hr directory and use FileZilla to upload it to the VM.

[Oracle @ hr] $ ls

Hr_cre. SQL hr_main. SQL hr_popul. SQL

[Oracle @ hr] $ sqlplus/as sysdba

SQL> @ hr_main. SQL

Note that the creation script for commonly used scott users is located at: % ORACLE_HOME % \ rdbms \ admin \ scott. SQL

Scott. SQL in oracle11gR2 in linux is not in this directory.