-
How to Compare Schemas between databases
For some reason, We need to compare between Test Schema objects with Prod Schema objects to can see a difference. Its possible to do that by using am going to share one document which is using TOAD program for this purpose. I hope you enjoy it. How to Generate A Schema Script to Compare with… Continue reading
-
ORA-00054: resource busy and acquire with NOWAIT specified error
You can hit ORA-00054: resource busy and acquire with NOWAIT specified error during some of your operations on your database such as alter some objects. The main reason for this error is Table Level Locks(TM lock). The transaction holds two locks (Row Locks(TX) and Table Locks(TM) when the session opens. So What are those locks? Continue reading
-
Oracle Database 18c Now Available on Oracle Database Appliance
This good news published in this link Oracle database appliance (aka ODA) is one of the best appliance machines. ODA is already certified by 11g-12c EE and SE versions. By this certification, the Hybrid Columnar Compression (HCC) functionality will be made available starting with the Database 18c release. Continue reading
-
TNS-12547: TNS-12560: TNS-00517
I have this error while I try to start my listener on R12 instance whit 10g database. While I try to start listener for my production, I have an error such as TNS-12547: TNS:lost contact TNS-12560: TNS:protocol adapter error TNS-00517: Lost contact Linux Error: 32: Broken pipe Continue reading
-
Statspack report in Oracle
As you know We already on 18c version, but I still see some questions which are related performance issues and how We can use Statpack reports. Its available since Oracle 8i, I want to share some Metalink documents which covers what is Statspack report, How We can install&run and read it, Purpose of usage Statspack reports Continue reading
-
ORA-04031: unable to allocate 976 bytes of shared memory (“shared pool”,”MGMT_JOB_ENGINESYSMAN”,”sga heap(1,1)”,”library cache”)
I hit this error while running the catupgrd.sql script during 10gR2 32 bit to 10G 64 bit on Windows Operating System. I was moving my 10.2.0.2 database from windows 2003-32 bit to windows2008-64 bit. As a mention, My source DB version is 10.2.0.2 and my target server database version is 10.2.0.4 which is certified with… Continue reading
-
ORA-01089-immediate shutdown in progress
I face this error message while I try to move my archive logs from one mount point to other and register my archive logs to Oracle 11gR1 database(11.1.0.7.0) on OEL 5.5 x-86-64. I had some space problem and I need to move my archive logs from mount point /u01 to /u02. After the copy process,… Continue reading
-
EXP-00113 & EXP-00006 Errors During Export On 11g Database
As you know, We use the export utility for many cases. I faced with that error on 11.2.0.2 DB on AIX 6.1 system. During export an error message EXP-113 is raised: EXP-00113: Feature New Composite Partitioning Method is unsupported. Table MYTABLE could not be exported But the export would still complete and also there are some addition… Continue reading
-
Oracle Database Security Assessment Tool-DBSAT
The Oracle Database Security Assessment Tool (DBSAT) analyzes database configurations and it tells us uncovers security risks and improves the security posture of Oracle Databases. Its very easy to use that tool. We can use DBSAT to implement and enforce security practices in our Oracle databases. DBSAT generate reports which We can easly find what… Continue reading
-
Is 18c available on-premise?
As you know, 18c come into our lives. Many people asking about DBA job will die or We should choose the dba path for our carriers. This subject is one other blog post topic I only want to say, I believe that If data exists than DBA or some other title will be available in… 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 