Oracle Forms || Ora-12514 : TNS listener doesnt know of the current descriptor || 12.2.1.3.0
Hello Everyone,
I Am receiving Ora-12514 TNS Listener does not currently know of the service requested in the connect descriptor Message.
When we try to connect to Oracle forms
http://hostname:9005/Forms/frmservlet?config=myconfig.
This is the tnsentry in my tnsnames.ora file.
Location : <Domain_HOME/>config/FMWConfig/
DBINSTANCE =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = PrimaryDB)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = SecondaryDB)(PORT = 1521))
)
(CONNECT_DATA =
(SID = DBinstanceprd_pm.world)
)
)
**Key Points :
1) I was able to connect to DB instance from SQL plus without issues
Cmd Prompt : Oracle_home\bin\sqlplus
sqlplus dbuser/dbpasswore@dbinstance
Result : connected succesfully
2) no issues connecting from forms builder