Oracle Database&EBS General
-
How to resolve ORA-01111, ORA-01110, ORA-01157 errors
You may hit this error on your standby database. I have 12c standalone database with dataguard setup. We got ORA-01111, ORA-01110, ORA-01157 errors on standby database and apply has been stoped. There are many reasons for a file being created as UNNAMED or MISSING in the standby database, including insufficient disk space on standby site Continue reading
-
How to use/enable Flash for Enterprise Manager’s Screen Part II
As you know Adobe ended support for Flash at the end of 2020. However, late last year Adobe announced that they had actually implemented a ‘kill switch’ that would cause existing installs of Flash to simply stop working entirely on 12th of Jan 2021. As of today (22th Jan 2021) anyone trying to use Oracle Continue reading
-
How to Maintenance AUD$ Table
In this post I will explain How to Delete&Purge Audit Trail Table. Auditing is the monitoring and collection of some user database actions and record these data in some tables. Auditing is always enabled. Oracle Database generates audit records during or after the execution phase of the audited SQL statements. But AUD$ table will growth Continue reading
-
ORA-39127: ORA-20000 DRG-10502 During export
I faced with that error during export process on Oracle 12c RAC database Complete error message is: ORA-39127: unexpected error from call to local_str := SYS.DBMS_EXPORT_EXTENSION.GET_DOMAIN_INDEX_METADATA(‘INDEX_NAME_HERE’,’SCHEMA_NAME_HERE’,’TEXTINDEXMETHODS’,’CTXSYS’,12.01.00.02.00,newblock,0) ORA-20000: Oracle Text error: DRG-10502: index SCHEMA_NAME_HERE”.”INDEX_NAME_HERE does not exist ORA-06512: at “SYS.DBMS_EXPORT_EXTENSION”, line 274 ORA-06512: at line 1 ORA-06512: at “SYS.DBMS_METADATA”, line 9524 Continue reading
-
Vi editor gives History file has no read permission error on AIX 7.1
I face with that error message on AIX 7.1 which is hosting our Oracle 18c database. While i try to open any documents by using vi editor, it gives below error but the actual operation is not affected $ vi initprod.oraHistory file has no read permission. [Hit return to continue] Continue reading
-
How to still use/enable Flash for Enterprise Manager’s Screen
Introduction As you know Adobe ended support for Flash at the end of 2020. However, late last year Adobe announced that they had actually implemented a ‘kill switch’ that would cause existing installs of Flash to simply stop working entirely on 12th of Jan 2021. As of today (22th Jan 2021) anyone trying to use Continue reading
-
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
HELIOS BLOG 