How to fix ORA-12547 TNS lost contact when try to connect to Oracle
Issue / Oracle error
sqlplus scott/tiger
SQL*Plus: Release 10.2.0.5.0 - Production on Wed May 18 09:32:35 2011
Copyright (c) 1982, 2010, Oracle. All Rights Reserved.
ERROR:
ORA-12547: TNS :lost contact when try to connect to Oracle.
Issue description
I saw that TNS connection issue along with ORA-12547 Oracle error several times, usually when trying to connect to Oracle database server on Unix / Linux host with an OS user that does not belong to oinstall group (Oracle binaries owner group). In this case, interesting enough that local TNS connection to database (when using tnsnames alias) works fine: Read more »
Oracle Data Pump (expdp) schema export fails with ORA-01801
Platform
Oracle Database Server 10gR2 (10.2.0.5)
Problem
Data Pump (expdp) schema export fails on Oracle 10gR2 with following Oracle error:
ORA-39125: Worker unexpected fatal error in KUPW$WORKER.UNLOAD_METADATA while calling DBMS_METADATA.FETCH_XML_CLOB [TABLE_STATISTICS]
Read more »
ORA-01801: date format is too long for internal buffer
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 105
ORA-06512: at "SYS.KUPW$WORKER", line 6313
Unable to DDL due to Oracle Spatial and XDB
I’ve just encountered an interesting Oracle database issue that was not described properly on the Internet. So, I’ve decided to give a solution in this post.
The issue is that you simply can not execute certain DDL (Data Definition Language) SQL statements due to the strange behavior of Oracle triggers and Oracle error ORA-00604 and ORA-04098. Read more »