Understanding of listening for static registration Configuration

Understanding of listening for static registration Configuration

Global_dbname In the Listener. ora configuration file can be configured at will;

SID_LIST_LISTENER =

(SID_LIST =

(SID_DESC =

(GLOBAL_DBNAME = ora11gbak) ---- customizable

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

(SID_NAME = ora11g)

)

(SID_DESC =

(GLOBAL_DBNAME = lixorabak) ---- customizable

(ORACLE_HOME =/oracle)

(SID_NAME = lixora)

)

)

LSNRCTL> status

Services Summary...

Service "PLSExtProc" has 1 instance (s ).

Instance "PLSExtProc", status UNKNOWN, has 1 handler (s) forthis service...

Service "lixora" has 1 instance (s ).

Instance "lixora", status READY, has 1 handler (s) for thisservice... ---------- Dynamic Registration

Service "lixorabak" has 1 instance (s ).

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

Service "ora11g" has 1 instance (s ).

Instance "ora11g", status READY, has 1 handler (s) for thisservice... -------------- Dynamic Registration

Service "ora11gbak" has 1 instance (s ).

Instance "ora11g", status UNKNOWN, has 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: --- normal connection

C: \ Users \ hlj> sqlplus system/oracle@10.80.18.241/ora11gbak

SQL * Plus: Release 10.2.0.1.0-Productionon Friday June 19 16:56:15 2015

Copyright (c) 1982,200 5, Oracle. All rights reserved.

Connect:

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	TheOracle system identifier (SID)Of the instance. You can obtain the SID value fromINSTANCE_NAMEParameter 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 ofSERVICE_NAMEParameter in the client connect descriptor. If the client connect descriptor usesSIDParameter, then the listener does not attempt to map the values. this parameter is primarily intended for deployments with Oracle8 databases (where dynamic service registration is not supported for dedicated servers ). this parameter may also be required for use with Oracle8IAnd later database services by some deployments. The value for this parameter is typically obtained from the combination ofDB_NAMEAndDB_DOMAINParameters (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 value is DB_NAME.DB_DOMAIN from pfile; However, we can also give ourselves a meaningful name;
Oracle Home Directory	ORACLE_HOME	The Oracle home location of the instance. Without this setting, the listener assumes its Oracle home for the instance. On Linux and UNIX, this setting is optional. On Microsoft Windows, this setting is ignored. The Oracle home specified byORACLE_HOMEParameter inHKEY_LOCAL_MACHINE \ SOFTWARE \ ORACLE \ HOMEIDOf the Microsoft Windows registry is used.