nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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

HauTran_Phuoc

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).

create view in new DC (DR old) but can not read it.

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

But can read on new DR (DC old)

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

and can not "register with Geodatabase" on both machine DC & DR

Najděte více příspěvků označených jako

Accepted answers

All comments

George_Thompson

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)?

HauTran_Phuoc

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?

George_Thompson

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.

HauTran_Phuoc

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,

HauTran_Phuoc

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

Van_QuocNguyen

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

Připojte se ke konverzaci

Přihlášení členové mohou přispívat, sledovat aktualizace a další. Jste tu noví? Zaregistrujte si bezplatný účet.

Rychlé odkazy

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.