Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Oracle Connection - Domain User

712634Sep 24 2012 — edited Oct 1 2012

Hi,

I am trying to connect oracle database with Domain User. I am facing weird behavior.

When first time the domain user connects database, it is getting failed. Next time, It is connected.

I followed below steps to connect database as domain user

1. Run cmd.exe
2. runas /user:domainname\username cmd.exe
3. SqlPlus /@instancename - at new cmd.exe
4. ORA-01017: invalid username/password; logon denied.
5. Again execute SqlPlus /@instancename
6. Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

Oracle Version : 11g

I have followed below steps to make oracle to authenticate OS user or domain user

1. os_authent_prefix = '' empty value
2. set SQLNET.AUTHENTICATION_SERVICES=NTS in sqlnet.ora
3. Added registry key OSAUTH_PREFIX_DOMAIN = TRUE

Have anyone faced this problem? What may be the cause? Is there any way to see the Oracle Connection logs if so how to enable that?

Thanks in Advance

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 29 2012

Added on Sep 24 2012

#11g, #database, #general-database-discussions, #oracle, #windows

20 comments

2,184 views