Hi,
I'm trying to connect from linux with domain user to remote Windows Oracle database and I'm getting ORA-1017: invalid username/password; logon denied
Using:
sqlplus "OPS$DOMAIN-COM\SERVICE.DB/password@TEST
In Oracle I created user IDENTIFIED EXTERNALLY. I tested it from remote Windows server and I was able to logon to Windows Oracle database( started CMD as domain user and connect with sqlplus /@TEST and it was working)
CREATE USER "OPS$DOMAIN-COM\SERVICE.DB" IDENTIFIED EXTERNALLY
DEFAULT TABLESPACE TOOLS
TEMPORARY TABLESPACE TEMP;
GRANT CREATE SESSION TO "OPS$DOMAIN-COM\SERVICE.DB";
I'm getting ORA-1017: invalid username/password; logon denied
On linux (client side) sqlnet.ora:
SQLNET.AUTHENTICATION_SERVICES = (BEQ,NTS)
NAMES.DEFAULT_DOMAIN=DOMAIN-COM
Do you know where can be a problem?
Thanks,
jan