配置Oracle XStream [英] Configuring Oracle XStream

问题描述

我正在尝试通过官方文档

所以，不久之后，我将以sysdba的身份连接

So, shortly, I'm connecting as sysdba

    sqlplus / as sysdba

然后执行命令创建CDB用户并为其授予权限

Then executing commands create create CDB user and give him privileges

    > CREATE TABLESPACE xstream_tbs DATAFILE '$ORACLE/cdb/orcl/xstream_tbs.dbf' SIZE 25M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED;
    > CREATE USER c##xstrmadmin IDENTIFIED BY password DEFAULT TABLESPACE xstream_tbs   QUOTA UNLIMITED ON xstream_tbs container=all;
    > GRANT CREATE SESSION, SET CONTAINER TO c##xstrmadmin CONTAINER=ALL;

完成此步骤后，我应授予用户使用XStream的权限

After this step I should give permissions to user to use XStream

    > BEGIN
        DBMS_XSTREAM_AUTH.GRANT_ADMIN_PRIVILEGE(
          grantee                 => 'c##xstrmadmin',
          privilege_type          => 'CAPTURE',
          grant_select_privileges => TRUE,
          container => 'ALL');
      END;
      /

在此阶段，我遇到此错误:

On this stage, I'm getting this error:

ERROR at line 1:
ORA-44001: invalid schema
ORA-06512: at "SYS.DBMS_XSTREAM_AUTH_IVK", line 3383
ORA-06512: at line 1
ORA-06512: at "SYS.DBMS_XSTREAM_AUTH_IVK", line 3500
ORA-06512: at "SYS.DBMS_XSTREAM_AUTH", line 34
ORA-06512: at line 2

当前容器为cdb $ root

Current container is cdb$root

Google搜索实际上什么也没有，而且我不知道我在关注DBA文档时出了什么问题.

Googling gives actually nothing and I have no idea whats wrong as I'm following DBA documentation.

推荐答案

我想我找到了解决方法.

I guess I found workaround.

如果您使用以下方式连接到oracle

If you connect to oracle with

> sqlplus /nolog

然后以sysdba身份连接

And then connect as sysdba

> conn / as sysdba

然后一切正常！

如果这只是解决创建权限问题的一种方法，则问题出在sqlplus或oracle本身.伤心！

If this is only one way to resolve problem with creating permissions then problem is in sqlplus or oracle itself. Sad!

这篇关于配置Oracle XStream的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！