Blog

OGG-00901 Failed to lookup object ID

When starting up OGG extract with the following error in ggserr.log :

ERROR OGG-00901 Failed to lookup object ID for table GG.D7A_GGS_TRACE
ERROR OGG-01668 Oracle GoldenGate Capture for Oracle,CAP.prm:PROCESS ABENDING

Check the parameter file of capture with one line:

tractable GG.D7A_GGS_TRACE

SOLUTION

Manually create trace table as required.

GGSCI>info credentialstore
GGSCI> DBLOGIN USERIDALIAS gg
or
GGSCI>DBLOGIN USERID gg, PASSWORD passwd
GGSCI> INFO TRACETABLE
GGSCI> add tracetable GG.D7A_GGS_TRACE
GGSCI> INFO TRACETABLE
GGSCI> 
SQL> desc GG.D7A_GGS_TRACE
 Name                                      Null?    Type
 ----------------------------------------- -------- -------------------
 GROUP_ID                                  NOT NULL VARCHAR2(8)
 DB_USER                                            VARCHAR2(30)
 LAST_UPDATE                                        DATE

Add default CHECKPOINTTABLE:

GGSCI> INFO TRACETABLE
GGSCI> ADD CHECKPOINTTABLE
GGSCI> info CHECKPOINTTABLE
SQL> select table_name from dba_tables where owner='GG';

TABLE_NAME
------------------------------
GGS_CHECKPOINT
GGS_CHECKPOINT_LOX
D7A_GGS_TRACE

[INS-06006] Passwordless SSH connectivity not set up between the following node(s): [racnode2]

When attempting to configure 19c grid infrastructure on Linux 8 by running gridSetup.sh the following error occurs in SSH connectivity step:

[INS-06006] Passwordless SSH connectivity not set up between the following node(s): [racnode2]

Even after manually setup SSH equivalence successfully, the error still exists and user cannot continue the GI installation and configuration.

SOLUTION

Apply patch 30159782 before run “gridSetup.sh”, see (Doc ID 1410202.1) for how to apply OneOff patch before run “gridSetup.sh”.

OR

apply the RU or higher where the fix for 30159782.8 is included

OR

Before installation, as root user: (please change the path if the location of your "scp" is not the same with below)

# Rename the original scp.
mv /usr/bin/scp /usr/bin/scp.orig

# Create a new file </usr/bin/scp>.
vi /usr/bin/scp
# Add the below line to the new created file </usr/bin/scp>.
/usr/bin/scp.orig -T $*

# Change the file permission.
chmod 555 /usr/bin/scp

After installation:
mv /usr/bin/scp.orig /usr/bin/scp

[INS-08101] Unexpected error while executing the action at state: ‘supportedOSCheck’

Running Oracle 19c gridSetup.sh or runInstaller on Linux 8, the following errors occur:

[INS-08101] Unexpected error while executing the action at state: ‘supportedOSCheck’

SOLUTION

Set the following variable:

    $ export CV_ASSUME_DISTID=OEL7.8

    OR

    Edit the file cvu_config which is located in $ORACLE_HOME/cv/admin, change the line from

    # Fallback to this distribution id

    #CV_ASSUME_DISTID=OEL5

    to

    # Fallback to this distribution id

    CV_ASSUME_DISTID=OEL7.8

    19c gridSetup.sh throws errors: PRVG-11095 : The TCP system call “connect” failed with error “113” while executing exectask on node “racnode2”

    The following errors occur when running Oracle 19c gridSetup.sh:

    Summary of node specific errors racnode2  
- PRVG-11067 : TCP connectivity from node "racnode2": "10.2.2.2" to node "racnode1": "10.2.2.1" failed.
PRVG-11095 : The TCP system call "connect" failed with error "113" while executing exectask on node "racnode2"
No route to host  - Cause:  Errors occurred while attempting to establish Transmission Control Protocol (TCP) connectivity between the identified two interfaces.  
- Action:  Ensure that there are no firewalls blocking TCP operations and no process monitors running that can interfere with programs'' network operations. racnode1  - PRVG-11067 : TCP connectivity from node "racnode1": "10.2.2.1" to node "racnode2": "10.2.2.2" failed.

PRVG-11095 : The TCP system call "connect" failed with error "113" while executing exectask on node "racnode1"
No route to host  - Cause:  Errors occurred while attempting to establish Transmission Control Protocol (TCP) connectivity between the identified two interfaces.  
- Action:  Ensure that there are no firewalls blocking TCP operations and no process monitors running that can interfere with programs'' network operations.

    SOLUTION

    Stop and disable firewalld.

    # systemctl status firewalld

    # systemctl stop firewalld

    # systemctl disable firewalld

    ORA-01950: no privileges on tablespace ‘USERS’

    SQL> create table test ( id number );
    create table test ( id number )
    *
    ERROR at line 1:
    ORA-01950: no privileges on tablespace ‘USERS’

    SOLUTION

    SQL> select TABLESPACE_NAME,USERNAME,MAX_BYTES,BYTES from dba_ts_quotas where USERNAME='SCOTT';

    no rows selected
    SQL> alter user scott default tablespace users quota 10m on users;

    

    User altered.

    SQL>  create table test ( id number );

    

    Table created.
    SQL> select TABLESPACE_NAME,USERNAME,MAX_BYTES,BYTES from dba_ts_quotas where USERNAME='SCOTT';

    

    TABLESPACE_NAME      USERNAME       MAX_BYTES      BYTES

    -------------------- ------------- ---------- ----------

    USERS                SCOTT      10485760      65536