Slide 1

Slide 1 text

ORDS 22.1: Installs, Upgrades, & Config Distinguished Product Manager [email protected] Jeff Smith Copyright © 2022, Oracle and/or its affiliates | All Rights Reserved.

Slide 2

Slide 2 text

Copyright © 2022, Oracle and/or its affiliates | All Rights Reserved. ORDS 22.1 is all about easier administration 1. Command line interface 2. Configuration directory layout 3. Documentation

Slide 3

Slide 3 text

22.1 is a MAJOR upgrade Copyright © 2022, Oracle and/or its affiliates | All Rights Reserved. • Config files WILL be relocated/changed • The installer/commands are all new • READ the README & DOCS

Slide 4

Slide 4 text

ORDS 3-21.4: java –jar ords.war install ORDS 22.1+ : ords install Copyright © 2022, Oracle and/or its affiliates | All Rights Reserved.

Slide 5

Slide 5 text

ords programs Copyright © 2022, Oracle and/or its affiliates | All Rights Reserved.

Slide 6

Slide 6 text

No more Java 8 1. Java 11 or 2. Java 17 Copyright © 2022, Oracle and/or its affiliates | All Rights Reserved.

Slide 7

Slide 7 text

Config no longer set in WAR file 1. Either include on EVERY ords call--config /path/to/config 2. [PREFERRED] or set environment variable ORDS_CONFIG Copyright © 2022, Oracle and/or its affiliates | All Rights Reserved.

Slide 8

Slide 8 text

Let’s do an install from scratch Copyright © 2022, Oracle and/or its affiliates | All Rights Reserved.

Slide 9

Slide 9 text

Upgrading from v3..v21 22 Copyright © 2022, Oracle and/or its affiliates | All Rights Reserved.

Slide 10

Slide 10 text

Upgrading from v3..v21 22 Copyright © 2022, Oracle and/or its affiliates | All Rights Reserved. ords --config /path/to/new/config install -i --legacy-config /path/to/old/config • --config : where the new configuration can be found • created if necessary • if you leave this out, defaults to CWD • Advice: do NOT put this in the ORDS install directory • -i : interactive • --legacy-config : where the ORDS v3..21.x configdir is • old files left in place, no longer used

Slide 11

Slide 11 text

Once upgrade is finished… Copyright © 2022, Oracle and/or its affiliates | All Rights Reserved.

Slide 12

Slide 12 text

About those config files… Copyright © 2022, Oracle and/or its affiliates | All Rights Reserved.

Slide 13

Slide 13 text

Show me my settings Copyright © 2022, Oracle and/or its affiliates | All Rights Reserved.

Slide 14

Slide 14 text

Mapping Patterns • Before, the first pool was apex_pu – mapped to / • Now, the first pool is ‘default’ – also maps to / • Additional pool names determine the mapping pattern Copyright © 2022, Oracle and/or its affiliates | All Rights Reserved.

Slide 15

Slide 15 text

Pool names are the mapping patterns Copyright © 2022, Oracle and/or its affiliates | All Rights Reserved.

Slide 16

Slide 16 text

Custom Mapping Patterns Copyright © 2022, Oracle and/or its affiliates | All Rights Reserved.

Slide 17

Slide 17 text

Secure Passwords Copyright © 2022, Oracle and/or its affiliates | All Rights Reserved.

Slide 18

Slide 18 text

Safe Keeping in your Wallet Copyright © 2022, Oracle and/or its affiliates | All Rights Reserved.

Slide 19

Slide 19 text

Silent Installs 1. No more parameter files 2. Everything goes onto the command as flags ords --config /path/to/config1 install ^ --db-pool db1 ^ --admin-user SYS ^ --proxy-user ^ --db-hostname localhost ^ --db-port 1521 ^ --db-servicename orcl ^ --log-folder /Users/epaglina/demo/logs << EOF firstpassword secondpassword EOF Copyright © 2022, Oracle and/or its affiliates | All Rights Reserved.

Slide 20

Slide 20 text

1. Installation & Configuration Guide 2. Development Guide Documentation is now 2 Books Copyright © 2022, Oracle and/or its affiliates | All Rights Reserved.

Slide 21

Slide 21 text

Copyright © 2022, Oracle and/or its affiliates | All Rights Reserved.

Slide 22

Slide 22 text

SQL Developer Web Features • OmniSearch • PL/SQL Editor • Open/Save files from OS • Import REST APIs from OpenAPI v2/v3 • Create/Edit Scheduler Jobs, Chains, Schedules, Notifications • PerfHub upgrade Copyright © 2022, Oracle and/or its affiliates | All Rights Reserved.

Slide 23

Slide 23 text

Copyright © 2022, Oracle and/or its affiliates | All Rights Reserved.

Slide 24

Slide 24 text

Copyright © 2022, Oracle and/or its affiliates | All Rights Reserved.

Slide 25

Slide 25 text

Modern Tooling Empowers Users, Increases Productivity Use the right tool for the right job Desktop REST APIs CLI WEB Copyright © 2022, Oracle and/or its affiliates | All Rights Reserved.