While configuration of rcu script (Repository Creation Utility)

While Configure OGG repository account getting below error.


Refer: (Doc ID 2370454.1)


The selected Oracle database is not configured to use the AL32UTF8
character set. Oracle strongly recommends using the AL32UTF8 character
set for databases that support Oracle Fusion Middleware.

bash-4.1$ ./sqlplus /nolog

SQL*Plus: Release 12.1.0.1.0 Production on Sat Nov 9 21:30:28 2019

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

SQL> conn / as sysdba
Connected to an idle instance.
SQL> startup mount
ORACLE instance started.

Total System Global Area 1469792256 bytes
Fixed Size     2288488 bytes
Variable Size   973079704 bytes
Database Buffers   486539264 bytes
Redo Buffers     7884800 bytes
Database mounted.
SQL>
SQL> ALTER SYSTEM ENABLE RESTRICTED SESSION;

System altered.

SQL> ALTER SYSTEM SET JOB_QUEUE_PROCESSES=0;

System altered.

SQL> ALTER SYSTEM SET AQ_TM_PROCESSES=0;

System altered.

SQL> ALTER DATABASE OPEN;

Database altered.

SQL> alter database character set AL32UTF8;
alter database character set AL32UTF8
*
ERROR at line 1:
ORA-12712: new character set must be a superset of old character set


SQL> ALTER DATABASE CHARACTER SET INTERNAL_USE AL32UTF8;

Database altered.

SQL>

SQL> shutdown; 
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.

Total System Global Area 1469792256 bytes
Fixed Size     2288488 bytes
Variable Size   973079704 bytes
Database Buffers   486539264 bytes
Redo Buffers     7884800 bytes
Database mounted.
Database opened.
SQL>






Refer:

https://deepdba.wordpress.com/2009/11/25/steps-to-migrate-the-characterset-of-database/

http://oracle.ittoolbox.com/documents/changing-the-character-set-of-an-oracle-database-18618#

ORA-19602: cannot backup or copy active file in NOARCHIVELOG mode

bash-4.1$ pwd
/ora/oracle/app/oracle/product/12.1.0/dbhome_1/bin
bash-4.1$ ./rman target /

Recovery Manager: Release 12.1.0.1.0 - Production on Sat Nov 9 21:15:12 2019

Copyright (c) 1982, 2013, Oracle and/or its affiliates.  All rights reserved.

connected to target database: ORATEST (DBID=3559263983)


RMAN> backup database;

Starting backup at 09-NOV-19
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=30 device type=DISK
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
RMAN-03009: failure of backup command on ORA_DISK_1 channel at 11/09/2019 21:15:36
ORA-19602: cannot backup or copy active file in NOARCHIVELOG mode
continuing other job steps, job failed will not be re-run
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00009 name=/ora/oracle/app/oracle/oradata/ORATEST/96E5EB6939A61161E0530A0000C0656E/datafile/o1_mf_sysaux_gwdtyz2t_.dbf
input datafile file number=00008 name=/ora/oracle/app/oracle/oradata/ORATEST/96E5EB6939A61161E0530A0000C0656E/datafile/o1_mf_system_gwdtyyxm_.dbf
input datafile file number=00010 name=/ora/oracle/app/oracle/oradata/ORATEST/96E5EB6939A61161E0530A0000C0656E/datafile/o1_mf_users_gwdv1k7g_.dbf
channel ORA_DISK_1: starting piece 1 at 09-NOV-19
channel ORA_DISK_1: finished piece 1 at 09-NOV-19
piece handle=/ora/oracle/app/oracle/fast_recovery_area/ORATEST/96E5EB6939A61161E0530A0000C0656E/backupset/2019_11_09/o1_mf_nnndf_TAG20191109T211536_gwfsk8v4_.bkp tag=TAG20191109T211536 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:36
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00007 name=/ora/oracle/app/oracle/oradata/ORATEST/datafile/o1_mf_sysaux_gwdtojz0_.dbf
input datafile file number=00005 name=/ora/oracle/app/oracle/oradata/ORATEST/datafile/o1_mf_system_gwdtojz6_.dbf
channel ORA_DISK_1: starting piece 1 at 09-NOV-19
channel ORA_DISK_1: finished piece 1 at 09-NOV-19
piece handle=/ora/oracle/app/oracle/fast_recovery_area/ORATEST/96E5DC8323B70F61E0530A0000C0D7FE/backupset/2019_11_09/o1_mf_nnndf_TAG20191109T211536_gwfsld9l_.bkp tag=TAG20191109T211536 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:45
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================

RMAN-03009: failure of backup command on ORA_DISK_1 channel at 11/09/2019 21:15:36
ORA-19602: cannot backup or copy active file in NOARCHIVELOG mode

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

Solution

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

RMAN> shutdown

