OGG-01751 Cannot register or UNREGISTER EXTRACT because no database login was provided. Use DBLOGIN to establish a connection

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/