NET Configuration Assistant in Oracle no response after click, sqlplus login database prompt oracle11g Ora-12560:tns: Protocol Adapter error

The first is a no-response question for the click:

If the net Configuration Assistant is available under the client, the server-side NET Configuration Assistant tools are not available for the following reasons.

The Oracle_home configuration error in the environment variable may be on one hand, and the Oracle_home system variable can be deleted directly at this time. In addition, the system path, if the client's Orale path and DB of the Oracle path, may start the database directory under the "Configuration and Migration Tool", the startup of net Mannget may be your client oracle_home path under the software, Rather than the software under the Oracle database. You can check your system path, reverse the path of Oracle client and Oracle DB, and be sure to ensure that the path is correct. So down, on the author's computer is a smooth launch of the database-side "configuration and migration tools" under the net configuration Assistant.

For Sqlplus logon database prompt oracle11g Ora-12560:tns: Protocol Adapter Error:

The most fundamental reason is that the wrong information is configured in the Network-->admin-->tnsnames.ora file. Oracle Net Manager to start the database segment at this time;

Then, review the service naming and listener, and remove the IPC address from the listener:

And the service that uses IPC in the service naming is removed. After that, start cmd, enter Sqlplus, and then log on without prompting oracle11g ORA-12560:TNS: Protocol adapter error.

Summarize:

For Oracle databases, errors occur, mostly SID name configuration, configuration of the Listener service program, error related to service named configuration. After you have done a secure backup of your data, you can use Oracle with confidence.

NET Configuration Assistant in Oracle no response after click, sqlplus login database prompt oracle11g Ora-12560:tns: Protocol Adapter error