Oracle 12.2安装示例schema
内容导读
互联网集市收集整理的这篇技术教程文章主要介绍了Oracle 12.2安装示例schema,小编现在分享给大家,供广大互联网技能从业者学习和参考。文章包含4659字,纯文字阅读大概需要7分钟。
内容图文
![Oracle 12.2安装示例schema](/upload/InfoBanner/zyjiaocheng/489/f7c982d65dc14bc28a821b5c104ada78.jpg)
在做Oracle数据库实验时都会用到一些示例SCHEMA如:HR、OE、SH等,在Oracle11g版本时在DBCA时直接勾选Sample Schemas就可以安装这些示例SCHEMA,如下图:
但到了Oracle12.2 版本,也有一个示例Schemas选项卡如下图所示:
但是数据库安装完成后却还是没有这些示例SCHEMA,到底是怎么回事呢?我们来查一下官方文档:
Starting with Oracle Database 12c Release 2, the latest version of the sample schema scripts are available on GitHub at https://github.com/oracle/db-sample-schemas/releases/latest.
During a complete installation of Oracle Database, the HR schema can be installed either manually or automatically when creating a database using the dbca
option. All the other sample schemas must be installed manually via the scripts available on GitHub.
从上面的官方文档中我们可以看到从Oracle12.2版本开始,示例Schemas的脚本被放到了GitHub上,在DBCA安装时只会安装hr示例Schema。从文档中给出的指定地址下载示例Schema安装脚本:
从README.txt文档中找到安装方法,开始安装:
sys@ORA12C>@mksample specify password for SYSTEM as parameter 1: Enter value for 1: 123456 specify password for SYS as parameter 2: Enter value for 2: 123456 specify password for HR as parameter 3: Enter value for 3: hr specify password for OE as parameter 4: Enter value for 4: oe specify password for PM as parameter 5: Enter value for 5: pm specify password for IX as parameter 6: Enter value for 6: ix specify password for SH as parameter 7: Enter value for 7: sh specify password for BI as parameter 8: Enter value for 8: bi specify default tablespace as parameter 9: Enter value for 9: users specify temporary tablespace as parameter 10: Enter value for 10: temp specify log file directory (including trailing delimiter) as parameter 11: Enter value for 11: /home/oracle/dbca specify connect string as parameter 12: Enter value for 12: localhost:1521/ora12c Sample Schemas are being created ... mkdir: cannot create directory ‘/home/oracle/dbca’: File exists Connected. DROP USER hr CASCADE * ERROR at line 1: ORA-01918: user ‘HR‘ does not exist DROP USER oe CASCADE * ERROR at line 1: ORA-01918: user ‘OE‘ does not exist DROP USER pm CASCADE * ERROR at line 1: ORA-01918: user ‘PM‘ does not exist DROP USER ix CASCADE * ERROR at line 1: ORA-01918: user ‘IX‘ does not exist DROP USER sh CASCADE * ERROR at line 1: ORA-01918: user ‘SH‘ does not exist DROP USER bi CASCADE * ERROR at line 1: ORA-01918: user ‘BI‘ does not exist Connected. SP2-0310: unable to open file "__SUB__CWD__/human_resources/hr_main.sql" Connected. SP2-0310: unable to open file "__SUB__CWD__/order_entry/oe_main.sql" Connected. SP2-0310: unable to open file "__SUB__CWD__/product_media/pm_main.sql" Connected. SP2-0310: unable to open file "__SUB__CWD__/info_exchange/ix_main.sql" Connected. SP2-0310: unable to open file "__SUB__CWD__/sales_history/sh_main.sql" Connected. SP2-0310: unable to open file "__SUB__CWD__/bus_intelligence/bi_main.sql" Connected. not spooling currently SP2-0310: unable to open file "__SUB__CWD__/mkverify.sql"
从上面看到输出报错,没有安装成功。报错的是“__SUB__CWD__”没有找到,打开mksample.sql文件,确实有这个变量,但不知道在哪里声明的。
重新查看README.md文档看到需要把“__SUB__CWD__”这个变量替换为当前路径,还给出了命令:
[oracle@rhel7 db-sample-schemas-12.2.0.1]$ perl -p -i.bak -e ‘s#__SUB__CWD__#‘$(pwd)‘#g‘ *.sql */*.sql */*.dat
执行完上面的脚本后重新安装示例Schema:
sys@ORA12C>@mksample 123456 123456 hr oe pm ix sh bi users temp /home/oracle/dbca/ 192.168.56.22:1521/ora12c
最终安装成功:
system@ORA12C>select username,created from dba_users where created>sysdate-1; USERNAME CREATED ------------------------------ ----------------- OE 20170816 23:32:22 SH 20170816 23:34:25 PM 20170816 23:33:13 IX 20170816 23:34:12 BI 20170816 23:36:20 HR 20170816 23:32:07
参考:http://docs.oracle.com/database/122/COMSC/installing-sample-schemas.htm#COMSC-GUID-B0BEE222-D8B0-4B68-B359-DEA153956EF6
本文出自 “DBA Fighting!” 博客,请务必保留此出处http://hbxztc.blog.51cto.com/1587495/1956932
Oracle 12.2安装示例schema
标签:oracle 12.2 示例 schema
本文系统来源:http://hbxztc.blog.51cto.com/1587495/1956932
内容总结
以上是互联网集市为您收集整理的Oracle 12.2安装示例schema全部内容,希望文章能够帮你解决Oracle 12.2安装示例schema所遇到的程序开发问题。 如果觉得互联网集市技术教程内容还不错,欢迎将互联网集市网站推荐给程序员好友。
内容备注
版权声明:本文内容由互联网用户自发贡献,该文观点与技术仅代表作者本人。本站仅提供信息存储空间服务,不拥有所有权,不承担相关法律责任。如发现本站有涉嫌侵权/违法违规的内容, 请发送邮件至 gblab@vip.qq.com 举报,一经查实,本站将立刻删除。
内容手机端
扫描二维码推送至手机访问。