-
ORA-19809&ORA-19804 during RMAN backup
I hit this error message during taking rman hot backup on one of my databases. Complete Error message is:RMAN-00571: ===========================================================RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============RMAN-00571: ===========================================================RMAN-03009: failure of backup command on ch1 channel at 21/12/2020 10:30:41ORA-19809: limit exceeded for recovery filesORA-19804: cannot reclaim 5487325853476 bytes disk space from 37418520 limit Actullay error is already… Continue reading
-
19c on Windows gives ORA-27300: OS system dependent operation:write failed with status: 5 ORA-27301: OS failure message: Access is denied. ORA-27302: failure occurred at: sskgmsmr_11
I face with that error on 19c version on Windows operating system. Alertlog has below error messages: ORA-27300: OS system dependent operation:write failed with status: 5ORA-27301: OS failure message: Access is denied.ORA-27302: failure occurred at: sskgmsmr_11 After investigate issue I have found below explanations Continue reading
-
OEM config show wrong node name in repo
If you have RAC system you need to verify your information is correct on configuration files. To can see it run below command as oracle user [oracle@Node1~]$ emca -config dbcontrol db -repos create -cluster As you can see we need to change it Continue reading
-
The Host CPU Chart Could Not Be Generated Error on OEM Home Page
I faced with that issue on while I recreated repo on 11.2.0.4 RAC system. My step is: [oracle@node1~]$ emca -config dbcontrol db -repos create -cluster <<<<< Enter the related information After related steps done the login to the database Console works fine. The Target is shown as UP but the ‘host cpu’ section in the… Continue reading
-
Getting ORA-01031: insufficient privileges while try to create trigger on 19c
I face with this error on Oracle19c database. My user has sysdba and also dba grant with create any trigger privilege. Complete message is: conn myuser/mypass@DB_SID SQL> create or replace trigger xxxxbeginnull;end;create or replace trigger xxxx*ERROR at line 1:ORA-01031: insufficient privileges Continue reading
-
ORA-00845: MEMORY_TARGET not supported on this system on Grid Infra Installation
I faced with that error during 19c standalone installation on linux. In Grid Installation step I get below error: INFO: [Nov 17, 2020 12:05:21 PM] Skipping line: Configuring HA resource failed. INFO: [Nov 17, 2020 12:05:21 PM] PRCR-1079 : Failed to start resource ora.asm INFO: [Nov 17, 2020 12:05:21 PM] Skipping line: PRCR-1079 : Failed… Continue reading
-
Linux Error: curl#6 – “Could not resolve host: mirrorlist.centos.org; Unknown error”
On linux yum is very useful to install package on operating system. You may hit this error while try to use yum. So here is the solutions steps but first let us see exact error message: [root@veridata yum.repos.d]# yum install httpdLoaded plugins: fastestmirror, langpacksLoading mirror speeds from cached hostfileCould not retrieve mirrorlist http://mirrorlist.centos.org/?release=7&arch=x86_64&repo=os&infra=stock error was14:… Continue reading
-
There was a problem creating the SQL Profile ORA-06502: PL/SQL: numeric or value error ORA-06512: at line 1
I face with that error while try to set SQL Plan on one of my sql. This is the one of he published bug. Bug 10313110 SQL Advisor raises an ORA-13786 when Trying to Implement a Recommended Parallel Profile If I try to use below syntax its also through error message such as: Continue reading
-
How to Scan New LUNs and SCSI Disks on Linux Using the rescan-scsi-bus.sh Script
The “rescan-scsi-bus.sh” can be used to scan new LUNs in a CentOS/RHEL machine. When ‘rescan-scsi-bus.sh -i’ is run, script execute as well a LIP_RESET (ISSUE_LIP) which may cause a disruption in I/O on the server and even cause an outage in case of a system running on heavy load. Redhat says this type of scan… Continue reading
-
How to Setup Disks for GI Installation on VMware Workstation
In this post I want to share my pdf file which covers step by step Disk preparation for Grid Installation on VMware Workstation You may need to add and format related disks for ASM setup Please click download button to can download step by step document. Continue reading
AWARDED TOP 60 ORACLE BLOGS SINCE 2018
Recent Posts
- Oracle CDB vs Non-CDB: A Future-Ready Database Architecture
- Hot Cloning of a PDB in Oracle Database
- Oracle + Artificial Intelligence = Smarter Database Management
- Understanding UNDO Tablespace in Oracle Database: Importance and Best Practices
- Fortifying Your Cloud: Understanding the OCI Zero Trust Landing Zone
CATEGORIES
- Cloud Computing Tutorials
- My Presentations
- Oracle Cloud Journey
- Oracle Database&EBS General
- Oracle E-Business Suite Release 11
- Oracle E-Business Suite Release 12
- Scripts for Oracle E-Business Suite
- Some other Oracle Products Installation
- Step by Step Oracle E-Business Suite Installation
- Video Tutorials
HELIOS BLOG 