Oracle Database 19c

https://docs.oracle.com/en/database/oracle/oracle-database/19/
Admin
Oracle Database 19c is a comprehensive relational database management system providing robust...
Tokens:16,820,193
Snippets:105,491
Trust Score:9.7
Update:1 week ago
Show doc for...
Tokens:
Raw
### Start Oracle Universal Installer using setup.exe

Source: https://docs.oracle.com/en/database/oracle/oracle-database/19/appcw/appc-gateway-installation.html

Execute the setup program from the installation media directory to begin the Oracle Universal Installer.

```shell

Copy
D:\Disk1\setup.exe

```

--------------------------------

### Run setup.exe syntax for response file configuration

Source: https://docs.oracle.com/en/database/oracle/oracle-database/19/cwwin/configuring-the-software-binaries-using-a-response-file.html

Syntax for starting Oracle Universal Installer in Grid Setup Wizard mode using a response file.

```shell
Grid_home\setup.exe [-debug] [-silent -responseFile filename]
```

--------------------------------

### Begin application installation syntax

Source: https://docs.oracle.com/en/database/oracle/oracle-database/19/multi/administering-application-containers-with-sql-plus.html

Starts the installation of an application in the application root.

```sql

Copy
ALTER PLUGGABLE DATABASE APPLICATION application_name BEGIN INSTALL 'application_version_number';

```

--------------------------------

### Run runInstaller from installation media

Source: https://docs.oracle.com/en/database/oracle/oracle-database/19/hpcli/running-oracle-universal-installer-to-install-oracle-database-client.html

Starts the Oracle setup wizard directly from the installation media path.

```bash
/dev/dvd-rw/media/runInstaller

```

--------------------------------

### Begin application installation

Source: https://docs.oracle.com/en/database/oracle/oracle-database/19/multi/administering-application-containers-with-sql-plus.html

Starts the installation process for version 1.0 of the application in the master application root.

```sql

Copy
ALTER PLUGGABLE DATABASE APPLICATION sampleapp BEGIN INSTALL '1.0';

```

--------------------------------

### Start Oracle Setup Wizard with runInstaller

Source: https://docs.oracle.com/en/database/oracle/oracle-database/19/axcli/running-oracle-universal-installer-to-install-oracle-database-client.html

Log in as the oracle user and run runInstaller from the directory containing the downloaded installation binaries (Oracle home directory). Do not run runInstaller from $ORACLE_HOME/oui/bin/ or symlinked paths.

```shell
$ cd /home/oracle_sw/
$ ./runInstaller
```

--------------------------------

### Run runInstaller to Start Oracle Database Client Setup Wizard

Source: https://docs.oracle.com/en/database/oracle/oracle-database/19/axcli/installing-database-client-using-image-files.html

Launches the client installation wizard directly from the Oracle home directory. Do not use runInstaller binaries residing in other locations.

```bash
$ cd /u01/app/oracle/product/19.0.0/client_1
$ ./runInstaller
```

--------------------------------

### Begin application installation in application root

Source: https://docs.oracle.com/en/database/oracle/oracle-database/19/multi/administering-application-containers-with-sql-plus.html

Starts an application installation session for version 1.0 of the application.

```sql
ALTER PLUGGABLE DATABASE APPLICATION salesapp BEGIN INSTALL '1.0';
```

--------------------------------

### Begin installation of salesapp version 4.2

Source: https://docs.oracle.com/en/database/oracle/oracle-database/19/multi/administering-application-containers-with-sql-plus.html

Example statement to begin installing the 'salesapp' application at version '4.2'.

```sql

Copy
ALTER PLUGGABLE DATABASE APPLICATION salesapp BEGIN INSTALL '4.2';

```

--------------------------------

### Begin Application Upgrade Example

Source: https://docs.oracle.com/en/database/oracle/oracle-database/19/multi/administering-application-containers-with-sql-plus.html

Example of starting an upgrade for the 'salesapp' application from version 4.2 to 4.3.

