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@www.bkjia.com ~ $ Cd $ ORACLE_HOME/demo/schema // the script for creating an example in oracle10g and oracle11gR1 is stored here.
[Oracle@www.bkjia.com 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:
Http://www.oracle.com/technetwork/database/enterprise-edition/downloads/112010-linx8664soft-100572.html
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 for demonstration, you can download from this link:
Http://st-curriculum.oracle.com/obe/jdev/obe11jdev/11/common/files/sample_schema_scripts.zip
Decompress the downloaded file to the hr directory and use FileZilla to upload it to the VM.
Oracle@www.bkjia.com hr $ ls
Hr_cre. SQL hr_main. SQL hr_popul. SQL
[Oracle@www.bkjia.com 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.