I faced with that issue on “Oracle Enterprise manager” on one of my client environments.

Here is the screen:

oem database is down

Read the rest of this entry »

If your Oracle datafiles host on filesystem architecture than you may need to move your datafiles to one other path because of not enough disk size etc.,

In this post, I am talking about a move or rename datafiles to a new location. You may also use below methods:
Online move (12c)
RMAN

Read the rest of this entry »

In my previous post, I tested dbForge Tools for Oracle side. In this post, I am going to share my thought about dbForge Studio for MySQL product.

The main link is here.

There some product available for Mysql but I can tell dbForge Studio for MySQL is one of the best in all those products. It has many features such as:

Read the rest of this entry »

I got the email from Devart company which is founded in 1997.  They Have Lots of Products which are related many fields in IT.  If you click the product list on their page, You will see lots of products are available for many different usages.

For Checking Devart company and their products, the main link click here.

Read the rest of this entry »

As you know dbca is a utility for create database. But if you get issue on x11 than you may need to create database manually.

My current setup versions are

db version –> 11.2.0.4
grid version –> 12.1.0.2
Os version –> RHEL 7

Here is the steps:

Read the rest of this entry »

We have x6-2 Exadata machine. When trying to create a single-instance database on one of the database nodes on Exadata system by using DBCA it throws :

ORA-02249 – missing or invalid value for MAXLOGMEMBERS.

For testing, I can create  RAC database without any issue.
My steps are:

Read the rest of this entry »

We faced with that issue while we are trying to install Oracle12cR2 database on Solaris 11
While we tried to install grid software on solaris root.sh ended by below syntax:

DATE CLSRSC-4001: Installing Oracle Trace File Analyzer (TFA) Collector.
DATE CLSRSC-4002: Successfully installed Oracle Trace File Analyzer (TFA) Collector.
DATE CLSRSC-594: Executing installation step 2 of 19: 'ValidateEnv'.
DATE CLSRSC-175: Failed to write the checkpoint 'ROOTCRS_STACK' with status 'START' (error code 1)
DATE CLSRSC-177: Failed to add (property/value):('VERSION'/'12.2.0.1.0') for checkpoint 'ROOTCRS_STACK' (error code 1)
DATE CLSRSC-363: User ignored prerequisites during installation
DATE CLSRSC-594: Executing installation step 3 of 19: 'CheckFirstNode'.
DATE CLSRSC-594: Executing installation step 4 of 19: 'GenSiteGUIDs'.
DATE CLSRSC-594: Executing installation step 5 of 19: 'SaveParamFile'.
DATE CLSRSC-175: Failed to write the checkpoint 'ROOTCRS_PARAM' with status 'START' (error code 1)
DATE  CLSRSC-594: Executing installation step 6 of 19: 'SetupOSD'.
DATE CLSRSC-594: Executing installation step 7 of 19: 'CheckCRSConfig'.
DATE CLSRSC-594: Executing installation step 8 of 19: 'SetupLocalGPNP'.
DATE CLSRSC-175: Failed to write the checkpoint 'ROOTCRS_GPNPSETUP' with status 'START' (error code 1)
DATE CLSRSC-175: Failed to write the checkpoint 'ROOTCRS_GPNPSETUP' with status 'SUCCESS' (error code 1)
DATE CLSRSC-175: Failed to write the checkpoint 'ROOTCRS_GPNPSETUP' with status 'SUCCESS' (error code 1)
DATE  CLSRSC-175: Failed to write the checkpoint 'ROOTCRS_STACK' with status 'FAIL' (error code 1)
Died at /u01/app/12.2.0/grid/crs/install/crsutils.pm line 4120.
The command '/u01/app/12.2.0/grid/perl/bin/perl -I/u01/app/12.2.0/grid/perl/lib -I/u01/app/12.2.0/grid/crs/install /u01/app/12.2.0/grid/crs/install/rootcrs.pl ' execution failed

Read the rest of this entry »

If you are using RMI connection than possibly this error should be familiar…

We face with that error after  our 10.2.0.5 to 11.2.0.4.6 upgrade. Some of functions just stopped. Those functions are use RMI connection and return some value from one other database.

After reboot database, function started to run again. After made some research I found the root cause.

Here is the steps; Read the rest of this entry »

Hot News!!!!

Finally Oracle 12cR2 version is available on the Oracle Public Cloud and free trial is available. This is a great platform to test new features  by using free trail.

Here is the screen shoot

Read the rest of this entry »

Advertisements
Follow Helios's Blog on WordPress.com
Advertisements