Oracle Apps EBS 12c Database Non-ASM file System Migration to 19c ASM

Oracle Apps EBS 12c Database file system migration to 19c ASM

In this post I am going to migrate my EBS 12c database non ASM file system to 19c ASM.

Current Version:

EBS: 12.2.10

DB: 12.1.0.2

ASM GRID : 19.3

OS: OEL 7.9

ORACLE_SID=FUAT

19c GRID Installation Steps

Make Sure 19c crs and ASM services are running.

NON-ASM to ASM Migration Steps

1) Check the Location of the Parameter File, Control file, Temp files, Redo Log files

show parameter pfile

select name from v$controlfile;

select name from V$datafile;

select name from v$tempfile;

select member from v$logfile;

2) Make sure you have the diskgroup.

I have already created a diskgroup name as EBS_DATA

3) Create ASM password(if not done or present) file to take a new name with actual path. Use -f to force create the file otherwise the command will say already file exists. Also make sure password is complex.

[oraasm@funebs122 ~]$ asmcmd pwcreate --asm '+EBS_DATA/orapwasm'

Enter password: ********

OPW-00010: Could not create the password file. A password file with this name is present.

ASMCMD-9454: could not create new password file

[oraasm@funebs122 ~]$ asmcmd pwcreate --asm '+EBS_DATA/orapwasm' -f

Enter password: ********

[oraasm@funebs122 ~]$

[oraasm@funebs122 ~]$ asmcmd pwget --asm

+EBS_DATA/orapwasm

sqlplus / as sysasm

SQL> alter system flush PASSWORDFILE_METADATA_CACHE;

Compare permissions of GRID home and database home

ls -lhrt $GRID_HOME/bin/oracle

ls -lhrt $ORACLE_HOME/bin/oracle

across the cluster, make sure that permissions on oracle binary are identical on each node. For example, GRID_HOME oracle permission should be 6751

To correct the permission, as owner of oracle binary:

cd $GRID_HOME/bin

chmod 6751 oracle

From DB home register to srvctl

[oracle@funebs122 trace]$ cd $ORACLE_HOME/bin

[oracle@funebs122 bin]$ srvctl add database -d FUAT -o /oraapps122/DATABASE/FUAT/12.1.0

4) Add ASM entry in tnsnames.ora ifile on Database

cat /oraapps122/DATABASE/FUAT/12.1.0/network/admin/FUAT_funebs122/FUAT_funebs122_ifile.ora

+ASM=(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = funebs122.lab)(PORT = 1521)))(CONNECT_DATA =(ORACLE_SID = +ASM)))

5) Change the location of control_files,db_create_file_dest

SYS@FUAT >alter system set control_files='+EBS_DATA' scope=spfile;

System altered.

SYS@FUAT >alter system set db_create_file_dest='+EBS_DATA' scope=spfile;

System altered.

SYS@FUAT >alter system set db_recovery_file_dest='+EBS_DATA' scope=spfile; -->optional if using

System altered.

6) Shutdown database and start in nomount

SYS@FUAT >shutdown immediate

Database closed.

Database dismounted.

ORACLE instance shut down.

SYS@FUAT >startup nomount

ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance

ORACLE instance started.

Total System Global Area 2147483648 bytes

Fixed Size 2926472 bytes

Variable Size 788531320 bytes

Database Buffers 1342177280 bytes

Redo Buffers 13848576 bytes

7) Restore Control file from file system to ASM. If multiple control file, pick any one.

RMAN> restore controlfile from '/oraapps122/DATABASE/FUAT/data/cntrl01.dbf';

Starting restore at 18-FEB-22

using target database control file instead of recovery catalog

allocated channel: ORA_DISK_1

channel ORA_DISK_1: SID=204 device type=DISK

channel ORA_DISK_1: copied control file copy

output file name=+EBS_DATA/FUAT/CONTROLFILE/current.259.1096979313

Finished restore at 18-FEB-22

8) Mount database and copy datafile from filesystem to ASM. This I am doing in EBS database(100 GB size) so it will take time.

RMAN> alter database mount;

Statement processed

released channel: ORA_DISK_1

RMAN> backup as copy database format '+EBS_DATA';

Starting backup at 18-FEB-22

allocated channel: ORA_DISK_1

channel ORA_DISK_1: SID=204 device type=DISK