Connection to Oracle remote Database error: ORA-12541,ORA-12514,ORA-01017 solution!

1. The following error occurred: Ora-12541:tns:no Listener, as shown in:

The reason for the error is that we do not have the Listener listener service open and the workaround is to open the service in the service as shown in.

2. The following error occurred: Ora-12514:tns: The listener is not currently aware of the service requested in the link descriptor. As shown in the following:

The workaround is to open the service ORACLESERVICEORCL as shown in:

3. Error occurred: Ora-01017:invalid Username/password;logon denied.

Workaround: The original configuration database connection when the user name and password are installed when the Oracle configuration root and root. However, the above error will occur, and later use the username: Scott, password: Tiger, can be successfully logged in. This Scott account is also configured when the database is installed.

The ORA-12514 error is not solved by the 2nd method, using the following method:

Workaround: Modify Listener.ora
Original:
Sid_list_listener =
(Sid_list =
(Sid_desc =
(Sid_name = Clrextproc)
(Oracle_home = E:\app\Val\product\11.2.0\dbhome_1)
(program = Extproc)
(Envs = "Extproc_dlls=only:e:\app\val\product\11.2.0\dbhome_1\bin\oraclr11.dll")
)
)

After modification:
Sid_list_listener =
(Sid_list =
(Sid_desc =
(Sid_name = Clrextproc)
(Oracle_home = E:\app\Val\product\11.2.0\dbhome_1)
(program = Extproc)
(Envs = "Extproc_dlls=only:e:\app\val\product\11.2.0\dbhome_1\bin\oraclr11.dll")
)
(Sid_desc =
(Global_dbname = ORCL)
  (Oracle_home = E:\app\Val\product\11.2.0\dbhome_ 1)
      (sid_name = ORCL)
    )  
 )
Note the service name must be used when connecting. orcl!!!
After this, turn off service and listener. Restart the service and listener, so you should be able to pay attention to the order. The
adds a piece of something, meaning that the listener service is actively enrolled in the Process Monitor (Pmon). So, but when you start the Serivce, when you start listener, you are actively registering to the Process Monitor (Pmon). So there's no problem. But it's not the opposite.
If the paragraph has not been added, the reverse is the case that the Pmon process of the instance registers the service in listener and listener is passively registered. So you need to start listener before you can.
sum up, if you do not add that paragraph, then you should start listener, if you add that piece of things, you should start serivce.
I tried it, and it did. (But on windows, sometimes you get an error, reboot and try again)

This article is for finishing and reprint, Reference document:

http://blog.csdn.net/xw13106209/article/details/6584753

Http://blog.sina.com.cn/s/blog_7c0e26230100t0ci.html

Connection to Oracle remote Database error: ORA-12541,ORA-12514,ORA-01017 solution!