How to install all sample schemas (HR,OE,PM,SH,IX,BI) in Oracle Database 21c in single shot
01. Extract the downloaded oracle sample schema scripts to ORACLE_HOME\demo\schema
2. Make sure that __SUB_CWD__ is replaced with absolute path in all directories like bus_intelligence, human_resources, info_exchange, order_entry, product_media, sales_history
3. Change directory ORACLE_HOME\demo\schema and Change the __SUB_CWD__ to absolute path in mksample.sql file wherever necessary as shown in the video.
4. Modify the tnsnames.ora to add orclpdb (pluggable database) as service and restart the oracle listener service.
5. Check the orclpdb is opened in read write mode before executing the queries, else execute this query
alter pluggable database orclpdb open read write;
5. Now login to sqlplus like "sys@orclpdb as sysdba". You can directly login to orclpdb pluggable database because you already added entry to tnsnames.ora
6. Execute the mksample.sql 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, oe, sh, pm, ix and bi separately and service name as "orclpdb" and check all objects are available in the schema.
Important Note: Since I am installing in my local machines i will be using connection string as "orclpdb" input while installation of some schemas.
"localhost:1521/orclpdb" also valid connection string.
Sample database schema can be downloaded from:
https://github.com/oracle-samples/db-sample-schemas/releases/tag/v21.1
#oracledatabase #oracledatabase21c #oracledba #oracletutorial #oracle #installsampleschemas #sampleschemas #sampledatabase #oracle21c #21c