Home » Developer & Programmer » Forms » Oracle forms Kerberos authentication (oracle forms 12c windows 2012)
Oracle forms Kerberos authentication [message #661600] Fri, 24 March 2017 11:40 Go to next message
marinab
Messages: 8
Registered: March 2017
Junior Member
Hi,
we have oracle databases 12c on windows 2012 configured with Kerberos authentication. oracle client 12c and sqldeveloper 4.1.5 are working perfect. The application designed in oracle forms. we planning move to 12c and I need Kerberos authentication in connection.
I found java code connect to oracle database using jdbc thin driver connection. It is working perfect. How I can use this connection into oracle forms.
Please help
Thanks Marinab
Re: Oracle forms Kerberos authentication [message #661605 is a reply to message #661600] Fri, 24 March 2017 13:12 Go to previous messageGo to next message
BlackSwan
Messages: 26648
Registered: January 2009
Location: SoCal
Senior Member
Do you have configuration similar to below?

EndUser<=>browser<=>webserver<=>ApplicationServer<=>DatabaseServer

If so, "forms" never talks directly to Oracle DB
Re: Oracle forms Kerberos authentication [message #661606 is a reply to message #661605] Fri, 24 March 2017 13:21 Go to previous messageGo to next message
marinab
Messages: 8
Registered: March 2017
Junior Member
yes, I have
what is your suggesting?
What should I change?
marinab
Re: Oracle forms Kerberos authentication [message #661607 is a reply to message #661606] Fri, 24 March 2017 13:47 Go to previous messageGo to next message
BlackSwan
Messages: 26648
Registered: January 2009
Location: SoCal
Senior Member
marinab wrote on Fri, 24 March 2017 11:21
yes, I have
what is your suggesting?
What should I change?
marinab
I do NOT understand what problem you are trying to solve.
JDBC is used by some clients to connect (CREATE SESSION) to Oracle database.
In the 3-tier architecture it is the application server which logs into the Oracle database.
IMO, the use of Kerberos only adds complication between application server & database server.
If you insist it must be included, please explain what benefit is gained by doing so.
Re: Oracle forms Kerberos authentication [message #661609 is a reply to message #661607] Fri, 24 March 2017 13:53 Go to previous messageGo to next message
marinab
Messages: 8
Registered: March 2017
Junior Member
Ok,
Help me configure oracle forms 12c using Kerberos authentication.
I'm open for any suggestion.
marinab
Re: Oracle forms Kerberos authentication [message #661612 is a reply to message #661609] Fri, 24 March 2017 14:34 Go to previous messageGo to next message
BlackSwan
Messages: 26648
Registered: January 2009
Location: SoCal
Senior Member
marinab wrote on Fri, 24 March 2017 11:53
Ok,
Help me configure oracle forms 12c using Kerberos authentication.

EXACTLY how, what, or where do you want, desire or expect Kerberos authentication to be used in 3-tier architecture below?

EndUser<=>browser<=>webserver<=>ApplicationServer<=>DatabaseServer
Re: Oracle forms Kerberos authentication [message #661613 is a reply to message #661612] Fri, 24 March 2017 14:52 Go to previous messageGo to next message
marinab
Messages: 8
Registered: March 2017
Junior Member
Hi,
could be on webserver or on database server. Like I mention before, all components (client, webserver, database) on windows.
maybe some plugin I can use.
marinab
Re: Oracle forms Kerberos authentication [message #661641 is a reply to message #661613] Sun, 26 March 2017 11:22 Go to previous message
marinab
Messages: 8
Registered: March 2017
Junior Member
Hi Guys,
I still open to any suggestion.
On Forms server I configured Kerberos client sqlnet.ora(put trace);
When I try login in form; Kerberos using "server user" authentication and connection to database;
I guess I need some Javascript called on-login trigger take username from login screen
and created KDC ticket on forms server and login to database using this account.
Please help
Marinab
Previous Topic: Dynamic Database link
Next Topic: ole2 package 'saveas' .xml file to tab-delimited .txt file
Goto Forum:
  


Current Time: Sun Jan 19 15:42:20 CST 2020