MININGDBLOGIN
Use MININGDBLOGIN
to establish a connection to a downstream
Oracle database logmining server in preparation to issue other Oracle GoldenGate
commands that affect this database, such as REGISTER EXTRACT
.
To log into a source Oracle Database that serves as the database logmining
server, use the DBLOGIN
command. MININGDBLOGIN
is
reserved for login to a downstream mining database.
The user who issues MININGDBLOGIN
must:
-
have privileges granted through the Oracle
dbms_goldengate_auth.grant_admin_privilege
procedure. -
be the user that is specified with the
TRANLOGOPTIONS MININGUSER
parameter for the Extract group that is associated with thisMININGDBLOGIN
.
Admin Client Syntax
MININGDBLOGIN USERIDALIAS alias
[DOMAIN domain
]
-
USERIDALIAS
alias
[DOMAIN
domain
]
-
Supplies the alias of a database login credential. Can be used instead of the
USERID
option if there is a local Oracle GoldenGate credential store that contains a credential with the required privileges for thisMININGDBLOGIN
command.To log into a pluggable database in an Oracle multitenant container database, the user must be stored as a connect string, such as
OGGUSER@FINANCE
. To log into the root container, the user must be stored as a common user, including the c## prefix, such asc##ggadmin@ggnorth
.-
alias
-
Specifies the alias of a database user credential that is stored in the Oracle GoldenGate credential store. The user that is specified with
USERIDALIAS
must be the common database user. -
DOMAIN
domain
-
Specifies the credential store domain for the specified alias. A valid domain entry must exist in the credential store for the specified alias.
-
-
SYSDBA
-
(Oracle) Specifies that the user logs in as
sysdba
. This option can be used forUSERID
andUSERIDALIAS
.