database closed

database dismounted

Oracle instance shut down

RMAN> startup mount 

connected to target database (not started)

Oracle instance started

Total System Global Area    1469792256 bytes

Fixed Size                     2288488 bytes

Variable Size                973079704 bytes

Database Buffers             486539264 bytes

Redo Buffers                   7884800 bytes

Statement processed

released channel: ORA_DISK_1

RMAN> backup database;

Starting backup at 09-NOV-19

allocated channel: ORA_DISK_1

channel ORA_DISK_1: SID=20 device type=DISK

channel ORA_DISK_1: starting full datafile backup set

channel ORA_DISK_1: specifying datafile(s) in backup set

input datafile file number=00001 name=/ora/oracle/app/oracle/oradata/ORATEST/datafile/o1_mf_system_gwdtl2js_.dbf

input datafile file number=00003 name=/ora/oracle/app/oracle/oradata/ORATEST/datafile/o1_mf_sysaux_gwdtj1bt_.dbf

input datafile file number=00004 name=/ora/oracle/app/oracle/oradata/ORATEST/datafile/o1_mf_undotbs1_gwdtn556_.dbf

input datafile file number=00006 name=/ora/oracle/app/oracle/oradata/ORATEST/datafile/o1_mf_users_gwdtn3pq_.dbf

channel ORA_DISK_1: starting piece 1 at 09-NOV-19

channel ORA_DISK_1: finished piece 1 at 09-NOV-19

piece handle=/ora/oracle/app/oracle/fast_recovery_area/ORATEST/backupset/2019_11_09/o1_mf_nnndf_TAG20191109T212336_gwft08r7_.bkp tag=TAG20191109T212336 comment=NONE

channel ORA_DISK_1: backup set complete, elapsed time: 00:01:15

channel ORA_DISK_1: starting full datafile backup set

channel ORA_DISK_1: specifying datafile(s) in backup set

input datafile file number=00009 name=/ora/oracle/app/oracle/oradata/ORATEST/96E5EB6939A61161E0530A0000C0656E/datafile/o1_mf_sysaux_gwdtyz2t_.dbf

input datafile file number=00008 name=/ora/oracle/app/oracle/oradata/ORATEST/96E5EB6939A61161E0530A0000C0656E/datafile/o1_mf_system_gwdtyyxm_.dbf

input datafile file number=00010 name=/ora/oracle/app/oracle/oradata/ORATEST/96E5EB6939A61161E0530A0000C0656E/datafile/o1_mf_users_gwdv1k7g_.dbf

channel ORA_DISK_1: starting piece 1 at 09-NOV-19

channel ORA_DISK_1: finished piece 1 at 09-NOV-19

piece handle=/ora/oracle/app/oracle/fast_recovery_area/ORATEST/96E5EB6939A61161E0530A0000C0656E/backupset/2019_11_09/o1_mf_nnndf_TAG20191109T212336_gwft2ov9_.bkp tag=TAG20191109T212336 comment=NONE

channel ORA_DISK_1: backup set complete, elapsed time: 00:00:45

channel ORA_DISK_1: starting full datafile backup set

channel ORA_DISK_1: specifying datafile(s) in backup set

input datafile file number=00007 name=/ora/oracle/app/oracle/oradata/ORATEST/datafile/o1_mf_sysaux_gwdtojz0_.dbf

input datafile file number=00005 name=/ora/oracle/app/oracle/oradata/ORATEST/datafile/o1_mf_system_gwdtojz6_.dbf

channel ORA_DISK_1: starting piece 1 at 09-NOV-19

channel ORA_DISK_1: finished piece 1 at 09-NOV-19

piece handle=/ora/oracle/app/oracle/fast_recovery_area/ORATEST/96E5DC8323B70F61E0530A0000C0D7FE/backupset/2019_11_09/o1_mf_nnndf_TAG20191109T212336_gwft41lk_.bkp tag=TAG20191109T212336 comment=NONE

channel ORA_DISK_1: backup set complete, elapsed time: 00:00:35

Finished backup at 09-NOV-19

Starting Control File and SPFILE Autobackup at 09-NOV-19

piece handle=/ora/oracle/app/oracle/fast_recovery_area/ORATEST/autobackup/2019_11_09/o1_mf_s_1023916940_gwft57rh_.bkp comment=NONE

Finished Control File and SPFILE Autobackup at 09-NOV-19

Installing and Configuring Oracle GoldenGate Studio 12c

Instead of configuring Oracle OGG through the command line now u can configure Oracle OGG through the studio (GUI).



Env:
----------------------------
Oracle Linux 6
Oracle 12.1 RDBMS
Oracle Gold Gate 12c
-----------------------------


Installing Oracle GoldenGate Studio consists of the following steps:

