Reconfigure the Database

Language:

The Oracle Database 12.1.0.2 environment has moved to a new hostname TargetDBzone, so the database requires some reconfiguration.

Perform all steps except for the last step listed in:
Configure Guest Domain Database Components (a chapter in the Lift and Shift Guide - Moving Oracle Solaris 10 Guest Domains to SPARC Servers Running Oracle Solaris 11), then return to Step 2 in this procedure.

The Oracle Database environment moved to a domain with a new hostname, and therefore requires some reconfiguration. The referenced procedure describes the reconfiguration process. The steps were derived and modified from the MOS document titled How to Reconfigure Oracle Restart on 12c / 12.1 (Doc ID 1570358.1).

Recreate the non-default database service.

TargetDBzone$ srvctl add service -d orcl9 -pdb pdborcl -s mydb
TargetDBzone$ srvctl status service -d orcl9 -s mydb
Service mydb is not running.

TargetDBzone$ srvctl start service -d orcl9 -s mydb
TargetDBzone$ srvctl status service -d orcl9 -s mydb
Service mydb is running

On dbzone, check the status of the database.

TargetDBzone$ crsctl status resource -t
--------------------------------------------------------------------------------
Name           Target  State        Server                   State details
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.DATA.dg
               ONLINE  ONLINE       TargetDBzone STABLE
ora.LISTENER.lsnr
               ONLINE  ONLINE       TargetDBzone STABLE
ora.asm
               ONLINE  ONLINE       TargetDBzone Started,STABLE
ora.ons
               OFFLINE OFFLINE      TargetDBzone STABLE
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.cssd
      1        ONLINE  ONLINE       TargetDBzone STABLE
ora.diskmon
      1        OFFLINE OFFLINE                               STABLE
ora.evmd
      1        ONLINE  ONLINE       TargetDBzone STABLE
ora.orcl9.db
      1        ONLINE  ONLINE       TargetDBzone Open,STABLE
ora.orcl9.mydb.svc
      1        ONLINE  ONLINE       TargetDBzone STABLE
--------------------------------------------------------------------------------

Check the database listener to ensure that the database services are successfully migrated.

TargetDBzone$ lsnrctl status

LSNRCTL for Solaris: Version 12.1.0.2.0 - Production on 17-AUG-2018 09:01:06
Copyright (c) 1991, 2014, Oracle.  All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=TargetDBzone.us.example.com)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Solaris: Version 12.1.0.2.0 - Production
Start Date                17-AUG-2018 09:00:33
Uptime                    0 days 0 hr. 0 min. 32 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /u01/app/oracle/product/12.1.0/grid/network/admin/listener.ora
Listener Log File         /u01/app/oracle/diag/tnslsnr/TargetDBzone/listener/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=TargetDBzone.us.example.com)(PORT=1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=TargetDBzone.us.example.com)(PORT=5500))(Security=(my_wallet_directory=/u01/app/oracle/product/12.1.0/dbhome_1/admin/orcl9/xdb_wallet))(Presentation=HTTP)(Session=RAW))
Services Summary...
Service "mydb.us.example.com" has 1 instance(s).
  Instance "orcl9", status READY, has 1 handler(s) for this service...
Service "orcl9.us.example.com" has 1 instance(s).
  Instance "orcl9", status READY, has 1 handler(s) for this service...
Service "orcl9XDB.us.example.com" has 1 instance(s).
  Instance "orcl9", status READY, has 1 handler(s) for this service...
Service "pdborcl.us.example.com" has 1 instance(s).
  Instance "orcl9", status READY, has 1 handler(s) for this service...
The command completed successfully
-bash-3.2$

From a database client system, check that the database files are in expected locations.

root@client-sys# sqlplus system/welcome1@//TargetDBzone.us.example.com:1521/mydb.us.example.com

SQL> select name from v$datafile union select member from v$logfile union select name from v$archived_log;
+DATA/ORCL9/DATAFILE/system.258.981701267
+DATA/ORCL9/DATAFILE/sysaux.257.981701213
...............
+DATA/ORCL9/71335771C4785E92E054000B5DDC023F/DATAFILE/soe.278.981702033
.....
/logs/redologs/redo04.log
/logs/redologs/redo05.log
...........
......
/logs/archivelogs/ORCL9/archivelog/2018_07_17/o1_mf_1_50_fnvzwkj8_.arc
......

Check the application schema (SOE) to verify that the expected data was migrated.
The count should match the count from Lift the Source Environment to the Shared Storage.
```
SQL> select count(*) from soe.orders ;

  COUNT(*)
----------
  1429790
```
Enable the CRS stack.
The CRS stack was disabled in the beginning of the migration. Now that the data has been lifted and shifted to the target, the CRS stack must be enabled.

Run this command as the application user (oracle1):
```
TargetDBzone$ crsctl enable has
```