Win a copy of Re-engineering Legacy Software this week in the Refactoring forum
or Docker in Action in the Cloud/Virtualization forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Connect oracle databse from Websphere 6.1 with OS Authentication

 
Lasy Gsd
Greenhorn
Posts: 3
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi All,

We are using thin client to connect to oracle database from websphere using JNDI data source with JBDC driver and it is working fine.
Now we have enabled OS authentication in Oracle so OS user can log into the database without giving any credentials.
how do i configure websphere to use OS authentication to connect to oracle
Am using oci driver and i do not know what to do with JAAS authetication username and password in the JAAS alias to filed is must
Please help me
 
Sekhar Choudary
Ranch Hand
Posts: 57
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator

Hi,

Are your websphere and Database running on same machine ?


You can use local OS user names only to use Websphere for OS Authenitcation.




 
Lasy Gsd
Greenhorn
Posts: 3
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Yes Both App and DB are on the same machine.
When you connect to oracle database from websphere we do use jdbc thin driver and also we need to pass database login credentials. But here we do not want to pass the login credentials to log into oracle so we are trying to use oci driver instead of thin. But we do not know what all changes need to done in websphere side .
I can log into oracle database from the machine as os user ( sqlplus / ) it wont ask usernamer and password, like this i want to connect to oracle from websphere using os authentication.


Please help ASAP
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic