Configuration of listener. ora and tnsnames. ora when the server contains multiple Libraries

1. Configuration content: 1). listener. ora

Sid_list_listener =
(Sid_list =
(Sid_desc =
(Sid_name = plsextproc)
(ORACLE_HOME = D:/Oracle/product/10.1.0/db_1)
(Program = EXTPROC)
)
(Sid_desc =
(Sid_name = orcl)
(ORACLE_HOME = D:/Oracle/product/10.1.0/db_1)
(Global_dbname = orcl)
)
(Sid_desc =
(Sid_name = Practice)
(ORACLE_HOME = D:/Oracle/product/10.1.0/db_1)
(Global_dbname = Practice)
)
(Sid_desc =
(Sid_name = rcat)
(ORACLE_HOME = D:/Oracle/product/10.1.0/db_1)
(Global_dbname = rcat)
)
)

Listener =
(Description_list =
(Description =
(Address_list =
(Address = (Protocol = TCP) (host = doone. PAN) (Port = 1521 ))
)
)
)

2). tnsnames. ora

Orcl =
(Description =
(Address = (Protocol = TCP) (host = doone) (Port = 1521 ))
(CONNECT_DATA =
(Server = dedicated)
(SERVICE_NAME = orcl)
)
)
Rcat =
(Description =
(Address = (Protocol = TCP) (host = doone) (Port = 1521 ))
(CONNECT_DATA =
(Server = dedicated)
(SERVICE_NAME = rcat)
)
)
Practice =
(Description =
(Address = (Protocol = TCP) (host = doone) (Port = 1521 ))
(CONNECT_DATA =
(Server = dedicated)
(SERVICE_NAME = Practice)
)
)
Extproc_connection_data =
(Description =
(Address_list =
(Address = (Protocol = IPC) (Key = EXTPROC ))
)
(CONNECT_DATA =
(SID = plsextproc)
(Presentation = Ro)
)
)

2. Note 1). Conn user/pwd @ orcl, Conn user/pwd @ ract, Conn user/pwd @ practice can be used for connection.

 

2). problems may occur if the above two files are not configured for multiple databases.

A. Conn user/pwd if this connection is directly used, the connection is connected to the last database created by default.

B. ORA-01041: Internal error. hostdef extension doesn't exist.

This is generally because TNS does not configure the corresponding database description. As a result, the database is shut down and the restart fails.

C. ORA-12170: TNS: connect timeout occurred

This error occurs. Generally, the listener. ora library is not configured.

D. ORA-12514: TNS: Listener does not currently know of Service requested in connect
Descriptor

This error occurs. Generally, the listener. ora library is not configured.