The same database of the same host, there can only be one listener, when we configure multiple listeners, it will listen to the database on the other host, but this performance is not good.
The Listener.ora configuration file explains:
Listener section:
LISTENER =
(Description_list =
(DESCRIPTION =
(address= (PROTOCOL = IPC) (Key=extpro1))
(address= (PROTOCOL = TCP) (HOST = 192.168.2.29) (PORT = 1521))
)
)
Database configuration section:
Sid_list_listener =
(Sid_list =
(Sid_desc =
(Global_dbname = orcl.localdomain)
(Oracle_home =/opt/oracle/product/11.2.0/dbhome_1)
(Sid_name = ORCL)
)
)
Tnsname.ora configuration file
Test =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.2.29) (PORT = 1521))
(Connect_data =
(service_name = orcl.localdomain)
)
Service_Name default is Global_name.
Query Global_name
SELECT * from Global_name;
Modify Global_name
ALTER DATABASE rename Global_name to ORCL;
Update global_name Set global_name = ' ORCL ';
Commit
But modified, Global_name will not change the default server_name, and will not modify the default db_domain;
So modify the Db_domain
Alter system set db_domain= ' Scope=spfile;
This article is from the "Common Documents" blog, so be sure to keep this source http://yujianglei.blog.51cto.com/7215578/1558698
Understanding the Oracle Listener configuration file