SQL> @cat_owb Enter Tablespace Name for OWBSYS user: users Package created. Package body created. Create user OWBSYS with default tablespace users ... old 1: CREATE USER OWBSYS IDENTIFIED BY OWBSYS DEFAULT TABLESPACE &owbsys_tbs new 1: CREATE USER OWBSYS IDENTIFIED BY OWBSYS DEFAULT TABLESPACE users 。。 User created. User altered.
NOTE: To associate the Control Center with the correct OWB home, now run owb/UnifiedRepos/reset_owbcc_home.sql. You must run the script. as a user with java admin privileges. For example, connect as sys as sysdba to run the script. SQL> SQL> SQL> SQL>
SQL> @reset_owbcc_home Enter the full path of the Oracle home for the OWB Control Center install. If you are installing in a Windows environment, please ensure that the case of the path exactly matches the Oracle install path including the drive letter. OWB Control Center Home: /usr/local/oracle/product/11.2.0/dbhome_1 PL/SQL procedure successfully completed. PL/SQL procedure successfully completed.
于是我查了一下,12c新增了CBD和PDB模块(这是我参考的网址:http://www.cnblogs.com/dingyingsi/p/3604789.html)。
但是这样只能新建公用用户:C##OWBSYS这不是我要的OWBSYS用户。。
Enter Tablespace Name for OWBSYS user:
users
Package created.
Package body created.
Create user OWBSYS with default tablespace users ...
old 1: CREATE USER OWBSYS IDENTIFIED BY OWBSYS DEFAULT TABLESPACE &owbsys_tbs
new 1: CREATE USER OWBSYS IDENTIFIED BY OWBSYS DEFAULT TABLESPACE users
。。
User created.
User altered.
NOTE: To associate the Control Center with the correct OWB home, now run owb/UnifiedRepos/reset_owbcc_home.sql. You must run the script. as a user with java admin privileges. For example, connect as sys as sysdba to run the script.
SQL> SQL> SQL> SQL>
SQL> @reset_owbcc_home
Enter the full path of the Oracle home for the OWB Control Center install.
If you are installing in a Windows environment, please ensure that the case of the path exactly matches the Oracle install path including the drive letter.
OWB Control Center Home:
/usr/local/oracle/product/11.2.0/dbhome_1
PL/SQL procedure successfully completed.
PL/SQL procedure successfully completed.
1、新建一个pdb
2、修改tnsnames.ora 增加一个指向pdb的tns
3、impdp时候 @新的tns
不过话说如果你不懂pdb,最好不要用,重新装一个数据库吧,安装的时候记得不要勾选 pdb选项