My Oracle Support Banner

GLBALFIX When Enter APPS_ACCOUNT Parameter Get ORA-12203: TNS:unable to connect to destination "Warning: You are no longer connected to ORACLE" (Doc ID 1933947.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle General Ledger - Version 12.1.3 and later
Information in this document applies to any platform.
GLBALFIX

Symptoms

On : 12.1.3 version, Balances and related objects

When run GLBALFIX to correct data in GL_BALANCES, after entering 'gl' for the GL_ACCOUNT and the password for GL_PASSWD, when enter the value for the APPS_ACCOUNT, it closes SQL*Plus and the following error occurs:-

ERROR
-----------------------
Enter value for gl_account: gl
Enter value for gl_passwd: gl
ERROR:
ORA-12203: TNS:unable to connect to destination


Warning: You are no longer connected to ORACLE.
Not connected
Not connected
...
Enter value for apps_account:

ERROR:
ORA-12203: TNS:unable to connect to destination


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run GLBALFIX

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.