Sample Header Ad - 728x90

ora-12715 - Oracle GoldaneGate can not connect to database

0 votes
0 answers
85 views
I install Oracle 21c database and Oracle GoldaneGate 21.3 on Windows server, I can connect to my PDB using sqlplus and SqlDeveloper from another pc, but when try to dblogin from GGSCI get error this is my environment I set in my server: ORACLE_HOME = D:\oracle21c\WINDOWS.X64_213000_db_home LD_LIBRARY_PATH = D:\oracle21c\WINDOWS.X64_213000_db_home\lib TNS_ADMIN = D:\oracle21c\app\oracle\homes\OraDB21Home1\network\admin NLS_LANG = AMERICAN_AMERICA.AR8MSWIN1256 OGG_HOME = OGG_HOME PATH = ...;D:\oracle21c\WINDOWS.X64_213000_db_home\bin;D:\oracle21c\WINDOWS.X64_213000_db_home\lib get this error: GGSCI (Oracle-test) 2> dblogin userid ggs@mypdb Password: Error: Failed to initialize timezone information. Check location of ORACLE_HOME. I set ORA_TZFILE in environment ORA_TZFILE = D:\oracle21c\WINDOWS.X64_213000_db_home\oracore\zoneinfo\timezlrg_35.dat now I get this error: GGSCI (Oracle-test) 2> dblogin userid ggs@mypdb Password: Error: OCI Error ORA (status = 12715-Error while trying to retrieve text for error ORA-12715 ) I change mgr file in dirprm like this: PORT 7809 USERID ggs@mypdb, PASSWORD ggs and when run start manager in ggsci, have this error: 2024-11-25T02:29:57.852-0800 INFO OGG-03541 Oracle GoldenGate Manager for Oracle, MGR.prm: Oracle Environment Variables: TNS_ADMIN = D:\oracle21c\WINDOWS.X64_213000_db_home\network\admin PATH = C:\Program Files\Common Files\Oracle\Java\javapath;D:\oracle21c\WINDOWS.X64_213000_db_home\bin;D:\oracle21c\WINDOWS.X64_213000_db_home\lib;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;C:\Windows\System32\OpenSSH\;D:\oracle21c\ords\bin;D:\ggs;C:\Users\Administrator\AppData\Local\Microsoft\WindowsApps;. 2024-11-25T02:29:57.978-0800 ERROR OGG-00303 Oracle GoldenGate Manager for Oracle, MGR.prm: OCI Error ORA (status = ١٢٧١٥-Error while trying to retrieve text for error ORA-12715 ). 2024-11-25T02:29:57.994-0800 ERROR OGG-01668 Oracle GoldenGate Manager for Oracle, MGR.prm: PROCESS ABENDING. I don't config extract,pump or replicate!
Asked by sadegh (101 rep)
Nov 25, 2024, 10:43 AM