1. Ensure Java JDK 1.8 is installed
2. Install Oracle GoldenGate Studio
3. Configure Oracle GoldenGate Studio repository
4. Start and Connect to Oracle GoldenGate Studio 

Java JDK 1.7 and earlier versions don't work with the JAR files for Studio.
Java JDK 1.8 is required for GoldenGate Studio Installation.

• To download the required JDK, navigate to the following URL and download the Java SE JDK:

https://www.oracle.com/technetwork/java/javase/downloads/jdk8-downloads-2133151.html

[root@orarac01 Desktop]# java -version

java version "1.6.0_17"

OpenJDK Runtime Environment (IcedTea6 1.7.4) (rhel-1.21.b17.el6-x86_64)

OpenJDK 64-Bit Server VM (build 14.0-b16, mixed mode)

bash-4.1$ 

[root@orarac01 Desktop]# rpm -ivh jdk-8u231-linux-x64.rpm 

Preparing...                ########################################### [100%]

   1:jdk1.8                 ########################################### [100%]

Unpacking JAR files...

tools.jar...

plugin.jar...

javaws.jar...

deploy.jar...

rt.jar...

jsse.jar...

charsets.jar...

localedata.jar...

[root@orarac01 Desktop]# 

[root@orarac01 Desktop]# java -version

java version "1.8.0_231"

Java(TM) SE Runtime Environment (build 1.8.0_231-b11)

Java HotSpot(TM) 64-Bit Server VM (build 25.231-b11, mixed mode)

bash-4.1$ 

Downloading Oracle Golden Gate Studio Software

https://www.oracle.com/middleware/technologies/goldengate-downloads.html

Once the file download is completed, you will see the file on the server as below

$/ora/oracle/Desktop

fmw_12.2.1.4.0_oggstudio_Disk1_1of1.zip

$unzip fmw_12.2.1.4.0_oggstudio_Disk1_1of1.zip

$fmw_12.2.1.4.0_oggstudio.jar

Steps to Install Oracle Golden Gate Studio 

• Make sure Java is set in your path properly.

bash-4.1$ whereis java

java: /usr/bin/java /etc/java /usr/lib/java /usr/lib64/java /usr/share/java /usr/share/man/man1/java.1

bash-4.1$ 

• Here I am using Oracle user to install Golden Gate Studio software

bash-4.1$ java -version

java version "1.8.0_231"

Java(TM) SE Runtime Environment (build 1.8.0_231-b11)

Java HotSpot(TM) 64-Bit Server VM (build 25.231-b11, mixed mode)

bash-4.1$ 

• Unzip the Oracle GoldenGate Studio software

bash-4.1$ fmw_12.2.1.4.0_oggstudio_Disk1_1of1.zip

Archive:  fmw_12.2.1.4.0_oggstudio_Disk1_1of1.zip

  inflating: fmw_12.2.1.4.0_oggstudio.jar

  inflating: fmw_122126_readme.htm

bash-4.1$ ls -ltr

-rw-r--r-- 1 oracle oinstall       9032 Dec  5 16:49 fmw_122126_readme.htm

-r-xr-xr-x 1 oracle oinstall 2042431392 Dec  5 16:55 fmw_12.2.1.4.0_oggstudio.jar

-rw-r--r-- 1 oracle oinstall 2042373304 Jan  3 04:42 fmw_12.2.1.4.0_oggstudio_Disk1_1of1.zip

bash-4.1$ java -jar fmw_12.2.1.4.0_oggstudio.jar 

Launcher log file is /tmp/OraInstall2019-11-09_03-47-43PM/launcher2019-11-09_03-47-43PM.log.

Extracting the installer . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Done

Checking if CPU speed is above 300 MHz.   Actual 1992.004 MHz    Passed

Checking monitor: must be configured to display at least 256 colors.   Actual 16777216    Passed

Checking swap space: must be greater than 512 MB.   Actual 9999 MB    Passed

Checking if this platform requires a 64-bit JVM.   Actual 64    Passed (64-bit not required)

Checking temp space: must be greater than 300 MB.   Actual 7196 MB    Passed

Preparing to launch the Oracle Universal Installer from /tmp/OraInstall2019-11-09_03-47-43PM

Log: /tmp/OraInstall2019-11-09_03-47-43PM/install2019-11-09_03-47-43PM.log

Configure Oracle GoldenGate Studio repository

The Oracle GoldenGate Studio store entire replication design and deployment details in a database repository. You must install the repository schema on a certified database before using Oracle GoldenGate Studio. The repository is created using the Oracle Repository Creation Utility (RCU).

Make sure you created a database for storing the Oracle GoldenGate Studio objects before proceeding. Here I already have a database created by the name "oratest" which I will be using as a repository.

• Make sure the DISPLAY is set properly and Launch the Repository Creation Utility as follows: