SQLNET.AUTHENTICATION_SERVICES = (NONE) ORA-01017 [message #670681] |
Thu, 19 July 2018 06:42 |
|
sagar.sandbhor
Messages: 5 Registered: July 2018
|
Junior Member |
|
|
Hi All,
I am trying to create the duplication of the database on Windows 2008R2. I had created ORGDB during installation of the Oracle 12.2.
See Properties of ORGDB -> security:
Administrator, OracleServiceORGDB is part of this.
When I am setting ORACLE SID to ORGDB, SQLNET.AUTHENTICATION_SERVICES = (NTS) or SQLNET.AUTHENTICATION_SERVICES = (NONE) I am able to connect to the DB.
remote_login_passwordfile='EXCLUSIVE'
I have created the pwd.ora file with a complex password(include a-z, A-Z, 0-9 and special char).
***************************************************************************************************
C:\Users\Administrator>set ORACLE_SID=ORGDB
C:\Users\Administrator>sqlplus
SQL*Plus: Release 12.2.0.1.0 Production on Thu Jul 19 16:52:27 2018
Copyright (c) 1982, 2016, Oracle. All rights reserved.
Enter user-name: sys as sysdba
Enter password:
Connected to:
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
SQL>
***************************************************************************************************
To recreate duplicate(MYDUP) the DB I have copied the datafile, created init.ora and created password file PWD$SID.ora.
I check the service created as NT SYSTEM\OracleService$SID
Check the properties of MYDUP->security:
Created with Administrator
When I set SQLNET.AUTHENTICATION_SERVICES = (NTS) I am able to connect to DUP DB sucessfully.
***************************************************************************************************
C:\Users\Administrator>set ORACLE_SID=MYDUP
C:\Users\Administrator>sqlplus
SQL*Plus: Release 12.2.0.1.0 Production on Thu Jul 19 16:52:27 2018
Copyright (c) 1982, 2016, Oracle. All rights reserved.
Enter user-name: sys as sysdba
Enter password:
Connected to:
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
SQL>
***************************************************************************************************
SQLNET.AUTHENTICATION_SERVICES = (NONE)
***************************************************************************************************
C:\Users\Administrator>set ORACLE_SID=MYDUP
C:\Users\Administrator>sqlplus
SQL*Plus: Release 12.2.0.1.0 Production on Thu Jul 19 16:56:13 2018
Copyright (c) 1982, 2016, Oracle. All rights reserved.
Enter user-name: sys as sysdba
Enter password:
ERROR:
ORA-01017: invalid username/password; logon denied
Enter user-name:
***************************************************************************************************
The MYDUP is created with NT SERVICE\OracleServiceMYDUP.
Here is my questions:
1. Do windows prefer NTS over NONE as Authentication service, does it recommended by Windows/Oracle?
2. if authentication set as NONE and it is connecting to ORGDB and why it is not connecting to MYDUP?
3. Is there any way I can connect to the MYDUP by providing administrator rights?
4. I even tried to add the user to the ora_dba but still unable to login to MYDUP. Could you please let me know what is missing here?
Help appreciated.
Thanks....
|
|
|