ORA-12154: TNS could not resolve the connect identifier specified (Solved)

ORA-12154: TNS could not resolve the connect identifier specified error comes when you try to connect Oracle database using clients/tools like SQL Plus, Toad, Oracle Forms, Oracle Reports, and SQL*Net could not find the alias specified for a connection in the TNSNAMES.ORA file or other naming adapters. Now, let’s reproduce the error and find out …

ORA-12154: TNS could not resolve the connect identifier specified (Solved) Read More »

How to Compile custom Oracle forms (fmb) and libraries(PLL) using frmcmp

This article explains how to compile custom forms (fmb), libraries(pll) using frmcmp utility in Oracle Apps.  frmcmp_batch frmcmp_batch or frmcmp_batch.sh is a UNIX level utility to compile custom form(.fmb) and libraries(.pll) in Oracle Apps R12. Syntax frmcmp_batch Module= Userid=<userid/password> [Parameters] Optional parameters are (default values given):   Steps to compile custom form (.fmb) Open Putty …

How to Compile custom Oracle forms (fmb) and libraries(PLL) using frmcmp Read More »

How to Create Materialized View in Oracle Apps 12.2.5 (R12)

Materialized views are the database objects in Oracle based on SQL Queries. Unlike the normal view, MV actually contains the data. The generic statement to create a Materialize View is, CREATE MATERIALIZED VIEW viewname [options] AS SELECT ….. While working on Oracle Apps 12.2.5 where editioning or online patching is enabled, you need to use …

How to Create Materialized View in Oracle Apps 12.2.5 (R12) Read More »

How to Install Oracle Developer Suite 10G On Windows

Oracle Developer Suite 10G provides Forms Developer, Designer, Reports Developer, and Oracle 10g JDeveloper tools. These tools let developers quickly build high-quality transactional applications, which can be deployed to multiple channels – including portals, web services, and wireless devices, and which can be extended with business intelligence capabilities – including ad hoc query and analysis, …

How to Install Oracle Developer Suite 10G On Windows Read More »