Imperva 导致的ORAbase 乱码

DBCA Failing Because Of Garbage Characters In ORACLE_BASE Variable (Doc ID 2947963.1)

​编辑To Bottom

In this Document Symptoms Changes Cause Solution

 

APPLIES TO:

Oracle Database Configuration Assistant - Version 19.14.0.0.0 and later
Oracle Database - Enterprise Edition - Version 19.14.0.0.0 and later
Information in this document applies to any platform.

SYMPTOMS

DBCA is inserting gargabe characters in the directories it is creating based on the ORACLE_BASE when invoked to create a new DB which leads the overall process to fail.
The same behavior is seen when manually calling the oraenv script, the ORACLE_BASE value is set to random characters.
 

## Sample output of the oraenv script using debug mode, the ORACLE_BASE is incorrectly set using random characters.

> set -x
no_sid @ hostname:/home/oracle
> + keybd_trap
.+ keybd_trap
+ keybd_trap
o+ keybd_trap
r+ keybd_trap
a+ keybd_trap
e+ keybd_trap
n+ keybd_trap
v+ keybd_trap

+ . oraenv
+ SILENT=''
+ [ 0 -gt 0 ]
+ N=''
+ C=''
+ grep '--color=auto' c
+ echo '\c'
+ 1> /dev/null 2>& 1
+ N=-n
+ [ 0 '=' 0 ]
+ OLDHOME=/u01/app/oracle/product/12.1.0.4/agent12c/core/12.1.0.4.0/jdk/bin:/usr/ccs/bin:/usr/dt/bin:/usr/sbin:/sbin:/usr/local/bin:/opt/bin:/usr/share/centrifydc/bin:/usr/local/bin:/bin:/usr/bin:/usr/local/sbin:/usr/sbin:/usr/X/bin:/usr/ucb:/opt/oracle/admin/rsync/bin:/opt/oracle/OPatch:/u01/app/oracle/product/12.1.0.4/emcli
+ ORASID=no_sid
+ echo -n 'ORACLE_SID = [no_sid] ? '
ORACLE_SID = [no_sid] ? + read NEWSID
+ keybd_trap
d+ keybd_trap
b+ keybd_trap
_+ keybd_trap
1+ keybd_trap

+ ORACLE_SID=db_1
+ export ORACLE_SID
+ dbhome db_1
+ ORAHOME=/u01/app/oracle/product/19.0.0/db_1
+ ORACLE_HOME=/u01/app/oracle/product/19.0.0/db_1
+ export ORACLE_HOME
+ LD_LIBRARY_PATH=/u01/app/oracle/product/19.0.0/db_1/lib::/opt/odbc/lib
+ export LD_LIBRARY_PATH
+ PATH=/u01/app/oracle/product/12.1.0.4/agent12c/core/12.1.0.4.0/jdk/bin:/usr/ccs/bin:/usr/dt/bin:/usr/sbin:/sbin:/usr/local/bin:/opt/bin:/usr/share/nnnn/bin:/usr/local/bin:/bin:/usr/bin:/usr/local/sbin:/usr/sbin:/usr/X/bin:/usr/ucb:/opt/oracle/admin/rsync/bin:/opt/oracle/OPatch:/u01/app/oracle/product/12.1.0.4/emcli:/u01/app/oracle/product/19.0.0/db_1/bin
+ export PATH
+ ulimit
+ 2> /dev/null
+ ULIMIT=unlimited
+ [ 0 '=' 0 -a unlimited '!=' unlimited ]
+ ORABASE_EXEC=/u01/app/oracle/product/19.0.0/db_1/bin/orabase
+ [ /u01/app/oracle '!=' x ]
+ OLD_ORACLE_BASE=/u01/app/oracle
+ unset ORACLE_BASE
+ export ORACLE_BASE
+ [ -w /u01/app/oracle/product/19.0.0/db_1/inventory/ContentsXML/oraclehomeproperties.xml ]
+ [ -f /u01/app/oracle/product/19.0.0/db_1/bin/orabase ]
+ [ -x /u01/app/oracle/product/19.0.0/db_1/bin/orabase ]

## After the orabase executable is called the ORACLE_BASE value changes to some random string.

+ /u01/app/oracle/product/19.0.0/db_1/bin/orabase
+ ORACLE_BASE=$'\xb87z\u[3f7]\x7f'
+ [ /u01/app/oracle '!=' x ]
+ [ /u01/app/oracle '!=' $'\xb87z\u[3f7]\x7f' ]
+ [ '' '!=' true ]
+ echo $'The Oracle base has been changed from /u01/app/oracle to \xb87z\u[3f7]\x7f'    <<---
The Oracle base has been changed from /u01/app/oracle to ▒7z                            <<---
+ export ORACLE_BASE
+ [ $'\xb87z\u[3f7]\x7f' '==' x ]
no_sid @ hostname:/home/oracle
> + keybd_trap
s+ keybd_trap
e+ keybd_trap
t+ keybd_trap
+ keybd_trap
++ keybd_trap
x+ keybd_trap

no_sid @ hostname:/home/oracle
> echo $ORACLE_BASE
▒7z

CHANGES

 Imperva agent is installed.

CAUSE

The investigation found that the Imperva agent is causing garbage characters inserted in the ORACLE_BASE variable when calling oraenv script or DBCA. After the orabase executable file is called a random value is exported for the ORACLE_BASE variable rather than the correct one.

 

SOLUTION

Temporarily disable/stop Imperva agent to be able to use DBCA.