You are currently browsing the category archive for the ‘Oracle Database&EBS General’ category.

I faced with that error during installing 18c Grid software on checking list screen.

If you dont want to hit this warning error You can follow below steps:

On each node within the Oracle RAC Database cluster, stop and disable the avahi services run the following commands:

Read the rest of this entry »

Advertisements

While trying to install 11.2.0.3 RAC binary, runInstaller fails with below error:
[INS-35354] The system on which you are attempting to install Oracle RAC is not part of a valid cluster.

Oracle  18c Clusterware has been installed successfully and running without any issue.

After making some search at metalink, I found  MOS Oracle 11.2.0.3 runInstaller fails with [INS-35354] error after Installing 12.2.0.1 Grid Infrastructure (Doc ID 2282456.1)

Here are the details:

Read the rest of this entry »

One of our 12c database hitting this message at alertlog

ORA-04036: PGA memory used by the instance exceeds PGA_AGGREGATE_LIMIT
PGA memory used by the instance exceeds PGA_AGGREGATE_LIMIT of 1024 MB

PGA_AGGREGATE_LIMIT parameter comes with 12c, it sets a hard limit on the amount of PGA taken up by an instance.

Program Global Area (PGA) is an area in memory that is used by sessions for session related activities like sorting. in 11g PGA can grow without any restriction if the session demands. Usually untunable processes, consume lot of PGA, which can impact the overall memory usage of the database.
So in 12c, pga_aggregate_limit was introduced, which puts a cap on the pga growth.

As per Oracle documentation

In Oracle Database 12c, a new parameter called PGA_AGGREGATE_LIMIT sets a hard limit on the amount of PGA taken up by an instance. When the overall PGA occupied by all the sessions in that instance exceed the limit, Oracle kills the session holding the most untunable PGA memory, releasing all PGA memory held by that session.

Read the rest of this entry »

You may need to move your control file to one other location. You can follow below steps for can move your control file to one other location.

First We  will verify the current location of the control files.

Read the rest of this entry »

I faced with that issue to make import process on our system.

My source db version is 11.2.0.4 and target db version is 12.1.0.2 RAC

During import process (used impdp) its ended by below error messages

Read the rest of this entry »

How to change the character set of a database. You may need to change your database character set due to do some requirements.

In this example, I am going to change my db character set from UTF8 to WE8ISO8859P9

Here are my steps:

Read the rest of this entry »

While I was trying to make rpm installation by yum, it gave below error

[root@veridata ~]# yum install pdksh*
Loaded plugins: langpacks, ulninfo
Existing lock /var/run/yum.pid: another copy is running as pid 8432.
Another app is currently holding the yum lock; waiting for it to exit...
The other application is: PackageKit
Memory : 85 M RSS (513 MB VSZ)
Started: Thu Mar 14 21:19:39 2019 - 01:41 ago
State : Sleeping, pid: 8432
Another app is currently holding the yum lock; waiting for it to exit...
The other application is: PackageKit
Memory : 85 M RSS (513 MB VSZ)
Started: Thu Mar 14 21:19:39 2019 - 01:43 ago
State : Sleeping, pid: 8432
Another app is currently holding the yum lock; waiting for it to exit...
The other application is: PackageKit
Memory : 85 M RSS (513 MB VSZ)
Started: Thu Mar 14 21:19:39 2019 - 01:45 ago
State : Sleeping, pid: 8432

So how We can handle this error? Here is the step:

Read the rest of this entry »

I face with that issue while I was making Oracle 11.2.0.1 version on OEL 7.6. At prerequest check screen

Here is the screen shot:

Screenshot_1.jpg

Read the rest of this entry »

While I am installing Oracle 11.2.0.4 on RHEL 7.6 I hit this message on prereq screen.

After I made some search I found a solution as below.

Login as installation user. In my case my user is oracle

Read the rest of this entry »

After Installing OEL7.6 boot loader comes with 3 options.  You need to choose the options to can login your system every boot.

linux.jpg

If you want to fix default boot you need to follow below steps:

Read the rest of this entry »

Advertisements
Advertisements