ORA-12631: Username retrieval failed

ORA-12631: Username retrieval failed

Following error occurred when i tried to login my database. Services of Oracle is running. I also restarted the services.

Error:

C:\Users\oracle>sqlplus sys@xe as sysdba
SQL*Plus: Release 11.2.0.2.0 Production on Thu Jan 24 10:58:53 2019
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Enter password:
ERROR:
ORA-12631: Username retrieval failed

Solution:

1. Check the SQLNET file with parameter value

--If parameter has NONE value then convert it into the NTS value & Save the file.
SQLNET.AUTHENTICATION_SERVICES = (NONE)
to
SQLNET.AUTHENTICATION_SERVICES = (NTS)

2. If you are in window environment open the CMD with Administrator rights and try to connect the SQLPLUS / as sysdba

3. Check the REMOTE_LOGIN_PASSWORDFILE parameter.

show parameter remote_login_passwordfile
NAME TYPE VALUE
-------------------------- ------ ------
remote_login_passwordfile string NONE

4. If it using the NONE value then convert it into EXCLUSIVE value, so that it will start using password file.

alter system set remote_login_passwordfile=EXCLUSIVE scope=spfile;

5. Restart the database for parameter change effects

shutdown immediate;
startup;

6. Again change the SQLNET ora file parameter back to NONE value

SQLNET.AUTHENTICATION_SERVICES = (NONE)

7. Now check the connectivity it working fine.

C:\Users\oracle>sqlplus sys as sysdba
SQL*Plus: Release 11.2.0.2.0 Production on Thu Jan 24 11:45:53 2019
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Enter password:
Connected to:
Oracle Database 11g Express Edition Release 11.2.0.2.0 - 64bit Production
SQL> exit

8. Hopefully upper steps fixed the issue but if you want more test then tried to create new password file.

orapwd file=D:\oraclexe\oracle\11.2.0\server\database\PWDXE.ora password="sys123" entries=3

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.