Home » RDBMS Server » Security » OS Authentication Followup
OS Authentication Followup [message #54815] Fri, 06 December 2002 10:52 Go to next message
Sid
Messages: 38
Registered: May 1999
Member
This was a precursor to my current problem of getting OS Authentication to work with OCI.

I have been successful in getting it to work with sqlplus.

Thanks a lot to psmyth, Ravi and Helena

I wanted to test whether OS authentication works in my environment. Now that I've gotten past the initial obstacle, can someone tell me how I can get it to work with OCI?

Our program uses Oracle backend via OCI. The parameters used in our software are:
database instance, username, password.
TWO_TASK has been set to the correct database.
Should I not specify the username/pwd or should I specify them as "" or something else?

With username "sdesai" but no password:
[[ORA8_ERR #13003]]: Oracle Error: Number 1005
Message: Error while trying to retrieve text for error ORA-01005

With username "sdesai" and password "":
[[ORA8_ERR #13003]]: Oracle Error: Number 1005
Message: Error while trying to retrieve text for error ORA-01005

With no username and password:
[[ORA8_ERR #13003]]: Oracle Error: Number 1017
Message: Error while trying to retrieve text for error ORA-01017

Any help will be appreciated.

-Siddharth
Re: OS Authentication Followup [message #54816 is a reply to message #54815] Fri, 06 December 2002 11:41 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Verify that the OCISessionBegin() call correctly
specifies OCI_CRED_EXT  attribute as its fourth
parameter.  In the case of OCI8 for OCISessionBegin
(*svchp,*errhp,*usrhp,credt,mode), credt specifies the 
type of credentials being used to establish the user 
session. Use OCI_CRED_EXT when authenticating using 
external credentials. 

Re: OS Authentication Followup [message #54818 is a reply to message #54815] Sat, 07 December 2002 00:03 Go to previous message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
okie.
then i beleive, u have change OCI options only.
I asked to check whether if u can connect via sqlplus becuase, if u cannot do that, there are many other settings, we need to look into (like NLS parameters etc, TWO_TASK etc).
that is not your case now.
the only option i know is to change the OCI setting in your CODE.
Previous Topic: DBMS_OBFUSCATION_TOOLKIT not present !
Next Topic: forgot password
Goto Forum:
  


Current Time: Thu Mar 28 16:58:55 CDT 2024