How to upgrade to Oracle Database 19c from 18c on Linux with autoupgrade tool

Following, the steps to upgrade from Oracle Database 18c to new Oracle Database 19c (version 19.3)  

During the upgrade, the database can’t provide any service because will be open with “upgrade” option. Ensure to have a database backup before apply the upgrade. 

Autoupgrade is a new oracle tool to upgrade database automatically. 

We used an an Oracle Linux 7.6 environment.

#STEP1: Download Oracle Database 19.3 release
https://download.oracle.com/otn/linux/oracle19c/190000/LINUX.X64_193000_db_home.zip

#STEP2: Install the software
sudo yum -y install oracle-database-preinstall-19c.x86_64
Plugin abilitati:langpacks, ulninfo
Risoluzione dipendenze
--> Esecuzione del controllo di transazione
---> Pacchetto oracle-database-preinstall-19c.x86_64 0:1.0-1.el7 settato per essere installato
--> Risoluzione delle dipendenze completata

Dipendenze risolte
Installazione:
 oracle-database-preinstall-19c    

Install  1 Pacchetto
Dimensione totale del download: 18 k
Dimensione installata: 55 k
Downloading packages:
oracle-database-preinstall-19c-1.0-1.el7.x86_64.rpm                                                                            |  18 kB  00:00:04     
Running transaction check
Running transaction test
Transaction test succeeded
Running transaction
  Installazione     : oracle-database-preinstall-19c-1.0-1.el7.x86_64                                                                             1/1 
  Verifica in corso : oracle-database-preinstall-19c-1.0-1.el7.x86_64                                                                             1/1 

Installato:
  oracle-database-preinstall-19c.x86_64 0:1.0-1.el7                                                                                                   

Completo!

=>Open Linux Desktop or setting X11<=
mkdir /oracle/product/19
cd /oracle/product/19
unzip /media/sf_Downloads/LINUX.X64_193000_db_home.zip -d /oracle/product/19
export ORACLE_HOME=/oracle/product/19
./runInstaller




Read moreHow to upgrade to Oracle Database 19c from 18c on Linux with autoupgrade tool

How to install Apex 18.1 to Oracle Database 18.3 on Linux

Following, the step to install Apex 18.1 to Oracle Database 18.3 on Oracle Linux 7.5.

#STEP1: Download Apex 18.1
http://download.oracle.com/otn/java/appexpress/apex_18.1.zip

#STEP2: Verify & Check Apex Installed 

sqlplus / as sysdba
SQL*Plus: Release 18.0.0.0.0 - Production on Dom Set 16 16:49:52 2018
Version 18.3.0.0.0

Copyright (c) 1982, 2018, Oracle. All rights reserved.

Connesso a:
Oracle Database 18c Enterprise Edition Release 18.0.0.0.0 - Production
Version 18.3.0.0.0

SQL> SELECT STATUS, VERSION FROM DBA_REGISTRY WHERE COMP_ID = 'APEX';

STATUS VERSION
-------------------------------------------- ------------------------------
VALID 5.1.1.00.08

 

Read moreHow to install Apex 18.1 to Oracle Database 18.3 on Linux

How to upgrade to Oracle Database 18c from 12c on Linux

Following, the step to upgrade an Oracle Database 12c to a new Oracle Database 18c (version 18.3)  

During the upgrade, the database can’t provide any service because will be open with “upgrade” option. Ensure to have a database backup before apply the upgrade. 

We are used an an Oracle Linux 7.5 environment.

#STEP1: Download Oracle Database 18.3 release
https://www.oracle.com/technetwork/database/enterprise-edition/downloads/oracle18c-linux-180000-5022980.html

#STEP2: Install the software 
Open Linux Desktop or setting X11
mkdir /oracle/product/18
cd /oracle/product/18
unzip LINUX.X64_180000_db_home.zip
export ORACLE_HOME=/oracle/product/18
./runInstaller




Read moreHow to upgrade to Oracle Database 18c from 12c on Linux

Activating and using debug in SQLDeveloper

Before to use debug in SQLDeveloper we need to prepare the database to accept this request and we need to add grants to the user that activate a debug.

Preparing database environments:

create role SQLDEV_DEBUG_ROLE;

begin
 dbms_network_acl_admin.append_host_ace(host=>'*', 
                                        ace=> sys.xs$ace_type(privilege_list=>sys.XS$NAME_LIST('JDWP') , 
                                        principal_name=>'SQLDEV_DEBUG_ROLE', 
                                        principal_type=>sys.XS_ACL.PTYPE_DB) );
end;
/

grant debug connect session to SQLDEV_DEBUG_ROLE; 
grant debug any procedure to SQLDEV_DEBUG_ROLE;
grant execute on DBMS_DEBUG_JDWP to SQLDEV_DEBUG_ROLE;

grant SQLDEV_DEBUG_ROLE to scott;

--to Check
select * from dba_network_acls;
select * from dba_network_acl_privileges;
select host from dba_host_acls;

--Check firewall port from 4000 and 4199 (in both direction client/server)

Output example from SQLDeveloper:

Read moreActivating and using debug in SQLDeveloper