USO DE IF EN CRYSTAL REPORT

 Crystal Reports Tutorial Using "If...Then...Else" Statements Business Objects Training Lesson 14.5 (youtube.com)

https://www.youtube.com/watch?v=5aq7o15RuqU

PRIVILEGIOS SDE CREATE GEODATBASE

CREATE USER SDE IDENTIEFIED BY sde112 

PRIVILEGIOS SDE

CREATE USER SDE IDENTIfied BY sde112 

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 ADMINISTER DATABASE TRIGGER TO SDE;

GRANT ALTER ANY INDEX TO SDE;

GRANT ALTER SYSTEM TO SDE;

GRANT CREATE ANY INDEX TO SDE;

GRANT CREATE ANY TRIGGER TO SDE;

GRANT CREATE ANY VIEW TO SDE;

GRANT CREATE INDEXTYPE TO SDE;

GRANT CREATE LIBRARY TO SDE;

GRANT CREATE OPERATOR TO SDE;

GRANT CREATE PROCEDURE TO SDE;

GRANT CREATE PUBLIC SYNONYM TO SDE;

GRANT CREATE SEQUENCE TO SDE;

GRANT CREATE SESSION TO SDE;

GRANT CREATE TABLE TO SDE;

GRANT CREATE TRIGGER TO SDE;

GRANT CREATE TYPE TO SDE;

GRANT CREATE VIEW TO SDE;

GRANT DROP ANY INDEX TO SDE;

GRANT DROP ANY VIEW TO SDE;

GRANT DROP PUBLIC SYNONYM TO SDE;

GRANT INHERIT ANY PRIVILEGES TO SDE;

GRANT SELECT ANY TABLE TO SDE;

GRANT EXECUTE ON DBMS_CRYPTO  TO SDE;

GRANT ADMINISTER DATABASE TRIGGER

GRANT SELECT_CATALOG_ROLE TO SDE; 

ROLES

SELECT_CATALOG_ROLE

true

false

true

PRIVILEGIOS DE PAQUETE

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 dba to sde

 grant dba to sde

ELIMINAR ESQUEMA SDE

 Resuelto: Eliminar SDE - Comunidad de Esri

https://community.esri.com/t5/data-management-questions/remove-sde/td-p/89351

You can "DROP USER SDE CASCADE" IF AND ONLY IF no other user has a table which uses

one of the SDE user's object types (e.g., no tables with an SDE.ST_GEOMETRY column).

If you drop the SDE user while some user references SDE-owned objects, it will cause the
DROP to partially fail, and set up a referential integrity issue within the database instance,

where further attempts to DROP will fail due to missing objects (and attempts to create

a new SDE login will fail due to conflicting objects,...).  The only solution to this is dropping
the database instance and restoring from backup.

The safest procedure would be to drop all the users that had SDE.ST_GEOMETRY at any time,
then recreate the user(s) and restore the non-ST_GEOMETRY table(s).

- V

COMO INSTALAR ORACLAR 19C

 Como instalar Oracle Database 19c y SQL Developer (youtube.com)

https://www.youtube.com/watch?v=_J0XeTsGFTk

INSTANCIAS DE SERVICIOS DE ARCGIS SERVER

 Configurar los ajustes de instancias de servicio—ArcGIS Server | Documentación de ArcGIS Enterprise

https://enterprise.arcgis.com/es/server/latest/administer/windows/configure-service-instance-settings.htm

ACTUALIZAR OPEN_CURSOR GEODATBASE

 https://pro.arcgis.com/es/pro-app/latest/help/data/geodatabases/manage-oracle/update-open-cursors.htm

Actualizar el parámetro open_cursors en geodatabases de Oracle—ArcGIS Pro | Documentación

CREAR CERTIFICADO ARCGIS WEB ADAPTOR

 Configurar ArcGIS Server con un nuevo certificado firmado por una autoridad certificadora—ArcGIS Server | Documentación de ArcGIS Enterprise

https://enterprise.arcgis.com/es/server/latest/administer/windows/configuring-https-using-a-new-ca-signed-certificate.htm#GUID-C9C2C3F8-9376-4433-8952-5C389FF74152

TUTORIAL DE ARCGIS ENTERPRICE BUILDER

 Introducción a ArcGIS Enterprise Builder | Learn ArcGIS

https://learn.arcgis.com/es/projects/get-started-with-arcgis-enterprise-builder/

Al utilizar ArcGIS Enterprice vamos a implementar una instalación Base de Arcgis Enterprice, donde se van a instalar 4 componentes.

LIBRO DE ARCGIS ENTERPRISE

 https://enterprise.arcgis.com/

REQUISITOS DE INSTALACIÓN DE WEB ADAPTOR ANTES DE INSTALAR

 Instalar ArcGIS Web Adaptor—ArcGIS Enterprise | Documentación de ArcGIS Enterprise

https://enterprise.arcgis.com/es/web-adaptor/latest/install/iis/install-arcgis-web-adaptor.htm