Invalid username/password: logon denied may be the result of tnsnames and do wro

I tested it on my own windows.
There are two databases, only one can be a normal landing (the post installed)
But I just put the contents of the SQLNET.ORA into SQLNET.AUTHENTICATION_SERVICES = (NTS), no problem.

I'm setting is such
SQLNET.ORA:

NAMES.DIRECTORY_PATH= (TNSNAMES)

=========================================
LISTENER.ORA:

LISTENER1 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1522))
)

SID_LIST_LISTENER1 =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = orabu)
(ORACLE_HOME = C:\oracle\product\11.2.0)
(SID_NAME = orabu)
)
)

LISTENER =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
)

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = catdb)
(ORACLE_HOME = C:\oracle\product\11.2.0)
(SID_NAME = catdb)
)
)

ADR_BASE_LISTENER1 = c:\oracle\product\11.2.0\log

ADR_BASE_LISTENER = c:\oracle\product\11.2.0\log

=========================================
TNANAMES.ORA:

ORABU =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1522))
)
(CONNECT_DATA =
(SERVICE_NAME = ORABU)
(SID = ORABU)
)
)

CATDB =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = CATDB)
(SID = CATDB)
)
)

Do you have any questions?
Cannot log in is ORABU database
ERROR:
ORA-01017: invalid username/password; logon denied

Started by Claudia at November 20, 2016 - 3:38 PM

When you set SQLNET.AUTHENTICATION_SERVICES = (NTS), using Windows local user landing, on behalf of SYSDBA.

This user is not present in the Oracle, so removed not landing.

Recommendations are as follows:
Create a new user with windows local user after landing, giving DBA permission. You can use this new user database.

Posted by King at November 25, 2016 - 4:13 PM

Or sys login after the new user.

Posted by Aubrey at December 02, 2016 - 5:00 PM