网站建设经验介绍常见的网络推广方法
首先从如下的地址选择合适的版本进行下载
https://github.com/oracle-samples/db-sample-schemas/releases
如果是rac环境，最好是将这个数据库停掉，然后只启动一个instance，然后再开始安装
[Tue May 09 20:26:34][377951][oracle@nshqae01adm01:/u01/app/orabase/21c/dbhome1/bin][0]$ date;./srvctl stop database -d cdb3;date;
Tue May 9 20:26:41 EDT 2023
Tue May 9 20:27:17 EDT 2023
[Tue May 09 20:27:17][377951][oracle@nshqae01adm01:/u01/app/orabase/21c/dbhome1/bin][0]$ date;./srvctl start instance -d cdb3 -n nshqae01adm01;date;
Tue May 9 20:27:34 EDT 2023
Tue May 9 20:27:54 EDT 2023
安装ORDER ENTRY sample schema
在相应的子目录运行下面命令
/tmp/a/db-sample-schemas-23.1/order_entry
perl -p -i.bak -e ‘s#SUB__CWD#’$(pwd)‘#g’ *.sql /.sql /.dat
看一下这个目录下所带的帮助文档，里面介绍了如何安装order entry这个schema
SQL> @/tmp/a/db-sample-schemas-23.1/order_entry/oe_main.sql;specify password for OE as parameter 1:
Enter value for 1: cdb3specify default tablespeace for OE as parameter 2:
Enter value for 2: systemspecify temporary tablespace for OE as parameter 3:
Enter value for 3: tempspecify password for HR as parameter 4:
Enter value for 4: cdb3specify password for SYS as parameter 5:
Enter value for 5: cdb3specify directory path for the data files as parameter 6:
Enter value for 6: /tmp/a/db-sample-schemas-23.1/order_entrywriteable directory path for the log files as parameter 7:
Enter value for 7: /tmp/aspecify version as parameter 8:
Enter value for 8: v3specify connect string as parameter 9:
Enter value for 9: cdb3pdb10001Package created.在安装的过程中碰到了这样的一个错误
Warning: Package Body created with compilation errors.但是当我去视图里查找看看是那个package body编译失败的时候，找不到，都是valid的状态，整个数据库中没有invalid状态的package body
后来我看安装日志，发现有Package dropped.，估计是有的包先创建，后来又删除了
通过查看源安装文件，应该就是先创建了然后用完了就删除了。https://blog.csdn.net/u011868279/article/details/127024168