Hi Team, I am trying to connect my Oracle forms builder project to database. But i am not.
I tried several ways.
set env variable for tsnames.ora file.
set the case_sensitive to false.
ALTER SYSTEM SET SEC_CASE_SENSITIVE_LOGON=FALSE;
Also, tried several combinations for Username/password.
Followed- https://community.oracle.com/tech/developers/discussion/2178104/not-able-to-connect-to-database-in-oracle-forms-and-reports
My sqldeveloper connection for SYS-
tsnames.ora file present in --
C:\App\db_home\network\admin\tsnames.ora
# tnsnames.ora Network Configuration File: C:\App\db_home\NETWORK\ADMIN\tnsnames.ora
# Generated by Oracle configuration tools.
LISTENER_ORCL =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
ORACLR_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
(CONNECT_DATA =
(SID = CLRExtProc)
(PRESENTATION = RO)
)
)
ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
C:\ORA\MWFR\12cappr2\forms1\tsnames.ora
#
# sample tnsnames.ora file
#
# sample entry
#<ALIAS> = (DESCRIPTION =(ADDRESS_LIST =
# (ADDRESS = (PROTOCOL = TCP)
# (HOST = <HOST>)(PORT = <PORT>)))
# (CONNECT_DATA = (SID = <SID>)))
#
#
Now, please consider the above information to get the User id/ password to fill in below -(Oracle forms builder)