```sql
ALTER PLUGGABLE DATABASE APPLICATION salesapp BEGIN UPGRADE 
  '4.2' TO '4.3';
```

--------------------------------

### Launch gridSetup.sh for software-only installation with patches

Source: https://docs.oracle.com/en/database/oracle/oracle-database/19/ssdbi/switch-gi-home-patching.html

Start the Oracle Grid Infrastructure installer with optional -applyRU or -applyOneOffs flags to apply updates during installation.

```bash
$ /u01/app/oracle/product/19.17.0/grid/gridSetup.sh [-applyRU patch_directory_location]
[-applyOneOffs comma_separated_list_of_patch_directory_locations]
```

--------------------------------

### Demo Examples Directory Path

Source: https://docs.oracle.com/en/database/oracle/oracle-database/19/spatl/spatial-concepts.html

Specifies the filesystem path where demo files and OCI examples are installed from the Oracle Database Examples media.

```shell
$ORACLE_HOME/md/demo/examples
```

--------------------------------

### Start Oracle Grid Infrastructure installer using gridSetup.sh

Source: https://docs.oracle.com/en/database/oracle/oracle-database/19/cwaix/installing-oracle-domain-services-cluster.html

Launches the Oracle Grid Infrastructure installer to begin cluster configuration.

```bash
/u01/app/19.0.0/grid/gridSetup.sh
```

--------------------------------

### Launch Oracle Grid Infrastructure setup wizard

Source: https://docs.oracle.com/en/database/oracle/oracle-database/19/uporw/upgrading-oracle-restart.html

Run setup.exe from the newly created Grid home to start the Oracle Grid Infrastructure upgrade wizard.

```bat
C:\> C:\app\grid\product\19.0.0\grid\setup.exe
```

--------------------------------

### Start gridSetup.sh to perform software-only installation with patches

Source: https://docs.oracle.com/en/database/oracle/oracle-database/19/upgor/switch-gi-home-patching.html

Executes gridSetup.sh with optional flags to apply Release Updates (RUs) or one-off patches during software installation.

```shell
 $ /u01/app/oracle/product/19.17.0/grid/gridSetup.sh [-applyRU patch_directory_location]
[-applyOneOffs comma_separated_list_of_patch_directory_locations]

```

--------------------------------

### Run runInstaller from Oracle Home

Source: https://docs.oracle.com/en/database/oracle/oracle-database/19/ssdbi/running-oracle-universal-installer-to-install-oracle-database.html

Starts the Oracle Database Setup Wizard from the Oracle home directory. Must be executed directly from the Oracle home directory rather than other locations like $ORACLE_HOME/oui/bin/.

```bash
$ cd /u01/app/oracle/product/19.0.0/dbhome_1
$ ./runInstaller
```

--------------------------------

### Example 3-19 Configuration with Deployment Delays and Refresh Rates

Source: https://docs.oracle.com/en/database/oracle/oracle-database/19/upgrd/autoupgrade-configuration-file-examples.html

Configures an unplug-plug relocate upgrade for a non-CDB and a PDB with staggered start times and file refresh rates.

```ini
global.autoupg_log_dir=/home/oracle/xupg 
#database1
upg1.sid=cdb18x 
upg1.target_cdb=cdb19x 
upg1.source_home=/databases/ee/product/18x/dbhome_1 
upg1.target_home=/databases/ee/product/19x/dbhome_1 
upg1.pdbs=pdbx 
upg1.target_pdb_name.pdbx=pdbxr 
upg1.target_pdb_copy_option.pdbx=file_name_convert=('pdbx', 'pdbxr') 
upg1.source_dblink.pdbx=pdbxcdb18x_link 600 
upg1.start_time=+3h 
#database2 
upg2.sid=db18x 
upg2.target_cdb=cdb19x 
upg2.source_home=/databases/ee/product/18x/dbhome_1 
upg2.target_home=/databases/ee/product/19x/dbhome_1 
upg2.target_pdb_copy_option.db18x=file_name_convert=('DB18X', 'db18x') 
upg2.source_dblink.db18x=db18x_link 900 
upg2.target_pdb_name.db18x=db18x 
upg2.start_time=+3h30m
```

