We need to move one or more datafile from our tablespace to one location to another because of the disk space issue.

In this post, I try to explain how We can achieve this process with CP command of asmcmd utility via a demo

The database version is –> 11.2.0.4

The Operating System is –> Linux 6

Read the rest of this entry »

Advertisements

You may need to require to relink oracle binaries because of some number of our cases and also We may need to do it because of the solution given by Oracle support.

The following method will relink the Oracle executables.

Read the rest of this entry »

Lots of EBS users ask the same question in the OTN forum: How we can Monitor our EBS’s System Health.

Actually, this question already answered in Steven Chan blog, for details please click here

In this post, I want to share some useful articles which cover  EBS’s System Health.

Read the rest of this entry »

Read the rest of this entry »

I face “OPatch failed with error code 73 error” on my E-Business Suite R12.1.2 on 11.2.0.1 RAC database with ASM

I wanted to apply a patch to my system. I started to check “opatch lsinventory “command on node 1 and no issue but on node 2 I faced OPatch failed with error code 73 error while running “opatch lsinventory”. Here are the details

Read the rest of this entry »

In this post, I am going to try to explain How you can Remove or Deinstall 11.2.0.1 Grid Infrastructure from your server.

I have 11.2.0.1 grid Infrastructure with 11.2.0.1 database on the AIX 6.1 operating system.

Here are my steps:

Read the rest of this entry »

If you want to use some different reports such as AWR; ASH etc. you may prefer to use the statspack report in Oracle Database.

STATSPACK is a performance diagnosis tool, available since Oracle8i. STATSPACK can be considered BSTAT/ESTAT’s successor, incorporating many new features. STATSPACK is a diagnosis tool for instance-wide performance problems; it also supports application tuning activities by providing data which identifies high-load SQL statements. STATSPACK can be used both proactively to monitor the changing load on a system, and also reactively to investigate a performance problem.

Here are some notes which you can get details about the Statspack report.

How to Identify Resource Intensive SQL for Tuning  Doc ID:232443.1
FAQ- Statspack Complete Reference  Doc ID:94224.1
TROUBLESHOOTING: Possible Causes of Poor SQL Performance    Doc ID:    33089.1

Installing and Configuring StatsPack Package [ID 149113.1]
FAQ- Statspack Complete Reference [ID 94224.1]
Creating a StatsPack performance report [ID 149124.1]
How To Understand AWR Report / Statspack Report [ID 842884.1]
What is StatsPack and where are the READMEs? [ID 149115.1]
Systemwide Tuning using STATSPACK Reports [ID 228913.1]
Oracle Applications and StatsPack [ID 153507.1]
Oracle9i Database Performance Tuning Guide and Reference-Using statspack
http://www.oracle-base.com/articles/8i/Statspack8i.php
How to Identify Resource Intensive SQL for Tuning  Doc ID:232443.1
TROUBLESHOOTING: Possible Causes of Poor SQL Performance Doc ID:33089.1

 

I faced those errors during startup of my database. Db version is 11.2.0.3 and cluster version is 18c

The complete error message is

[USER(4431)]CRS-2317: Fatal error: cannot get local GPnP security keys (wallet).
2019-03-29 21:50:12.876
[USER(4431)]CRS-2316:Fatal error: cannot initialize GPnP, CLSGPNP_ERR (Generic GPnP error).
kggpnpInit: failed to init gpnp
WARNING: No cluster interconnect has been specified. Depending on
the communication driver configured Oracle cluster traffic
may be directed to the public interface of this machine.
Oracle recommends that RAC clustered databases be configured
with a private interconnect for enhanced security and
performance.

Read the rest of this entry »

In this post, I created pdf file to show How to install Oracle Database 18c Grid Infrastructure On Oracle Linux 7.5

You can download installation guide by clicking below link

Installation Oracle Database 18c Grid Infrastructure On Oracle Linux 7

Enjoy it !

While I try to create database by using DBCA on 18c Grid Infrastructure I am hitting below screen:

Screenshot_1

Read the rest of this entry »

Advertisements
Advertisements