Home » Fusion Middleware & Colab Suite » Weblogic & Application Server » Problem In Switching Connection (Windows Server 2012, Forms12.2.1.2.0,Databse 12c )
Problem In Switching Connection [message #672627] Sat, 20 October 2018 00:03 Go to next message
deepakmannazhi
Messages: 136
Registered: February 2010
Location: Dubai, UAE
Senior Member

Dear Experts,

We have 3 Different Schema(DB User) in Our Application.

Application is connecting to User ABC

ABC/ABC@DB01

this we mentioned in formsweb.cfg.

After login

	call_form('Comp_Sele');




We are using separate buttons to connect to Different Schemas.

Using LOGOUT, LOGIN procedures.


IN WHEN-BUTTON-PRESSED TRIGGER WE ARE USING

BUTTON 1

 
  the_connect  := Get_Application_Property(CONNECT_STRING); 
  logout;
  logon('XYZ','XYZ@' || the_connect);


BUTTON 2

 
  the_connect  := Get_Application_Property(CONNECT_STRING); 
  logout;
  logon('TUV','TUV@' || the_connect);



This press event will navigate to another screen, from that screen when we press button to move to another screens, we are getting error showing invalid user id

ORA-01017: invalid username/password; logon denied


Is there any limitations in 12c for switching connections using LOGON procedure?


Thanks and Best Regards
Deepak





Re: Problem In Switching Connection [message #672631 is a reply to message #672627] Sat, 20 October 2018 09:14 Go to previous message
BlackSwan
Messages: 26606
Registered: January 2009
Location: SoCal
Senior Member
deepakmannazhi wrote on Fri, 19 October 2018 22:03
Dear Experts,

We have 3 Different Schema(DB User) in Our Application.

Application is connecting to User ABC

ABC/ABC@DB01

this we mentioned in formsweb.cfg.

After login

	call_form('Comp_Sele');




We are using separate buttons to connect to Different Schemas.

Using LOGOUT, LOGIN procedures.


IN WHEN-BUTTON-PRESSED TRIGGER WE ARE USING

BUTTON 1

 
  the_connect  := Get_Application_Property(CONNECT_STRING); 
  logout;
  logon('XYZ','XYZ@' || the_connect);


BUTTON 2

 
  the_connect  := Get_Application_Property(CONNECT_STRING); 
  logout;
  logon('TUV','TUV@' || the_connect);



This press event will navigate to another screen, from that screen when we press button to move to another screens, we are getting error showing invalid user id

ORA-01017: invalid username/password; logon denied


Is there any limitations in 12c for switching connections using LOGON procedure?


Thanks and Best Regards
Deepak





The database does not know or care from where the logon request originates.
Each new connection request that originates via the Oracle listener get logged into listener.log file.
Post excerpts from listener.log that shows the connection requests.

using sqlplus & using COPY & PASTE show us successful connection requests using username/password combinations above
Simply put, Oracle DB is too dumb to lie about ORA-01017 error.
Previous Topic: Create ShortCut to run Allpication in 10g form
Next Topic: Unable to bind portable JNDI name error
Goto Forum:
  


Current Time: Sun Oct 20 16:40:06 CDT 2019