Oracle Database&EBS General
-
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
-
Missing package when installing Grid Infrastructure 19c
I was hit that missing package messahe while installing Grid Infrastructure software on standalone installation. You may face an error on prerequest check steps which says that package cvuqdisk is required to be installed before Grid Infrastructure installation. You have 2 options in that steps Continue reading
-
How To Change ASMSNMP Password on Oracle 12c
I was try to re-configuring a cluster in the Cloud Control and in one of the steps is to configure access to the ASM part. For This part is used by the asmsnmp user, which is the one that must be configured. I did not know the password of this user. So I need to Continue reading
-
How to manage CRS and RAC services
In this post We will see how to check CRS related info and also how to stop/start RAC components. Here is the my system details: My db version : 11.2.0.4My Operating System : Linux 7My servers hostname : node1-node2My database name : ORCL01My instance name : ORCL011-ORCL012 Continue reading
-
How to Switchover Primary database to Standby Database in Oracle
In this post, I want to share Switchover process on Dataguard Setup. Primary Db version is 12c( 2 node RAC)Standby db is standalone Operation system is Linux Here is the steps: Continue reading
HELIOS BLOG 