dbca建库未安装example补救方法

1、上传example安装包

[root@ora11g software]# ll -shrt

total 466M

466M -rw-r--r-- 1 root root 466M Sep  6 17:05 p13390677_112040_Linux-x86-64_6of7.zip

[root@ora11g software]# pwd

/software

[root@ora11g software]#

2、解压安装包

[root@ora11g software]# unzip p13390677_112040_Linux-x86-64_6of7.zip

 

3、图形化安装

[root@ora11g software]# xhost +

 [root@ora11g software]# su - oracle

[oracle@ora11g ~]$ xhost +

 [oracle@ora11g ~]$ cd /software/examples/

[oracle@ora11g examples]$ ./runInstaller

4、运行配置脚本

[oracle@ora11g ~]$ cd /u01/app/oracle/product/11.2.0/db_1/demo/schema/

[oracle@ora11g schema]$ pwd

/u01/app/oracle/product/11.2.0/db_1/demo/schema

[oracle@ora11g schema]$

[oracle@ora11g schema]$ sqlplus / as sysdba

 

SQL*Plus: Release 11.2.0.4.0 Production on Mon Sep 6 17:23:12 2021

 

Copyright (c) 1982, 2013, Oracle.  All rights reserved.

 

 

Connected to:

Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

 

SQL>              

SQL> @?/demo/schema/mksample.sql

 

specify password for SYSTEM as parameter 1:

Enter value for 1: oracle --system用户密码

 

specify password for SYS as parameter 2:

Enter value for 2: oracle --sys用户密码

 

specify password for HR as parameter 3:

Enter value for 3: hr --hr用户密码,自己定义即可

 

specify password for OE as parameter 4:

Enter value for 4: oe --oe用户密码,自己定义即可

 

specify password for PM as parameter 5:

Enter value for 5: pm --pm用户密码,自己定义即可

 

specify password for IX as parameter 6:

Enter value for 6: ix --ix用户密码,自己定义即可

 

specify password for  SH as parameter 7:

Enter value for 7: sh --sh用户密码,自己定义即可

 

specify password for  BI as parameter 8:

Enter value for 8: bi --bi用户密码,自己定义即可

 

specify default tablespace as parameter 9:

Enter value for 9: USERS --默认永久表空间，USERS

 

specify temporary tablespace as parameter 10:

Enter value for 10: TEMP --默认临时表空间，TEMP

 

specify log file directory (including trailing delimiter) as parameter 11:

Enter value for 11: /u01/app/oracle/diag/rdbms/db11g/db11g/trace --默认日志路径，参考oracle用户.bash_profile下的log别名定义路径

 

等待完成即可！！！