Connect Oracle using SqlPlus by Domain User

Question

Client and Server machines are under Domain. I am trying to connect orace db using SqlPlus tool. I am getting

ERROR:
ORA-01017: invalid username/password; logon denied

though username and pwd is right.

Connect Command :

SqlPlus DomainName\UserName/passowrd@school

Database address in tnsnames.ora

school =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = machinename)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = PRD)
    )
  )

Is there any wrong in database address? Way of connect?

Thanks in Advance

Nick Krasnov · Accepted Answer · 2012-09-23 22:35:12Z

3

There is no need of specifying DomainName in front of a username in sqlplus to connect to an instance.

sqlplus username/password@connect_identifier

Also check these options

Try to use use IP address instead of computer name in tnsnames.ora
Set parameter NAMES.DEFAULT_DOMAIN in sqlnet.ora
Specify a fully qualified computer name (computername.domain) in tnsnames.ora

edited Sep 23, 2012 at 22:35

answered Sep 1, 2012 at 13:24

Nick Krasnov

27.3k6 gold badges66 silver badges81 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Connect Oracle using SqlPlus by Domain User

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related