Deleting RCU Schemas

19.2 Deleting RCU Schemas

To delete the RCU schemas, perform the following steps:

Check to see if the helper pod exists by running:

kubectl get pods -n <domain_namespace> | grep helper

For example:

kubectl get pods -n oamns | grep helper

The output should look similar to the following:

helper                                  1/1     Running     0          26h

If the helper pod doesn’t exist, run the following:

If using Oracle Container Registry or your own container registry for the Oracle Access Management (OAM) container image:

kubectl run --image=<image_name-from-registry>:<tag> \
--image-pull-policy="IfNotPresent" \
--overrides='{"apiVersion": "v1", "spec":{"imagePullSecrets": [{"name": "orclcred"}]}}' \
helper -n <domain_namespace> \
-- sleep infinity

For example:

kubectl run --image=container-registry.oracle.com/middleware/oam_cpu:14.1.2.1.0-jdk17-ol8-<YYMMDD> \
--image-pull-policy="IfNotPresent" \
--overrides='{"apiVersion": "v1","spec":{"imagePullSecrets": [{"name": "orclcred"}]}}' \
helper -n oamns \
-- sleep infinity

If you are not using a container registry and have loaded the image on each of the worker nodes, run the following command:
```
kubectl run helper --image <image>:<tag> -n oamns -- sleep infinity
```
For example:
```
kubectl run helper --image oracle/oam_cpu:14.1.2.1.0-jdk17-ol8-<YYMMDD> -n oamns -- sleep infinity
```
The output will look similar to the following:
```
pod/helper created
```

Run the following command to start a bash shell in the helper pod:
```
kubectl exec -it helper -n <domain_namespace> -- /bin/bash
```
For example:
```
kubectl exec -it helper -n oamns -- /bin/bash
```
This will take you into a bash shell in the running helper pod:
```
[oracle@helper ~]$
```
In the helper bash shell run the following commands to set the environment:
```
export CONNECTION_STRING=<db_host.domain>:<db_port>/<service_name>
```
```
export RCUPREFIX=<rcu_schema_prefix>
```
```
echo -e <db_pwd>"\n"<rcu_schema_pwd> > /tmp/pwd.txt
```
Where:
- <db_host.domain>:<db_port>/<service_name> is your database connect string.
- <rcu_schema_prefix> is the RCU schema prefix.
- <db_pwd> is the SYS password for the database.
- <rcu_schema_pwd> is the password for the <rcu_schema_prefix>
For example:
```
export CONNECTION_STRING=mydatabasehost.example.com:1521/orcl.example.com
```
```
export RCUPREFIX=OAMK8S
```
```
echo -e <password>"\n"<password> > /tmp/pwd.txt
```
```
cat /tmp/pwd.txt
```
Ensure the cat /tmp/pwd.txt command shows the correct passwords.

In the helper bash shell, drop the RCU schemas as follows:

/u01/oracle/oracle_common/bin/rcu -silent -dropRepository -databaseType ORACLE -connectString $CONNECTION_STRING \
-dbUser sys -dbRole sysdba -selectDependentsForComponents true -schemaPrefix $RCUPREFIX \
-component MDS -component IAU -component IAU_APPEND -component IAU_VIEWER -component OPSS \
-component WLS -component STB -component OAM -f < /tmp/pwd.txt

Exit the helper bash shell by issuing the command exit.