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 the service and listener. Restart the service and listener, so you should be able to pay attention to the order.
Add a section of the thing, meaning is the Listener service actively registered to the Process Monitor (Pmon) go. 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 is not added, the reverse is the case that the Pmon process of the instance registers the service in listener, listener for passive registration. So you need to start listener before you can.
Summing 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 documents:

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!