--------------------------------

### Start instance and mount and open database with SQL*Plus

Source: https://docs.oracle.com/en/database/oracle/oracle-database/19/admin/starting-up-and-shutting-down.html

Starts an instance, reads initialization parameters from the default location, and mounts and opens the database for normal operation.

```sql
STARTUP
```

--------------------------------

### Start SQL*Plus and Start the Target Oracle Database Instance

Source: https://docs.oracle.com/en/database/oracle/oracle-database/19/upgrd/migrating-data-after-upgrade-oracle.html

Starts SQL*Plus as SYSDBA and starts up the new Oracle Database instance in the new environment.

```sql
$ SQLPLUS / AS SYSDBA
SQL> STARTUP
```

--------------------------------

### Execute setup.exe with grid_setup.rsp response file

Source: https://docs.oracle.com/en/database/oracle/oracle-database/19/cwwin/configuring-the-software-binaries-using-a-response-file.html

Example commands to navigate to the Grid home and run setup.exe specifying a response file path.

```shell
C:\> cd Grid_home
C:\> setup.exe -responseFile C:\app\19.0.0\grid\response\grid_setup.rsp
```

--------------------------------

### Launch Oracle Grid Infrastructure Setup Wizard with gridSetup.bat

Source: https://docs.oracle.com/en/database/oracle/oracle-database/19/cwwin/upgrading-oracle-grid-infrastructure-from-an-earlier-release.html

Executes the Oracle Grid Infrastructure installer from the new Grid home to start the setup wizard and initiate the upgrade.

```bat
Grid_home\gridSetup.bat
```

--------------------------------

### Start Database Using srvctl

Source: https://docs.oracle.com/en/database/oracle/oracle-database/19/upgrd/manual-upgrade-scenarios-multitenant-architecture-oracle-databases.html

Starts up the upgraded database using Server Control (srvctl).

```bash
srvctl start database -db db-unique-name

```

--------------------------------

### Launch Oracle Grid Infrastructure setup wizard with gridSetup.sh

Source: https://docs.oracle.com/en/database/oracle/oracle-database/19/axdbi/installing-oracle-grid-infrastructure-for-a-standalone-server-with-a-new-database-installation.html

Starts the setup wizard to configure Oracle Restart and Oracle ASM. The gridSetup.sh command can also be supplied with -applyRU and -applyOneOffs options to apply patches during installation.

```shell
$ Grid_home/gridSetup.sh
```

--------------------------------

### Complete Installation with setup.exe and Response File

Source: https://docs.oracle.com/en/database/oracle/oracle-database/19/cwwin/continuing-incomplete-installations-on-first-nodes.html

Execute setup.exe with executeConfigTools and provide the response file to complete the configuration.

```bat
C:\> cd app\19.0.0\grid\
setup.exe --executeConfigTools -gridinstall.rsp CRS_home/install/response/gridinstall.rsp
```

--------------------------------

### Launch runInstaller with -applyRU Flag

Source: https://docs.oracle.com/en/database/oracle/oracle-database/19/axdbi/installing-seha-on-oracle-acfs.html

Starts the Oracle Database Setup Wizard from the Oracle home directory while applying Release Update 19.13 or later during installation.

```bash
$ ./runInstaller -applyRU patch_directory_location/patch_ID


```

--------------------------------

### Start up and open database with STARTUP

Source: https://docs.oracle.com/en/database/oracle/oracle-database/19/bradv/user-managed-recovery-advanced.html

Starts an instance and mounts and opens the database after restoring missing control files.

```sql
SQL> STARTUP
```

--------------------------------

### Start installer and apply Release Update with runInstaller

