我的oracle 10版本是10.2.0,OS为:AIX5.3
#ps -fu oracle
oracle 180618 1 0 May 17 - 0:28 /u01/oracle/product/10.2.0/db_1/bin/tnslsnr LISTENER_HIS -inherit
oracle 496000 1 0 16:37:43 - 0:05 /u01/oracle/product/10.2.0/db_1/bin/tnslsnr LISTENER -inherit
发现两个LISTENER都已经启动
但是我的listener.ora文件里面只有
LISTENER_HIS =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.1)(PORT = 1522))
)
)
SID_LIST_LISTENER_HIS =
(SID_LIST =
(SID_DESC =
(SID_NAME = HIS)
(ORACLE_HOME = /u01/oracle/product/10.2.0/db_1)
)
)-----------------
LISTENER不知道从何而来,
而且我在客户端用1522,1521都可以连接到我的sid上,
不知道为什么?
#ps -fu oracle
oracle 180618 1 0 May 17 - 0:28 /u01/oracle/product/10.2.0/db_1/bin/tnslsnr LISTENER_HIS -inherit
oracle 496000 1 0 16:37:43 - 0:05 /u01/oracle/product/10.2.0/db_1/bin/tnslsnr LISTENER -inherit
发现两个LISTENER都已经启动
但是我的listener.ora文件里面只有
LISTENER_HIS =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.1)(PORT = 1522))
)
)
SID_LIST_LISTENER_HIS =
(SID_LIST =
(SID_DESC =
(SID_NAME = HIS)
(ORACLE_HOME = /u01/oracle/product/10.2.0/db_1)
)
)-----------------
LISTENER不知道从何而来,
而且我在客户端用1522,1521都可以连接到我的sid上,
不知道为什么?
it the details of the database instance you would like to connect to. It will
be found on the client side. Note that a SERVER can be a client of another
database so it is typical to find it on the SERVER as well.The listener.ora is used to setup the configuration of the net8 listener. to
specify the port it will listen on, give it the details of the databases it can
connect to and so on. This file is on the SERVER only.The sqlnet.ora is an optional file expressing more parameters about the
connection (eg: the trace level for debugging, the types of authentication you
would like to support and so on). It may be found on the client or the server.这里就不翻译了,翻译过来可能不能准确表述