How to install HR schema?

Installing_the_HR_Schema

=========================
How to install HR schema?

Steps:

1. Connect to database and verify that HR schema/user does not exists:
2. Run the below hr_main.sql which will create the HR schema with sample database_objects in it 
3. Connect to HR schema and verify the object in it
4. Verify the log files if there are any errors while installation

1. Connect to database and verify that HR schema/user does not exists:

[root@oraclelab1 ~]# su - oracle

Last login: Thu Dec 30 09:58:49 IST 2021 on pts/1

[oracle@oraclelab1 ~]$ . oraenv

ORACLE_SID = [oracle] ? DEVDB

The Oracle base has been set to /u01/app/oracle

[oracle@oraclelab1 ~]$ sqlplus / as sysdba

SQL*Plus: Release 19.0.0.0.0 - Production on Mon Jan 3 08:44:31 2022

Version 19.3.0.0.0

Copyright (c) 1982, 2019, Oracle.  All rights reserved.

Connected to:

Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production

Version 19.3.0.0.0

SQL> select username, account_status from dba_users where username='HR';

no rows selected

2. Run the below hr_main.sql which will create the HR schema with sample database_objects in it 

SQL> @?/demo/schema/human_resources/hr_main.sql

specify password for HR as parameter 1:

Enter value for 1: hr

specify default tablespeace for HR as parameter 2:

Enter value for 2: USERS

specify temporary tablespace for HR as parameter 3:

Enter value for 3: TEMP

specify log path as parameter 4:

Enter value for 4: /tmp

PL/SQL procedure successfully completed.

User created.

User altered.

User altered.

Grant succeeded.

Grant succeeded.

Session altered.

Session altered.

Session altered.

******  Creating REGIONS table ....

Table created.

Index created.

Table altered.

******  Creating COUNTRIES table ....

Table created.

Table altered.

******  Creating LOCATIONS table ....

Table created.

Index created.

Table altered.

Sequence created.

******  Creating DEPARTMENTS table ....

Table created.

Index created.

Table altered.

Sequence created.

******  Creating JOBS table ....

Table created.

Index created.

Table altered.

******  Creating EMPLOYEES table ....

Table created.

Index created.

Table altered.

Table altered.

Sequence created.

******  Creating JOB_HISTORY table ....

Table created.

Index created.

Table altered.

******  Creating EMP_DETAILS_VIEW view ...

View created.

Commit complete.

Session altered.

******  Populating REGIONS table ....

1 row created.

1 row created.

1 row created.

1 row created.

******  Populating COUNTIRES table ....

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

******  Populating LOCATIONS table ....

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

******  Populating DEPARTMENTS table ....

Table altered.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

******  Populating JOBS table ....

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

******  Populating EMPLOYEES table ....

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

******  Populating JOB_HISTORY table ....

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

Table altered.

Commit complete.

Index created.

Index created.

Index created.

Index created.

Index created.

Index created.

Index created.

Index created.

Index created.

Index created.

Index created.

Commit complete.

Procedure created.

Trigger created.

Trigger altered.

Procedure created.

Trigger created.

Commit complete.

Comment created.

Comment created.

Comment created.

Comment created.

Comment created.

Comment created.

Comment created.

Comment created.

Comment created.

Comment created.

Comment created.

Comment created.

Comment created.

Comment created.

Comment created.

Comment created.

Comment created.

Comment created.

Comment created.

Comment created.

Comment created.

Comment created.

Comment created.

Comment created.

Comment created.

Comment created.

Comment created.

Comment created.

Comment created.

Comment created.

Comment created.

Comment created.

Comment created.

Comment created.

Comment created.

Comment created.

Comment created.

Comment created.

Comment created.

Commit complete.

PL/SQL procedure successfully completed.

SQL>

3. Connect to HR schema and verify the object in it

SQL> select username, account_status from dba_users where username='HR';

USERNAME

--------------------------------------------------------------------------------

ACCOUNT_STATUS

--------------------------------

HR

OPEN

1 row selected.

SQL> conn hr/hr

Connected.

SQL> select * from tab;

TNAME

--------------------------------------------------------------------------------

TABTYPE        CLUSTERID

------------- ----------

REGIONS

TABLE

COUNTRIES

TABLE

LOCATIONS

TABLE

DEPARTMENTS

TABLE

JOBS

TABLE

EMPLOYEES

TABLE

JOB_HISTORY

TABLE

EMP_DETAILS_VIEW

VIEW

8 rows selected.

SQL> exit

Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production

Version 19.3.0.0.0

[oracle@oraclelab1 ~]$

4. Verify the log files if there are any errors while installation

[oracle@oraclelab1 ~]$ cd /tmp/

[oracle@oraclelab1 tmp]$ ls -ltrh

total 2.4M

drwx------. 3 root   root       17 Dec 15 19:54 systemd-private-996a2bb59d444dfeaab816aa6e8124f1-rtkit-daemon.service-FWwb0r

drwx------. 3 root   root       17 Dec 15 19:54 systemd-private-996a2bb59d444dfeaab816aa6e8124f1-cups.service-FHdPDh