Source: https://docs.oracle.com/en/database/oracle/oracle-database/19/axdbi/installing-seha-on-local-file-system.html

Execute runInstaller with the -applyRU option from the Oracle home directory to launch the Oracle Database Setup Wizard and apply Release Update 19.13 or later.

```shell
$ ./runInstaller -applyRU patch_directory_location/patch_ID
```

--------------------------------

### Launch Grid Infrastructure setup wizard

Source: https://docs.oracle.com/en/database/oracle/oracle-database/19/cwwin/completing-failed-installations-and-upgrades.html

Starts the setup wizard. Once running, select 'Add more nodes to the cluster' to follow the steps for adding nodes.

```bat
C:\>cd Grid_home\setup.exe
```

--------------------------------

### Display Oracle Universal Installer Help Options

Source: https://docs.oracle.com/en/database/oracle/oracle-database/19/ntcli/running-oracle-universal-installe-using-the-response-file.html

Runs setup.exe with the -help option to view the full set of installer command-line options. Execute this from a command prompt opened with Administrator privileges.

```bat
DRIVE_LETTER:\setup.exe_location setup -help
```

--------------------------------

### Get previous shape point measure example

Source: https://docs.oracle.com/en/database/oracle/oracle-database/19/spatl/SDO_LRS-reference.html

Returns the measure value of the closest shape point before measure 14 on Route 1. Returns null if the specified measure identifies the segment start point.

```sql
SELECT SDO_LRS.GET_PREV_SHAPE_PT_MEASURE(a.route_geometry, 14)
   FROM lrs_routes a WHERE a.route_id = 1;

SDO_LRS.GET_PREV_SHAPE_PT_MEASURE(A.ROUTE_GEOMETRY,14)                          
------------------------------------------------------                          
                                                    12
```

--------------------------------

### List Distributed openUTM Example Files

Source: https://docs.oracle.com/en/database/oracle/oracle-database/19/dfsig/database-applications.html

Example procedures and programs installed in the installation user ID for openUTM integration.

```text

Copy
UTM.DEMO.P.COMPILE.C
UTM.DEMO.P.COMPILE.COBOL
UTM.DEMO.P.KDCDEF
UTM.DEMO.P.KDCROOT
UTM.DEMO.P.PROBIND
UTM.DEMO.P.PROSTRT
UTM.DEMO.CSELEMP.PC
UTM.DEMO.SELDEP.PCO
UTM.DEMO.SELEMP.PCO
UTM.DEMO.UPDEMP.PCO
UTM.DEMO.ERRSQL.C
UTM.DEMO.ERRTXT.C

```

--------------------------------

### Display Oracle Universal Installer help options

Source: https://docs.oracle.com/en/database/oracle/oracle-database/19/otgiw/gateway-response-files.html

Runs setup.exe with the -help option from the oui\bin directory to display available command options.

```shell
C:\ORACLE_BASE\ORACLE_HOME\oui\bin> setup.exe -help
```

--------------------------------

### Preview az_setup.jar parameters

Source: https://docs.oracle.com/en/database/oracle/oracle-database/19/bradv/azure-sbt-module.html

Run the setup tool JAR without arguments to view available parameter options.

```shell

Copy
$ java -jar az_setup.jar

```

--------------------------------

### Start Specific Listener Example

Source: https://docs.oracle.com/en/database/oracle/oracle-database/19/admin/configuring-automatic-restart-of-an-oracle-database.html

Starts an individual listener named listener using srvctl start listener.

```shell
srvctl start listener -listener listener
```

--------------------------------

### Start Oracle Database software installation with setup.exe

Source: https://docs.oracle.com/en/database/oracle/oracle-database/19/riwin/installing-oracle-rac-and-oracle-rac-one-node-database-software.html

Run setup.exe directly from the Oracle home directory where the database installation files were extracted.

```bat
cd C:\app\oracle\product\19.0.0\dbhome_1
setup.exe
```
Tokens:
Raw