How to install HR schema in Oracle Database 23c running in Oracle Linux 8 - Human Resources Schema

Channel:

java frm

Subscribers:

5,790

Published on June 23, 2023 3:29:40 AM ● Video Link: https://www.youtube.com/watch?v=YHKc3_ntM60

Category:

Tutorial

Duration: 2:56

71 views

0

1. Extract the downloaded oracle sample schema scripts to ORACLE_HOME/demo/schema
2. Change directory to human_resources.
3. Modify the tnsnames.ora to add freepdb1 (pluggable database) as service and restart the oracle listener service.
4. Check the freepdb1 is opened in read write mode before executing the queries, else execute this query
alter pluggable database freepdb1 open read write;
5. Now login to sqlplus like "sys@freepdb1 as sysdba". You can directly login to freepdb1 pluggable database because you already added entry to tnsnames.ora
6. Execute the hr_install.sql and provide the inputs as shown in the video.
7. After executing check the logs for any errors if no errors you are done.
8. Open the SQL Developer and login as hr/hr and service name as "freepdb1" and check all objects are available in the schema.

Download link: Sample schemas for 23c can be downloaded from
https://github.com/oracle-samples/db-sample-schemas/releases/tag/v23.1

#oracle23c #23c #oracledatabase23c #oracledatabase #oracle #hr #hrschema #sampleschemas #sampledatabase #oracledba #oracleinstallation #oracletutorial