drwx------. 3 root   root       17 Dec 15 19:54 systemd-private-996a2bb59d444dfeaab816aa6e8124f1-bolt.service-NuTbrb

drwx------. 3 root   root       17 Dec 15 19:54 systemd-private-996a2bb59d444dfeaab816aa6e8124f1-colord.service-DU75yt

drwx------. 3 root   root       17 Dec 15 19:57 systemd-private-996a2bb59d444dfeaab816aa6e8124f1-fwupd.service-rHpbIe

drwx------. 2 root   root        6 Dec 20 09:32 tracker-extract-files.0

drwx------. 2 oracle oinstall   25 Dec 20 10:20 ssh-0eF8t8RrE6Nm

-rw-------. 1 root   root     219K Dec 24 06:14 yum_save_tx.2021-12-24.06-14.5pLbrp.yumtx

-rw-------. 1 root   root     219K Dec 25 06:14 yum_save_tx.2021-12-25.06-14.EClQQ3.yumtx

-rw-------. 1 root   root     219K Dec 26 06:14 yum_save_tx.2021-12-26.06-14.axzTcw.yumtx

-rw-------. 1 root   root     219K Dec 27 06:14 yum_save_tx.2021-12-27.06-14.Ohme5r.yumtx

-rw-------. 1 root   root     219K Dec 28 06:14 yum_save_tx.2021-12-28.06-14.I27226.yumtx

-rw-------. 1 root   root     219K Dec 29 06:14 yum_save_tx.2021-12-29.06-14.inBIFs.yumtx

drwxr-xr-x. 2 oracle oinstall    6 Dec 29 10:18 hsperfdata_oracle

drwx------. 2 root   root       25 Dec 30 02:35 ssh-lXAQq56uba58

-rw-------. 1 root   root     219K Dec 30 06:36 yum_save_tx.2021-12-30.06-36.vUAOHy.yumtx

-rw-------. 1 root   root     219K Dec 31 06:36 yum_save_tx.2021-12-31.06-36.gqthBx.yumtx

-rw-------. 1 root   root     219K Jan  1 06:36 yum_save_tx.2022-01-01.06-36.90Zi5q.yumtx

-rw-------. 1 root   root     219K Jan  2 06:36 yum_save_tx.2022-01-02.06-36.SZNLqw.yumtx

-rw-------. 1 root   root     219K Jan  3 06:36 yum_save_tx.2022-01-03.06-36.ZhVF9O.yumtx

-rw-r--r--. 1 oracle oinstall 6.0K Jan  3 08:46 hr_main.log

[oracle@oraclelab1 tmp]$ more hr_main.log

PL/SQL procedure successfully completed.

User created.

User altered.

User altered.

Grant succeeded.

Grant succeeded.

Session altered.

Session altered.

Session altered.

******  Creating REGIONS table ....

Table created.

Index created.

Table altered.

******  Creating COUNTRIES table ....

Table created.

Table altered.

******  Creating LOCATIONS table ....

Table created.

Index created.

Table altered.

Sequence created.

******  Creating DEPARTMENTS table ....

Table created.

Index created.

Table altered.

Sequence created.

******  Creating JOBS table ....

Table created.

Index created.

Table altered.

******  Creating EMPLOYEES table ....

Table created.

Index created.

Table altered.

Table altered.

Sequence created.

******  Creating JOB_HISTORY table ....

Table created.

Index created.

Table altered.

******  Creating EMP_DETAILS_VIEW view ...

View created.

Commit complete.

Session altered.

******  Populating REGIONS table ....

1 row created.

1 row created.

1 row created.

1 row created.

******  Populating COUNTIRES table ....

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

******  Populating LOCATIONS table ....

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

******  Populating DEPARTMENTS table ....

Table altered.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

******  Populating JOBS table ....

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

******  Populating EMPLOYEES table ....

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

******  Populating JOB_HISTORY table ....

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

1 row created.

Table altered.

Commit complete.

Index created.

Index created.

Index created.

Index created.

Index created.

Index created.

Index created.

Index created.

Index created.

Index created.

Index created.

Commit complete.

Procedure created.

Trigger created.

Trigger altered.

Procedure created.

Trigger created.

Commit complete.

Comment created.

Comment created.

Comment created.

Comment created.

Comment created.

Comment created.

Comment created.

Comment created.

Comment created.

Comment created.

Comment created.

Comment created.

Comment created.

Comment created.

Comment created.

Comment created.

Comment created.

Comment created.

Comment created.

Comment created.

Comment created.

Comment created.

Comment created.

Comment created.

Comment created.

Comment created.

Comment created.

Comment created.

Comment created.

Comment created.

Comment created.

Comment created.

Comment created.

Comment created.

Comment created.

Comment created.

Comment created.

Comment created.

Comment created.

Commit complete.

PL/SQL procedure successfully completed.

[oracle@oraclelab1 tmp]$

Refer below Oracle Document for more information:

https://docs.oracle.com/database/121/COMSC/installation.htm#COMSC001

Regards,

Mallik