文章/答案/技术大牛

发布

社区首页 >问答首页 >角色'APEX_ADMINISTRATOR_READ_ROLE‘不存在

问角色'APEX_ADMINISTRATOR_READ_ROLE‘不存在
EN

Stack Overflow用户

提问于 2018-12-23 11:56:08

回答 1查看 1.3K关注 0票数 0

使用Oracle 11g和2台运行Windows 10的不同计算机(真恶心)

我试图通过network_link导入一个模式。

我收到了一些错误，有些赠款丢失了。

以下是错误：(其中一个错误，其他错误相似)

ORA-39083: Object type ROLE_GRANT failed to create with error:
ORA-01919: role 'APEX_ADMINISTRATOR_READ_ROLE' does not exist
Failing sql is:
 GRANT "APEX_ADMINISTRATOR_READ_ROLE" TO "GEO127" WITH ADMIN OPTION
ORA-39083: Object type ROLE_GRANT failed to create with error:
ORA-01919: role 'APEX_GRANTS_FOR_NEW_USERS_ROLE' does not exist
Failing sql is:
 GRANT "APEX_GRANTS_FOR_NEW_USERS_ROLE" TO "GEO127" WITH ADMIN OPTION

我的问题是.我知道我可以“创建角色”，但我如何知道哪些特权属于该角色？

我确实尝试过添加这个角色，但它不在目录中？

Error starting at line : 1 in command -
grant apex_administrator_read_role to geo127
Error report -
SQL Error: ORA-01919: role 'APEX_ADMINISTRATOR_READ_ROLE' does not exist
01919. 00000 -  "role '%s' does not exist"
*Cause:    Role by that name does not exist.
*Action:   Verify you are using the correct role name.

此外，我查看了“源”数据库，并且“APEX_ADMINISTRATOR_READ_ROLE”确实存在，我想我想知道如何在“目标”上复制它。

