Apex solutions - Oracle Cloud
0 likes240 views
Were the only company that says, hey, what you run in the cloud and what you run on premises should be compatible so that you can push a button and move a workload from your private cloud to the Oracle public cloud and back again, or you can do development tests in the public cloud and do production in your private cloud on premises if you want to, Larry Ellison said
![PRSTUP K
APLIKCIM
http://database-trialaejm.db.us1.oraclecloudapps.com/apex/f?p=100082
Nie je mo転n辿 zvoli泥 vlastn炭 dom辿nu
Presmerovanie vytvori泥 na vlastnom hardware
Redirect pomocou Mod_rewrite
- RewriteEngine On RewriteRule /(.*) http://database-
trialaejm.db.us1.oraclecloudapps.com/apex/f?p=100082 [R=301]](https://image.slidesharecdn.com/apexsolutionscloudseminar-150628153652-lva1-app6891/85/Apex-solutions-Oracle-Cloud-11-320.jpg)
Apex solutions - Oracle Cloud
- 1. V PRAZE, 9-6-2015APEX 5.0 SEMIN APEX A 禽粥意粥京舘掘 V CLOUDU
- 2. 禽粥意粥京舘掘
- 3. MO貼NOSTI DB V CLOUDU DB 11g alebo 12c predin邸talovan叩 DB pln箪 pr鱈stup k DB root pr鱈stup k OS SQL*Net access Automatizovan箪 backup DB ako service / virtual image DB schema 1x sch辿ma na Oracle DB 11g Enterprise edition 2 - 50 GB v DB APEX 4.2 Data cez RESTful WS DB spravovan叩 v Oracle - bez DBA pr鱈stupu
- 4. DB SCHMA
- 5. POVOLEN DB OPERCIE CREATE TABLE CREATE INDEX CREATE VIEW CREATE PROCEDURE CREATE PACKAGE CREATE FUNCTION CREATE SEQUENCE CREATE TRIGGER CREATE SESSION CREATE DIMENSION CREATE INDEXTYPE CREATE OPERATOR CREATE TYPE
- 6. CREATE CLUSTER CREATE JOB - pou転i泥 CLOUD_SCHEDULER CREATE MATERIALIZED VIEW CREATE SNAPSHOT CREATE SYNONYM CREATE JAVA CREATE ROLE CREATE DIRECTORY CREATE TABLESPACE CREATE SYNONYM CREATE DATABASE LINK - Parallel nie je podporovan箪 NEPOVOLEN DB OPERCIE
- 7. DAL VLASTNOSTI Zoznam povolen箪ch syst辿mov箪ch PL/SQL packages alebo typov je v dokument叩cii: http://docs.oracle.com/cloud/latest/dbcs_schema/CSDBU/GUID-EDE1F644- DB55-4D3C-A87B-4E5F7A610E75.htm#CSDBU265 Joby na pozad鱈 - 10 de鍖novan箪ch pomocou CLOUD_SCHEDULER - 5 be転iacich alebo napl叩novan箪ch v jednom ase 5000 e-mailov za 24 hod鱈n Nie je integrovan箪 BI Publisher Webov辿 slu転by iba cez HTTPS alebo SSL - 50 certi鍖kan箪ch autorit upload max. 100 MB s炭bory cez APEX Workshop time zone - UTC +0 - BEGIN APEX_UTIL.SET_SESSION_TIME_ZONE( P_TIME_ZONE => '+02:00'); END;
- 8. APEX
- 9. APEX APLIKCIA = SQL METADATA Nepo鱈taj炭 sa do DB quoty Neobmedzen辿 mno転stvo aplik叩cii vo Workspace Automatizovan箪 backup pomocou packaged application APEX Application Archive - backupovan辿 data sa po鱈taj炭 do DB quoty
- 10. PRSTUP K DB OBJEKTOM POMOCOU SQL DEVELOPERU Pr鱈stup cez RESTful a SFTP User management pre RESTful pr鱈stup v APEXe - Administration - Users and groups - Require change password - NO - User Group - SQL Developer
- 11. PRSTUP K APLIKCIM http://database-trialaejm.db.us1.oraclecloudapps.com/apex/f?p=100082 Nie je mo転n辿 zvoli泥 vlastn炭 dom辿nu Presmerovanie vytvori泥 na vlastnom hardware Redirect pomocou Mod_rewrite - RewriteEngine On RewriteRule /(.*) http://database- trialaejm.db.us1.oraclecloudapps.com/apex/f?p=100082 [R=301]
- 12. PRSTUP K APLIKCIM Maskovanie pomocou mod_proxy - ProxyRequests O鍖 - <Proxy *> - Order deny,allow - Allow from all - </Proxy> - ProxyPass /apex http://cloud.oracle.com/apex - ProxyPassReverse /apex http://cloud.oracle.com/apex - ProxyPass /i http://cloud.oracle.com/i - ProxyPassReverse /i http://cloud.oracle.com/i - RewriteRule ^/$ https://%{HTTP_HOST}/apex/f?p=100082
- 13. MIGRCIA APEXOVEJ APLIKCIE DO CLOUDU Export / import aplik叩ci鱈 Export / import workspace Export / import DDL Statick辿 s炭bory na disku Export type - full - SQL scripty - hist坦ria SQL dotazov - ulo転en辿 SQL - u転ivate直sk辿 nastavenia - hist坦ria pr鱈stupov developerov - log odoslan箪ch emailov - user interface nastavenia Kam s nimi?
- 14. 禽楢悪雨干掘珂掘