Solution to wrong ORA-12541, ORA-12514, ORA-01017 in Oracle connection

ArticleDirectory

• 3. Error: ORA-01017: invalid username/password; logon denied.
• ORA-01017: invalid username/password; logon denied.

1. the following error occurs: ORA-12541: TNS: No listener, as shown in:

 

The error is because the listener service is not enabled. The solution is to enable this service in the service, as shown in.

2. the following error occurs: ORA-12514: TNS: Listener Program The requested service in the Link descriptor cannot be recognized currently. As shown in:

The solution is to open the oracleserviceorcl service, as shown in:

3. Error: ORA-01017: invalid username/password; logon denied.

Solution: When the database connection is configured, the user name and password are the root and root configured when oracle is installed. However, the above error may occur. Later, you can use the username: Scott and password: Tiger to log on successfully. This Scott account is also configured during database installation.

 

 

PS:

Reference: http://hi.baidu.com/lslyl/blog/item/c3626c031495d7e908fa93b7.html/cmtid/98692dfd328f9a1908244dcf

Resolution error: ORA-01017: invalid username/password; logon denied

The: ORA-01017: invalid username/password; logon denied error occurs, and: cannot be logged on in SQL * Plus:
Solution:
1. "Run"-> Enter cmd-> enter the root directory: C:>;
2. Input: sqlplus/nolog;
3. Connect username/password as sysdba. "linked" is displayed ";
4. Then you can use another user (non-Administrator account logon ).

As shown in:

PS: 2012-6-18ora-01017: invalid username/password; logon denied.

The above error is reported when sqlplus Scott/tiger @ orcl is used today. The solution is to log in with sys and reset the Scott account password.

 
Sqlplus sys/Root@ Orcl AsSysdba;Alter UserScott identifiedByTiger;