Oracle Database&EBS General
-
Investigating SQL performance? But how? What i should control or use?
Investigating SQL performance is very big topic in Oracle worlds. Many times we hit performance issue during daily control. Many of performance problems are related with bad coding, changed plan, missing index or missing statistics. It my also related with server components too. Investigating SQL performance in an Oracle database involves analyzing and identifying performance Continue reading
-
Exadata? What is new?
Exadata.. If you are dba than its not possible to don’t hear Exadata machine. It is a popular and powerful database platform developed by Oracle Corporation. It is a most popular Appliance for Oracle database. Basically, It is designed for high-performance, scalable, and efficient processing of large volumes of data. I believe that, the most Continue reading
-
RMAN-06820 ORA-17629 ORA-12154 During Backup of a Standby Database
One of our customer hit below message during backup of a Standby Database. Db version is 11.2.0.4 (yeah I know its old one) and linux version is OEL 7.8 Error messages are: RMAN-03090: Starting backup at 20-May-23RMAN-06820: WARNING: failed to archive current log at primary databaseRMAN-06003: ORACLE error from target database:ORA-17629: Cannot connect to the Continue reading
-
Oracle Database Appliance (ODA)…Hımmm. I should use it?
In one of our customer want to use new server for their database. We offer Oracle Database Appliance (ODA) is an engineered system which is designed by Oracle. But why customer should prefer this engineered system? There are many competitors at current IT market. In this post, I try to explain why We offer Oracle Continue reading
-
General Approach’s check to Migrating an Oracle Database to newer version on new server
With each Oracle release, we need to make plan database upgrade. It can be move from 12c to 19c or higher. Its better to use new server(of course if its possible) for this migration. In this posts, i wanted to share general approach for database migration steps by using new server In this example we Continue reading
-
Get into Oracle Security Products Family
Oracle is a well-known name in the world of database management systems and enterprise software. The company provides a range of security products that help organizations protect their data from threats and vulnerabilities. In this blog post, we will take a closer look at some of the security products offered by Oracle. Continue reading
-
Imdp fail with ORA-30094: failed to find the time zone data file
I faced with that error during expdp&impdp process between 2 databases. There was no any issue on expdp process. I copied those export files to new server. While I started to impdp command it fails those errors: ORA-39097: Data Pump job encountered unexpected error -30094ORA-39065: unexpected master process exception in DISPATCHORA-30094: failed to find the Continue reading
-
Upgrading The Time Zone File And Timestamp With Time Zone Data Oracle Database12c
It is sometimes necessary to upgrade the time zone file and timestamp with time zone (TSTZ) data in an Oracle database, for instance when you upgrade to a new version of the database or when the rules for Daylight Saving Time (DST) change. Here is the our steps: Continue reading
-
TNS-00505: Operation Timed Out
I faced with that issue on 12c database. Error message detail is:TNS-00505: Operation timed out Here is the solution: To solve this error, follow below steps Continue reading
-
ORA-12012: error on auto execute of job “SYS”.”ORA$AT_OS_OPT_SY_**”
I got this error at alertlog on Oracle 18c Database.Complete errors are: There is an error in the Oracle alert log file!\nORA-12012: error on auto execute of job “SYS”.”ORA$AT_OS_OPT_SY_111029″ORA-20001: Statistics Advisor: Invalid task name for the current userORA-06512: at “SYS.DBMS_STATS”, line 49565ORA-06512: at “SYS.DBMS_STATS_ADVISOR”, line 881ORA-06512: at “SYS.DBMS_STATS_INTERNAL”, line 21631ORA-06512: at “SYS.DBMS_STATS_INTERNAL”, line 23763ORA-06512: at Continue reading
HELIOS BLOG 