Month: October 2023

PKI-04015: Trusted cert cannot be removed

Trying to remove the trusted certificates from the wallet and getting the errors 

$ orapki wallet remove -wallet . -trusted_cert_all
Oracle PKI Tool : Version 11.2.0.4.0 - Production
Copyright (c) 2004, 2013, Oracle and/or its affiliates. All rights reserved.

Enter wallet password:
PKI-04015: Trusted cert cannot be removed. CN=A,O=B,C=C

SOLUTION

$ orapki wallet display -wallet .
Oracle PKI Tool : Version 11.2.0.4.0 - Production
Copyright (c) 2004, 2013, Oracle and/or its affiliates. All rights reserved.

Enter wallet password:
Requested Certificates:
User Certificates:
Subject:        CN=A,O=B,C=C
Trusted Certificates:
Subject:        CN=A,O=B,C=C

$orapki wallet remove -wallet . -trusted_cert -dn "CN=A,O=B,C=C"
$ orapki wallet remove -wallet . -cert_req -dn "CN=A,O=B,C=C"
$ orapki wallet display -wallet .
Oracle PKI Tool : Version 11.2.0.4.0 - Production
Copyright (c) 2004, 2013, Oracle and/or its affiliates. All rights reserved.

Enter wallet password:
Requested Certificates:
User Certificates:
Trusted Certificates:

ORA-01591: lock held by in-doubt distributed transaction 1.23.456789

SQL>  select local_tran_id from dba_2pc_pending;

LOCAL_TRAN_ID
----------------------
1.23.456789

SQL> select local_tran_id, state,fail_time,force_time, retry_time 
     from dba_2pc_pending;

LOCAL_TRAN_ID  STATE   FAIL_TIME   RETRY_TIME  MIXED
------------   -----   ---------   ----------  -----
1.23.456789    prepared 1-OCT-23   22-OCT-23    no
SQL> rollback force '1.23.456789';

Rollback complete.

SQL> exec dbms_transaction.purge_lost_db_entry( '1.23.456789');
BEGIN dbms_transaction.purge_lost_db_entry( '1.23.456789'); END;

*
ERROR at line 1:
ORA-01453: SET TRANSACTION must be first statement of transaction
ORA-06512: at "SYS.DBMS_TRANSACTION", line 74
ORA-06512: at "SYS.DBMS_TRANSACTION", line 96
ORA-06512: at line 1

SQL>exec dbms_transaction.purge_lost_db_entry('1.23.456789');

PL/SQL procedure successfully completed.

SQL> select local_tran_id from dba_2pc_pending;

no rows selected

OGG Agent instance directory should be outside ORACLE_HOME

The following error occurs when creating OGG monitoring instance:

$  ./createMonitorAgentInstance.sh

Please enter absolute path of Oracle GoldenGate home directory : /home/oracle/ggs

Please enter absolute path of OGG Agent instance : /home/oracle/oggmon_agent/instance1

OGG Agent instance directory should be outside ORACLE_HOME.

RESOLUTION

$ unset ORACLE_HOME
$ ./createMonitorAgentInstance.sh

Please enter absolute path of Oracle GoldenGate home directory : /home/oracle/ggs

Please enter absolute path of OGG Agent instance : /home/oracle/oggmon_agent/instance1

Please enter unique name to replace timestamp in startMonitorAgent script (startMonitorAgentInstance_20231012111213.sh) :

Successfully created OGG Agent instance.

How to Clone 11.2 Oracle Client Software

Client accidently uninstalled Oracle 11.2 Oracle client. Here is the quick way to clone 11.2 Oracle client from another server installations.

Make a tar or zip of the Oracle Client home from another server.

$ tar -cvf 11204.tar ./client_1

2. scp the tar file to the server

3. Untar the file to the location of the same directory path like the source server. 

$cd /u01/app/oracle/product/11.2.0.4

$tar -xvf 11204.tar

4. Clone the home

export ORACLE_HOME=/u01/app/oracle/product/11.2.0.4/client_1

export PATH=$ORACLE_HOME/bin:$PATH:

The run the following command in one line:

$ORACLE_HOME/oui/bin/runInstaller -silent -clone ORACLE_BASE="/u01/app/oracle/"  ORACLE_HOME="/u01/app/oracle/product/11.2.0.4/client_1" ORACLE_HOME_NAME="Oracle11204_client" -invPtrLoc="/u01/app/oracle/oraInventory"