-
Operations on Scan listener
There arethe some example of stop/start/add/relocate SCAN Listener command. Here is example: Continue reading
-
How to Import Your Data to Autonomous Cloud Database
If you are using Autonomous Database on Oracle Cloud services you may need to import your on prime database’s data using some methods to cloud. Oracle Data Pump (AKA expdp, impdp) is one of the recommended way to move your existing schemas or data to migrate Autonomous Database on cloud. There are many useful… Continue reading
-
How to increase apply rate on Standby Database
If your primary has huge load or if there are huge gap on your standby, you may need to increase your apply rate on your standby database.Do not forget your standby server’s CPU and Disk should be strong enough for this actions. Here is the steps Continue reading
-
12.2 space advisor job fails with ORA-12012 and ORA-00060:
Hi friends… One of our 12.2 db we got below errors from alertlog: ORA-00060: deadlock resolved; details in file /u01/app/oracle/diag/rdbms/db_name/DB_NAME/trace/DB_NAME_j001_10041.trcORA-12012: error on auto execute of job “SYS”.”ORA$AT_SA_SPC_SY_56337″ORA-00060: deadlock detected while waiting for resourceORA-06512: at “SYS.DBMS_SPACE”, line 2741ORA-06512: at “SYS.DBMS_HEAT_MAP_INTERNAL”, line 716ORA-06512: at “SYS.DBMS_HEAT_MAP_INTERNAL”, line 1164ORA-06512: at “SYS.DBMS_HEAT_MAP”, line 228ORA-06512: at “SYS.DBMS_SPACE”, line 2747 Continue reading
-
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
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 