Oracle Database&EBS General
-
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
-
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
-
Recovering Standby Database Using Incremental RMAN (Roll Forward )
Sometimes standby database lags far behind from the primary database leading to Archive Gap. There are some reasons could be for that such as Network issue between the primary and the standby database leading to the archive gaps. Standby archive log dest may be full or Standby db disk becomes full so the primary and the Continue reading
-
How to Monitor Data Pump Job (IMPDP)
Datapump (expdp&impdp) is very useful tool while you need to take data from one DB to another or on the same database. So its very critical to know what is import status, what import do exact time etc. In this post, I will share some useful SQL to can monitor data pump jobs. Continue reading
-
How to enable Flashback on Standby Database
Flashback Database quickly rewinds an Oracle database to a previous point in time to correct any problems caused by logical data corruptions or user errors. Flashback A database is like a ‘rewind button’ for your database. To revert the entire database to a prior point in time, you can either revert the entire database to Continue reading
HELIOS BLOG 