Home / Oracle Error (page 4)

Oracle Error

Orocle Error Complete Soutions

ORA-02063: Preceding String Error

ORA-02063: Preceding String Error Sometimes an error crops up in Oracle that seems to have no solution of its own. Instead, these errors tag along with other errors in a quest to halt databases and frustrate database managers. The ORA-02063 is one of these followers – an error with an …

Read More »

ORA-12537: TNS: Connection Closed Error

ORA-12537: TNS: Connection Closed Error Oracle’s ability to be customized with deep mechanics in regards to the construction of company databases is one of many reasons that it has become so prevalent in corporations today. Due in part to the complex nature of Oracle database structures, occasionally errors can arise, …

Read More »

ORA-54002 when trying to create Virtual Column using REGEXP_REPLACE on Oracle 12cR2

I encountered an issue today trying to create a table in an Oracle 12cR2 database, the DDL for which, I extracted from an Oracle 11gR2 database. The error returned when trying to create the table was: ORA-54002: only pure functions can be specified in a virtual column expression The definition of …

Read More »

ORA-12154: TNS could not resolve service name

TNS could not resolve service name is a very common error, always related to your local copy of the tnsnames.ora file, your listener configuration, and your database name aliases. Make sure that your listener is listening for the same service name that you are using. Your service name might have …

Read More »

WARNING OGG-01223: Connection refused by target machine.

This problem happened when you did not put mgr port in extract process , when did not put mgr port in extract process then extract try to connect to dynamic port, to avoid this problem follow same as below configuration: Extract Configuration: ================================= [crayon-5adb8e380b49a996825525/]    

Read More »