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

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

Yazının devamını oku »

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 shows:

The host cpu chart could not be generated.
1. Error: Invalid BoundDataSource: no class, method or dataSource provided.
2. check the log file for details

– The ‘Active Sessions’ section shows

The Active Sessions chart could not be generated.
1. Error: Invalid BoundDataSource: no class, method or dataSource provided.
2. check the log file for details

Even I try drop and recreate repos but still hitting same issue
emca -deconfig dbcontrol db -repos create -cluster  <<< for drop
emca -deconfig dbcontrol db -repos drop -cluster    <<< for recreate
Yazının devamını oku »

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 xxxx
begin
null;
end;
create or replace trigger xxxx
*
ERROR at line 1:
ORA-01031: insufficient privileges

Yazının devamını oku »

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 to start resource ora.asm
INFO: [Nov 17, 2020 12:05:21 PM] CRS-2674: Start of 'ora.LISTENER.lsnr' on 'veridatait' failed
INFO: [Nov 17, 2020 12:05:21 PM] Skipping line: CRS-2674: Start of 'ora.LISTENER.lsnr' on 'nodename' failed
INFO: [Nov 17, 2020 12:05:21 PM] CRS-5017: The resource action "ora.asm start" encountered the following error:
INFO: [Nov 17, 2020 12:05:21 PM] Skipping line: CRS-5017: The resource action "ora.asm start" encountered the following error:
INFO: [Nov 17, 2020 12:05:21 PM] ORA-00845: MEMORY_TARGET not supported on this system
INFO: [Nov 17, 2020 12:05:21 PM] Skipping line: ORA-00845: MEMORY_TARGET not supported on this system
INFO: [Nov 17, 2020 12:05:21 PM] . For details refer to "(:CLSN00107:)" in "/u01/app/oracle/diag/crs/nodename/crs/trace/ohasd_oraagent_oracle.trc".
INFO: [Nov 17, 2020 12:05:21 PM] Skipping line: . For details refer to "(:CLSN00107:)" in "/u01/app/oracle/diag/crs/nodename/crs/trace/ohasd_oraagent_oracle.trc".
INFO: [Nov 17, 2020 12:05:21 PM] Skipping line:
INFO: [Nov 17, 2020 12:05:21 PM] CRS-2674: Start of 'ora.asm' on 'veridatait' failed
INFO: [Nov 17, 2020 12:05:21 PM] Skipping line: CRS-2674: Start of 'ora.asm' on 'nodename' failed
INFO: [Nov 17, 2020 12:05:21 PM] Skipping line:
INFO: [Nov 17, 2020 12:05:21 PM] Completed Plugin named: asmca
Yazının devamını oku »

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 httpd
Loaded plugins: fastestmirror, langpacks
Loading mirror speeds from cached hostfile
Could not retrieve mirrorlist http://mirrorlist.centos.org/?release=7&arch=x86_64&repo=os&infra=stock error was
14: curl#6 – “Could not resolve host: mirrorlist.centos.org; Unknown error”

Yazının devamını oku »

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:

Yazının devamını oku »

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 can be distributive,since it can cause delays while I/O operation timeout and remove devices unexpectedly from OS.

So perform this scan when really you want to scan the disks and LUNS.

Yazının devamını oku »

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.

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

Yazının devamını oku »

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 change it with new one.

To make this, We have two options. Those option can be use Oracle 12c to 20c.

Yazının devamını oku »