Rejected-tragic ORA-01017: invalid username/password; logon denied error, ora-01017denied

Rejected-tragic ORA-01017: invalid username/password; logon denied error, ora-01017denied

Oracle is not installed locally. oracle client and PL/SQL Developer are installed. To visualize the oracle database.

Failed to log on when using PL/SQL login, error: ORA-01017: invalid username/password; logon denied (user and password in the program cannot log on, login is rejected ).

Identify the cause of the tragedy:

1. Check whether the user name and password are correct. After checking, there is no problem. Tip: if you are using an IDE development tool to connect to a database, do not ignore the space check. If the system user can log on, you can log on and check whether the user exists. The password cannot be seen: "select username from dba_users ;". If the user exists, change the password and try: "alter user Username identified by password ;". Maybe the password is wrong, but I don't know it.

2. Check whether the database you configured is correct when configuring oracle.

Open the installation path of the oracle client, D: \ Program Files (x86) \ Oracle \ odac_client. Locate tnsnames. ora and check whether the IP address is correct. (This is my problem)

To remotely connect to the server, the client must first contact the listening process on the server. Oracle uses the connection descriptor in the tnsnames. ora file to describe the connection information.

Glossary:

ORCL248: Connection Descriptor

Address_list: indicates that the client connects to one or more servers through multiple protocols. In the preceding example, the client uses the TCP protocol to connect to the server.

PROTOCOL: used PROTOCOL

HOST: the IP address of the server used by the TCP/IP protocol.
PORT: the PORT address used by TCP/IP.

CONNECT_DATA: database connection Configuration

SERVER = DEDICATED: indicates using a dedicated server to connect to the oracle database.

SERVICE_NAME: Server Service name

3. Check whether the user is locked.
If the user is locked, the above problem occurs. First, the system can enter the system. solution:
Log on to plsql with a system user and query all current users: select * from dba_users; check whether the status is LOCKED. If the user connected to your database is LOCKED, unlock the account.
Alter user user1 account unlock;

4. Whether the user is assigned permissions. You can authorize the user after logging on to the system:

Grant create session, create table, create view, unlimited, connect, resource; specific permissions are implemented based on the user's actual permissions.

5. I have also said that I have no problem configuring environment variables on the Internet. When I delete all environment variables related to oracle, there is no issue that I cannot log on, it can only be used as a way to try.

Summary:

The final problem was finally solved, and I had a lot of detours in the search process. However, detours at least prove that this road cannot be achieved. Looking back, the answer is in sight.

Oracle zookeeper? Cross-region system authentication allow attackers to initiate a flood attacks against the ORA-01017 using nvalid username/password; logon denied
This error occurs when logging on to sqlplus: ORA-01017: invalid username/password; logon denied

SQL> conn/as sysdba
SQL> alter user SCOTT account unlock identified by tiger;
User altered.
SQL> select username, account_status from dba_users where username = 'Scott ';
USERNAME ACCOUNT_STATUS
--------------------------------------------------------------
SCOTT OPEN
SQL> conn scott/tiger
Connected.
SQL> select * from tab;
TNAME TABTYPE CLUSTERID
-----------------------------------------------
DEPT TABLE
EMP TABLE
BONUS TABLE
SALGRADE TABLE