You are currently browsing the category archive for the ‘Oracle Database&EBS General’ category.
This article is about Oracle Statspack. We are going to learn How We can Install and what is Oracle Statspack?
Statspack is a performance tuning tool provided by Oracle with the Oracle9i database distribution. With minimal effort, it can be installed on any Oracle9i database to rapidly gather detailed analysis of the performance of that database instance.
So What is Oracle Statspack?
The Statspack package is a set of SQL, PL/SQL, and SQL*Plus scripts that allow the collection, automation, storage, and viewing of performance data. Statspack stores the performance statistics perennially in Oracle tables, which can later be used for reporting and analysis. The data collected can be analyzed using Statspack reports, which includes an instance health and load summary page, high resource SQL statements, and the traditional wait events and initialization parameters.
Read the rest of this entry »How We Are Adding new disk to ACFS disk group or extending/increasing the size of ACFS file system diskgroup
Oracle Automatic Storage Management Cluster File System (Oracle ACFS) is a multi-platform, scalable file system, and storage management technology that extends Oracle Automatic Storage Management (Oracle ASM) functionality to support all customer files. The Oracle ASM Dynamic Volume Manager (Oracle ADVM) provides volume management services and a standard disk device driver interface to clients.
In this scenario We assume that disks have been formated by udev utulity.
So here We go
Read the rest of this entry »One of our customer want to check their rman backup can be restore or not. As you know Oracle RMAN utility which you can try Verification whole backup, controlfile and so on.
While I am making this scenario I faced with below error message:
Starting restore at 19-AUG-20 using channel ORA_DISK_1 RMAN-00571: ================ RMAN-00569: ==== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: ================ RMAN-03002: failure of restore command at 08/19/2020 23:13:41 RMAN-06026: some targets not found - aborting restore RMAN-06025: no backup of archived log for thread 2 with sequence 26302 and starting SCN of 24674954085 found to restore RMAN-06025: no backup of archived log for thread 2 with sequence 26301 and starting SCN of 24674835189 found to restore RMAN-06025: no backup of archived log for thread 2 with sequence 26300 and starting SCN of 24674673364 found to restore RMAN-06025: no backup of archived log for thread 2 with sequence 26299 and starting SCN of 24674438135 found to restore RMAN-06025: no backup of archived log for thread 2 with sequence 26298 and starting SCN of 24674341864 found to restore RMAN-06025: no backup of archived log for thread 2 with sequence 26297 and starting SCN of 24674135281 found to restoreRead the rest of this entry »
As you know Oracle has new naming convention. Before start Let us check current Release and Support Timelines.
Now here is the details
Read the rest of this entry »You may face with that error while you are working with dblink. Sometimes, after a remote operation a user wants to close the connection to the remote site to conserve resources.
Formal details lets look at the oerr:
ORA-02080, 00000, "database link is in use" Cause: a transaction is active or a cursor is open on the database link given in the alter session close database link command. Action: commit or rollback, and close all cursorsRead the rest of this entry »
One of our customer need to decreased server RAM from 128Gb to 32 Gb.
After closing database, We rebooted server. While server trying to open it gave below error message:
As you know there many oracle process are running as background process.
You may now some of them or you may not. So You can find related process from oracle documentation or you can follow below steps:
Some of Oracle Process:
Read the rest of this entry »I got email from one of our customer. He says they have been changed their SMS system and they want to use https. But when they try to get select query return with below error message
ORA-29273: HTTP request failed ORA-06512: at "SYS.UTL_HTTP", line 1572 ORA-29024: Certificate validation failure ORA-06512: at line 1
I tried below query and get same error:
Select utl_http.request('https://smsservice.tuzla.bel.tr/SmsProxy.asmx') from dual;
After I investigate error I found Tim’s blog post. You can click here to get more details about his post.
What I do? Here are my steps:
In my previous post I shared some command which are related to get information RMAN backups. You can find this post in this link
In this post I try to give more details and examples for to get information about our RMAN backups
Read the rest of this entry »Yo may need to change your existing IP or hostname after installation for your setup
In this case I need to change my current IP to another on my standalone GI.
Operation System –> AIX 7.1
Oracle GI Version –> 12.1.0.2
