I am sure solution mentioned in this article should help you to resolve this TNS 12154 error. NAMES.DIRECTORY_PATH = (TNSNAMES) Summary Sample SQLNET.ora entry, TRACE_LEVEL_CLIENT = OFF Verify TNSNAMES.ORA and SQLNET.ORA filesįirst, verify tnsnames.ora and sqlnet.ora file exists in ORACLE_HOME and there is a proper entry of the database which you are trying to connect.īelow is the default location for tnsnames.ora and sqlnet.ora files for Windows and Linux /Unix Operating System. Still facing the issue, it means something wrong with TNS entries. Then run the forms, your forms should work fine. ORACLE_HOME=C:\Oracle\Middleware\Oracle_FRHome1 If this does not work, just comment the TNS_ADMIN variable entry in default.env file as shown below and copy tnsnames.ora file to ORACLE_HOME path. So copy the tnsnames.ora file to the location specified by the TNS_ADMIN variable to resolve ORA 12154 error in Oracle forms.
TNS_ADMIN – C:\Oracle\Middleware\asinst_1\config The form builder is able to connect to the database during design time what happens when you run the form.įorm builder uses default.env file during run time and TNS_ADMIN variable to locate the tnsnames.ora file. Internet Explorer (IE) opens and launches the form service, but you get the error as shown below, Compile the form and then start the web logic server.
Open the Oracle form builder and connect it to the database. We are going to us Oracle Forms 11G on the Oracle Web logic server for demonstration. Now, let’s reproduce the error and find out solution for ora 12154.
0 kommentar(er)
