Migration Oracle Database 11g to 19c (CDB)

    Moving from Oracle Database 11g to 19c (CDB) might be challenging, but with the appropriate knowledge and direction, it can be a straightforward procedure. This article offers a thorough tutorial to assist you in upgrading your Oracle Database 11g to 19c (CDB).

Are you considering upgrading from Oracle Database 11g to 19c (CDB)? If so, a thorough understanding of the procedure is required to guarantee a smooth upgrading. This article offers a thorough tutorial on how to smoothly upgrade your Oracle Database 11g to 19c (CDB).

 

  A Complete Guide on Upgrading from Oracle Database 11g to 19c

                                                Are you still using Oracle Database 11g for your database? It's time to update it to Oracle Database 19c (CDB), the most recent version, in order to benefit from new features, improved security, and improved speed. The transition from Oracle Database 11g to Oracle Database 19c (CDB) might be challenging, but with the correct information and direction, it can be a straightforward procedure. This article offers a thorough tutorial to assist you in upgrading your Oracle Database 11g to 19c (CDB).

There are a few things you should take into account before you start the update process:

Make sure your system and software fit Oracle Database 19c's hardware and software requirements (CDB).

Verify your existing Oracle Database 11g's compatibility with Oracle Database 19c (CDB). Verify that the new version is compatible with all the applications that use the database.

Backup: Create a copy of your current database before you start the upgrade procedure. In the event that the upgrade procedure fails, this will assist you in restoring the database.

Testing: Prior to upgrading the production system, it is generally desirable to carry out a test upgrade on a test system. This will assist you in locating any problems that might occur throughout the update procedure.

After giving these things some thought, let's go on to the upgrade procedure.

Upgrade Oracle Database 11g to 12c as the first step

Upgrade your Oracle Database from 11g to 12c is the first step in moving to Oracle Database 19c (CDB). Because Oracle Database 19c (CDB) requires Oracle Database 12c Release 2 (12.2.0.1) or later versions, this step is crucial. The following stages are involved in upgrading Oracle Database 11g to Oracle Database 12c:

Install Oracle Database 12c Release 2 (12.2.0.1) or a later version by downloading it.

Make a backup of the database.

Using the command-line interface or the Database Upgrade Assistant (DBUA), upgrade the database (CLI).

Do post-upgrade duties, such as recompiling broken objects using the utlrp.sql script.

Upgrade Oracle Database 12c to 19c in step two (CDB)

The next stage is to upgrade to Oracle Database 19c after you have upgraded your Oracle Database 11g to 12c (CDB). The following steps are part of the upgrade process:

Install Oracle Database 19c by downloading it (CDB).

Make an Oracle Database 12c backup.

Use the DBUA or CLI to upgrade the database.

run the utlrp.sql script and other post-upgrade actions.

Looking forward to your suggestions.. please feel free to write to me.. Your help would definitely help to improve our blog. Chetan Yadav

Upgrade from Oracle Database 11g to 19c (Non-CDB)

                     Upgrading your Oracle database is a crucial task that ensures your system is up-to-date and functioning properly. Oracle Database 19c is the latest version of the database software that offers many new features and improvements over its predecessors. In this blog, we will discuss how to upgrade from Oracle Database 11g to 19c (Non-CDB).

Before starting the upgrade process, it is essential to perform a thorough backup of your existing database. This will help you recover your data in case of any issues during the upgrade process. Once you have backed up your data, you can proceed with the following steps:

Step 1: Pre-Upgrade Tasks

Before upgrading to 19c, you need to perform some pre-upgrade tasks. These tasks include:

Checking the minimum requirements for the Oracle Database 19c installation.

Gathering information about the existing database, such as the version, patch level, and configuration details.

Ensuring that the existing database is compatible with 19c. You can use the pre-upgrade information tool to check for compatibility issues.

Resolving any compatibility issues that may be identified by the pre-upgrade information tool.

Step 2: Install Oracle Database 19c Software

Download and install the Oracle Database 19c software on your server. Ensure that you install the software for the same platform as the existing database.

Step 3: Upgrade the Database

To upgrade the database, follow these steps:

Connect to the existing database as a privileged user.

Start the Database Upgrade Assistant (DBUA) utility.

The DBUA will guide you through the upgrade process, including the upgrade options and parameters.

Once the upgrade process is complete, verify the upgraded database's functionality.

Step 4: Post-Upgrade Tasks

After upgrading to 19c, perform the following post-upgrade tasks:

Run the post-upgrade status tool to verify the upgraded database's status.

Ensure that all the required database parameters are correctly set.

Run the time zone script to update the database's time zone data.

If you are using Oracle Enterprise Manager, ensure that the agent and plug-ins are upgraded to 19c.

In conclusion, upgrading to Oracle Database 19c (Non-CDB) from 11g is a straightforward process that requires careful planning and execution. By following the steps outlined above, you can ensure a successful upgrade and take advantage of the new features and improvements offered by Oracle Database 19c. Remember always to back up your database before making any changes to your system to ensure that your data is secure.

Looking forward to your suggestions.. please feel free to write to me.. Your help would definitely help to improve our blog. Chetan Yadav

Parameter for Oracle Data Guard

1. LOG_ARCHIVE_CONFIG - highly recommended by oracle, The DG_CONFIG is set on each database to set Data Guard Configuration. 

