Oracle 10g database Conflict with client causes instance creation without monitoring issues

A colleague creates an instance on Oracle 10g, and at the end of the page, an error pops up, prompting for a failed listener. View the service without generating a listening service. So I deleted it, tried it several times, and so on.

It's really upsetting. The hint says port 1521, is this port occupied? With the Netstat-aon command looked down, and did not. And there is no place to set up the port during the creation of the instance.

Later, the net manager was tried, and a listener was created manually. Look at the system services, found that there are already listener; then modify the Tnsnames.ora file, create a connection string, connect, success.

In fact, the Tnsnames.ora file that I modified is the Oracle 10g client below. The client was installed in advance, and then the database was installed. It is estimated that there is a conflict. The answer is

1. Create an instance
2, manually create monitoring
3, modify the Tnsnames.ora at the client

Do you have to modify the client's Tnsnames.ora? Does the client have a higher priority than the database? This is not an estimate, it can be set in the environment variables of the operating system:

Set path.

PATH=C:\instantclient-basic-windows.x64-12.1.0.2.0\instantclient_12_1;E:\oracle\product\10.2.0\db_1\bin;1

The top priority should be high.

As for what Oracle_home, it seems that there is no egg to use. It's not clear what the eggs are for. On the Internet to copy some, first write down:

ORACLE_BASE、ORACLE_HOME有什么区别ORACLE_BASE下是admin和productORACLE_HOME下则是ORACLE的命令、连接库、安装助手、listener等等一系列的东东。这只是ORACLE自己的定义习惯。ORACLE_HOME比ORACLE_BASE目录要更深一些。也就是说：ORACLE_HOME＝$ORACLE_BASE/product/versionORACLE_BASE是oracle的根目录，ORACLE_HOME是oracle产品的目录。简单说，你如果装了2个版本的oracle，那么ORACLE_BASE可以是一个，但ORACLE_HOME是2个

Oracle 10g database conflicts with client causes no listener issues with instance creation