OGG-04514
The log transfer context for the current database({1}) is already reserved by previous instance of Oracle GoldenGate extract process{0}.SQL Error text ({2}).Grant SA_ROLE to Oracle GoldenGate replication user to release the log transfer context.Alternatively,the log transfer context can be released manually with SA_ROLE user by finding SPID of the process using sql query (select SPID from master..sysprocesses where dbid=db_id('dbName') and program_name = 'GG_SYBLTM') and then terminating the process by ASE provided kill command eg 'kill SPID'.
Cause
Oracle GoldenGate Extract process has reserved the log transfer context of the database due to abnormalities in ASE such as crash, forceful termination, slowness in response of the server, the log transfer context reserved during startup is not released by previous instance Oracle GoldenGate extract process, hence the next start of extract will fail with the above error.
Action
Grant the Oracle GoldenGate database replication user with SA_ROLE to terminate the extract process that has reserved the log context.
OGG-04514
The log transfer context for the current database({1}) is already reserved by previous instance of Oracle GoldenGate extract process{0}.SQL Error text ({2}).Grant SA_ROLE to Oracle GoldenGate replication user to release the log transfer context.Alternatively,the log transfer context can be released manually with SA_ROLE user by finding SPID of the process using sql query (select SPID from master..sysprocesses where dbid=db_id('dbName') and program_name = 'GG_SYBLTM') and then terminating the process by ASE provided kill command eg 'kill SPID'.
Cause
Oracle GoldenGate Extract process has reserved the log transfer context of the database due to abnormalities in ASE such as crash, forceful termination, slowness in response of the server, the log transfer context reserved during startup is not released by previous instance Oracle GoldenGate extract process, hence the next start of extract will fail with the above error.
Action
Grant the Oracle GoldenGate database replication user with SA_ROLE to terminate the extract process that has reserved the log context.
OGG-04514
The log transfer context for the current database({1}) is already reserved by previous instance of Oracle GoldenGate extract process{0}.SQL Error text ({2}).Grant SA_ROLE to Oracle GoldenGate replication user to release the log transfer context.Alternatively,the log transfer context can be released manually with SA_ROLE user by finding spid of the process using sql query (select spid from master..sysprocesses where dbid=db_id('dbName') and program_name = 'GG_SYBLTM') and then killing the process by ASE provided kill command eg 'kill spid'.
Cause
Oracle GoldenGate extract process has reserved the log transfer context of the database and due to abnormalities in ASE like crash, forcefully kill, slow in response etc of the server, the log transfer
context reserved during startup is not released by previous instance Oracle GoldenGate extract process, hence the next start of extract will fail with the above error.
Action
Grant the Oracle GoldenGate database replication user with SA_ROLE to kill the extract process that has reserved the log context.
