2.66 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 USERIDALIASalias
[DOMAINdomain
]
GGSCI Syntax
MININGDBLOGIN { USERID {/ | userid}[, PASSWORD password] [algorithm ENCRYPTKEY {keyname | DEFAULT}] | USERIDALIASalias
[DOMAINdomain
] | [SYSDBA] }
-
USERID
-
Supplies a database login credential. Can be used if an Oracle GoldenGate credential store is not in use. (See the
USERIDALIAS
option.) Input varies, depending on the database, as follows:-
userid
-
Specifies the name of a database user or a SQL*Net connect string. To log into a pluggable database in an Oracle multitenant container database, specify
userid
as a connect string, such asOGGUSER@FINANCE
. To log into the root container, specifyuserid
as a common user, including the C## prefix, such asC##GGADMIN@FINANCE
. -
/
-
(Oracle) Directs Oracle GoldenGate to use an operating-system login for Oracle, not a database user login. Use this argument only if the database allows authentication at the operating-system level. To use this option, the correct user name must exist in the database, in relation to the value of the Oracle
OS_AUTHENT_PREFIX
initialization parameter, see theUSERID | NOUSERID
parameter. -
PASSWORD
password
-
Use when authentication is required to specify the password for the database user. If the password was encrypted by means of the
ENCRYPT PASSWORD
command, supply the encrypted password; otherwise, supply the clear-text password. If the password is case-sensitive, type it that way.If the
PASSWORD
clause is omitted, you are prompted for a password, and the password is not echoed. -
algorithm
-
If the password was encrypted with the
ENCRYPT PASSWORD
command, specify the encryption algorithm that was used:AES128
AES192
AES256
BLOWFISH
-
ENCRYPTKEY {
keyname
| DEFAULT}
-
Specifies the encryption key that was specified with
the ENCRYPT PASSWORD command
. Use one of the following:-
ENCRYPTKEY
keyname
-
Specifies the logical name of a user-created encryption key in the
ENCKEYS
lookup file. Use ifENCRYPT PASSWORD
was used with theKEYNAME
keyname
option. -
ENCRYPTKEY DEFAULT
-
Directs Oracle GoldenGate to generate a Blowfish key. Use if the
ENCRYPT PASSWORD
command was used with theKEYNAME DEFAULT
option.
-
-
-
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@FINANCE
.-
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
.
Parent topic: Common Command Line Interface Commands