C:\Users\COMPUTER>impdp geo127/******** directory=data_pump_dir network_link=legacy remap_schema=geo:geo127

Import: Release 11.2.0.2.0

Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.

Connected to: Oracle Database 11g Express Edition Release 11.2.0.2.0 - Production
Starting "GEO127"."SYS_IMPORT_SCHEMA_01":  geo127/******** directory=data_pump_dir network_link=legacy remap_schema=geo:geo127
Estimate in progress using BLOCKS method...
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 882.8 MB
Processing object type SCHEMA_EXPORT/USER
ORA-31684: Object type USER:"GEO127" already exists
Processing object type SCHEMA_EXPORT/SYSTEM_GRANT
Processing object type SCHEMA_EXPORT/ROLE_GRANT
ORA-39083: Object type ROLE_GRANT failed to create with error:
ORA-01919: role 'APEX_ADMINISTRATOR_READ_ROLE' does not exist
Failing sql is:
 GRANT "APEX_ADMINISTRATOR_READ_ROLE" TO "GEO127" WITH ADMIN OPTION
ORA-39083: Object type ROLE_GRANT failed to create with error:
ORA-01919: role 'APEX_GRANTS_FOR_NEW_USERS_ROLE' does not exist
Failing sql is:
 GRANT "APEX_GRANTS_FOR_NEW_USERS_ROLE" TO "GEO127" WITH ADMIN OPTION
Processing object type SCHEMA_EXPORT/DEFAULT_ROLE
ORA-39083: Object type DEFAULT_ROLE failed to create with error:
ORA-01919: role 'APEX_ADMINISTRATOR_READ_ROLE' does not exist
Failing sql is:
 ALTER USER "GEO127" DEFAULT ROLE "CONNECT", "RESOURCE", "DBA", "SELECT_CATALOG_ROLE", "EXECUTE_CATALOG_ROLE", "DELETE_CATALOG_ROLE", "EXP_FULL_DATABASE", "IMP_FULL_DATABASE", "LOGSTDBY_ADMINISTRATOR", "DBFS_ROLE", "AQ_ADMINISTRATOR_ROLE", "AQ_USER_ROLE", "DATAPUMP_EXP_FULL_DATABASE", "DATAPUMP_IMP_FULL_DATABASE", "ADM_PARALLEL_EXECUTE_TASK", "GATHER_SYSTEM_STATIST
Processing object type SCHEMA_EXPORT/TABLESPACE_QUOTA
Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA
Processing object type SCHEMA_EXPORT/SEQUENCE/SEQUENCE
ORA-31684: Object type SEQUENCE:"GEO127"."HIER_SEQ" already exists
Processing object type SCHEMA_EXPORT/TABLE/TABLE
ORA-39083: Object type TABLE:"GEO127"."NOCOUNTRY" failed to create with error:
ORA-00959: tablespace 'GEOGRAPHIC' does not exist
Failing sql is:
CREATE TABLE "GEO127"."NOCOUNTRY" ("GEONAMEID" VARCHAR2(20 BYTE), "ASCIINAME" VARCHAR2(255 BYTE), "LATITUDE" VARCHAR2(20 BYTE), "LONGITUDE" VARCHAR2(20 BYTE), "FEATURE_CLASS" VARCHAR2(255 BYTE), "FEATURE_CODE" VARCHAR2(255 BYTE), "COUNTRY_CODE" VARCHAR2(255 BYTE), "CC2" VARCHAR2(255 BYTE), "ADMIN1_CODE" VARCHAR2(255 BYTE), "ADMIN2_CODE" VARCHAR2(255 BYTE), "ADMIN
ORA-39083: Object type TABLE:"GEO127"."HIERARCHY" failed to create with error:
ORA-00959: tablespace 'GEOGRAPHIC' does not exist
Failing sql is:
CREATE TABLE "GEO127"."HIERARCHY" ("PARENTID" VARCHAR2(20 BYTE), "CHILDID" VARCHAR2(20 BYTE), "TYPE" VARCHAR2(255 BYTE), "HID" NUMBER NOT NULL ENABLE) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEF
ORA-39083: Object type TABLE:"GEO127"."GEONAMES" failed to create with error:
ORA-00959: tablespace 'GEOGRAPHIC' does not exist
Failing sql is:
CREATE TABLE "GEO127"."GEONAMES" ("GEONAMEID" VARCHAR2(20 BYTE), "ASCIINAME" VARCHAR2(255 BYTE), "LATITUDE" VARCHAR2(20 BYTE), "LONGITUDE" VARCHAR2(20 BYTE), "FEATURE_CLASS" VARCHAR2(255 BYTE), "FEATURE_CODE" VARCHAR2(255 BYTE), "COUNTRY_CODE" VARCHAR2(255 BYTE), "CC2" VARCHAR2(255 BYTE), "ADMIN1_CODE" VARCHAR2(255 BYTE), "ADMIN2_CODE" VARCHAR2(255 BYTE), "ADMIN3_
ORA-39083: Object type TABLE:"GEO127"."EXPORT_JOB_SQLDEV_2712" failed to create with error:
ORA-00959: tablespace 'GEOGRAPHIC' does not exist
Failing sql is:
CREATE TABLE "GEO127"."EXPORT_JOB_SQLDEV_2712" ("PROCESS_ORDER" NUMBER, "DUPLICATE" NUMBER, "DUMP_FILEID" NUMBER, "DUMP_POSITION" NUMBER, "DUMP_LENGTH" NUMBER, "DUMP_ORIG_LENGTH" NUMBER, "DUMP_ALLOCATION" NUMBER, "COMPLETED_ROWS" NUMBER, "ERROR_COUNT" NUMBER, "ELAPSED_TIME" NUMBER, "OBJECT_TYPE_PATH" VARCHAR2(200 BYTE), "OBJECT_PATH_SEQNO" NUMBER, "O
Processing object type SCHEMA_EXPORT/TABLE/INDEX/INDEX
Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
Processing object type SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
Processing object type SCHEMA_EXPORT/TABLE/COMMENT
Processing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
Job "GEO127"."SYS_IMPORT_SCHEMA_01" completed with 9 error(s)


C:\Users\COMPUTER>

--试图赋予这一角色

Error starting at line : 1 in command -
grant apex_administrator_read_role to geo127
Error report -
SQL Error: ORA-01919: role 'APEX_ADMINISTRATOR_READ_ROLE' does not exist
01919. 00000 -  "role '%s' does not exist"
*Cause:    Role by that name does not exist.
*Action:   Verify you are using the correct role name.

oracle

oracle11g

oracle-apex

回答 1

Stack Overflow用户

回答已采纳

发布于 2018-12-23 16:46:46

它是关于与Apex (Application Express) (https://docs.oracle.com/database/apex-18.2/HTMDB/about-utilizing-database-reporting.htm#HTMDB29893)相关的数据库报告。

如果您被授予了APEX_ADMINISTRATOR_READ_ROLE或APEX_ADMINISTRATOR_ROLE，那么您可以对整个实例进行查询，而不仅仅是与您的模式用户关联的工作区。您应该将APEX_ADMINISTRATOR_READ_ROLE授予监视用户，而APEX_ADMINISTRATOR_ROLE则应该用于管理实例参数、工作区等的实例管理员。

似乎在源数据库中安装了Apex，而在目标数据库中不存在Apex。因此，我认为你应该：

在目标数据库中安装Apex
忽略错误(但是您正在导入的用户将无法查询整个实例，这与目标数据库中没有Apex无关)

编辑，在读取注释之后

我在笔记本电脑上运行11克XE。它附带了Apex 4，所以我检查了是否存在导致问题的角色。显然，它没有：

SQL> select * From all_users where username like 'APEX%';

USERNAME                          USER_ID CREATED
------------------------------ ---------- --------
APEX_040000                            47 29.05.14
APEX_PUBLIC_USER                       45 29.05.14

SQL> select * From dba_roles where role like 'APEX%';

ROLE                           PASSWORD AUTHENTICAT
------------------------------ -------- -----------
APEX_ADMINISTRATOR_ROLE        NO       NONE

SQL>

看见?在Apex 4没有APEX_ADMINISTRATOR_READ_ROLE。

所以，我不会像你建议的那样戏剧性地(重新格式化硬盘，重新开始)--相反，升级到Apex5.x要简单得多。

票数 1

页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持

原文链接：

https://stackoverflow.com/questions/53903403

复制

相似问题

问角色'APEX_ADMINISTRATOR_READ_ROLE‘不存在
EN

回答 1

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问角色'APEX_ADMINISTRATOR_READ_ROLE‘不存在EN

回答 1

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问角色'APEX_ADMINISTRATOR_READ_ROLE‘不存在
EN