2. LOG_ARCHIVE_MAX_PROCESS - optional by Oracle, specify the number ( from 1- 30 ) of archiver (ARCn) process you want oracle software to invoke initially.

The default value is 4.

3.DB_CREATE_FILE_DEST - It specifies the default location of the Oracle Managed datafile.4

DB_CREATE_FILE_DEST= dictory / disk group. 

4.FAL_CLIENT - this parameter is no longer required.

5. FAL_SERVER - it specifies more oracle Net Services name, it can retrieve the missing archive file.

ORACLE_NET _SERVICE_NAME

 looking forward to your suggestions.. please feel free to write to me. Your help would definitely help to improve our blog. Chetan Yadav

how many Database are using ASM

How to know how many databases are using ASM 

we can use 

V$asm_client 

Looking forward to your suggestions.. please feel free to write to me.. Your help would definitely help to improve our blog. Chetan Yadav

Parameter to set in primary and standby dataguard

Parameter are 

1. LOG_ARCHIVE_CONFIG 

2.LOG_ARCHIVE_MAX_PROCESSES 

3.DB_CREATE_FILE_DEST 

4.DB_FILE_CONVERT 

5.LOG_FILE_NAME_CONVERT 

6.LOG_ARCHIVE_DEST_n 

7.lOG_ARCHIVE_DEST_STATE_n 

8.FAL_SERVER 

9.FAL_CLIENT

 10.STANDBY_FILE_MANAGMENT 

Looking forward to your suggestions.. please feel free to write to me.. Your help would definitely help to improve our blog. Chetan Yadav

How to use shared folder in oracle virtual machine

how to share the folder from Windows to Linux in VM using shared folder option

1. Click on "Device " and then on "shared folder setting".

this box will appear

2 then click on "shared folder "  and choose your path  , as shown in figure .

3. reboot your machine.

[root@localhost ~]# cd /media/
[root@localhost media]# ls
sf_XXXX

with the name sf you can find your shared folder .

Looking forward for your suggestions.. please feel free to write to me.. Your help would definitely help to improve our blog. Chetan Yadav

steps for Installation of oracle 11g R2 on Linux

Step 1 :-- Check the space 

[root@localhost ~]# df -kh
Filesystem            Size  Used Avail Use% Mounted on
/dev/mapper/VolGroup00-LogVol00
18G   14G  2.7G  84% /
/dev/sda1              99M   11M   83M  12% /boot
tmpfs                1003M     0 1003M   0% /dev/shm
Oracle11gR2           932G  821G  111G  89% /media/sf_Oracle11gR2
[root@localhost ~]# 



Step 2
add 2 groups "oinstall" and "dba"and 1 user "oracle"


[root@localhost ~]# groupadd oinstall
[root@localhost ~]# groupadd dba
[root@localhost ~]# useradd -g oinstall -G dba oracle
[root@localhost ~]# passwd oracle  

step 3
copy database dump in  linux 

[root@localhost home]# cp -r /media/sf_Oracle11gR2/database  /home/oracle/

Logout from Root user

loging as oracle user

step 4 
oracle@localhost ~]$ pwd
/home/oracle
[oracle@localhost ~]$ ls -ltr
total 8
drwxr-x--- 8 root   root     4096 Aug 25 01:05 database
drwxr-xr-x 2 oracle oinstall 4096 Aug 25 01:11 Desktop
[oracle@localhost ~]$ su - root
Password: 
[root@localhost ~]# pwd
/root
[root@localhost ~]# cd /home
[root@localhost home]# pwd
/home
[root@localhost home]# cd oracle/





[root@localhost oracle]# chown -R oracle:oinstall database
[root@localhost oracle]# ls -ltr
total 8
drwxr-x--- 8 oracle oinstall 4096 Aug 25 01:05 database
drwxr-xr-x 2 oracle oinstall 4096 Aug 25 01:11 Desktop
[root@localhost oracle]# EXIT

oracle@localhost ~]$ cd database/
[oracle@localhost database]$ ls
doc  install  response  rpm  runInstaller  sshsetup  stage  welcome.html
[oracle@localhost database]$ ls -ltr
total 36
drwxr-x--- 12 oracle oinstall 4096 Aug 25 01:02 doc
drwxr-x---  2 oracle oinstall 4096 Aug 25 01:02 sshsetup
-rwxr-x---  1 oracle oinstall 3226 Aug 25 01:02 runInstaller
drwxr-x---  2 oracle oinstall 4096 Aug 25 01:02 rpm
drwxr-x---  2 oracle oinstall 4096 Aug 25 01:02 response
drwxr-x---  4 oracle oinstall 4096 Aug 25 01:02 install
-rwxr-x---  1 oracle oinstall 5402 Aug 25 01:05 welcome.html
drwxr-x--- 14 oracle oinstall 4096 Aug 25 01:05 stage





oracle@localhost database]$ cd ..
[oracle@localhost ~]$ chmod -R 777 database 
[oracle@localhost ~]$ ls -ltr
total 8
drwxrwxrwx 8 oracle oinstall 4096 Aug 25 01:05 database
drwxr-xr-x 2 oracle oinstall 4096 Aug 25 01:11 Desktop

[oracle@localhost ~]$ cd database/
[oracle@localhost database]$ ./r
response/     rpm/          runInstaller  
[oracle@localhost database]$ ./runInstaller 
Starting Oracle Universal Installer...

Looking forward for your suggestions.. please feel free to write to me.. Your help would definitely help to improve our blog. Chetan Yadav