IT Tutorial IT Tutorial | Oracle DBA | SQL Server, Goldengate, Exadata, Big Data, Data ScienceTutorial
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 [email protected], password AACAAAAAAAAAAAIAXETGCCSCYFRAAAOG, encryptkey default GGSCI (msdbadm01) 12> dblogin userid [email protected], 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 [email protected], password GoldenGate135246 GGSCI (msdbadm01 as [email protected]_2) 16> dblogin USERID [email protected], password GoldenGate135246 Successfully logged into database.
Now try again.
GGSCI (msdbadm01 as [email protected]_2) 13> UNREGISTER EXTRACT EXMSD01 DATABASE 2020-04-23 13:05:33 INFO OGG-01750 Successfully UNREGISTERED EXTRACT EXMSD01 from database. GGSCI (msdbadm01 as [email protected]_2) 14> delete EXMSD01 Deleted EXTRACT EXMSD01. GGSCI (msdbadm01 as [email protected]_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/
1,932 views last month, 1 views today
