Understanding of listening to static registration configuration

Listener.ora configuration file Global_dbname can be arbitrarily configured;

Sid_list_listener =

(Sid_list =

(Sid_desc =

(global_dbname = ora11gbak)----can be customized

(Oracle_home =/u01/app/ora11/product/11.2.0/dbhome_1)

(Sid_name = ora11g)

)

(Sid_desc =

(global_dbname = Lixorabak)----can be customized

(Oracle_home =/oracle)

(Sid_name = Lixora)

)

)

lsnrctl> status

Services Summary ...

Service "Plsextproc" has 1instance (s).

Instance "Plsextproc", Status UNKNOWN, has 1 handler (s) forthis service ...

Service "Lixora" has 1instance (s).

Instance "Lixora", status ready, have 1 handler (s) for thisservice ...----------dynamic registration

Service "lixorabak" has 1 instance (s).

Instance "Lixora", status UNKNOWN, have 1 handler (s) for this service ...----------static registration

Service "ora11g" has 1instance (s).

Instance "ora11g", status ready, have 1 handler (s) for thisservice ...--------------dynamic registration

Service "ora11gbak" has 1 instance (s).

Instance "ora11g", status UNKNOWN, have 1 handler (s) for this service ...----------static registration

The command completed successfully

NAME TYPE VALUE

---------------------------------------------------------- ------------------------------

Db_name string ora11g

Db_unique_name string ora11g

Global_names Boolean FALSE

instance_name string ora11g

Service_names string ora11g

Client Connection test:---can connect properly

C:\users\hlj>sqlplus System/[email Protected]/ora11gbak

Sql*plus:release 10.2.0.1.0-productionon Friday June 19 16:56:15 2015

Copyright (c) 1982, 2005, Oracle. All rights reserved.

Connect to:

Oracle Database 11g Enterprise editionrelease 11.2.0.1.0-64bit Production

With the partitioning, OLAP, Data miningand Real Application Testing Options

Sql> SELECT * from dual;

DU

--

X

Racle Net Manager Field	Listener.ora File Parameter	Description
Sid	Sid_name	The Oracle system identifier (SID) of the instance. You can obtain the SID valuefrom theinstance_name parameter in the initialization parameter file.
Service Name	Global_dbname	The database service. while processing a client connection request, the listener tries to match the Value of this parameter with the value of the  service_ NAME parameter in the client connect descriptor. If The client connect descriptor uses the  sid Strong>parameter, then the listener does isn't attempt to map the values. This parameter are primarily intended for configurations with Oracle8 databases (where dynamic service registration are not Supported for dedicated servers). This parameter may also is required for use with Oracle8 i  and later database services by some configurations . the value for this parameter are typically obtained from the combination of the   db_name AND  db_domain  parameters ( db_name . db_domain ) in the initialization parameter file, but the value can also contain any valid name used by Clients to identify the service. The default is from Pfile Medium Take db_name. Db_domain   ; But we can also take a meaningful name on our own;
Oracle Home Directory	Oracle_home	The Oracle home location of the instance. Without this setting, the listener assumes it Oracle home for the instance. On Linux and UNIX, this setting is optional. On Microsoft Windows, this setting is ignored. The Oracle home specifiedby theoracle_home parameterinhkey_local_machine\software\oracle \homeID of the Microsoft Windows registry is used.

Understanding of listening to static registration configuration