Shulou(Shulou.com)06/01 Report--

Environment

Operating system: RHEL 6.4x86x64

DB:oracle 11.2.0.3

For a test library, you forgot to install example when you installed the library. Sometimes it's not easy to test without these users. For example, without scott users, if you want to do connect by testing, you have to build your own emp table.

The following is the process of installing example

Step1: download the installation package

Download the installation package from http://www.oracle.com/technetwork/database/enterprise-edition/downloads/112010-linx8664soft-100572.html

Linux.x64_11gR2_examples.zip

Upload it to the server, then decompress it.

[oracle@server package] $unzip linux.x64_11gR2_examples.zip

Step2: go to the unzipped directory and then perform the installation

Su-# # switch to root to execute command

Xhost +

Su-oracle # # switch to oracle user to execute command

[oracle@server ~] $cd package/examples/

[oracle@server examples] $ls

Doc install response runInstaller stage welcome.html

. / runInstaller # # Note: it is best to use the desktop to operate on the server. If the xshell is broken remotely, you need to do it again.

Step3: installation process and configuration

Missing a lot of packages, on an one-time yum installation

As you can see, these packages have been installed on my system, and the version is newer than the one provided by oracle

So I can ignore these errors here, click ignore all, as follows

At this point, the installation is complete and the next step is to run the configuration script

Step4: configuration process after installation

Go to the demo directory

[oracle@server schema] $pwd

/ u01/app/oracle/product/11.2.0/dbhome_1/demo/schema

[oracle@server schema] $ls

Bus_intelligence human_resources log mk_dir.sql.ouibak mkplug.sql mksample.sql.sbs mkverify.sql product_media

Sales_history sted_mkplug.sql.dbl

Drop_sch.sql info_exchange mk_dir.sql mk_dir.sql.ouibak.1 mksample.sql mkunplug.sql order_entry README.txt shipping

As you can see, a lot of scripts are installed

You need to open the database and then run the mksample.sql script

Here, you need to enter the password of system/sys, set the password for users such as sh/oe, and enter the path to the default and temporary tablespaces.

SYS@fgh > startup

SYS@fgh > @? / demo/schema/mksample.sql

Specify password for SYSTEM as parameter 1:

Enter value for 1: oracle

Specify password for SYS as parameter 2:

Enter value for 2: oracle

Specify password for HR as parameter 3:

Enter value for 3: hr

Specify password for OE as parameter 4:

Enter value for 4: oe

Specify password for PM as parameter 5:

Enter value for 5: pm

Specify password for IX as parameter 6:

Enter value for 6: ix

Specify password for SH as parameter 7:

Enter value for 7: sh

Specify password for BI as parameter 8:

Enter value for 8: bi

Specify default tablespace as parameter 9:

Enter value for 9: users

Specify temporary tablespace as parameter 10:

Enter value for 10: temp

Specify log file directory (including trailing delimiter) as parameter 11:

Enter value for 11: / u01/app/oracle/diag/rdbms/fgh/fgh/trace

Sample Schemas are being created...

Connected.

DROP USER hr CASCADE

*

ERROR at line 1:

ORA-01918: user 'HR' does not exist

DROP USER oe CASCADE

*

ERROR at line 1:

ORA-01918: user 'OE' does not exist

DROP USER pm CASCADE

*

ERROR at line 1:

ORA-01918: user 'PM' does not exist

DROP USER ix CASCADE

*

ERROR at line 1:

ORA-01918: user 'IX' does not exist

DROP USER sh CASCADE

*

ERROR at line 1:

ORA-01918: user 'SH' does not exist

DROP USER bi CASCADE

*

ERROR at line 1:

ORA-01918: user 'BI' does not exist

Connected.

Specify password for HR as parameter 1:

Specify default tablespeace for HR as parameter 2:

Specify temporary tablespace for HR as parameter 3:

Specify password for SYS as parameter 4:

Specify log path as parameter 5:

.

In the process, oracle creates multiple users and creates many sample tables under these users

After the configuration is complete, view the sample tables under each user

SH user

SYSTEM@fgh > conn sh/sh

Connected.

SH@fgh > select * from tab

TNAME TABTYPE CLUSTERID

CAL_MONTH_SALES_MV TABLE

CHANNELS TABLE

COSTS TABLE

COUNTRIES TABLE

CUSTOMERS TABLE

DIMENSION_EXCEPTIONS TABLE

DR$SUP_TEXT_IDX$I TABLE

DR$SUP_TEXT_IDX$K TABLE

DR$SUP_TEXT_IDX$N TABLE

DR$SUP_TEXT_IDX$R TABLE

FWEEK_PSCAT_SALES_MV TABLE

PRODUCTS TABLE

PROFITS VIEW

PROMOTIONS TABLE

SALES TABLE

SALES_TRANSACTIONS_EXT TABLE

SUPPLEMENTARY_DEMOGRAPHICS TABLE

TIMES TABLE

OE user

OE@fgh > select * from tab

TNAME TABTYPE CLUSTERID

ACCOUNT_MANAGERS VIEW

ACTION_TABLE TABLE

BOMBAY_INVENTORY VIEW

CATEGORIES_TAB TABLE

COUNTRIES SYNONYM

CUSTOMERS TABLE

CUSTOMERS_VIEW VIEW

.

Other users will not verify them one by one.

OK, the installation of the sample user is completed.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.