在Oracle和MySQL上安装hr schema

SYS@orcl(CDB$ROOT)> alter session set container=pdb1;




Session altered.




SYS@orcl(CDB$ROOT)> create tablespace users datafile '/u01/app/oracle/oradata/ORCL/pdb1/user01.dbf' size 100m autoextend on;




Tablespace created.




SYSTEM@oracleace/pdb1.yaoyuan.com(PDB1)> @?/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
复制

$ sqlplus hr/hr@pdb1
...
SQL> select table_name from user_tables;




TABLE_NAME
--------------------------------------------------------------------------------
COUNTRIES
REGIONS
LOCATIONS
DEPARTMENTS
JOBS
EMPLOYEES
JOB_HISTORY




7 rows selected.




SQL> select count(*) from employees;




  COUNT(*)
----------
       107
复制

wget https://github.com/nomemory/hr-schema-mysql/archive/refs/heads/master.zip
 unzip master.zip 
 [oracle@dell hr-schema-mysql-master]$ ll
total 36
-rw-r--r--. 1 oracle oinstall 31342 Feb 15  2021 hr-schema-mysql.sql
-rw-r--r--. 1 oracle oinstall   231 Feb 15  2021




[oracle@dell hr-schema-mysql-master]$ mysql < hr-schema-mysql.sql
复制

mysql> use hr;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A




Database changed
mysql> show tables;
+------------------+
| Tables_in_hr     |
+------------------+
| countries        |
| departments      |
| emp_details_view |
| employees        |
| job_history      |
| jobs             |
| locations        |
| regions          |
+------------------+
8 rows in set (0.00 sec)
mysql> select count(*) from employees;
+----------+
| count(*) |
+----------+
|      107 |
+----------+
1 row in set (0.01 sec)
复制

$ cd home/oracle/examples/
[oracle@wl examples]$ ls
install response runInstaller stage welcome.html
复制

[oracle@oracleace examples]$ pwd
/media/sf_oracle/19c/examples
[oracle@oracleace examples]$ ./runInstaller -silent -force -ignorePrereq -ignoreSysPrereqs -responseFile media/sf_oracle/19c/examples/response/demos_install.rsp 
Starting Oracle Universal Installer...




Checking Temp space: must be greater than 415 MB.   Actual 28381 MB    Passed
Checking swap space: must be greater than 150 MB.   Actual 7935 MB    Passed
Preparing to launch Oracle Universal Installer from tmp/OraInstall2022-03-28_06-45-48PM. Please wait ...[oracle@oracleace examples]$ 
[oracle@oracleace examples]$ The response file for this session can be found at:
 u01/app/oracle/product/19.3.0/db_1/install/response/examples_2022-03-28_06-45-48PM.rsp




You can find the log of this install session at:
 u01/app/oraInventory/logs/installActions2022-03-28_06-45-48PM.log
Successfully Setup Software.
The installation of Oracle Database 19c Examples was successful.
Please check '/u01/app/oraInventory/logs/silentInstall2022-03-28_06-45-48PM.log' for more details.
复制

[oracle@oracleace ~]$ cp -r /media/sf_oracle/19c/db-sample-schemas-19c $ORACLE_HOME/demo/schema


mv db-sample-schemas-19c  $ORACLE_HOME/demo/schema/
复制

[oracle@wl db-sample-schemas-19c] pwd
/u01/app/oracle/product/19.3.0/db_1/demo/schema/db-sample-schemas-19c
[oracle@wl db-sample-schemas-19c]$ perl -p -i.bak -e 's#__SUB__CWD__#'$(pwd)'#g' *.sql */*.sql */*.dat
复制

[oracle@oracleace db-sample-schemas-19c]$ sqlplus system/oracle@oracleace/pdb1.yaoyuan.com
...
SYSTEM@oracleace/pdb1.yaoyuan.com(PDB1)> @?/demo/schema/db-sample-schemas-19c/mksample  oracle oracle hr oe pm ix sh bi users temp $ORACLE_HOME/demo/schema/log/ oracleace:1521/pdb1.yaoyuan.com
复制

[oracle@oracleace ~]$ sqlplus system/oracle@localhost/pdb1.yaoyuan.com




SCOTT@localhost/pdb1.yaoyuan.com(PDB1)> @/u01/app/oracle/product/19.3.0/db_1/rdbms/admin/utlsampl.sql
Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0
复制

SCOTT@localhost/pdb1.yaoyuan.com(PDB1)> select table_name from user_tables;




TABLE_NAME
--------------------------------------------------------------------------------
DEPT
EMP
BONUS
SALGRADE
复制