Oracle Database - Gateway Agent Registration
About
Registration is an operation through which Oracle stores information about an gateway agent in the data dictionary. Agents do not have to be registered. If an agent is not registered, Oracle stores information about the agent in memory instead of in the data dictionary; when a session involving an agent terminates, this information ceases to be available.
Articles Related
Self-registration
Self-registration is an operation in which a database administrator sets an initialization parameter that lets the agent automatically upload information into the data dictionary. In release 8.0 of the Oracle database server, an agent could determine whether to self-register. In Oracle9i and later, self-registration occurs only when the HS_AUTOREGISTER initialization parameter is set to TRUE (default).
If the Oracle database server runs with the HS_AUTOREGISTER server initialization parameter set to FALSE, then no registration occurs and then no information is stored automatically in the Oracle data dictionary. The equivalent data is uploaded by the Heterogeneous Services agent on a connection-specific basis each time a connection is made, with any instance-specific information taking precedence over class information.
HS_AUTOREGISTER is an Oracle initialization parameter that you set in the init.ora file; it is not a Heterogeneous Services initialization parameter that is set in the gateway initialization file.
For the instance
connect to the Oracle database as DBA user and execute:
select * from v$parameter where name like 'hs_autoregister'
or
show parameter HS_AUTOREGISTER
If it is set to FALSE then please change it to TRUE by executing:
alter system set HS_AUTOREGISTER==true scope=spfile;
For the agent
You can determine the values of Heterogeneous Services initialization parameters by querying the VALUE column of the VHS_PARAMETER view. Note that the VALUE column of VHS_PARAMETER truncates the actual initialization parameter value from a maximum of 255 characters to a maximum of 64 characters, and it truncates the parameter name from a maximum of 64 characters to a maximum of 30 characters.
SELECT *
FROM V$HS_PARAMETER
| HS_SESSION_ID | PARAMETER | VALUE | SOURCE | ENV |
|---|---|---|---|---|
| 1 | HS_NLS_DATE_FORMAT | YYYY-MM-DD HH24:MI:SS | A | T |
| 1 | HS_AUTOREGISTER | TRUE | A | F |
| 1 | HS_FDS_CONNECT_INFO | DSN_Excel_Employe | A | F |