June, 2020

• 15 June

  ORA-12804: parallel query server appears to have died with ORA-12801: error signaled in parallel query server

  

  Hi, When I run the SQL, I got ” ORA-12804: parallel query server appears to have died with ORA-12801: error signaled in parallel query server ” error.

  Read More »
• 13 June

  Alter session set current_schema for Setting Default Schema from Different Schema in Oracle

  

  I will explain Alter session set current_schema for Switching to a Different Schema in Oracle in this post.

  Read More »
• 12 June

  SP2-0750: You may need to set ORACLE_HOME to your Oracle software directory with SP2-0667: Message file sp1.msb not found | Set Oracle Home SID in Windows and Linux

  

  Hi, Sometimes You can get ” SP2-0750: You may need to set ORACLE_HOME to your Oracle software directory with SP2-0667: Message file sp1<lang>.msb not found ” error.

  Read More »
• 12 June

  PRCD-1229 : An attempt to access configuration of database was rejected because its version 18.0.0.0.0 differs from the program version 11.2.0.4.0. Instead run the program from 18c Home with PRCD-1027 : Failed to retrieve database MSDB

  

  Hi, Sometimes You can get ” PRCD-1229 : An attempt to access configuration of database was rejected because its version 18.0.0.0.0 differs from the program version 11.2.0.4.0. Instead run the …

  Read More »
• 9 June

  enq: SS – contention Wait Event in Oracle Database

  

  Hi, I will explain enq: SS – contention  Wait Event in this article.

  Read More »
• 5 June

  DIM-00014: Cannot open the Windows NT Service Control Manager, OPW-00001: Unable to open password-file

  

  Hi, Sometimes You can get ” DIM-00014: Cannot open the Windows NT Service Control Manager, OPW-00001: Unable to open password-file ” error.

  Read More »
• 5 June

  ORADIM Utility | Create Oracle Instance for Windows Environment

  

  Hi, I will explain ORADIM Utility in Oracle Database and Create Oracle Instance for Windows Environment in this post.

  Read More »
• 2 June

  ORA-39166: Object was not found or could not be exported or imported with ORA-31655: no data or metadata objects selected for job | parfile ( parameter file )

  

  Hi, Sometimes You can get ” ORA-39166: Object was not found or could not be exported or imported with ORA-31655: no data or metadata objects selected for job ” error.

  Read More »

May, 2020

• 28 May

  PLUGGABLE DATABASE HOT CLONE REFRESH AUTO

  

  Author     : Cihan Gedik Email        : [email protected] Linkedin  : https://www.linkedin.com/in/cihan-gedik-13b55065/ Group      : https://www.linkedin.com/groups/13792740/   PLUGGABLE DATABASE HOT CLONE REFRESH AUTO Compatible Versions Oracle Database 12.1.x and Later …

  Read More »
• 27 May

  enq: TX – allocate ITL entry in Oracle database and Goldengate Replicate Process

  

  Hi, You can see hight waits for event enq: TX – allocate ITL entry in AWR report and Goldengate Replicate process.

  Read More »
• 27 May

  ORA-39710: the database mode conflicts with the connection type

  

  Hi, Sometimes You can get ” ORA-39710: the database mode conflicts with the connection type ” error.

  Read More »
• 24 May

  ORA-02292: integrity constraint violated – child record found

  

  Hi, Sometimes You can get ”  ORA-02292: integrity constraint violated – child record found ” error.

  Read More »
• 17 May

  Tnsping Tips in Oracle

  

  I will explain Tnsping Tips in Oracle in this post.

  Read More »
• 16 May

  ORA-31603: object of type TYPE not found in schema and DBMS_METADATA.GET_DDL Privilige SELECT_CATALOG_ROLE in Oracle

  

  Hi, Sometimes developers need any table DDL using DBMS_METADATA.GET_DDL, but they don’t have related priviliges.

  Read More »
• 14 May

  ORA-00937: not a single-group group function

  

  Sometimes You can get ”  ORA-00937: not a single-group group function ” error.

  Read More »
• 14 May

  ORA-01434: private synonym to be dropped does not exist

  

  Hi, Sometimes You can get ”  ORA-01434: private synonym to be dropped does not exist ” error.

  Read More »
• 13 May

  ORA-15477: cannot communicate with the volume driver (dbd error: ocistmtexecute)

  

  Hi, Sometimes You can get ”  ORA-15477: cannot communicate with the volume driver (dbd error: ocistmtexecute) ” error.

  Read More »
• 13 May

  ORA-28094: SQL Construct not Supported by Data Redaction

  

  Hi, Sometimes You can get ”  ora-28094: sql construct not supported by data redaction  ” error.

  Read More »
• 13 May

  ORA-20000: Insufficient privileges to Analyze an object in Schema during Gather DBMS_STATS

  

  Hi, Sometimes You can get ”  ORA-20000: Insufficient privileges to Analyze an object in Schema  ” error during Gather DBMS_STATS Database, Schema, Table and Dictionary Stats.

  Read More »
• 12 May

  ORA-14006: invalid partition name

  

  Hi, Sometimes You can get ”  ORA-14006: invalid partition name ” error.

  Read More »
• 12 May

  ORA-46258: cleanup not initialized for the audit trail

  

  Hi, Sometimes You can get ” ORA-46258: cleanup not initialized for the audit trail ” error.

  Read More »
• 11 May

  Error in invoking target ‘mkldflags ntcontab.o nnfgt.o’ of makefile error During Grid Installation

  

  Hi, Sometimes You can get “Error in invoking target ‘mkldflags ntcontab.o nnfgt.o’ of makefile ” error During Grid Installation   Check related logfile. I saw “listener is currently in use …

  Read More »
• 10 May

  ORA-39358: Export dump file version 18.3.0.0.0 not compatible with target version 18.1.0.0.0

  

  Hi, Sometimes You can get ” ORA-39358: Export dump file version 18.3.0.0.0 not compatible with target version 18.1.0.0.0 ” during impdp operation.

  Read More »
• 9 May

  ORA-12696: Double Encryption Turned On, login disallowed

  

  Hi, Sometimes You can get “ORA-12696: Double Encryption Turned On, login disallowed ” error.

  Read More »
• 9 May

  TNS-12696: Double Encryption Turned On, login disallowed

  

  Hi, Sometimes You can get “TNS-12696: Double Encryption Turned On, login disallowed ” error.

  Read More »