Hi,
You can get ” OGG-01751 Cannot register or UNREGISTER EXTRACT because no database login was provided. Use DBLOGIN to establish a connection ” error.
Details of error are as follows.
GGSCI (msdbadm01) 11> UNREGISTER EXTRACT EXMSD01 DATABASE
2020-04-23 13:03:44 ERROR OGG-01751 Cannot register or UNREGISTER EXTRACT EXMSD01 because no database login was provided. Use DBLOGIN to establish a connection.
To register or unregister and delete or add any extract process, you need to firstly login database.
To solve this problem, you need to firstly login database as follows.
dblogin userid GGS_ADMIN@MSDB, password AACAAAAAAAAAAAIAXETGCCSCYFRAAAOG, encryptkey default GGSCI (msdbadm01) 12> dblogin userid GGS_ADMIN@MSDB, password AACAAAAAAAAAAAIAXETGCCSCYFRAAAOG, encryptkey default Successfully logged into database.
If you don’t know Goldengate user’s hash password, then you can use and login its normal password as follows.
dblogin USERID GGS_ADMIN19C@MSDB, password GoldenGate135246 GGSCI (msdbadm01 as GGS_ADMIN@MSDB_2) 16> dblogin USERID GGS_ADMIN19C@MSDB, password GoldenGate135246 Successfully logged into database.
Now try again.
GGSCI (msdbadm01 as GGS_ADMIN@MSDB_2) 13> UNREGISTER EXTRACT EXMSD01 DATABASE 2020-04-23 13:05:33 INFO OGG-01750 Successfully UNREGISTERED EXTRACT EXMSD01 from database. GGSCI (msdbadm01 as GGS_ADMIN@MSDB_2) 14> delete EXMSD01 Deleted EXTRACT EXMSD01. GGSCI (msdbadm01 as GGS_ADMIN@MSDB_2) 15> delete PKN18PR1 Deleted EXTRACT PKN18PR1.
Do you want to learn Oracle Goldengate from scratch, then read the following Goldengate Tutorial articles.
https://ittutorial.org/goldengate-tutorials-oracle-for-beginners/