Visit Counter

Saturday, November 23, 2019

MYSQL Administration Tool for Backup / Restore on Windows



Download MYSQL Administration GUI Tool (Windows)

https://downloads.mysql.com/archives/administrator/

Downloaded File

mysql-administrator-1.1.2-win-noinstall

After the download unzip the file.


















Now you can perform backup/restore...and other activities.








MySQL 8.0 Database Installation Step by Step on Windows 10


Download MySQL Database on Windows 10

https://dev.mysql.com/downloads/installer/


















 (Downloaded Set up----Install it).

mysql-installer-web-community-8.0.18.0































After MYSQL Database Installation...Start CMD and run

c:\mysql.exe (Getting error)














Copy the path and edit environment variable


Saturday, November 9, 2019

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/

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:





















[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



















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:

























Friday, November 8, 2019

A fatal error has been detected by the Java Runtime Environment: SIGSEGV, libjvm


When I run the DBCA getting below error.


bash-4.1$ ./dbca
#
# A fatal error has been detected by the Java Runtime Environment:
#
#  SIGSEGV (0xb) at pc=0x00000030ca214d70, pid=2931, tid=140074425837328
#
# JRE version: 6.0_37-b06
# Java VM: Java HotSpot(TM) 64-Bit Server VM (20.12-b01 mixed mode linux-amd64 compressed oops)
# Problematic frame:
# C  [ld-linux-x86-64.so.2+0x14d70]
#
# An error report file with more information is saved as:
# /ora/oracle/app/oracle/product/12.1.0/dbhome_1/bin/hs_err_pid2931.log
#
# If you would like to submit a bug report, please visit:
#   http://java.sun.com/webapps/bugreport/crash.jsp
# The crash happened outside the Java Virtual Machine in native code.
# See problematic frame for where to report the bug.
#
Aborted
bash-4.1$ 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)


Solution:


bash-4.1$ export LD_BIND_NOW=1

bash-4.1$ ./dbca







Monday, November 4, 2019

Virtual Directory & JSP is not responding after ERP 12.2 Installation



On Oracle Applications: 12.2 version,
during the R12.2.0 installation process at 'Post - Install Checks', Virtual Directory, the JSP and Login Page of the post-install tests did not succeed.
The following was from the install log:

vi /../db/fs1/inst/apps/SID_hostname/logs/08201230.log
Virtual Directory
  checking URL = http://hostname.domain:port/OA_MEDIA/FNDLOGOL.gif
  RW-50016: Error: - {0} was not created:
  File = {1} checking URL = http://hostname.domain:port/OA_JAVA/oracle/apps/fnd/admin/server/server.xml
  RW-50016: Error: - {0} was not created:
  File = {1} checking URL = http://hostname.domain:port/OA_CGI/FNDWRR.exe
  RW-50016: Error: - {0} was not created:
  File = {1}

JSP
  checking URL = http:///hostname.domain:port/OA_HTML/jtfTestCookie.jsp
  JSP is not responding, waiting 15 seconds and retesting.
....
  JSP is not responding, waiting 15 seconds and retesting.
  JSP is not responding

Login Page
-----------
  checking URL = http://hostname.domain:port/OA_HTML/AppsLogin

  RW-50016: Error: - {0} was not created:File = {1}
Warning: The following setup  is only specific to Oracle Linux 6.
The issue mainly caused by  missing 'oravis - nproc 2048' setup in the /etc/security/limits.d/90-nproc.conf for Oracle Linux 6.

The following is the correct setup example:

etc/security/limits.d/90-nproc.conf

* soft nproc 1024
root soft nproc unlimited
oravis - nproc 2048                <---add this line: use the oravis  which you used as the DB installation owner instead of ovavis.

Note: The default value on a Oracle Linux 6 system shows as 1024.
In Oracle Linux 6, a new file /etc/security/limits.d/90-nproc.conf, sets the maximum number of processes to 1024 for non-root users.

The value for max forked process is actually read / taken from /etc/security/limits.d/90-nproc.conf file instead of /etc/security/limits.conf file.

SOLUTION

To implement the solution, please execute the following steps:
1. cd /etc/security/limits.conf
increase * hard nofile 65535 to * hard nofile 65536

2 Make a backup for /etc/security/limits.d/90-nproc.conf before changing.
3 Modify the entry in /etc/security/limits.d/90-nproc.conf 

From:

# cat /etc/security/limits.d/90-nproc.conf
* soft nproc 1024
root soft nproc unlimited

To:

* soft nproc 1024
root soft nproc unlimited
oravis - nproc 2048

4 Run the RDA - Health Check / Validation Engine Guide ( Document 250262.1 ) for the installation to ensure healthy report output for the following rule set:
APPS ebs122_lin Oracle E-Business Suite Release 12 (12.2.0) Preinstall (Linux x86_64)
5 Retest the issue.