topic Re: Geodatabase error when switch function between DC & DR (using Data Guard)) in Geodatabase Questions

Geodatabase error when switch function between DC & DR (using Data Guard))

HauTran_Phuoc — Mon, 17 Aug 2020 03:34:01 GMT

Kindly help me,

My Geodatabase is stored on DC (platform Oracle DB ver 12.0.1) and sync with DR (DC to full permission and DR just Read-Only). Now, I switch function between DC & DR (DC -> DR and DR -> DC). After switch, the data on still normal, but when i use Arc Catalog create new "view" on new DC (DR old) i can not read it, but i can read on new DR (DC old), and on both DC DR i can not "register with Geodatabase".

Step 1: create "View" on new DC (DR old) but can not read it (i have Object ID).

Step 2: I can read new "view" on new DR (DC old)

Step 3: Can not "Register with Geodatabase" on both DC & DR

Re: Geodatabase error when switch function between DC & DR (using Data Guard))

George_Thompson — Mon, 17 Aug 2020 11:11:46 GMT

Is the database an Enterprise Geodatabase?

Can you create a feature dataset in the Oracle DB"s (as a test)?

What version of ArcMap are you using?

I am not sure about the switching behavior, if they are the same then it should work. Can you add the layer to a new map and see the data (outside the preview window)?

Re: Geodatabase error when switch function between DC & DR (using Data Guard))

HauTran_Phuoc — Tue, 18 Aug 2020 02:37:21 GMT

Hi Thompson,

Yes, it's Enterprise Geodatabase.

I can created a feature dataset in Enterprise Geodatabase (OracleDB).

I use the ArcMap version 10.2.1 (i also tried version 10.7.1 but still it doesn't work)

Geodatabase does not understand permissions after switch DC&DR, do i need any configuration on the geodatabase?

Re: Geodatabase error when switch function between DC & DR (using Data Guard))

George_Thompson — Tue, 18 Aug 2020 11:16:51 GMT

I would make sure that the permissions on both the DC & DR Enterprise Geodatabase's are the same. There may be something that is not carried over correctly. Privileges for geodatabases in Oracle—Geodatabases in Oracle | Documentation

Make sure your Enterprise Geodatabase is upgraded to at least 10.5 or newer. That is when the Register with Geodatabase functionality was added.

What is the current version of the Oracle Enterprise Geodatabase? Look in the SDE VERSION table.

You may want to work with technical support on this also.

Re: Geodatabase error when switch function between DC & DR (using Data Guard))

HauTran_Phuoc — Wed, 19 Aug 2020 04:04:16 GMT

Hi Thompson,

The permissions on both the DC & DR the same.

Current version of Oracle Geodatabase is 10.2.1, i will try upgrade to 10.5 or newer.

i will report the results to you.

thanks,

Re: Geodatabase error when switch function between DC & DR (using Data Guard))

HauTran_Phuoc — Wed, 19 Aug 2020 08:16:27 GMT

Hi Thompson,

"There may be something that is not carried over correctly. Privileges for geodatabases in Oracle—Geodatabases in Oracle | Documentation"

=> i has check install document when i deploy:

GRANT EXECUTE ON DBMS_LOCK TO PUBLIC;
GRANT EXECUTE ON DBMS_LOB TO PUBLIC;
GRANT EXECUTE ON DBMS_UTILITY TO PUBLIC;
GRANT EXECUTE ON DBMS_SQL TO PUBLIC;
GRANT EXECUTE ON UTL_RAW TO PUBLIC;
GRANT EXECUTE ON DBMS_CRYPTO TO SDE;
ALTER USER SDE QUOTA UNLIMITED ON SDE;
GRANT CREATE SESSION TO SDE;
GRANT CREATE TABLE TO SDE;
GRANT CREATE TRIGGER TO SDE;
GRANT CREATE SEQUENCE TO SDE;
GRANT CREATE PROCEDURE TO SDE;
GRANT CREATE INDEXTYPE TO SDE;
GRANT CREATE LIBRARY TO SDE;
GRANT CREATE OPERATOR TO SDE;
GRANT CREATE PUBLIC SYNONYM TO SDE;
GRANT CREATE TYPE TO SDE;
GRANT CREATE VIEW TO SDE;
GRANT DROP PUBLIC SYNONYM TO SDE;
GRANT ADMINISTER DATABASE TRIGGER TO SDE;
GRANT UNLIMITED TABLESPACE TO SDE;
GRANT ALTER SYSTEM TO SDE;
GRANT SELECT_CATALOG_ROLE TO SDE;

And check now:

"SELECT
*
FROM
DBA_SYS_PRIVS where GRANTEE='SDE'"

PRIVILEGE
INHERIT ANY PRIVILEGES
CREATE TABLE
UNLIMITED TABLESPACE
CREATE LIBRARY
CREATE OPERATOR
CREATE VIEW
CREATE TYPE
ALTER SYSTEM
CREATE TRIGGER
CREATE PUBLIC SYNONYM
CREATE SESSION
SELECT ANY DICTIONARY
ADMINISTER DATABASE TRIGGER
CREATE INDEXTYPE
CREATE PROCEDURE
CREATE SEQUENCE
DROP PUBLIC SYNONYM

Here are information I update to you

Re: Geodatabase error when switch function between DC & DR (using Data Guard))

Van_QuocNguyen — Mon, 14 Sep 2020 08:58:14 GMT

Hi bros,

We work with the ESRI's local technical but till now this issue can't resolve.

So the next step, how can we do it? Escalate to the ESRI global support or anything else?

Please advice us

Thank you in advance

Quoc

Re: Geodatabase error when switch function between DC & DR (using Data Guard))

George_Thompson — Mon, 14 Sep 2020 09:50:35 GMT

I would ask if the local technical support has or can reach out to Esri Inc. based support.

Re: Geodatabase error when switch function between DC & DR (using Data Guard))

Van_QuocNguyen — Tue, 15 Sep 2020 04:10:43 GMT

Hi bros,

Today, We worked with the customer, They told with us the process how to active the enterprise geodatabase as below:

Step 1:

Create new database

Step 2:

Create the tablespace for owner user.

Ex:

create tablespace sde datafile '+DATA' size 1G autoextend on next 10M maxsize unlimited logging extent management local segment space management auto;

Step 3:

Create the SDE user

Ex:

create user sde identified by xxxxxxx default tablespace sde temporary tablespace temp;

Step 4:

Grant sde user as below:

GRANT EXECUTE ON DBMS_PIPE TO PUBLIC;

GRANT EXECUTE ON DBMS_LOCK TO PUBLIC;

GRANT EXECUTE ON DBMS_LOB TO PUBLIC;

GRANT EXECUTE ON DBMS_UTILITY TO PUBLIC;

GRANT EXECUTE ON DBMS_SQL TO PUBLIC;

GRANT EXECUTE ON UTL_RAW TO PUBLIC;

GRANT EXECUTE ON DBMS_CRYPTO TO SDE;

ALTER USER SDE QUOTA UNLIMITED ON SDE;

GRANT CREATE SESSION TO SDE;

GRANT CREATE TABLE TO SDE;

GRANT CREATE TRIGGER TO SDE;

GRANT CREATE SEQUENCE TO SDE;

GRANT CREATE PROCEDURE TO SDE;

GRANT CREATE INDEXTYPE TO SDE;

GRANT CREATE LIBRARY TO SDE;

GRANT CREATE OPERATOR TO SDE;

GRANT CREATE PUBLIC SYNONYM TO SDE;

GRANT CREATE TYPE TO SDE;

GRANT CREATE VIEW TO SDE;

GRANT DROP PUBLIC SYNONYM TO SDE;

GRANT ADMINISTER DATABASE TRIGGER TO SDE;

GRANT UNLIMITED TABLESPACE TO SDE;

GRANT ALTER SYSTEM TO SDE;

GRANT SELECT_CATALOG_ROLE TO SDE;

GRANT INHERIT ANY PRIVILEGES TO SDE;

GRANT CREATE ANY VIEW,

CREATE ANY TRIGGER,

CREATE ANY INDEX,

CREATE TYPE,

CREATE TABLE,

CREATE INDEXTYPE,

CREATE LIBRARY,

CREATE PUBLIC SYNONYM,

CREATE OPERATOR,

SELECT ANY TABLE,

DROP ANY VIEW,

DROP ANY INDEX,

DROP PUBLIC SYNONYM,

ALTER ANY INDEX,

ADMINISTER DATABASE TRIGGER,

CREATE SESSION,

CREATE TRIGGER,

CREATE PROCEDURE,

CREATE VIEW,

CREATE SEQUENCE

TO SDE;

Step 5:

Copy and Import Schema Active GEO - ORACLE 12C
impdp system/xxxxxxx@GISINS directory=DUMP dumpfile=GISTEST_SDE_EXP.dmp logfile=GISTEST_DP1.log full=y cluster=n;

ALTER VIEW SDE.GDB_ITEMS_VW COMPILE;

ALTER VIEW SDE.GDB_ITEMRELATIONSHIPS_VW COMPILE;

Step 6:

Check Schema import

select object_name from dba_objects where status <> 'VALID' and owner = 'SDE';

Our customer was using this solution as the ESRI's advise because They couldn't activate the enterprise geodatabse through the ArcMap application.

Here is the schema file.

12C_Schema.zip - Google Drive