Oracle E-Business Suite Database Upgrade (19c)
In this post we will upgrade the Oracle database from version 12.1 to 19c and apply the latest database Patch Set Update (PSU).
Table of Contents
If you are interested in the steps it takes to install an Oracle E-Business Suite 12.2 with Oracle Database 12.2 take a look here. Since 12.2 is out of support, we need to upgrade the database to 19c or 23ai. Since we cannot upgrade directly to 23ai we need to upgrade to 19c first.
Downloading the software
The Oracle Database 19c software can be downloaded from edelivery.oracle.com from the same place as we downloaded the Oracle E-Business Suite software (see here). The latest hcheck.sql script can be downloaded from Doc ID 136697.1.
Database Upgrade preparation
The primary documentation for this database Upgrade can be found in Doc ID 2580629.1 on the Oracle support portal.
Running hcheck.sql
We will run hcheck.sql to check the database for common Data Dictionary errors.
# run hcheck.sql as user oracle
hn=`hostname|awk -F. {'print $1'}`
mkdir -p ~/hcheck; cd ~/hcheck
. /d01/oracle/VIS/12.1.0/VIS_$hn.env;
sqlplus -S / as sysdba <<EOF
spool hcheck.log
@/sw/ora_ebs/12214/hcheck.sql
spool off
exit
EOF
In my case I had problems with 5 database objects (1 x HCKE-0002 and 4 x HCKE-0023):
Sample Output (click to expand):
HCheck Version 04AUG23 on 03-MAR-2025 07:55:42
----------------------------------------------
Catalog Version 12.1.0.2.0 (1201000200)
db_name: VIS
Is CDB?: NO
Catalog Fixed
Procedure Name Version Vs Release Timestamp
Result
------------------------------ ... ---------- -- ---------- --------------
------
.- LobNotInObj ... 1201000200 <= *All Rel* 03/03 07:55:42 PASS
.- MissingOIDOnObjCol ... 1201000200 <= *All Rel* 03/03 07:55:42 FAIL
HCKE-0002: Object type column with missing OID$ (Doc ID 1360268.1)
OBJ#=525262 Name=CSR.CSR_RULE_WINDOWS_B IntCol#=3=SYS_NC_ROWINFO$
TabProp=2107603
.- SourceNotInObj ... 1201000200 <= *All Rel* 03/03 07:55:43 PASS
.- OversizedFiles ... 1201000200 <= *All Rel* 03/03 07:55:55 PASS
.- PoorDefaultStorage ... 1201000200 <= *All Rel* 03/03 07:55:55 PASS
.- PoorStorage ... 1201000200 <= *All Rel* 03/03 07:55:55 PASS
.- TabPartCountMismatch ... 1201000200 <= *All Rel* 03/03 07:55:55 PASS
.- OrphanedTabComPart ... 1201000200 <= *All Rel* 03/03 07:55:56 PASS
.- MissingSum$ ... 1201000200 <= *All Rel* 03/03 07:55:56 PASS
.- MissingDir$ ... 1201000200 <= *All Rel* 03/03 07:55:56 PASS
.- DuplicateDataobj ... 1201000200 <= *All Rel* 03/03 07:55:57 PASS
.- ObjSynMissing ... 1201000200 <= *All Rel* 03/03 07:55:58 PASS
.- ObjSeqMissing ... 1201000200 <= *All Rel* 03/03 07:55:58 PASS
.- OrphanedUndo ... 1201000200 <= *All Rel* 03/03 07:55:59 PASS
.- OrphanedIndex ... 1201000200 <= *All Rel* 03/03 07:55:59 PASS
.- OrphanedIndexPartition ... 1201000200 <= *All Rel* 03/03 07:55:59 PASS
.- OrphanedIndexSubPartition ... 1201000200 <= *All Rel* 03/03 07:55:59 PASS
.- OrphanedTable ... 1201000200 <= *All Rel* 03/03 07:55:59 PASS
.- OrphanedTablePartition ... 1201000200 <= *All Rel* 03/03 07:56:00 PASS
.- OrphanedTableSubPartition ... 1201000200 <= *All Rel* 03/03 07:56:00 PASS
.- MissingPartCol ... 1201000200 <= *All Rel* 03/03 07:56:00 PASS
.- OrphanedSeg$ ... 1201000200 <= *All Rel* 03/03 07:56:00 FAIL
HCKE-0023: Orphaned SEG$ Entry (Doc ID 1360934.1)
ORPHAN SEG$: SegType=INDEX TS=15 RFILE/BLOCK=61/137666
ORPHAN SEG$: SegType=INDEX TS=15 RFILE/BLOCK=61/137650
ORPHAN SEG$: SegType=LOB TS=15 RFILE/BLOCK=61/137642
ORPHAN SEG$: SegType=LOB TS=15 RFILE/BLOCK=61/137658
.- OrphanedIndPartObj# ... 1201000200 <= *All Rel* 03/03 07:56:00 PASS
.- DuplicateBlockUse ... 1201000200 <= *All Rel* 03/03 07:56:00 PASS
.- FetUet ... 1201000200 <= *All Rel* 03/03 07:56:00 PASS
.- Uet0Check ... 1201000200 <= *All Rel* 03/03 07:56:00 PASS
.- SeglessUET ... 1201000200 <= *All Rel* 03/03 07:56:00 PASS
.- BadInd$ ... 1201000200 <= *All Rel* 03/03 07:56:00 PASS
.- BadTab$ ... 1201000200 <= *All Rel* 03/03 07:56:00 PASS
.- BadIcolDepCnt ... 1201000200 <= *All Rel* 03/03 07:56:00 PASS
.- ObjIndDobj ... 1201000200 <= *All Rel* 03/03 07:56:00 PASS
.- TrgAfterUpgrade ... 1201000200 <= *All Rel* 03/03 07:56:00 PASS
.- ObjType0 ... 1201000200 <= *All Rel* 03/03 07:56:00 PASS
.- BadOwner ... 1201000200 <= *All Rel* 03/03 07:56:00 PASS
.- StmtAuditOnCommit ... 1201000200 <= *All Rel* 03/03 07:56:00 PASS
.- BadPublicObjects ... 1201000200 <= *All Rel* 03/03 07:56:00 PASS
.- BadSegFreelist ... 1201000200 <= *All Rel* 03/03 07:56:00 PASS
.- BadDepends ... 1201000200 <= *All Rel* 03/03 07:56:00 PASS
.- CheckDual ... 1201000200 <= *All Rel* 03/03 07:56:01 PASS
.- ObjectNames ... 1201000200 <= *All Rel* 03/03 07:56:01 PASS
.- BadCboHiLo ... 1201000200 <= 1202000000 03/03 07:56:02 PASS
.- ChkIotTs ... 1201000200 <= *All Rel* 03/03 07:56:02 PASS
.- NoSegmentIndex ... 1201000200 <= *All Rel* 03/03 07:56:02 PASS
.- BadNextObject ... 1201000200 <= *All Rel* 03/03 07:56:02 PASS
.- DroppedROTS ... 1201000200 <= *All Rel* 03/03 07:56:02 PASS
.- FilBlkZero ... 1201000200 <= *All Rel* 03/03 07:56:02 PASS
.- DbmsSchemaCopy ... 1201000200 <= *All Rel* 03/03 07:56:02 PASS
.- OrphanedIdnseqObj ... 1201000200 > 1201000000 03/03 07:56:02 PASS
.- OrphanedIdnseqSeq ... 1201000200 > 1201000000 03/03 07:56:02 PASS
.- OrphanedObjError ... 1201000200 > 1102000000 03/03 07:56:02 PASS
.- ObjNotLob ... 1201000200 <= *All Rel* 03/03 07:56:02 PASS
.- MaxControlfSeq ... 1201000200 <= *All Rel* 03/03 07:56:02 PASS
.- SegNotInDeferredStg ... 1201000200 > 1102000000 03/03 07:56:02 PASS
.- SystemNotRfile1 ... 1201000200 > 902000000 03/03 07:56:02 PASS
.- DictOwnNonDefaultSYSTEM ... 1201000200 <= *All Rel* 03/03 07:56:03 PASS
.- OrphanTrigger ... 1201000200 <= *All Rel* 03/03 07:56:03 PASS
.- ObjNotTrigger ... 1201000200 <= *All Rel* 03/03 07:56:03 PASS
---------------------------------------
03-MAR-2025 07:56:03 Elapsed: 21 secs
---------------------------------------
Found 5 potential problem(s) and 0 warning(s)
Contact Oracle Support with the output and trace file
to check if the above needs attention or not
PL/SQL procedure successfully completed.
Statement processed.
Complete output is in trace file:
/d01/oracle/VIS/12.1.0/admin/VIS_lin1/diag/rdbms/vis/VIS/trace/VIS_ora_13510_HCHECK.trcRegarding Oracle Support (HCKE-0002, HCKE-0023) these issues can be ignored. After checking the patches we can continue with the upgrade:
Install the Oracle 19c database software and CDB creation
# run as oracle
hn=`hostname|awk -F. {'print $1'}`
# Create the initialization parameter setup files
. /d01/oracle/VIS/12.1.0/VIS_$hn.env
cd /d01/oracle/VIS/12.1.0/appsutil
. ./txkSetCfgCDB.env dboraclehome=/d01/oracle/VIS/12.1.0
export ORACLE_SID=VIS
cd /d01/oracle/VIS/12.1.0/appsutil/bin
echo apps|perl txkOnPremPrePDBCreationTasks.pl -dboraclehome=/d01/oracle/VIS/12.1.0 \
-outdir=/d01/oracle/VIS/12.1.0/appsutil/log -appsuser=apps \
-dbsid=VIS -skipdbshutdown=yes
# unzip database software
unzip -q /sw/ora_ebs/12214/V982063-01.zip -d /d01/oracle/VIS/19.3.0
# install the 19.3 database software
cat > ~oracle/rsp_db.rsp << EOF
oracle.install.responseFileVersion=/oracle/install/rspfmt_dbinstall_response_schema_v19.0.0
oracle.install.option=INSTALL_DB_SWONLY
UNIX_GROUP_NAME=dba
INVENTORY_LOCATION=/oracle/oraInventory
ORACLE_BASE=/d01/oracle/VIS
oracle.install.db.InstallEdition=EE
oracle.install.db.OSDBA_GROUP=dba
oracle.install.db.OSOPER_GROUP=oper
oracle.install.db.OSBACKUPDBA_GROUP=dba
oracle.install.db.OSDGDBA_GROUP=dba
oracle.install.db.OSKMDBA_GROUP=dba
oracle.install.db.OSRACDBA_GROUP=dba
oracle.install.db.rootconfig.executeRootScript=true
oracle.install.db.rootconfig.configMethod=ROOT
oracle.install.db.config.starterdb.type=GENERAL_PURPOSE
oracle.install.db.ConfigureAsContainerDB=false
oracle.install.db.config.starterdb.memoryOption=false
oracle.install.db.config.starterdb.installExampleSchemas=false
oracle.install.db.config.starterdb.managementOption=DEFAULT
oracle.install.db.config.starterdb.omsPort=0
oracle.install.db.config.starterdb.enableRecovery=false
oracle.install.db.config.starterdb.password.ALL=change_on_install
EOF
export ORACLE_HOME=/d01/oracle/VIS/19.3.0
export PATH=$ORACLE_HOME/bin:$ORACLE_HOME/perl/bin:$ORACLE_HOME/OPatch:$PATH
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$LD_LIBRARY_PATH
export PERL5LIB=/d01/oracle/VIS/19.3.0/perl/lib/5.38.2:/d01/oracle/VIS/19.3.0/perl/lib/site_perl/5.38.2/:/d01/oracle/VIS/19.3.0/appsutil/perl
export CV_ASSUME_DISTID=OL7
echo changeme|/d01/oracle/VIS/19.3.0/runInstaller -silent -responseFile /home/oracle/rsp_db.rsp
# update opatch
mv $ORACLE_HOME/OPatch $ORACLE_HOME/OPatch.old
unzip -oq /sw/ora_ebs/12214patches/p6880880_122010_Linux-x86-64.zip -d $ORACLE_HOME
unzip -oq /sw/ora_ebs/12214patches/p37260974_190000_Linux-x86-64.zip -d ~/dbfixes
unzip -oq /sw/ora_ebs/12214patches/p37102264_190000_Linux-x86-64.zip -d ~/dbfixes
unzip -oq /sw/ora_ebs/12214patches/p33538523_1926000DBRU_Linux-x86-64.zip -d ~/dbfixes
unzip -oq /sw/ora_ebs/12214patches/p36749043_1926000DBRU_Linux-x86-64.zip -d ~/dbfixes
unzip -oq /sw/ora_ebs/12214patches/p37327930_1926000DBRU_Linux-x86-64.zip -d ~/dbfixes
# applying patches
unzip -oq /sw/ora_ebs/12214patches/p37260974_190000_Linux-x86-64.zip -d ~/dbfixes
cd ~/dbfixes; $ORACLE_HOME/OPatch/opatch apply 37260974 -silent
echo changeme|su - root -c 'chown root /d01/oracle/VIS/19.3.0/bin/extjob; chmod 4750 /d01/oracle/VIS/19.3.0/bin/extjob'
$ORACLE_HOME/OPatch/opatch napply -id 37102264,33538523,36749043 -silent
cd ~/dbfixes/zip-bundle/LINUX_X86-64/database/19.26.0.0.250121DBRU/
for i in *zip; do unzip -qo $i; done
$ORACLE_HOME/OPatch/opatch napply -id 33538523,36749043 -silent; cd
# Create nls/data/9idata directory
perl $ORACLE_HOME/nls/data/old/cr9idata.pl
# Create appsutil.zip and copy it to the database tier
. /d01/oracle/VIS/EBSapps.env run
perl /d01/oracle/VIS/fs1/EBSapps/appl/ad/12.0.0/bin/admkappsutil.pl
unzip -qo /d01/oracle/VIS/fs1/inst/apps/VIS_$hn/admin/out/appsutil.zip -d /d01/oracle/VIS/19.3.0
# Copy the orai18n.jar file
cp /d01/oracle/VIS/19.3.0/jlib/orai18n.jar /d01/oracle/VIS/19.3.0/jdk/jre/lib/ext
# Install JRE 8
cd /d01/oracle/VIS/19.3.0/appsutil
cp -r /d01/oracle/VIS/19.3.0/jdk/jre .
cp /d01/oracle/VIS/19.3.0/jlib/orai18n.jar /d01/oracle/VIS/19.3.0/appsutil/jre/lib/ext
# Create the CDB
mkdir /d01/oracle/VIS/19.3.0/VISCDB
cat > ~oracle/rsp_dbca.rsp << EOF
responseFileVersion=/oracle/assistants/rspfmt_dbca_response_schema_v12.2.0
gdbName=VISCDB.fritz.box
sid=VISCDB
databaseConfigType=SI
policyManaged=false
createServerPool=false
force=false
createAsContainerDatabase=true
numberOfPDBs=0
useLocalUndoForPDBs=true
templateName=/d01/oracle/VIS/19.3.0/assistants/dbca/templates/General_Purpose.dbc
emConfiguration=DBEXPRESS
emExpressPort=5500
runCVUChecks=FALSE
omsPort=0
dvConfiguration=false
olsConfiguration=false
datafileJarLocation={ORACLE_HOME}/assistants/dbca/templates/
datafileDestination={ORACLE_BASE}/oradata/{DB_UNIQUE_NAME}/
storageType=FS
characterSet=AL32UTF8
nationalCharacterSet=UTF8
registerWithDirService=false
skipListenerRegistration=true
variables=ORACLE_BASE_HOME=/d01/oracle/VIS/19.3.0,DB_UNIQUE_NAME=VISCDB,ORACLE_BASE=/d01/oracle/VIS,PDB_NAME=,DB_NAME=VISCDB,ORACLE_HOME=/d01/oracle/VIS/19.3.0,SID=VISCDB
initParams=undo_tablespace=UNDOTBS1,sga_target=2GB,db_block_size=8192BYTES,nls_language=AMERICAN,dispatchers=(PROTOCOL=TCP) (SERVICE=VISCDBXDB),diagnostic_dest=/d01/oracle/VIS/19.3.0/VISCDB,control_files=("{ORACLE_BASE}/oradata/{DB_UNIQUE_NAME}/control01.ctl", "{ORACLE_BASE}/oradata/{DB_UNIQUE_NAME}/control02.ctl"),remote_login_passwordfile=EXCLUSIVE,audit_file_dest={ORACLE_BASE}/admin/{DB_UNIQUE_NAME}/adump,processes=640,pga_aggregate_target=1GB,nls_territory=AMERICA,open_cursors=300,db_domain=fritz.box,compatible=19.0.0,db_name=VISCDB,audit_trail=db
sampleSchema=false
memoryPercentage=40
databaseType=MULTIPURPOSE
automaticMemoryManagement=false
totalMemory=0
sysPassword=change_on_install
systemPassword=manager
EOF
export ORACLE_HOME=/d01/oracle/VIS/19.3.0
export PATH=$ORACLE_HOME/bin:$ORACLE_HOME/perl/bin:$ORACLE_HOME/OPatch:$PATH
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$LD_LIBRARY_PATH
export PERL5LIB=/d01/oracle/VIS/19.3.0/perl/lib/5.38.2:/d01/oracle/VIS/19.3.0/perl/lib/site_perl/5.38.2/:/d01/oracle/VIS/19.3.0/appsutil/perl
dbca -silent -createDatabase -responseFile ~/rsp_dbca.rsp
# Run datapatch on CDB
export ORACLE_SID=VISCDB; unset TWO_TASK
$ORACLE_HOME/OPatch/datapatch
# Create the CDB MGDSYS schema
echo '@?/rdbms/admin/catmgd.sql'|sqlplus -S / as sysdba
# Create the CDB TNS files
cd $ORACLE_HOME/appsutil
. ./txkSetCfgCDB.env dboraclehome=/d01/oracle/VIS/19.3.0
cd $ORACLE_HOME/appsutil/bin
perl txkGenCDBTnsAdmin.pl -dboraclehome=/d01/oracle/VIS/19.3.0 \
-cdbname=VISCDB -cdbsid=VISCDB -dbport=1521 \
-outdir=/d01/oracle/VIS/19.3.0/appsutil/log
# Set parameters and shutdown the CDB
echo 'shutdown immediate'|sqlplus -S / as sysdba
Now we are ready to perform the actual database upgrade involving downtime for the end users.
Performing the actual database upgrade
# run as oracle
hn=`hostname|awk -F. {'print $1'}`
# Store the UTL_FILE_DIR parameter values
. /d01/oracle/VIS/12.1.0/VIS_$hn.env
echo apps|perl $ORACLE_HOME/appsutil/bin/txkCfgUtlfileDir.pl -contextfile=/d01/oracle/VIS/12.1.0/appsutil/VIS_$hn.xml \
-oraclehome=/d01/oracle/VIS/12.1.0 -outdir=/home/oracle \
-upgradedhome=/d01/oracle/VIS/19.3.0 -mode=getUtlFileDir -servicetype=onpremise
mkdir -p /d01/oracle/VIS/temp/VIS
mkdir -p /d01/oracle/VIS/19.3.0/appsutil/outbound/VIS_$hn
. /d01/oracle/VIS/12.1.0/VIS_$hn.env
(echo apps; echo manager)|perl $ORACLE_HOME/appsutil/bin/txkCfgUtlfileDir.pl -contextfile=/d01/oracle/VIS/12.1.0/appsutil/VIS_$hn.xml -oraclehome=/d01/oracle/VIS/12.1.0 -outdir=/home/oracle -upgradedhome=/d01/oracle/VIS/19.3.0 -mode=setUtlFileDir -servicetype=onpremise
# stop Application Tier
. /d01/oracle/VIS/fs1/EBSapps/appl/VIS_$hn.env
(echo apps; echo apps; echo welcome1)|/d01/oracle/VIS/fs1/inst/apps/VIS_$hn/admin/scripts/adstpall.sh
. /d01/oracle/VIS/12.1.0/VIS_$hn.env
lsnrctl stop
echo 'VIS:/d01/oracle/VIS/12.1.0:N' >> /etc/oratab
sed -i s/^sec_case_sensitive_logon.*// /d01/oracle/VIS/12.1.0/dbs/initVIS.ora
sed -i s/^olap_page_pool_size.*// /d01/oracle/VIS/12.1.0/dbs/initVIS.ora
sed -i s/'^processes.*'/'processes = 300 # Max. no. of users x 2'/ /d01/oracle/VIS/12.1.0/dbs/initVIS.ora
sed -i s/'^sessions.*'/'sessions = 600 # 2 X processes'/ /d01/oracle/VIS/12.1.0/dbs/initVIS.ora
sed -i s/'^o7_dictionary_accessibility.*'/'#o7_dictionary_accessibility = FALSE #MP'/ /d01/oracle/VIS/12.1.0/dbs/initVIS.ora
sed -i s/'^optimizer_adaptive_features.*'/'#optimizer_adaptive_features = FALSE #MP'/ /d01/oracle/VIS/12.1.0/dbs/initVIS.ora
sed -i s/'^utl_file_dir.*'/'#utl_file_dir = \/usr\/tmp,\/usr\/tmp,\/d01\/oracle\/VIS\/12.1.0\/appsutil\/outbound\/VIS_$hn,\/usr\/tmp'/ /d01/oracle/VIS/12.1.0/dbs/initVIS.ora
echo "EVENT='10946 trace name context forever, level 8454144'" >>/d01/oracle/VIS/12.1.0/dbs/initVIS.ora
sqlplus -S / as sysdba <<EOF
shutdown immediate
startup
@?/olap/admin/catnoamd.sql
exec dbms_stats.gather_dictionary_stats()
EOF
# Upgrade the database instance
# fix dbua check failures
. /d01/oracle/VIS/12.1.0/VIS_$hn.env
cat <<EOF >~/drop.sql
set pause off
set heading off
set pagesize 0
set feedback off
set verify off
spool /home/oracle/dropsys.sql
select 'DROP ' || object_type || ' SYSTEM."' || object_name || '";'
from dba_objects
where object_name not in ('AQ$_SCHEDULES_PRIMARY','DBMS_REPCAT_AUTH','AQ$_SCHEDULES','PRODUCT_USER_PROFILE','SQLPLUS_PRODUCT_PROFILE','PRODUCT_PRIVS','HELP','HELP_TOPIC_SEQ') and object_name||object_type in
(select object_name||object_type
from dba_objects
where owner = 'SYS')
and owner = 'SYSTEM';
spool off
exit
EOF
sqlplus -S / as sysdba @/home/oracle/drop.sql
echo '@/home/oracle/dropsys.sql'|sqlplus -S system/manager
echo '@?/rdbms/admin/utlrp'|sqlplus -S / as sysdba
# Case insensitive password version
sqlplus / as sysdba <<EOF
alter user DCM identified by change_on_install;
alter user REPADMIN identified by change_on_install;
alter user IP identified by change_on_install;
alter user CTXTEST identified by change_on_install;
alter user CSDUMMY identified by change_on_install;
alter user TRACESVR identified by change_on_install;
alter user EDGE identified by change_on_install;
alter user AD_MONITOR identified by change_on_install;
alter user EM_MONITOR identified by change_on_install;
exit
EOF
# remove Streams
echo 'exec dbms_streams_adm.remove_streams_configuration()'|sqlplus -S / as sysdba
sqlplus / as sysdba <<EOF
truncate table sys.apply\$_source_obj ;
truncate table apply\$_source_schema;
EOF
export ORACLE_HOME=/d01/oracle/VIS/19.3.0
export ORACLE_SID=VIS
export PATH=$ORACLE_HOME/bin:$ORACLE_HOME/perl/bin:$ORACLE_HOME/OPatch:$PATH
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$LD_LIBRARY_PATH
export PERL5LIB=/d01/oracle/VIS/19.3.0/perl/lib/5.38.2:/d01/oracle/VIS/19.3.0/perl/lib/site_perl/5.38.2/:/d01/oracle/VIS/19.3.0/appsutil/perl
export CV_ASSUME_DISTID=OL7
lsnrctl start
dbua -silent -sid VIS -keepEvents -upgradeTimezone true -recompile_invalid_objects true -upgrade_parallelism 4 -emConfiguration DBEXPRESS -listeners LISTENER -performFixUp true
sqlplus -S / as sysdba <<EOF
alter system set compatible='19.0.0' scope=spfile;
alter user apps identified by apps;
shutdown immediate
startup
EOF
$ORACLE_HOME/OPatch/datapatch
Sample Output (click to expand):
[oracle@lin7 bin]$ # run as oracle
[oracle@lin7 bin]$ hn=`hostname|awk -F. {'print $1'}`
(echo apps; echo manager)|perl $ORACLE_HOME/appsutil/bin/txkCfgUtlfileDir.pl -contextfile=/d01/oracle/VIS/12.1.0/appsutil/VIS_$hn.xml -oraclehome=/d01/oracle/VIS/12.1.0 -outdir=/home/oracle -upgradedhome=/d01/oracle/VIS/19.3.0 -mode=setUtlFileDir -servicetype=onpremise
# stop Application Tier
. /d01/oracle/VIS/fs1/EBSapps/appl/VIS_$hn.env
(echo apps; echo apps; echo welcome1)|/d01/oracle/VIS/fs1/inst/apps/VIS_$hn/admin/scripts/adstpall.sh
. /d01/oracle/VIS/12.1.0/VIS_$hn.env
lsnrctl stop
echo 'VIS:/d01/oracle/VIS/12.1.0:N' >> /etc/oratab
sed -i s/^sec_case_sensitive_logon.*// /d01/oracle/VIS/12.1.0/dbs/initVIS.ora
sed -i s/^olap_page_pool_size.*// /d01/oracle/VIS/12.1.0/dbs/initVIS.ora
sed -i s/'^processes.*'/'processes = 300 # Max. no. of users x 2'/ /d01/oracle/VIS/12.1.0/dbs/initVIS.ora
sed -i s/'^sessions.*'/'sessions = 600 # 2 X processes'/ /d01/oracle/VIS/12.1.0/dbs/initVIS.ora
sed -i s/'^o7_dictionary_accessibility.*'/'#o7_dictionary_accessibility = FALSE #MP'/ /d01/oracle/VIS/12.1.0/dbs/initVIS.ora
sed -i s/'^optimizer_adaptive_features.*'/'#optimizer_adaptive_features = FALSE #MP'/ /d01/oracle/VIS/12.1.0/dbs/initVIS.ora
sed -i s/'^utl_file_dir.*'/'#utl_file_dir = \/usr\/tmp,\/usr\/tmp,\/d01\/oracle\/VIS\/12.1.0\/appsutil\/outbound\/VIS_$hn,\/usr\/tmp'/ /d01/oracle/VIS/12.1.0/dbs/initVIS.ora
echo "EVENT='10946 trace name context forever, level 8454144'" >>/d01/oracle/VIS/12.1.0/dbs/initVIS.ora
sqlplus -S / as sysdba <<EOF
shutdown immediate
startup
@?/olap/admin/catnoamd.sql
exec dbms_stats.gather_dictionary_stats()
EOF
# Upgrade the database instance
# fix dbua check failures
. /d01/oracle/VIS/12.1.0/VIS_$hn.env
cat <<EOF >~/drop.sql
set pause off
set heading off
set pagesize 0
set feedback off
set verify off
spool /home/oracle/dropsys.sql
select 'DROP ' || object_type || ' SYSTEM."' || object_name || '";'
from dba_objects
where object_name not in ('AQ$_SCHEDULES_PRIMARY','DBMS_REPCAT_AUTH','AQ$_SCHEDULES','PRODUCT_USER_PROFILE','SQLPLUS_PRODUCT_PROFILE','PRODUCT_PRIVS','HELP','HELP_TOPIC_SEQ') and object_name||object_type in
(select object_name||object_type
from dba_objects
where owner = 'SYS')
and owner = 'SYSTEM';
spool off
exit
EOF
sqlplus -S / as sysdba @/home/oracle/drop.sql
echo '@/home/oracle/dropsys.sql'|sqlplus -S system/manager
echo '@?/rdbms/admin/utlrp'|sqlplus -S / as sysdba
# Case insensitive password version
sqlplus / as sysdba <<EOF
alter user DCM identified by change_on_install;
alter user REPADMIN identified by change_on_install;
alter user IP identified by change_on_install;
alter user CTXTEST identified by change_on_install;
alter user CSDUMMY identified by change_on_install;
alter user TRACESVR identified by change_on_install;
alter user EDGE identified by change_on_install;
alter user AD_MONITOR identified by change_on_install;
alter user EM_MONITOR identified by change_on_install;
exit
EOF
# remove Streams
echo 'exec dbms_streams_adm.remove_streams_configuration()'|sqlplus -S / as sysdba
sqlplus / as sysdba <<EOF
truncate table sys.apply\$_source_obj ;
[oracle@lin7 bin]$ # Store the UTL_FILE_DIR parameter values
export PATH=$ORACLE_HOME/bin:$ORACLE_HOME/perl/bin:$ORACLE_HOME/OPatch:$PATH
[oracle@lin7 bin]$ . /d01/oracle/VIS/12.1.0/VIS_$hn.env
lsnrctl start
dbua -silent -sid VIS -keepEvents -upgradeTimezone true -recompile_invalid_objects true -upgrade_parallelism 4 -emConfiguration DBEXPRESS -listeners LISTENER -performFixUp true
sqlplus [oracle@lin7 bin]$ echo apps|perl $ORACLE_HOME/appsutil/bin/txkCfgUtlfileDir.pl -contextfile=/d01/oracle/VIS/12.1.0/appsutil/VIS_$hn.xml \
> -oraclehome=/d01/oracle/VIS/12.1.0 -outdir=/home/oracle \
> -upgradedhome=/d01/oracle/VIS/19.3.0 -mode=getUtlFileDir -servicetype=onpremise
stty: 'standard input': Inappropriate ioctl for device
Enter the APPS Password:
stty: 'standard input': Inappropriate ioctl for device
Script Name : txkCfgUtlfileDir.pl
Script Version : 120.0.12020000.31
Started : Tue Oct 7 20:43:51 CEST 2025
Log File : /home/oracle/TXK_UTIL_DIR_Tue_Oct_7_20_43_51_2025/txkCfgUtlfileDir.log
Context file: /d01/oracle/VIS/12.1.0/appsutil/VIS_lin7.xml exists.
==============================================================================
Successfully generated the below file with UTL_FILE_DIR content:
/d01/oracle/VIS/12.1.0/dbs/VIS_utlfiledir.txt
==============================================================================
Completed : Tue Oct 7 20:43:52 CEST 2025
Successfully Completed the script
ERRORCODE = 0 ERRORCODE_END
[oracle@lin7 bin]$ mkdir -p /d01/oracle/VIS/temp/VIS
[oracle@lin7 bin]$ mkdir -p /d01/oracle/VIS/19.3.0/appsutil/outbound/VIS_$hn
[oracle@lin7 bin]$ . /d01/oracle/VIS/12.1.0/VIS_$hn.env
[oracle@lin7 bin]$ (echo apps; echo manager)|perl $ORACLE_HOME/appsutil/bin/txkCfgUtlfileDir.pl -contextfile=/d01/oracle/VIS/12.1.0/appsutil/VIS_$hn.xml -oraclehome=/d01/oracle/VIS/12.1.0 -outdir=/home/oracle -upgradedhome=/d01/oracle/VIS/19.3.0 -mode=setUtlFileDir -servicetype=onpremise
stty: 'standard input': Inappropriate ioctl for device
Enter the APPS Password:
stty: 'standard input': Inappropriate ioctl for device
Script Name : txkCfgUtlfileDir.pl
Script Version : 120.0.12020000.31
Started : Tue Oct 7 20:43:52 CEST 2025
Log File : /home/oracle/TXK_UTIL_DIR_Tue_Oct_7_20_43_52_2025/txkCfgUtlfileDir.log
Context file: /d01/oracle/VIS/12.1.0/appsutil/VIS_lin7.xml exists.
stty: 'standard input': Inappropriate ioctl for device
Enter the ebs_system Password:
stty: 'standard input': Inappropriate ioctl for device
Completed : Tue Oct 7 20:43:55 CEST 2025
Successfully Completed the script
ERRORCODE = 0 ERRORCODE_END
[oracle@lin7 bin]$ # stop Application Tier
[oracle@lin7 bin]$ . /d01/oracle/VIS/fs1/EBSapps/appl/VIS_$hn.env
[oracle@lin7 bin]$ (echo apps; echo apps; echo welcome1)|/d01/oracle/VIS/fs1/inst/apps/VIS_$hn/admin/scripts/adstpall.sh
You are running adstpall.sh version 120.22.12020000.7
Enter the APPS username: stty: 'standard input': Inappropriate ioctl for device
Enter the APPS password:
Enter the WebLogic Server password:
stty: 'standard input': Inappropriate ioctl for device
The logfile for this session is located at /d01/oracle/VIS/fs1/inst/apps/VIS_lin7/logs/appl/admin/log/adstpall.log
Executing service control script:
/d01/oracle/VIS/fs1/inst/apps/VIS_lin7/admin/scripts/adapcctl.sh stop
Timeout specified in context file: 100 second(s)
script returned:
****************************************************
You are running adapcctl.sh version 120.0.12020000.6
Stopping OPMN managed Oracle HTTP Server (OHS) instance ...
adapcctl.sh: exiting with status 0
adapcctl.sh: check the logfile /d01/oracle/VIS/fs1/inst/apps/VIS_lin7/logs/appl/admin/log/adapcctl.txt for more information ...
.end std out.
.end err out.
****************************************************
Executing service control script:
/d01/oracle/VIS/fs1/inst/apps/VIS_lin7/admin/scripts/adcmctl.sh stop
Timeout specified in context file: 1000 second(s)
script returned:
****************************************************
You are running adcmctl.sh version 120.19.12020000.7
Shutting down concurrent managers for VIS ...
ORACLE Password:
Submitted request 7471136 for CONCURRENT FND SHUTDOWN
adcmctl.sh: exiting with status 0
adcmctl.sh: check the logfile /d01/oracle/VIS/fs1/inst/apps/VIS_lin7/logs/appl/admin/log/adcmctl.txt for more information ...
.end std out.
.end err out.
****************************************************
Executing service control script:
/d01/oracle/VIS/fs1/inst/apps/VIS_lin7/admin/scripts/jtffmctl.sh stop
Timeout specified in context file: 100 second(s)
script returned:
****************************************************
You are running jtffmctl.sh version 120.3.12020000.4
Shutting down Fulfillment Server for VIS on port 9300 ...
jtffmctl.sh: exiting with status 0
.end std out.
.end err out.
****************************************************
Executing service control script:
/d01/oracle/VIS/fs1/inst/apps/VIS_lin7/admin/scripts/adopmnctl.sh stop
Timeout specified in context file: 100 second(s)
script returned:
****************************************************
You are running adopmnctl.sh version 120.0.12020000.2
Stopping Oracle Process Manager (OPMN) and the managed processes ...
opmnctl stopall: stopping opmn and all managed processes...
adopmnctl.sh: exiting with status 0
adopmnctl.sh: check the logfile /d01/oracle/VIS/fs1/inst/apps/VIS_lin7/logs/appl/admin/log/adopmnctl.txt for more information ...
.end std out.
.end err out.
****************************************************
Executing service control script:
/d01/oracle/VIS/fs1/inst/apps/VIS_lin7/admin/scripts/admanagedsrvctl.sh abort oafm_server1 -nopromptmsg
Timeout specified in context file: -1 second(s)
script returned:
****************************************************
You are running admanagedsrvctl.sh version 120.14.12020000.12
Stopping oafm_server1...
Refer /d01/oracle/VIS/fs1/inst/apps/VIS_lin7/logs/appl/admin/log/adoafmctl.txt for details
Server specific logs are located at /d01/oracle/VIS/fs1/FMW_Home/user_projects/domains/EBS_domain_VIS/servers/oafm_server1/logs
admanagedsrvctl.sh: exiting with status 0
admanagedsrvctl.sh: check the logfile /d01/oracle/VIS/fs1/inst/apps/VIS_lin7/logs/appl/admin/log/adoafmctl.txt for more information ...
.end std out.
.end err out.
****************************************************
Executing service control script:
/d01/oracle/VIS/fs1/inst/apps/VIS_lin7/admin/scripts/admanagedsrvctl.sh abort oacore_server1 -nopromptmsg
Timeout specified in context file: -1 second(s)
script returned:
****************************************************
You are running admanagedsrvctl.sh version 120.14.12020000.12
Stopping oacore_server1...
Refer /d01/oracle/VIS/fs1/inst/apps/VIS_lin7/logs/appl/admin/log/adoacorectl.txt for details
Server specific logs are located at /d01/oracle/VIS/fs1/FMW_Home/user_projects/domains/EBS_domain_VIS/servers/oacore_server1/logs
admanagedsrvctl.sh: exiting with status 0
admanagedsrvctl.sh: check the logfile /d01/oracle/VIS/fs1/inst/apps/VIS_lin7/logs/appl/admin/log/adoacorectl.txt for more information ...
.end std out.
.end err out.
****************************************************
Executing service control script:
/d01/oracle/VIS/fs1/inst/apps/VIS_lin7/admin/scripts/admanagedsrvctl.sh abort forms_server1 -nopromptmsg
Timeout specified in context file: -1 second(s)
script returned:
****************************************************
You are running admanagedsrvctl.sh version 120.14.12020000.12
Stopping forms_server1...
Refer /d01/oracle/VIS/fs1/inst/apps/VIS_lin7/logs/appl/admin/log/adformsctl.txt for details
Server specific logs are located at /d01/oracle/VIS/fs1/FMW_Home/user_projects/domains/EBS_domain_VIS/servers/forms_server1/logs
admanagedsrvctl.sh: exiting with status 0
admanagedsrvctl.sh: check the logfile /d01/oracle/VIS/fs1/inst/apps/VIS_lin7/logs/appl/admin/log/adformsctl.txt for more information ...
.end std out.
.end err out.
****************************************************
Executing service control script:
/d01/oracle/VIS/fs1/inst/apps/VIS_lin7/admin/scripts/adalnctl.sh stop
Timeout specified in context file: 100 second(s)
script returned:
****************************************************
adalnctl.sh version 120.3.12020000.4
Shutting down listener process APPS_VIS.
adalnctl.sh: exiting with status 0
adalnctl.sh: check the logfile /d01/oracle/VIS/fs1/inst/apps/VIS_lin7/logs/appl/admin/log/adalnctl.txt for more information ...
.end std out.
.end err out.
****************************************************
Executing service control script:
/d01/oracle/VIS/fs1/inst/apps/VIS_lin7/admin/scripts/adadminsrvctl.sh stop -nopromptmsg
Timeout specified in context file: -1 second(s)
script returned:
****************************************************
You are running adadminsrvctl.sh version 120.10.12020000.11
Stopping WLS Admin Server...
Refer /d01/oracle/VIS/fs1/inst/apps/VIS_lin7/logs/appl/admin/log/adadminsrvctl.txt for details
AdminServer logs are located at /d01/oracle/VIS/fs1/FMW_Home/user_projects/domains/EBS_domain_VIS/servers/AdminServer/logs
adadminsrvctl.sh: exiting with status 0
adadminsrvctl.sh: check the logfile /d01/oracle/VIS/fs1/inst/apps/VIS_lin7/logs/appl/admin/log/adadminsrvctl.txt for more information ...
.end std out.
.end err out.
****************************************************
Executing service control script:
/d01/oracle/VIS/fs1/inst/apps/VIS_lin7/admin/scripts/adnodemgrctl.sh stop -nopromptmsg
Timeout specified in context file: -1 second(s)
script returned:
****************************************************
You are running adnodemgrctl.sh version 120.11.12020000.12
NodeManager log is located at /d01/oracle/VIS/fs1/FMW_Home/wlserver_10.3/common/nodemanager/nmHome1
adnodemgrctl.sh: exiting with status 0
adnodemgrctl.sh: check the logfile /d01/oracle/VIS/fs1/inst/apps/VIS_lin7/logs/appl/admin/log/adnodemgrctl.txt for more information ...
.end std out.
.end err out.
****************************************************
All enabled services on this node are stopped.
adstpall.sh:Exiting with status 0
adstpall.sh: check the logfile /d01/oracle/VIS/fs1/inst/apps/VIS_lin7/logs/appl/admin/log/adstpall.log for more information ...
[oracle@lin7 bin]$ . /d01/oracle/VIS/12.1.0/VIS_$hn.env
[oracle@lin7 bin]$ lsnrctl stop
LSNRCTL for Linux: Version 12.1.0.2.0 - Production on 07-OCT-2025 20:44:43
Copyright (c) 1991, 2014, Oracle. All rights reserved.
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
The command completed successfully
[oracle@lin7 bin]$ echo 'VIS:/d01/oracle/VIS/12.1.0:N' >> /etc/oratab
[oracle@lin7 bin]$ sed -i s/^sec_case_sensitive_logon.*// /d01/oracle/VIS/12.1.0/dbs/initVIS.ora
[oracle@lin7 bin]$ sed -i s/^olap_page_pool_size.*// /d01/oracle/VIS/12.1.0/dbs/initVIS.ora
[oracle@lin7 bin]$ sed -i s/'^processes.*'/'processes = 300 # Max. no. of users x 2'/ /d01/oracle/VIS/12.1.0/dbs/initVIS.ora
[oracle@lin7 bin]$ sed -i s/'^sessions.*'/'sessions = 600 # 2 X processes'/ /d01/oracle/VIS/12.1.0/dbs/initVIS.ora
[oracle@lin7 bin]$ sed -i s/'^o7_dictionary_accessibility.*'/'#o7_dictionary_accessibility = FALSE #MP'/ /d01/oracle/VIS/12.1.0/dbs/initVIS.ora
[oracle@lin7 bin]$ sed -i s/'^optimizer_adaptive_features.*'/'#optimizer_adaptive_features = FALSE #MP'/ /d01/oracle/VIS/12.1.0/dbs/initVIS.ora
[oracle@lin7 bin]$ sed -i s/'^utl_file_dir.*'/'#utl_file_dir = \/usr\/tmp,\/usr\/tmp,\/d01\/oracle\/VIS\/12.1.0\/appsutil\/outbound\/VIS_$hn,\/usr\/tmp'/ /d01/oracle/VIS/12.1.0/dbs/initVIS.ora
[oracle@lin7 bin]$ echo "EVENT='10946 trace name context forever, level 8454144'" >>/d01/oracle/VIS/12.1.0/dbs/initVIS.ora
[oracle@lin7 bin]$ sqlplus -S / as sysdba <<EOF
> shutdown immediate
> startup
> @?/olap/admin/catnoamd.sql
> exec dbms_stats.gather_dictionary_stats()
> EOF
Database closed.
Database dismounted.
ORACLE instance shut down.
ORACLE instance started.
Total System Global Area 2147483648 bytes
Fixed Size 2926472 bytes
Variable Size 469764216 bytes
Database Buffers 1660944384 bytes
Redo Buffers 13848576 bytes
Database mounted.
Database opened.
Synonym dropped.
Synonym dropped.
Synonym dropped.
Synonym dropped.
Synonym dropped.
Synonym dropped.
Synonym dropped.
Synonym dropped.
Synonym dropped.
Synonym dropped.
Synonym dropped.
Synonym dropped.
Synonym dropped.
Synonym dropped.
Synonym dropped.
Synonym dropped.
Synonym dropped.
Synonym dropped.
Synonym dropped.
Synonym dropped.
Synonym dropped.
Synonym dropped.
Synonym dropped.
Synonym dropped.
Synonym dropped.
Synonym dropped.
Synonym dropped.
Synonym dropped.
Synonym dropped.
Synonym dropped.
Synonym dropped.
Synonym dropped.
Synonym dropped.
Synonym dropped.
Synonym dropped.
Synonym dropped.
Synonym dropped.
Synonym dropped.
Synonym dropped.
Synonym dropped.
Synonym dropped.
Synonym dropped.
Synonym dropped.
Synonym dropped.
Synonym dropped.
Synonym dropped.
Synonym dropped.
Synonym dropped.
Synonym dropped.
Synonym dropped.
Synonym dropped.
Synonym dropped.
Synonym dropped.
Synonym dropped.
Synonym dropped.
Synonym dropped.
Synonym dropped.
Synonym dropped.
Synonym dropped.
Synonym dropped.
Synonym dropped.
Synonym dropped.
Synonym dropped.
Synonym dropped.
Synonym dropped.
Synonym dropped.
Synonym dropped.
Synonym dropped.
Synonym dropped.
Synonym dropped.
Synonym dropped.
Synonym dropped.
Synonym dropped.
Synonym dropped.
Synonym dropped.
Synonym dropped.
Synonym dropped.
Synonym dropped.
Synonym dropped.
Synonym dropped.
Synonym dropped.
Synonym dropped.
Synonym dropped.
Synonym dropped.
Synonym dropped.
Synonym dropped.
Synonym dropped.
Synonym dropped.
Synonym dropped.
Synonym dropped.
Synonym dropped.
Synonym dropped.
Synonym dropped.
Synonym dropped.
Synonym dropped.
Synonym dropped.
Synonym dropped.
Synonym dropped.
Synonym dropped.
Synonym dropped.
Synonym dropped.
Synonym dropped.
Synonym dropped.
Synonym dropped.
Synonym dropped.
Synonym dropped.
Synonym dropped.
Synonym dropped.
Synonym dropped.
Synonym dropped.
Synonym dropped.
Synonym dropped.
Synonym dropped.
Synonym dropped.
Synonym dropped.
Synonym dropped.
Synonym dropped.
Synonym dropped.
Synonym dropped.
Synonym dropped.
Synonym dropped.
Synonym dropped.
Synonym dropped.
Synonym dropped.
Synonym dropped.
Synonym dropped.
Synonym dropped.
Synonym dropped.
Synonym dropped.
Synonym dropped.
Synonym dropped.
Synonym dropped.
Synonym dropped.
Synonym dropped.
Synonym dropped.
Synonym dropped.
Synonym dropped.
Synonym dropped.
Synonym dropped.
Synonym dropped.
Synonym dropped.
Synonym dropped.
Synonym dropped.
Synonym dropped.
Synonym dropped.
Synonym dropped.
Synonym dropped.
Synonym dropped.
Synonym dropped.
Synonym dropped.
Synonym dropped.
Synonym dropped.
Synonym dropped.
Synonym dropped.
Synonym dropped.
Synonym dropped.
Synonym dropped.
Synonym dropped.
Synonym dropped.
Synonym dropped.
Synonym dropped.
Synonym dropped.
Synonym dropped.
Synonym dropped.
Synonym dropped.
Synonym dropped.
Synonym dropped.
Synonym dropped.
Synonym dropped.
Synonym dropped.
Package dropped.
Synonym dropped.
Synonym dropped.
Synonym dropped.
Synonym dropped.
Synonym dropped.
Synonym dropped.
Synonym dropped.
Synonym dropped.
Synonym dropped.
Synonym dropped.
Synonym dropped.
Synonym dropped.
Synonym dropped.
Synonym dropped.
Synonym dropped.
Synonym dropped.
Synonym dropped.
Synonym dropped.
Synonym dropped.
Synonym dropped.
Synonym dropped.
Synonym dropped.
Synonym dropped.
Synonym dropped.
Synonym dropped.
Synonym dropped.
Synonym dropped.
Synonym dropped.
Synonym dropped.
Synonym dropped.
Synonym dropped.
Synonym dropped.
Synonym dropped.
Synonym dropped.
Synonym dropped.
Synonym dropped.
Synonym dropped.
Synonym dropped.
Synonym dropped.
Synonym dropped.
Synonym dropped.
Synonym dropped.
Synonym dropped.
Synonym dropped.
Synonym dropped.
Synonym dropped.
Synonym dropped.
Synonym dropped.
Synonym dropped.
Synonym dropped.
Synonym dropped.
Synonym dropped.
Synonym dropped.
Synonym dropped.
Synonym dropped.
Synonym dropped.
Synonym dropped.
Synonym dropped.
Synonym dropped.
Synonym dropped.
Synonym dropped.
Synonym dropped.
Synonym dropped.
Synonym dropped.
Synonym dropped.
Synonym dropped.
Synonym dropped.
Synonym dropped.
Synonym dropped.
Synonym dropped.
Synonym dropped.
Synonym dropped.
Synonym dropped.
Synonym dropped.
Synonym dropped.
Synonym dropped.
Synonym dropped.
Synonym dropped.
Synonym dropped.
Synonym dropped.
Synonym dropped.
Synonym dropped.
Synonym dropped.
Synonym dropped.
Synonym dropped.
Synonym dropped.
Synonym dropped.
Synonym dropped.
Synonym dropped.
Synonym dropped.
Synonym dropped.
Synonym dropped.
Synonym dropped.
Synonym dropped.
Synonym dropped.
Synonym dropped.
Synonym dropped.
Synonym dropped.
Synonym dropped.
PL/SQL procedure successfully completed.
1 row deleted.
PL/SQL procedure successfully completed.
[oracle@lin7 bin]$
[oracle@lin7 bin]$ # Upgrade the database instance
[oracle@lin7 bin]$ # fix dbua check failures
[oracle@lin7 bin]$ . /d01/oracle/VIS/12.1.0/VIS_$hn.env
[oracle@lin7 bin]$ cat <<EOF >~/drop.sql
> set pause off
> set heading off
> set pagesize 0
> set feedback off
> set verify off
> spool /home/oracle/dropsys.sql
> select 'DROP ' || object_type || ' SYSTEM."' || object_name || '";'
> from dba_objects
> where object_name not in ('AQ$_SCHEDULES_PRIMARY','DBMS_REPCAT_AUTH','AQ$_SCHEDULES','PRODUCT_USER_PROFILE','SQLPLUS_PRODUCT_PROFILE','PRODUCT_PRIVS','HELP','HELP_TOPIC_SEQ') and object_name||object_type in
> (select object_name||object_type
> from dba_objects
> where owner = 'SYS')
> and owner = 'SYSTEM';
> spool off
> exit
> EOF
[oracle@lin7 bin]$ sqlplus -S / as sysdba @/home/oracle/drop.sql
DROP JAVA CLASS SYSTEM."/1dbf45b0_MessageNotReadableEx";
DROP JAVA CLASS SYSTEM."/21fb8a53_AQjmsStreamMessage_C";
DROP JAVA CLASS SYSTEM."/2619b921_AQjmsConnectionMetaD";
DROP JAVA CLASS SYSTEM."/28400b8_AQjmsQueueConnectionF";
DROP JAVA CLASS SYSTEM."/2922d097_XAQueueConnectionFac";
DROP JAVA CLASS SYSTEM."/2ec2ee1d_AQjmsMessageHeaderEx";
DROP JAVA CLASS SYSTEM."/43b76d8b_AQOracleObjectPayloa";
DROP JAVA CLASS SYSTEM."/51827d69_TransactionRolledBac";
DROP JAVA CLASS SYSTEM."/5d6dbfa_InvalidClientIDExcept";
DROP JAVA CLASS SYSTEM."/61a6120b_AQjmsDeqSelConstants";
DROP JAVA CLASS SYSTEM."/61e54c96_ResourceAllocationEx";
DROP JAVA CLASS SYSTEM."/65132ceb_TopicConnectionFacto";
DROP JAVA CLASS SYSTEM."/703e85e0_InvalidSelectorExcep";
DROP JAVA CLASS SYSTEM."/752e8fe_AQjmsDeqSelTokenManag";
DROP JAVA CLASS SYSTEM."/7553a031_IllegalStateExceptio";
DROP JAVA CLASS SYSTEM."/777c3a97_TransactionInProgres";
DROP JAVA CLASS SYSTEM."/7bef4462_AQjmsTopicSubscriber";
DROP JAVA CLASS SYSTEM."/93869da0_AQjmsMessageFormatEx";
DROP JAVA CLASS SYSTEM."/940b5b2a_XATopicConnectionFac";
DROP JAVA CLASS SYSTEM."/9a34c3ac_MessageNotWriteableE";
DROP JAVA CLASS SYSTEM."/9a56c411_AQjmsMessageHeaderEx";
DROP JAVA CLASS SYSTEM."/9d4f20e5_AQjmsObjectMessage_C";
DROP JAVA CLASS SYSTEM."/a72c31e9_AQjmsTextMessage_CRe";
DROP JAVA CLASS SYSTEM."/b47a6340_QueueConnectionFacto";
DROP JAVA CLASS SYSTEM."/bc87784e_AQjmsDestinationProp";
DROP JAVA CLASS SYSTEM."/bec9bee5_AQjmsParserTokenMana";
DROP JAVA CLASS SYSTEM."/c19b426a_AQjmsTopicConnection";
DROP JAVA CLASS SYSTEM."/e970ba98_AQjmsParserConstants";
DROP JAVA CLASS SYSTEM."/f3c38e0b_MessageFormatExcepti";
DROP JAVA CLASS SYSTEM."/f41b8b3_InvalidDestinationExc";
DROP TABLE SYSTEM."AQ$_SCHEDULES";
DROP INDEX SYSTEM."AQ$_SCHEDULES_PRIMARY";
DROP VIEW SYSTEM."DBA_REGISTERED_SNAPSHOT_GROUPS";
DROP LIBRARY SYSTEM."DBMS_LDAP_API_LIB";
DROP LIBRARY SYSTEM."DBMS_REPAPI_LIB";
DROP LIBRARY SYSTEM."DBMS_REPCAT_INTERNAL_PKG_LIB";
DROP LIBRARY SYSTEM."DBMS_SNAPSHOT_LIB";
DROP VIEW SYSTEM."DEFCALLDEST";
DROP VIEW SYSTEM."DEFTRANDEST";
DROP SEQUENCE SYSTEM."GENERATOR$_S";
DROP JAVA RESOURCE SYSTEM."META-INF/MANIFEST.MF";
DROP VIEW SYSTEM."REPCAT_REPOBJECT_BASE";
DROP JAVA CLASS SYSTEM."javax/jms/BytesMessage";
DROP JAVA CLASS SYSTEM."javax/jms/Connection";
DROP JAVA CLASS SYSTEM."javax/jms/ConnectionConsumer";
DROP JAVA CLASS SYSTEM."javax/jms/ConnectionFactory";
DROP JAVA CLASS SYSTEM."javax/jms/ConnectionMetaData";
DROP JAVA CLASS SYSTEM."javax/jms/DeliveryMode";
DROP JAVA CLASS SYSTEM."javax/jms/Destination";
DROP JAVA CLASS SYSTEM."javax/jms/ExceptionListener";
DROP JAVA CLASS SYSTEM."javax/jms/JMSException";
DROP JAVA CLASS SYSTEM."javax/jms/JMSSecurityException";
DROP JAVA CLASS SYSTEM."javax/jms/MapMessage";
DROP JAVA CLASS SYSTEM."javax/jms/Message";
DROP JAVA CLASS SYSTEM."javax/jms/MessageConsumer";
DROP JAVA CLASS SYSTEM."javax/jms/MessageEOFException";
DROP JAVA CLASS SYSTEM."javax/jms/MessageListener";
DROP JAVA CLASS SYSTEM."javax/jms/MessageProducer";
DROP JAVA CLASS SYSTEM."javax/jms/ObjectMessage";
DROP JAVA CLASS SYSTEM."javax/jms/Queue";
DROP JAVA CLASS SYSTEM."javax/jms/QueueBrowser";
DROP JAVA CLASS SYSTEM."javax/jms/QueueConnection";
DROP JAVA CLASS SYSTEM."javax/jms/QueueReceiver";
DROP JAVA CLASS SYSTEM."javax/jms/QueueRequestor";
DROP JAVA CLASS SYSTEM."javax/jms/QueueSender";
DROP JAVA CLASS SYSTEM."javax/jms/QueueSession";
DROP JAVA CLASS SYSTEM."javax/jms/ServerSession";
DROP JAVA CLASS SYSTEM."javax/jms/ServerSessionPool";
DROP JAVA CLASS SYSTEM."javax/jms/Session";
DROP JAVA CLASS SYSTEM."javax/jms/StreamMessage";
DROP JAVA CLASS SYSTEM."javax/jms/TemporaryQueue";
DROP JAVA CLASS SYSTEM."javax/jms/TemporaryTopic";
DROP JAVA CLASS SYSTEM."javax/jms/TextMessage";
DROP JAVA CLASS SYSTEM."javax/jms/Topic";
DROP JAVA CLASS SYSTEM."javax/jms/TopicConnection";
DROP JAVA CLASS SYSTEM."javax/jms/TopicPublisher";
DROP JAVA CLASS SYSTEM."javax/jms/TopicRequestor";
DROP JAVA CLASS SYSTEM."javax/jms/TopicSession";
DROP JAVA CLASS SYSTEM."javax/jms/TopicSubscriber";
DROP JAVA CLASS SYSTEM."javax/jms/XAConnection";
DROP JAVA CLASS SYSTEM."javax/jms/XAConnectionFactory";
DROP JAVA CLASS SYSTEM."javax/jms/XAQueueConnection";
DROP JAVA CLASS SYSTEM."javax/jms/XAQueueSession";
DROP JAVA CLASS SYSTEM."javax/jms/XASession";
DROP JAVA CLASS SYSTEM."javax/jms/XATopicConnection";
DROP JAVA CLASS SYSTEM."javax/jms/XATopicSession";
DROP JAVA CLASS SYSTEM."oracle/AQ/AQAgent";
DROP JAVA CLASS SYSTEM."oracle/AQ/AQConstants";
DROP JAVA CLASS SYSTEM."oracle/AQ/AQDequeueOption";
DROP JAVA CLASS SYSTEM."oracle/AQ/AQDriver";
DROP JAVA CLASS SYSTEM."oracle/AQ/AQDriverManager";
DROP JAVA CLASS SYSTEM."oracle/AQ/AQEnqueueOption";
DROP JAVA CLASS SYSTEM."oracle/AQ/AQException";
DROP JAVA CLASS SYSTEM."oracle/AQ/AQMessage";
DROP JAVA CLASS SYSTEM."oracle/AQ/AQMessageProperty";
DROP JAVA CLASS SYSTEM."oracle/AQ/AQObjectPayload";
DROP JAVA CLASS SYSTEM."oracle/AQ/AQOracleAdmin";
DROP JAVA CLASS SYSTEM."oracle/AQ/AQOracleAgent";
DROP JAVA CLASS SYSTEM."oracle/AQ/AQOracleDebug";
DROP JAVA CLASS SYSTEM."oracle/AQ/AQOracleDriver";
DROP JAVA CLASS SYSTEM."oracle/AQ/AQOracleMessage";
DROP JAVA CLASS SYSTEM."oracle/AQ/AQOracleQueue";
DROP JAVA CLASS SYSTEM."oracle/AQ/AQOracleQueueTable";
DROP JAVA CLASS SYSTEM."oracle/AQ/AQOracleRawPayload";
DROP JAVA CLASS SYSTEM."oracle/AQ/AQOracleSQLException";
DROP JAVA CLASS SYSTEM."oracle/AQ/AQOracleSession";
DROP JAVA CLASS SYSTEM."oracle/AQ/AQOracleStructData";
DROP JAVA CLASS SYSTEM."oracle/AQ/AQQueue";
DROP JAVA CLASS SYSTEM."oracle/AQ/AQQueueAdmin";
DROP JAVA CLASS SYSTEM."oracle/AQ/AQQueueProperty";
DROP JAVA CLASS SYSTEM."oracle/AQ/AQQueueTable";
DROP JAVA CLASS SYSTEM."oracle/AQ/AQQueueTableProperty";
DROP JAVA CLASS SYSTEM."oracle/AQ/AQRawPayload";
DROP JAVA CLASS SYSTEM."oracle/AQ/AQSession";
DROP JAVA CLASS SYSTEM."oracle/AQ/AQStructData";
DROP JAVA CLASS SYSTEM."oracle/AQ/AQUtil";
DROP JAVA CLASS SYSTEM."oracle/jms/AQjmsAdtMessage";
DROP JAVA CLASS SYSTEM."oracle/jms/AQjmsAgent";
DROP JAVA CLASS SYSTEM."oracle/jms/AQjmsBytesMessage";
DROP JAVA CLASS SYSTEM."oracle/jms/AQjmsBytesMessage_C";
DROP JAVA CLASS SYSTEM."oracle/jms/AQjmsConnection";
DROP JAVA CLASS SYSTEM."oracle/jms/AQjmsConstants";
DROP JAVA CLASS SYSTEM."oracle/jms/AQjmsConsumer";
DROP JAVA CLASS SYSTEM."oracle/jms/AQjmsDeqSel";
DROP JAVA CLASS SYSTEM."oracle/jms/AQjmsDestination";
DROP JAVA CLASS SYSTEM."oracle/jms/AQjmsError";
DROP JAVA CLASS SYSTEM."oracle/jms/AQjmsException";
DROP JAVA CLASS SYSTEM."oracle/jms/AQjmsFactory";
DROP JAVA CLASS SYSTEM."oracle/jms/AQjmsMapItem";
DROP JAVA CLASS SYSTEM."oracle/jms/AQjmsMapMessage";
DROP JAVA CLASS SYSTEM."oracle/jms/AQjmsMapMessage_C";
DROP JAVA CLASS SYSTEM."oracle/jms/AQjmsMessage";
DROP JAVA CLASS SYSTEM."oracle/jms/AQjmsMessages";
DROP JAVA CLASS SYSTEM."oracle/jms/AQjmsObjectMessage";
DROP JAVA CLASS SYSTEM."oracle/jms/AQjmsOracleDebug";
DROP JAVA CLASS SYSTEM."oracle/jms/AQjmsParseException";
DROP JAVA CLASS SYSTEM."oracle/jms/AQjmsParser";
DROP JAVA CLASS SYSTEM."oracle/jms/AQjmsParser$JJCalls";
DROP JAVA CLASS SYSTEM."oracle/jms/AQjmsProducer";
DROP JAVA CLASS SYSTEM."oracle/jms/AQjmsPropDatum";
DROP JAVA CLASS SYSTEM."oracle/jms/AQjmsProperty";
DROP JAVA CLASS SYSTEM."oracle/jms/AQjmsPropertyList";
DROP JAVA CLASS SYSTEM."oracle/jms/AQjmsPropertyRef";
DROP JAVA CLASS SYSTEM."oracle/jms/AQjmsQueueBrowser";
DROP JAVA CLASS SYSTEM."oracle/jms/AQjmsQueueReceiver";
DROP JAVA CLASS SYSTEM."oracle/jms/AQjmsQueueSender";
DROP JAVA CLASS SYSTEM."oracle/jms/AQjmsSelector";
DROP JAVA CLASS SYSTEM."oracle/jms/AQjmsSession";
DROP JAVA CLASS SYSTEM."oracle/jms/AQjmsStreamMessage";
DROP JAVA CLASS SYSTEM."oracle/jms/AQjmsTextMessage";
DROP JAVA CLASS SYSTEM."oracle/jms/AQjmsTextMessage_C";
DROP JAVA CLASS SYSTEM."oracle/jms/AQjmsTopicPublisher";
DROP JAVA CLASS SYSTEM."oracle/jms/AQjmsTopicReceiver";
DROP JAVA CLASS SYSTEM."oracle/jms/AdtMessage";
DROP JAVA CLASS SYSTEM."oracle/jms/ParseException";
DROP JAVA CLASS SYSTEM."oracle/jms/Token";
DROP JAVA CLASS SYSTEM."oracle/jms/TokenMgrError";
DROP JAVA CLASS SYSTEM."oracle/jms/TopicReceiver";
[oracle@lin7 bin]$ echo '@/home/oracle/dropsys.sql'|sqlplus -S system/manager
Java dropped.
Java dropped.
Java dropped.
Java dropped.
Java dropped.
Java dropped.
Java dropped.
Java dropped.
Java dropped.
Java dropped.
Java dropped.
Java dropped.
Java dropped.
Java dropped.
Java dropped.
Java dropped.
Java dropped.
Java dropped.
Java dropped.
Java dropped.
Java dropped.
Java dropped.
Java dropped.
Java dropped.
Java dropped.
Java dropped.
Java dropped.
Java dropped.
Java dropped.
Java dropped.
Table dropped.
DROP INDEX SYSTEM."AQ$_SCHEDULES_PRIMARY"
*
ERROR at line 1:
ORA-01418: specified index does not exist
View dropped.
Library dropped.
Library dropped.
Library dropped.
Library dropped.
View dropped.
View dropped.
Sequence dropped.
Java dropped.
View dropped.
Java dropped.
Java dropped.
Java dropped.
Java dropped.
Java dropped.
Java dropped.
Java dropped.
Java dropped.
Java dropped.
Java dropped.
Java dropped.
Java dropped.
Java dropped.
Java dropped.
Java dropped.
Java dropped.
Java dropped.
Java dropped.
Java dropped.
Java dropped.
Java dropped.
Java dropped.
Java dropped.
Java dropped.
Java dropped.
Java dropped.
Java dropped.
Java dropped.
Java dropped.
Java dropped.
Java dropped.
Java dropped.
Java dropped.
Java dropped.
Java dropped.
Java dropped.
Java dropped.
Java dropped.
Java dropped.
Java dropped.
Java dropped.
Java dropped.
Java dropped.
Java dropped.
Java dropped.
Java dropped.
Java dropped.
Java dropped.
Java dropped.
Java dropped.
Java dropped.
Java dropped.
Java dropped.
Java dropped.
Java dropped.
Java dropped.
Java dropped.
Java dropped.
Java dropped.
Java dropped.
Java dropped.
Java dropped.
Java dropped.
Java dropped.
Java dropped.
Java dropped.
Java dropped.
Java dropped.
Java dropped.
Java dropped.
Java dropped.
Java dropped.
Java dropped.
Java dropped.
Java dropped.
Java dropped.
Java dropped.
Java dropped.
Java dropped.
Java dropped.
Java dropped.
Java dropped.
Java dropped.
Java dropped.
Java dropped.
Java dropped.
Java dropped.
Java dropped.
Java dropped.
Java dropped.
Java dropped.
Java dropped.
Java dropped.
Java dropped.
Java dropped.
Java dropped.
Java dropped.
Java dropped.
Java dropped.
Java dropped.
Java dropped.
Java dropped.
Java dropped.
Java dropped.
Java dropped.
Java dropped.
Java dropped.
Java dropped.
Java dropped.
Java dropped.
Java dropped.
Java dropped.
Java dropped.
Java dropped.
Java dropped.
Java dropped.
[oracle@lin7 bin]$ echo '@?/rdbms/admin/utlrp'|sqlplus -S / as sysdba
TIMESTAMP
--------------------------------------------------------------------------------
COMP_TIMESTAMP UTLRP_BGN 2025-10-07 20:45:56
PL/SQL procedure successfully completed.
TIMESTAMP
--------------------------------------------------------------------------------
COMP_TIMESTAMP UTLRP_END 2025-10-07 20:46:08
OBJECTS WITH ERRORS
-------------------
0
ERRORS DURING RECOMPILATION
---------------------------
0
Function created.
PL/SQL procedure successfully completed.
Function dropped.
PL/SQL procedure successfully completed.
[oracle@lin7 bin]$ # Case insensitive password version
[oracle@lin7 bin]$ sqlplus / as sysdba <<EOF
> alter user DCM identified by change_on_install;
> alter user REPADMIN identified by change_on_install;
> alter user IP identified by change_on_install;
> alter user CTXTEST identified by change_on_install;
> alter user CSDUMMY identified by change_on_install;
> alter user TRACESVR identified by change_on_install;
> alter user EDGE identified by change_on_install;
> alter user AD_MONITOR identified by change_on_install;
> alter user EM_MONITOR identified by change_on_install;
> exit
> EOF
SQL*Plus: Release 12.1.0.2.0 Production on Tue Oct 7 20:46:17 2025
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
SQL>
User altered.
SQL>
User altered.
SQL>
User altered.
SQL>
User altered.
SQL>
User altered.
SQL>
User altered.
SQL>
User altered.
SQL>
User altered.
SQL>
User altered.
SQL> Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
[oracle@lin7 bin]$ # remove Streams
[oracle@lin7 bin]$ echo 'exec dbms_streams_adm.remove_streams_configuration()'|sqlplus -S / as sysdba
PL/SQL procedure successfully completed.
[oracle@lin7 bin]$ sqlplus / as sysdba <<EOF
> truncate table sys.apply\$_source_obj ;
> truncate table apply\$_source_schema;
> EOF
SQL*Plus: Release 12.1.0.2.0 Production on Tue Oct 7 20:46:18 2025
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
SQL>
Table truncated.
SQL>
Table truncated.
SQL> Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
[oracle@lin7 bin]$
[oracle@lin7 bin]$ export ORACLE_HOME=/d01/oracle/VIS/19.3.0
[oracle@lin7 bin]$ export ORACLE_SID=VIS
[oracle@lin7 bin]$ export PATH=$ORACLE_HOME/bin:$ORACLE_HOME/perl/bin:$ORACLE_HOME/OPatch:$PATH
[oracle@lin7 bin]$ export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$LD_LIBRARY_PATH
[oracle@lin7 bin]$ export PERL5LIB=/d01/oracle/VIS/19.3.0/perl/lib/5.38.2:/d01/oracle/VIS/19.3.0/perl/lib/site_perl/5.38.2/:/d01/oracle/VIS/19.3.0/appsutil/perl
[oracle@lin7 bin]$ export CV_ASSUME_DISTID=OL7
[oracle@lin7 bin]$
[oracle@lin7 bin]$ lsnrctl start
LSNRCTL for Linux: Version 19.0.0.0.0 - Production on 07-OCT-2025 20:46:18
Copyright (c) 1991, 2024, Oracle. All rights reserved.
Starting /d01/oracle/VIS/19.3.0/bin/tnslsnr: please wait...
TNSLSNR for Linux: Version 19.0.0.0.0 - Production
System parameter file is /d01/oracle/VIS/12.1.0/network/admin/VIS_lin7/listener.ora
Log messages written to /d01/oracle/VIS/diag/tnslsnr/lin7/listener/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=lin7.fritz.box)(PORT=1521)))
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 19.0.0.0.0 - Production
Start Date 07-OCT-2025 20:46:18
Uptime 0 days 0 hr. 0 min. 0 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /d01/oracle/VIS/12.1.0/network/admin/VIS_lin7/listener.ora
Listener Log File /d01/oracle/VIS/diag/tnslsnr/lin7/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=lin7.fritz.box)(PORT=1521)))
The listener supports no services
The command completed successfully
[oracle@lin7 bin]$ dbua -silent -sid VIS -keepEvents -upgradeTimezone true -recompile_invalid_objects true -upgrade_parallelism 4 -emConfiguration DBEXPRESS -listeners LISTENER -performFixUp true
Logs directory: /d01/oracle/VIS/cfgtoollogs/dbua/upgrade2025-10-07_08-46-19PM
Performing Pre-Upgrade Checks...
============================
Pre-Upgrade Checks Results
=============================
/d01/oracle/VIS/cfgtoollogs/dbua/upgrade2025-10-07_08-46-19PM/VIS/upgrade.xml
/d01/oracle/VIS/cfgtoollogs/dbua/upgrade2025-10-07_08-46-19PM/VIS/preupgrade_fixups.sql
/d01/oracle/VIS/cfgtoollogs/dbua/upgrade2025-10-07_08-46-19PM/VIS/postupgrade_fixups.sql
[WARNING] [DBT-20060] One or more Oracle upgrade pre-checks resulted in warning conditions that may require further review.
ACTION: Refer to the pre-upgrade results location for details: /d01/oracle/VIS/cfgtoollogs/dbua/upgrade2025-10-07_08-46-19PM/VIS
2% complete
12% complete
25% complete
25% complete
25% complete
25% complete
26% complete
26% complete
26% complete
26% complete
27% complete
27% complete
27% complete
27% complete
28% complete
28% complete
28% complete
28% complete
29% complete
29% complete
29% complete
29% complete
30% complete
30% complete
30% complete
30% complete
31% complete
31% complete
31% complete
31% complete
32% complete
32% complete
32% complete
32% complete
33% complete
33% complete
33% complete
33% complete
34% complete
34% complete
34% complete
34% complete
35% complete
35% complete
35% complete
35% complete
36% complete
36% complete
36% complete
36% complete
37% complete
37% complete
37% complete
50% complete
62% complete
63% complete
65% complete
75% complete
76% complete
87% complete
Database upgrade has been completed successfully, and the database is ready to use.
100% complete
[oracle@lin7 bin]$ sqlplus -S / as sysdba <<EOF
> alter system set compatible='19.0.0' scope=spfile;
> alter user apps identified by apps;
> shutdown immediate
> startup
> EOF
System altered.
User altered.
Database closed.
Database dismounted.
ORACLE instance shut down.
ORACLE instance started.
Total System Global Area 2147479664 bytes
Fixed Size 8941680 bytes
Variable Size 486539264 bytes
Database Buffers 1627389952 bytes
Redo Buffers 24608768 bytes
Database mounted.
Database opened.
[oracle@lin7 bin]$ $ORACLE_HOME/OPatch/datapatch
SQL Patching tool version 19.26.0.0.0 Production on Tue Oct 7 22:40:34 2025
Copyright (c) 2012, 2025, Oracle. All rights reserved.
Log file for this invocation: /d01/oracle/VIS/cfgtoollogs/sqlpatch/sqlpatch_40358_2025_10_07_22_40_34/sqlpatch_invocation.log
Connecting to database...OK
Gathering database info...done
Bootstrapping registry and package to current versions...done
Determining current state...done
Current state of interim SQL patches:
Interim patch 37102264 (OJVM RELEASE UPDATE: 19.26.0.0.250121 (37102264)):
Binary registry: Installed
SQL registry: Applied successfully on 07-OCT-25 09.13.14.461640 PM
Current state of release update SQL patches:
Binary registry:
19.26.0.0.0 Release_Update 250118124854: Installed
SQL registry:
Applied 19.26.0.0.0 Release_Update 250118124854 successfully on 07-OCT-25 09.13.14.433911 PM
Adding patches to installation queue and performing prereq checks...done
Installation queue:
No interim patches need to be rolled back
No release update patches need to be installed
No interim patches need to be applied
SQL Patching tool complete on Tue Oct 7 22:41:08 2025
[oracle@lin7 bin]$After the database has been upgraded to Oracle 19c these steps need to be done:
# run as oracle
# Run adgrants.sql
mkdir -p /d01/oracle/VIS/19.3.0/appsutil/admin
cp /d01/oracle/VIS/fs_ne/EBSapps/patch/36989014/admin/adgrants.sql /d01/oracle/VIS/19.3.0/appsutil/admin
echo '@/d01/oracle/VIS/19.3.0/appsutil/admin/adgrants.sql apps'|sqlplus -S /nolog
# Grant create procedure privilege on CTXSYS
cp /d01/oracle/VIS/fs1/EBSapps/appl/ad/12.0.0/patch/115/sql/adctxprv.sql /d01/oracle/VIS/19.3.0/appsutil/admin
sqlplus -S apps/apps @/d01/oracle/VIS/19.3.0/appsutil/admin/adctxprv.sql manager CTXSYS
# Compile invalid objects
echo '@$ORACLE_HOME/rdbms/admin/utlrp.sql'|sqlplus -S / as sysdba
# Grant datastore access
echo 'grant text datastore access to public;'|sqlplus -S / as sysdba
# Validate Workflow ruleset
cp /d01/oracle/VIS/fs1/EBSapps/appl/fnd/12.0.0/patch/115/sql/wfaqupfix.sql /d01/oracle/VIS/19.3.0/appsutil/admin
sqlplus apps/apps @/d01/oracle/VIS/19.3.0/appsutil/admin/wfaqupfix.sql applsys apps
# Gather statistics for SYS schema
cp /d01/oracle/VIS/fs1/EBSapps/appl/admin/adstats.sql /d01/oracle/VIS/19.3.0/appsutil/admin
sqlplus -S / as sysdba <<EOF
alter system enable restricted session;
@/d01/oracle/VIS/19.3.0/appsutil/admin/adstats.sql
EOF
sqlplus -S / as sysdba <<EOF
alter system disable restricted session;
EOF
Sample Output (click to expand):
[oracle@lin7 bin]$ # run as oracle
# Run adgrants.sql
[oracle@lin7 bin]$ # Run adgrants.sql
[oracle@lin7 bin]$ mkdir -p /d01/oracle/VIS/19.3.0/appsutil/admin
echo '@/d01/oracle/VIS/19.3.0/appsutil/admin/adgrants.sql apps'|sqlplus -S /nolog
# Grant create procedure privilege on CTXSYS
cp /d01/oracle/VIS/fs1/EBSapps/appl/ad/12.0.0/patch/115/sql/adctxprv.sql /d01/oracle/VIS/19.3.0/appsutil/admin
sqlplus -S apps/apps @/d01/oracle/VIS/19.3.0/appsutil/admin/adctxprv.sql manager CTXSYS
# Compile invalid objects
echo '@$ORACLE_HOME/rdbms/admin/utlrp.sql'|sqlplus -S / as sysdba
# Grant datastore access
echo 'grant text datastore access to public;'|sqlplus -S / as sysdba
# Validate Workflow ruleset
cp /d01/oracle/VIS/fs1/EBSapps/appl/fnd/12.0.0/patch/115/sql/wfaqupfix.sql /d01/oracle/VIS/19.3.0/appsutil/admin
sqlplus apps/apps @/d01/oracle/VIS/19.3.0/appsutil/admin/wfaqupfix.sql applsys apps
# Gather statistics for SYS schema
cp /d01/oracle/VIS/fs1/EBSapps/appl/admin/adstats.sql /d01/oracle/VIS/19.3.0/appsutil/admin
sqlplus -S / as sysdba <<EOF
alter system enable restricted session;
@/d01/oracle/VIS/19.3.0/appsutil/admin/adstats.sql
EOF
sqlplus -S / as sysdba <<EOF
alter system disable restricted session;
EOF
[oracle@lin7 bin]$ cp /d01/oracle/VIS/fs_ne/EBSapps/patch/36989014/admin/adgrants.sql /d01/oracle/VIS/19.3.0/appsutil/admin
[oracle@lin7 bin]$ echo '@/d01/oracle/VIS/19.3.0/appsutil/admin/adgrants.sql apps'|sqlplus -S /nolog
Current user is SYS
---------------------------------------------------
--- adgrants.sql started at 2025-10-08 06:25:38 ---
_disable_actualization_for_grant Parameter
------------------------------------------------------------------------
WARNING - _disable_actualization_for_grant parameter must be set to
TRUE
---------------------------------------------------
Removing logs from prior runs of adgrants.sql
-
Start granting from SYS to EBS_SYSTEM
-
End granting from SYS to EBS_SYSTEM
Completed granting and checking privileges
Generating list of ERRORS and WARNINGS to print out
CURRENT_USER
--------------------------------------------------------------------------------------------------------------------------------
SYS user ERRORS and WARNINGS will report at end of script
Creating PL/SQL profiler objects.
---------------------------------------------------
--- profload.sql started at 2025-10-08 06:25:39 ---
In 12.2c and beyond, the Oracle-supplied profload.sql script is a verification script, not an installation script.
Testing for correct installation
SYS.DBMS_PROFILER successfully loaded.
-----------------------------------------------------
--- profload.sql completed at 2025-10-08 06:25:40 ---
--------------------------------------------------
--- proftab.sql started at 2025-10-08 06:25:40 ---
-----------------------------------------------------
--- profltab.sql completed at 2025-10-08 06:25:40 ---
Installing Hierarchical Profiler.
-
Loading Stylesheets if missing
Begin creating the APPS_NE.ADGRANTS_VER_PKG package
End creating the APPS_NE.ADGRANTS_VER_PKG package
Executing PURGE DBA_RECYCLEBIN.
The following ERRORS and WARNINGS have been encountered during this adgrants session:
Grants given by this script have been written to the ad_zd_logs table.
You can run $AD_TOP/sql/ADZDSHOWLOG.sql to produce a report showing these grants.
[oracle@lin7 bin]$ # Grant create procedure privilege on CTXSYS
[oracle@lin7 bin]$ cp /d01/oracle/VIS/fs1/EBSapps/appl/ad/12.0.0/patch/115/sql/adctxprv.sql /d01/oracle/VIS/19.3.0/appsutil/admin
[oracle@lin7 bin]$ sqlplus -S apps/apps @/d01/oracle/VIS/19.3.0/appsutil/admin/adctxprv.sql manager CTXSYS
Commit complete.
[oracle@lin7 bin]$ # Compile invalid objects
[oracle@lin7 bin]$ echo '@$ORACLE_HOME/rdbms/admin/utlrp.sql'|sqlplus -S / as sysdba
Session altered.
TIMESTAMP
--------------------------------------------------------------------------------
COMP_TIMESTAMP UTLRP_BGN 2025-10-08 06:25:42
PL/SQL procedure successfully completed.
TIMESTAMP
--------------------------------------------------------------------------------
COMP_TIMESTAMP UTLRP_END 2025-10-08 06:25:54
OBJECTS WITH ERRORS
-------------------
237
ERRORS DURING RECOMPILATION
---------------------------
0
Function created.
PL/SQL procedure successfully completed.
Function dropped.
PL/SQL procedure successfully completed.
[oracle@lin7 bin]$ # Grant datastore access
[oracle@lin7 bin]$ echo 'grant text datastore access to public;'|sqlplus -S / as sysdba
Grant succeeded.
[oracle@lin7 bin]$ # Validate Workflow ruleset
[oracle@lin7 bin]$ cp /d01/oracle/VIS/fs1/EBSapps/appl/fnd/12.0.0/patch/115/sql/wfaqupfix.sql /d01/oracle/VIS/19.3.0/appsutil/admin
[oracle@lin7 bin]$ sqlplus apps/apps @/d01/oracle/VIS/19.3.0/appsutil/admin/wfaqupfix.sql applsys apps
SQL*Plus: Release 19.0.0.0.0 - Production on Wed Oct 8 06:26:37 2025
Version 19.26.0.0.0
Copyright (c) 1982, 2024, Oracle. All rights reserved.
Last Successful login time: Wed Oct 08 2025 06:25:41 +02:00
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.26.0.0.0
PL/SQL procedure successfully completed.
Commit complete.
Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.26.0.0.0
[oracle@lin7 bin]$ # Gather statistics for SYS schema
[oracle@lin7 bin]$ cp /d01/oracle/VIS/fs1/EBSapps/appl/admin/adstats.sql /d01/oracle/VIS/19.3.0/appsutil/admin
[oracle@lin7 bin]$ sqlplus -S / as sysdba <<EOF
> alter system enable restricted session;
> @/d01/oracle/VIS/19.3.0/appsutil/admin/adstats.sql
> EOF
System altered.
--------------------------------------------------
--- adstats.sql started at 2025-10-08 06:30:47 ---
Checking for the DB version and collecting statistics ...
PL/SQL procedure successfully completed.
------------------------------------------------
--- adstats.sql ended at 2025-10-08 06:34:14 ---
Commit complete.
[oracle@lin7 bin]$ sqlplus -S / as sysdba <<EOF
> alter system disable restricted session;
> EOF
System altered.
[oracle@lin7 bin]$In the next step we will convert the database to a pluggable database (VIS) in the container database VISCDB:
# run as oracle
hn=`hostname|awk -F. {'print $1'}`
# Create the PDB descriptor
sed -i s/'^alias tal.*'/"alias tal\='tail -200f \/d01\/oracle\/VIS\/19.3.0\/VISCDB\/diag\/rdbms\/viscdb\/VISCDB\/trace\/alert_VISCDB.log'"/ ~/.bash_profile
cd $ORACLE_HOME/appsutil
. ./txkSetCfgCDB.env dboraclehome=/d01/oracle/VIS/19.3.0
export ORACLE_SID=VIS
cd $ORACLE_HOME/appsutil/bin
echo apps|perl txkOnPremPrePDBCreationTasks.pl -dboraclehome=/d01/oracle/VIS/19.3.0 \
-outdir=/d01/oracle/VIS/19.3.0/appsutil/log -appsuser=apps -dbsid=VIS
# Update the CDB initialization parameters
cp /d01/oracle/VIS/12.1.0/dbs/VIS_initparam.sql /d01/oracle/VIS/19.3.0/dbs
cp /d01/oracle/VIS/12.1.0/dbs/VIS_datatop.txt /d01/oracle/VIS/19.3.0/dbs
cd $ORACLE_HOME/appsutil
. ./txkSetCfgCDB.env dboraclehome=/d01/oracle/VIS/19.3.0
export ORACLE_SID=VISCDB
sqlplus -S / as sysdba <<EOF
startup nomount;
@?/dbs/VIS_initparam.sql
alter system set LOCAL_LISTENER="$hn.fritz.box:1521" scope=both;
alter system set processes=300 scope=spfile;
alter system set sessions=600 scope=spfile;
shutdown;
startup;
EOF
# Check for PDB violations
cd $ORACLE_HOME/appsutil
. ./txkSetCfgCDB.env dboraclehome=/d01/oracle/VIS/19.3.0
export ORACLE_SID=VISCDB
cd $ORACLE_HOME/appsutil/bin
perl txkChkPDBCompatability.pl -dboraclehome=/d01/oracle/VIS/19.3.0 \
-outdir=/d01/oracle/VIS/19.3.0/appsutil/log -cdbsid=VISCDB \
-pdbsid=VIS -servicetype=onpremise
# Create the PDB
cd $ORACLE_HOME/appsutil
. ./txkSetCfgCDB.env dboraclehome=/d01/oracle/VIS/19.3.0
cd $ORACLE_HOME/appsutil/bin
(/d01/oracle/VIS/data; echo /d01/oracle/VIS/data)|perl txkCreatePDB.pl -dboraclehome=/d01/oracle/VIS/19.3.0 -outdir=/d01/oracle/VIS/19.3.0/appsutil/log \
-cdbsid=VISCDB -pdbsid=VIS -dbuniquename=VIS.fritz.box -servicetype=onpremise
# Run the post PDB script
exit
su - oracle
hn=`hostname|awk -F. {'print $1'}`
cd /d01/oracle/VIS/19.3.0/appsutil
. ./txkSetCfgCDB.env dboraclehome=/d01/oracle/VIS/19.3.0
(echo apps; echo manager)|perl $ORACLE_HOME/appsutil/bin/txkPostPDBCreationTasks.pl -dboraclehome=/d01/oracle/VIS/19.3.0 \
-outdir=/d01/oracle/VIS/19.3.0/appsutil/log -cdbsid=VISCDB -pdbsid=VIS \
-appsuser=apps -dbport=1521 -servicetype=onpremise
# Modify initialization parameters
export ORACLE_SID=VISCDB
sqlplus -S / as sysdba <<EOF
alter system reset core_dump_dest;
alter system reset "_pdb_name_case_sensitive";
alter system set event="10946 trace name context forever, level 8454144" scope=spfile;
alter system set optimizer_secure_view_merging=false;
alter system set shared_pool_size=600m scope=spfile;
alter system set shared_pool_reserved_size=60m scope=spfile;
alter system set filesystemio_options = 'SETALL' scope=spfile;
alter system set sec_case_sensitive_logon = false;
alter session set container=VIS;
alter system set temp_undo_enabled=false;
alter session set container=cdb\$root;
shutdown immediate
startup
EOF
# Run AutoConfig on applications tier
cat >>/d01/oracle/VIS/fs1/inst/apps/VIS_$hn/ora/10.1.2/network/admin/tnsnames.ora <<EOF
viscdb_$hn.fritz.box=
(DESCRIPTION=
(ADDRESS=(PROTOCOL=tcp)(HOST=$hn.fritz.box)(PORT=1521))
(CONNECT_DATA=(SERVICE_NAME=ebs_VIS)(INSTANCE_NAME=VISCDB)
)
)
EOF
sed -i s/'<jdbc_url oa_var=\"s_apps_jdbc_connect_descriptor.*'/' <jdbc_url oa_var=\"s_apps_jdbc_connect_descriptor\"><\/jdbc_url>'/ /d01/oracle/VIS/fs1/inst/apps/VIS_$hn/appl/admin/VIS_$hn.xml
sed -i s/'<APPLPTMP oa_var=\"s_applptmp\".*'/' <APPLPTMP oa_var=\"s_applptmp\" osd=\"UNIX\">\/d01\/oracle\/VIS\/temp\/VIS<\/APPLPTMP>'/ /d01/oracle/VIS/fs1/inst/apps/VIS_$hn/appl/admin/VIS_$hn.xml
. /d01/oracle/VIS/EBSapps.env run
echo apps|$INST_TOP/admin/scripts/adautocfg.sh
exit
su - oracle
hn=`hostname|awk -F. {'print $1'}`
. /d01/oracle/VIS/EBSapps.env run
# Restart applications tier server processes
(echo apps; echo apps; echo welcome1)|/d01/oracle/VIS/fs1/inst/apps/VIS_$hn/admin/scripts/adstrtal.sh
Sample Output (click to expand):
[oracle@lin7 bin]$ # run as oracle
hn=`hostname|awk -F. {'print $1'}`
# Create the PDB descriptor
sed -i s/'^alias tal.*'/"alias tal\='tail -200f \/d01\/oracle\/VIS\/19.3.0\/VISCDB\/diag\/rdbms\/viscdb\/VISCDB\/trace\/alert_VISCDB.log'"/ ~/.bash_profile
cd $ORACLE_HOME/appsutil
[oracle@lin7 bin]$ hn=`hostname|awk -F. {'print $1'}`
export ORACLE_SID=VIS
cd $ORACLE_HOME/appsutil/bin
echo apps|perl txkOnPremPrePDBCreationTasks.pl -dboraclehome=/d01/oracle/VIS/19.3.0 \
-outdir=/d01/oracle/VIS/19.3.0/appsutil/log -appsuser=apps -dbsid=VIS
# Update the CDB initialization parameters
cp /d01/oracle/VIS/12.1.0/dbs/VIS_initparam.sql /d01/oracle/VIS/19.3.0/dbs
cp /d01/oracle/VIS/12.1.0/dbs/VIS_datatop.txt /d01/oracle/VIS/19.3.0/dbs
cd $ORACLE_HOME/appsutil
. ./txkSetCfgCDB.env dboraclehome=/d01/oracle/VIS/19.3.0
export ORACLE_SID=VISCDB
sqlplus -S / as sysdba <<EOF
startup nomount;
@?/dbs/VIS_initparam.sql
alter system set LOCAL_LISTENER="$hn.fritz.box:1521" scope=both;
alter system set processes=300 scope=spfile;
alter system set sessions=600 scope=spfile;
shutdown;
startup;
EOF
# Check for PDB violations
cd $ORACLE_HOME/appsutil
. ./txkSetCfgCDB.env dboraclehome=/d01/oracle/VIS/19.3.0
export ORACLE_SID=VISCDB
cd $ORACLE_HOME/appsutil/bin
perl txkChkPDBCompatability.pl -dboraclehome=/d01/oracle/VIS/19.3.0 \
-outdir=/d01/oracle/VIS/19.3.0/appsutil/log -cdbsid=VISCDB \
-pdbsid=VIS -servicetype=onpremise
# Create the PDB
cd $ORACLE_HOME/appsutil
. ./txkSetCfgCDB.env dboraclehome=/d01/oracle/VIS/19.3.0
cd $ORACLE_HOME/appsutil/bin
(/d01/oracle/VIS/data; echo /d01/oracle/VIS/data)|perl txkCreatePDB.pl -dboraclehome=/d01/oracle/VIS/19.3.0 -outdir=/d01/oracle/VIS/19.3.0/appsutil/log \
-cdbsid=VISCDB -pdbsid=VIS -dbuniquename=VIS.fritz.box -servicetype=onpremise
# Run the post PDB script
exit
su - oracle
hn=`hostname|awk -F. {'print $1'}`
cd /d01/oracle/VIS/19.3.0/appsutil
. ./txkSetCfgCDB.env dboraclehome=/d01/oracle/VIS/19.3.0
(echo apps; echo manager)|perl $ORACLE_HOME/appsutil/bin/txkPostPDBCreationTasks.pl -dboraclehome=/d01/oracle/VIS/19.3.0 \
-outdir=/d01/oracle/VIS/19.3.0/appsutil/log -cdbsid=VISCDB -pdbsid=VIS \
-appsuser=apps -dbport=1521 -servicetype=onpremise
# Modify initialization parameters
export ORACLE_SID=VISCDB
sqlplus -S / as sysdba <<EOF
alter system reset core_dump_dest;
alter system reset "_pdb_name_case_sensitive";
alter system set event="10946 trace name context forever, level 8454144" scope=spfile;
alter system set optimizer_secure_view_merging=false;
alter system set shared_pool_size=600m scope=spfile;
alter system set shared_pool_reserved_size=60m scope=spfile;
alter system set filesystemio_options = 'SETALL' scope=spfile;
alter system set sec_case_sensitive_logon = false;
alter session set container=VIS;
alter system set temp_undo_enabled=false;
alter session set container=cdb\$root;
shutdown immediate
startup
EOF
# Run AutoConfig on applications tier
cat >>/d01/oracle/VIS/fs1/inst/apps/VIS_$hn/ora/10.1.2/network/admin/tnsnames.ora <<EOF
viscdb_$hn.fritz.box=
(DESCRIPTION=
(ADDRESS=(PROTOCOL=tcp)(HOST=$hn.fritz.box)(PORT=1521))
(CONNECT_DATA=(SERVICE_NAME=ebs_VIS)(INSTANCE_NAME=VISCDB)
)
)
EOF
sed -i s/'<jdbc_url oa_var=\"s_apps_jdbc_connect_descriptor.*'/' <jdbc_url oa_var=\"s_apps_jdbc_connect_descriptor\"><\/jdbc_url>'/ /d01/oracle/VIS/fs1/inst/apps/VIS_$hn/appl/admin/VIS_$hn.xml
sed -i s/'<APPLPTMP oa_var=\"s_applptmp\".*'/' <APPLPTMP oa_var=\"s_applptmp\" osd=\"UNIX\">\/d01\/oracle\/VIS\/temp\/VIS<\/APPLPTMP>'/ /d01/oracle/VIS/fs1/inst/apps/VIS_$hn/appl/admin/VIS_$hn.xml
. /d01/oracle/VIS/EBSapps.env run
echo apps|$INST_TOP/admin/scripts/adautocfg.sh
exit
su - oracle
hn=`hostname|awk -F. {'print $1'}`
. /d01/oracle/VIS/EBSapps.env run
[oracle@lin7 bin]$ # Create the PDB descriptor
[oracle@lin7 bin]$ sed -i s/'^alias tal.*'/"alias tal\='tail -200f \/d01\/oracle\/VIS\/19.3.0\/VISCDB\/diag\/rdbms\/viscdb\/VISCDB\/trace\/alert_VISCDB.log'"/ ~/.bash_profile
[oracle@lin7 bin]$ cd $ORACLE_HOME/appsutil
[oracle@lin7 appsutil]$ . ./txkSetCfgCDB.env dboraclehome=/d01/oracle/VIS/19.3.0
# Restart applications tier server processes
(echo apps; echo apps; echo welcome1)|/d01/oracle/VIS/fs1/inst/apps/VIS_$hn/admin/scripts/adstrtal.sh
Oracle Home being passed: /d01/oracle/VIS/19.3.0
[oracle@lin7 appsutil]$ export ORACLE_SID=VIS
[oracle@lin7 appsutil]$ cd $ORACLE_HOME/appsutil/bin
[oracle@lin7 bin]$ echo apps|perl txkOnPremPrePDBCreationTasks.pl -dboraclehome=/d01/oracle/VIS/19.3.0 \
> -outdir=/d01/oracle/VIS/19.3.0/appsutil/log -appsuser=apps -dbsid=VIS
stty: 'standard input': Inappropriate ioctl for device
Enter the APPS Password:
stty: 'standard input': Inappropriate ioctl for device
Script Name : txkOnPremPrePDBCreationTasks.pl
Script Version : 120.0.12020000.17
Started : Fri Oct 10 10:41:42 CEST 2025
Log File : /d01/oracle/VIS/19.3.0/appsutil/log/TXK_PRE_PDB_Fri_Oct_10_10_41_42_2025/txkOnPremPrePDBCreationTasks.log
-----------
Values used
-----------
DB Oracle Home : /d01/oracle/VIS/19.3.0
OUT Directory : /d01/oracle/VIS/19.3.0/appsutil/log
Skip DB shutdown : No
EBS SID : VIS
APPS Schema Username : apps
Is RAC? : No
Logical Hostname :
=========================
Validating oracle home...
=========================
Oracle Home: /d01/oracle/VIS/19.3.0 exists.
===========================
Validating out directory...
===========================
Out directory: /d01/oracle/VIS/19.3.0/appsutil/log exists.
============================
Inside getDBHostDetails()...
============================
DB Hostname : lin7
DB Domain : fritz.box
Logical hostname is not passed, hence using physical hostname details.
Logical hostname: lin7.fritz.box
==========================
Inside setContextName()...
==========================
CONTEXT_NAME: VIS_lin7
============================
Inside setFileLocations()...
============================
=====================
Inside getDBName()...
=====================
Generating SQL file : /d01/oracle/VIS/19.3.0/appsutil/log/TXK_PRE_PDB_Fri_Oct_10_10_41_42_2025/get_db_name.sql
SQL output file : /d01/oracle/VIS/19.3.0/appsutil/log/TXK_PRE_PDB_Fri_Oct_10_10_41_42_2025/get_db_name.out
Spool File : /d01/oracle/VIS/19.3.0/appsutil/log/TXK_PRE_PDB_Fri_Oct_10_10_41_42_2025/spool_get_db_name.log
==========================
Inside executeSQLFile()...
==========================
Executing the SQL...
Execute SYSTEM command : sqlplus -s /nolog @/d01/oracle/VIS/19.3.0/appsutil/log/TXK_PRE_PDB_Fri_Oct_10_10_41_42_2025/get_db_name.sql
==============================
Inside searchFileContents()...
==============================
log_file: /d01/oracle/VIS/19.3.0/appsutil/log/TXK_PRE_PDB_Fri_Oct_10_10_41_42_2025/get_db_name.out
pattern: ERROR
=============================
Could not find the pattern...
=============================
Removing the file: /d01/oracle/VIS/19.3.0/appsutil/log/TXK_PRE_PDB_Fri_Oct_10_10_41_42_2025/get_db_name.sql
EXIT STATUS: 0
Getting the value of DB Name...
db_name: VIS
PDB_DESC_XML: /d01/oracle/VIS/19.3.0/dbs/VIS_PDBDesc.xml
INITPARAM_FILE: /d01/oracle/VIS/19.3.0/dbs/VIS_initparam.sql
DATATOP_FILE: /d01/oracle/VIS/19.3.0/dbs/VIS_datatop.txt
========================
Inside getDBVersion()...
========================
DB_VERSION = db190
=============================
Shutting down the database...
=============================
Shutdown mode : IMMEDIATE
Generating SQL file : /d01/oracle/VIS/19.3.0/appsutil/log/TXK_PRE_PDB_Fri_Oct_10_10_41_42_2025/shutdown_IMMEDIATE.sql
SQL output file : /d01/oracle/VIS/19.3.0/appsutil/log/TXK_PRE_PDB_Fri_Oct_10_10_41_42_2025/shutdown_IMMEDIATE.out
==========================
Inside executeSQLFile()...
==========================
Executing the SQL...
Execute SYSTEM command : sqlplus -s /nolog @/d01/oracle/VIS/19.3.0/appsutil/log/TXK_PRE_PDB_Fri_Oct_10_10_41_42_2025/shutdown_IMMEDIATE.sql
==============================
Inside searchFileContents()...
==============================
log_file: /d01/oracle/VIS/19.3.0/appsutil/log/TXK_PRE_PDB_Fri_Oct_10_10_41_42_2025/shutdown_IMMEDIATE.out
pattern: ERROR
=============================
Could not find the pattern...
=============================
EXIT STATUS: 0
SQL execution went through successfully.
LOG FILE: /d01/oracle/VIS/19.3.0/appsutil/log/TXK_PRE_PDB_Fri_Oct_10_10_41_42_2025/shutdown_IMMEDIATE.out.
========================
Starting the database...
========================
Startup mode : MOUNT
Generating SQL file : /d01/oracle/VIS/19.3.0/appsutil/log/TXK_PRE_PDB_Fri_Oct_10_10_41_42_2025/startup_MOUNT.sql
SQL output file : /d01/oracle/VIS/19.3.0/appsutil/log/TXK_PRE_PDB_Fri_Oct_10_10_41_42_2025/startup_MOUNT.out
==========================
Inside executeSQLFile()...
==========================
Executing the SQL...
Execute SYSTEM command : sqlplus -s /nolog @/d01/oracle/VIS/19.3.0/appsutil/log/TXK_PRE_PDB_Fri_Oct_10_10_41_42_2025/startup_MOUNT.sql
==============================
Inside searchFileContents()...
==============================
log_file: /d01/oracle/VIS/19.3.0/appsutil/log/TXK_PRE_PDB_Fri_Oct_10_10_41_42_2025/startup_MOUNT.out
pattern: ERROR
=============================
Could not find the pattern...
=============================
EXIT STATUS: 0
SQL execution went through successfully.
LOG FILE: /d01/oracle/VIS/19.3.0/appsutil/log/TXK_PRE_PDB_Fri_Oct_10_10_41_42_2025/startup_MOUNT.out.
==================================
Inside createPDBDescriptorXML()...
==================================
==================================
Inside backupPDBDescriptorXML()...
==================================
File /d01/oracle/VIS/19.3.0/dbs/VIS_PDBDesc.xml does not exist.
File /d01/oracle/VIS/19.3.0/dbs/VIS_PDBDesc.xml does not exist.
Generating SQL file : /d01/oracle/VIS/19.3.0/appsutil/log/TXK_PRE_PDB_Fri_Oct_10_10_41_42_2025/create_pdb_desc_xml.sql
SQL output file : /d01/oracle/VIS/19.3.0/appsutil/log/TXK_PRE_PDB_Fri_Oct_10_10_41_42_2025/create_pdb_desc_xml.out
==========================
Inside executeSQLFile()...
==========================
Executing the SQL...
Execute SYSTEM command : sqlplus -s /nolog @/d01/oracle/VIS/19.3.0/appsutil/log/TXK_PRE_PDB_Fri_Oct_10_10_41_42_2025/create_pdb_desc_xml.sql
==============================
Inside searchFileContents()...
==============================
log_file: /d01/oracle/VIS/19.3.0/appsutil/log/TXK_PRE_PDB_Fri_Oct_10_10_41_42_2025/create_pdb_desc_xml.out
pattern: ERROR
=============================
Could not find the pattern...
=============================
EXIT STATUS: 0
PDB Descriptor XML /d01/oracle/VIS/19.3.0/dbs/VIS_PDBDesc.xml created successfully.
LOG FILE: /d01/oracle/VIS/19.3.0/appsutil/log/TXK_PRE_PDB_Fri_Oct_10_10_41_42_2025/create_pdb_desc_xml.out.
=============================
Shutting down the database...
=============================
Shutdown mode : IMMEDIATE
Generating SQL file : /d01/oracle/VIS/19.3.0/appsutil/log/TXK_PRE_PDB_Fri_Oct_10_10_41_42_2025/shutdown_IMMEDIATE.sql
SQL output file : /d01/oracle/VIS/19.3.0/appsutil/log/TXK_PRE_PDB_Fri_Oct_10_10_41_42_2025/shutdown_IMMEDIATE.out
==========================
Inside executeSQLFile()...
==========================
Executing the SQL...
Execute SYSTEM command : sqlplus -s /nolog @/d01/oracle/VIS/19.3.0/appsutil/log/TXK_PRE_PDB_Fri_Oct_10_10_41_42_2025/shutdown_IMMEDIATE.sql
==============================
Inside searchFileContents()...
==============================
log_file: /d01/oracle/VIS/19.3.0/appsutil/log/TXK_PRE_PDB_Fri_Oct_10_10_41_42_2025/shutdown_IMMEDIATE.out
pattern: ERROR
=============================
Could not find the pattern...
=============================
EXIT STATUS: 0
SQL execution went through successfully.
LOG FILE: /d01/oracle/VIS/19.3.0/appsutil/log/TXK_PRE_PDB_Fri_Oct_10_10_41_42_2025/shutdown_IMMEDIATE.out.
****************************************************************************************
* *
* IMPORTANT NOTE: DO NOT START THE DB TILL THE DATA FILES ARE MIGRATED *
* *
* IF DB IS STARTED, THEN PDB DESCRIPTOR XML GENERATED BECOMES INVALID *
* *
****************************************************************************************
Exiting from the script.
Ended: Fri Oct 10 10:42:38 CEST 2025
[oracle@lin7 bin]$ # Update the CDB initialization parameters
[oracle@lin7 bin]$ cp /d01/oracle/VIS/12.1.0/dbs/VIS_initparam.sql /d01/oracle/VIS/19.3.0/dbs
[oracle@lin7 bin]$ cp /d01/oracle/VIS/12.1.0/dbs/VIS_datatop.txt /d01/oracle/VIS/19.3.0/dbs
[oracle@lin7 bin]$ cd $ORACLE_HOME/appsutil
[oracle@lin7 appsutil]$ . ./txkSetCfgCDB.env dboraclehome=/d01/oracle/VIS/19.3.0
Oracle Home being passed: /d01/oracle/VIS/19.3.0
[oracle@lin7 appsutil]$ export ORACLE_SID=VISCDB
[oracle@lin7 appsutil]$ sqlplus -S / as sysdba <<EOF
> startup nomount;
> @?/dbs/VIS_initparam.sql
> alter system set LOCAL_LISTENER="$hn.fritz.box:1521" scope=both;
> alter system set processes=300 scope=spfile;
> alter system set sessions=600 scope=spfile;
> shutdown;
> startup;
> EOF
ORACLE instance started.
Total System Global Area 2147481032 bytes
Fixed Size 9180616 bytes
Variable Size 587202560 bytes
Database Buffers 1543503872 bytes
Redo Buffers 7593984 bytes
System altered.
System altered.
System altered.
System altered.
System altered.
System altered.
System altered.
System altered.
System altered.
System altered.
System altered.
System altered.
System altered.
System altered.
System altered.
System altered.
System altered.
System altered.
System altered.
System altered.
System altered.
System altered.
System altered.
System altered.
System altered.
System altered.
System altered.
System altered.
System altered.
System altered.
System altered.
System altered.
System altered.
System altered.
System altered.
System altered.
System altered.
System altered.
System altered.
System altered.
System altered.
System altered.
System altered.
System altered.
System altered.
System altered.
System altered.
System altered.
System altered.
System altered.
System altered.
System altered.
System altered.
System altered.
ORA-01507: database not mounted
ORACLE instance shut down.
ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance
ORACLE instance started.
Total System Global Area 2147480352 bytes
Fixed Size 9179936 bytes
Variable Size 452984832 bytes
Database Buffers 1660944384 bytes
Redo Buffers 24371200 bytes
Database mounted.
Database opened.
[oracle@lin7 appsutil]$ # Check for PDB violations
[oracle@lin7 appsutil]$ cd $ORACLE_HOME/appsutil
[oracle@lin7 appsutil]$ . ./txkSetCfgCDB.env dboraclehome=/d01/oracle/VIS/19.3.0
Oracle Home being passed: /d01/oracle/VIS/19.3.0
[oracle@lin7 appsutil]$ export ORACLE_SID=VISCDB
[oracle@lin7 appsutil]$ cd $ORACLE_HOME/appsutil/bin
[oracle@lin7 bin]$ perl txkChkPDBCompatability.pl -dboraclehome=/d01/oracle/VIS/19.3.0 \
> -outdir=/d01/oracle/VIS/19.3.0/appsutil/log -cdbsid=VISCDB \
> -pdbsid=VIS -servicetype=onpremise
Script Name : txkChkPDBCompatability.pl
Script Version : 120.0.12020000.11
Started : Fri Oct 10 10:43:18 CEST 2025
Log File : /d01/oracle/VIS/19.3.0/appsutil/log/TXK_CHK_PDB_COMPTABILITY_Fri_Oct_10_10_43_18_2025/txkChkPDBCompatability.log
-----------
Values used
-----------
Database Oracle Home : /d01/oracle/VIS/19.3.0
CDB SID : VISCDB
PDB SID : VIS
OUT Directory : /d01/oracle/VIS/19.3.0/appsutil/log
Service Type : onpremise
=========================
Validating oracle home...
=========================
Oracle Home: /d01/oracle/VIS/19.3.0 exists.
===========================
Validating out directory...
===========================
Oracle Home: /d01/oracle/VIS/19.3.0/appsutil/log exists.
=============================
Validating DB service type...
=============================
Service Type: onpremise
Service type is valid.
============================
Inside setFileLocations()...
============================
PDB_DESC_XML: /d01/oracle/VIS/19.3.0/dbs/VIS_PDBDesc.xml
**** Setting ORACLE_SID to VISCDB
========================
Inside getDBVersion()...
========================
DB_VERSION = db190
=================================
Inside checkPDBCompatibility()...
=================================
File /d01/oracle/VIS/19.3.0/dbs/VIS_PDBDesc.xml exists.
Generating SQL file : /d01/oracle/VIS/19.3.0/appsutil/log/TXK_CHK_PDB_COMPTABILITY_Fri_Oct_10_10_43_18_2025/create_pdb_compatible.sql
SQL output file : /d01/oracle/VIS/19.3.0/appsutil/log/TXK_CHK_PDB_COMPTABILITY_Fri_Oct_10_10_43_18_2025/create_pdb_compatible.out
==========================
Inside executeSQLFile()...
==========================
Executing the SQL...
Execute SYSTEM command : sqlplus -s /nolog @/d01/oracle/VIS/19.3.0/appsutil/log/TXK_CHK_PDB_COMPTABILITY_Fri_Oct_10_10_43_18_2025/create_pdb_compatible.sql
==============================
Inside searchFileContents()...
==============================
log_file: /d01/oracle/VIS/19.3.0/appsutil/log/TXK_CHK_PDB_COMPTABILITY_Fri_Oct_10_10_43_18_2025/create_pdb_compatible.out
pattern: ERROR
=============================
Could not find the pattern...
=============================
EXIT STATUS: 0
PDB compatability check executed successfully.
LOG FILE: /d01/oracle/VIS/19.3.0/appsutil/log/TXK_CHK_PDB_COMPTABILITY_Fri_Oct_10_10_43_18_2025/create_pdb_compatible.out.
====================================
Inside checkPDBPluginViolations()...
====================================
File /d01/oracle/VIS/19.3.0/dbs/VIS_PDBDesc.xml exists.
Generating SQL file : /d01/oracle/VIS/19.3.0/appsutil/log/TXK_CHK_PDB_COMPTABILITY_Fri_Oct_10_10_43_18_2025/check_pdb_plugin_violations.sql
SQL output file : /d01/oracle/VIS/19.3.0/appsutil/log/TXK_CHK_PDB_COMPTABILITY_Fri_Oct_10_10_43_18_2025/check_pdb_plugin_violations.out
==========================
Inside executeSQLFile()...
==========================
Executing the SQL...
Execute SYSTEM command : sqlplus -s /nolog @/d01/oracle/VIS/19.3.0/appsutil/log/TXK_CHK_PDB_COMPTABILITY_Fri_Oct_10_10_43_18_2025/check_pdb_plugin_violations.sql
==============================
Inside searchFileContents()...
==============================
log_file: /d01/oracle/VIS/19.3.0/appsutil/log/TXK_CHK_PDB_COMPTABILITY_Fri_Oct_10_10_43_18_2025/check_pdb_plugin_violations.out
pattern: ERROR
================
Pattern found...
================
EXIT STATUS: 1
Violations reported for the database 'VIS' to be plugged in. Cannot proceed further.
****************************************************************************************
CHECK THE BELOW LOG FILE FOR VIOLATIONS:
/d01/oracle/VIS/19.3.0/appsutil/log/TXK_CHK_PDB_COMPTABILITY_Fri_Oct_10_10_43_18_2025/check_pdb_plugin_violations.out
****************************************************************************************
===================================
Inside checkUNDOMgmtViolations()...
===================================
File /d01/oracle/VIS/19.3.0/dbs/VIS_PDBDesc.xml exists.
Generating SQL file : /d01/oracle/VIS/19.3.0/appsutil/log/TXK_CHK_PDB_COMPTABILITY_Fri_Oct_10_10_43_18_2025/check_undo_mgmt.sql
SQL output file : /d01/oracle/VIS/19.3.0/appsutil/log/TXK_CHK_PDB_COMPTABILITY_Fri_Oct_10_10_43_18_2025/check_undo_mgmt.out
==========================
Inside executeSQLFile()...
==========================
Executing the SQL...
Execute SYSTEM command : sqlplus -s /nolog @/d01/oracle/VIS/19.3.0/appsutil/log/TXK_CHK_PDB_COMPTABILITY_Fri_Oct_10_10_43_18_2025/check_undo_mgmt.sql
==============================
Inside searchFileContents()...
==============================
log_file: /d01/oracle/VIS/19.3.0/appsutil/log/TXK_CHK_PDB_COMPTABILITY_Fri_Oct_10_10_43_18_2025/check_undo_mgmt.out
pattern: ERROR|WARNING
=============================
Could not find the pattern...
=============================
EXIT STATUS: 0
No UNDO MANAGEMENT violations in the plugged in PDB 'VIS'. Proceed further.
****************************************************************************************
CHECK THE BELOW LOG FILE FOR VIOLATIONS:
/d01/oracle/VIS/19.3.0/appsutil/log/TXK_CHK_PDB_COMPTABILITY_Fri_Oct_10_10_43_18_2025/check_undo_mgmt.out
****************************************************************************************
****************************************************************************************
* *
* IMPORTANT NOTE: RESOLVE ALL VIOLATIONS BEFORE PROCEEDING TO CREATE PDB *
* *
* - All the errors except SQL PATCH ERRORS should be resolved *
* *
* - All the warnings except CHARACTER SET WARNINGS can be ignored *
* *
* - Review and set the INIT PARAMETERs to match the EBS requirements *
* *
****************************************************************************************
Exiting from the script.
Ended: Fri Oct 10 10:43:19 CEST 2025
[oracle@lin7 bin]$ # Create the PDB
[oracle@lin7 bin]$ cd $ORACLE_HOME/appsutil
[oracle@lin7 appsutil]$ . ./txkSetCfgCDB.env dboraclehome=/d01/oracle/VIS/19.3.0
Oracle Home being passed: /d01/oracle/VIS/19.3.0
[oracle@lin7 appsutil]$ cd $ORACLE_HOME/appsutil/bin
[oracle@lin7 bin]$ (/d01/oracle/VIS/data; echo /d01/oracle/VIS/data)|perl txkCreatePDB.pl -dboraclehome=/d01/oracle/VIS/19.3.0 -outdir=/d01/oracle/VIS/19.3.0/appsutil/log \
> -cdbsid=VISCDB -pdbsid=VIS -dbuniquename=VIS.fritz.box -servicetype=onpremise
-bash: /d01/oracle/VIS/data: Is a directory
TDE is not enabled, WALLET credentials and SECRET KEY are not required.
Script Name : txkCreatePDB.pl
Script Version : 120.0.12020000.38
Started : Fri Oct 10 10:43:19 CEST 2025
Log File : /d01/oracle/VIS/19.3.0/appsutil/log/TXK_CREATE_PDB_Fri_Oct_10_10_43_19_2025/txkCreatePDB.log
-----------
Values used
-----------
Database Oracle Home : /d01/oracle/VIS/19.3.0
CDB SID : VISCDB
PDB SID : VIS
Non-CDB Name :
Non-CDB data directory :
PDB data directory :
Non-CDB undo tablespace :
PDB undo tablespace :
Copy data files : no
OUT Directory : /d01/oracle/VIS/19.3.0/appsutil/log
Ignore PDB State : No
Service Type : onpremise
Is TDE enabled : No
DB Unique Name : VIS.fritz.box
Prompt secret key : no
Backup Wallet : No
=========================
Validating oracle home...
=========================
Oracle Home: /d01/oracle/VIS/19.3.0 exists.
===========================
Validating out directory...
===========================
Out directory: /d01/oracle/VIS/19.3.0/appsutil/log exists.
=============================
Validating DB service type...
=============================
Service Type: onpremise
Service type is valid.
============================
Inside getDBHostDetails()...
============================
DB Hostname : lin7
DB Domain : fritz.box
=====================================
Inside checkNonCDBDatabaseStatus()...
=====================================
Checking for PMON and SMON process with "VIS"...
==============================
Inside checkProcessStatus()...
==============================
Checking for process ora_pmon_VIS...
No process with name ora_pmon_VIS is running.
==============================
Inside checkProcessStatus()...
==============================
Checking for process ora_smon_VIS...
No process with name ora_smon_VIS is running.
No PMON and SMON process with "VIS" are found.
Checking for PMON and SMON process with "VIS1"...
==============================
Inside checkProcessStatus()...
==============================
Checking for process ora_pmon_VIS1...
No process with name ora_pmon_VIS1 is running.
==============================
Inside checkProcessStatus()...
==============================
Checking for process ora_smon_VIS1...
No process with name ora_smon_VIS1 is running.
Non-CDB database is SHUTDOWN. Proceeding further...
============================
Inside setFileLocations()...
============================
PDB_DESC_XML: /d01/oracle/VIS/19.3.0/dbs/VIS_PDBDesc.xml
========================
Inside loadDataTops()...
========================
Reading the data tops from file /d01/oracle/VIS/19.3.0/dbs/VIS_datatop.txt
Processing entry for DATA_TOP_1-->/d01/oracle/VIS/data
============================
Inside promptDataTopDir()...
============================
Number of DATA_TOPs: 1
DATA_TOP_1
===========
Enter the non-CDB data top [/d01/oracle/VIS/data]: Enter the corresponding PDB data top [/d01/oracle/VIS/data]:
======================
Inside setASMFlag()...
======================
data_first_char: /
DATA_ASM_FLAG: 0
Not checking keystore as TDE is not enabled.
============================
Inside validateDataTops()...
============================
================================
Validating data top directory...
================================
Data top directory /d01/oracle/VIS/data exists.
**** Setting ORACLE_SID to VISCDB for PDB Creation.
========================
Inside getDBVersion()...
========================
DB_VERSION = db190
**** Setting ORACLE_SID to VISCDB for PDB Creation.
=============================
Shutting down the database...
=============================
Shutdown mode : IMMEDIATE
Generating SQL file : /d01/oracle/VIS/19.3.0/appsutil/log/TXK_CREATE_PDB_Fri_Oct_10_10_43_19_2025/shutdown_IMMEDIATE.sql
SQL output file : /d01/oracle/VIS/19.3.0/appsutil/log/TXK_CREATE_PDB_Fri_Oct_10_10_43_19_2025/shutdown_IMMEDIATE.out
==========================
Inside executeSQLFile()...
==========================
Executing the SQL...
Execute SYSTEM command : sqlplus -s /nolog @/d01/oracle/VIS/19.3.0/appsutil/log/TXK_CREATE_PDB_Fri_Oct_10_10_43_19_2025/shutdown_IMMEDIATE.sql
==============================
Inside searchFileContents()...
==============================
log_file: /d01/oracle/VIS/19.3.0/appsutil/log/TXK_CREATE_PDB_Fri_Oct_10_10_43_19_2025/shutdown_IMMEDIATE.out
pattern: ERROR
=============================
Could not find the pattern...
=============================
EXIT STATUS: 0
SQL execution went through successfully.
LOG FILE: /d01/oracle/VIS/19.3.0/appsutil/log/TXK_CREATE_PDB_Fri_Oct_10_10_43_19_2025/shutdown_IMMEDIATE.out.
========================
Starting the database...
========================
Startup mode : NONE
Generating SQL file : /d01/oracle/VIS/19.3.0/appsutil/log/TXK_CREATE_PDB_Fri_Oct_10_10_43_19_2025/startup_NONE.sql
SQL output file : /d01/oracle/VIS/19.3.0/appsutil/log/TXK_CREATE_PDB_Fri_Oct_10_10_43_19_2025/startup_NONE.out
==========================
Inside executeSQLFile()...
==========================
Executing the SQL...
Execute SYSTEM command : sqlplus -s /nolog @/d01/oracle/VIS/19.3.0/appsutil/log/TXK_CREATE_PDB_Fri_Oct_10_10_43_19_2025/startup_NONE.sql
Removing the file: /d01/oracle/VIS/19.3.0/appsutil/log/TXK_CREATE_PDB_Fri_Oct_10_10_43_19_2025/startup_NONE.sql
==============================
Inside searchFileContents()...
==============================
log_file: /d01/oracle/VIS/19.3.0/appsutil/log/TXK_CREATE_PDB_Fri_Oct_10_10_43_19_2025/startup_NONE.out
pattern: ERROR
=============================
Could not find the pattern...
=============================
EXIT STATUS: 0
SQL execution went through successfully.
LOG FILE: /d01/oracle/VIS/19.3.0/appsutil/log/TXK_CREATE_PDB_Fri_Oct_10_10_43_19_2025/startup_NONE.out.
=================================
Inside checkPDBCompatibility()...
=================================
File /d01/oracle/VIS/19.3.0/dbs/VIS_PDBDesc.xml exists.
Generating SQL file : /d01/oracle/VIS/19.3.0/appsutil/log/TXK_CREATE_PDB_Fri_Oct_10_10_43_19_2025/create_pdb_compatible.sql
SQL output file : /d01/oracle/VIS/19.3.0/appsutil/log/TXK_CREATE_PDB_Fri_Oct_10_10_43_19_2025/create_pdb_compatible.out
==========================
Inside executeSQLFile()...
==========================
Executing the SQL...
Execute SYSTEM command : sqlplus -s /nolog @/d01/oracle/VIS/19.3.0/appsutil/log/TXK_CREATE_PDB_Fri_Oct_10_10_43_19_2025/create_pdb_compatible.sql
==============================
Inside searchFileContents()...
==============================
log_file: /d01/oracle/VIS/19.3.0/appsutil/log/TXK_CREATE_PDB_Fri_Oct_10_10_43_19_2025/create_pdb_compatible.out
pattern: ERROR
=============================
Could not find the pattern...
=============================
EXIT STATUS: 0
PDB compatability check executed successfully.
LOG FILE: /d01/oracle/VIS/19.3.0/appsutil/log/TXK_CREATE_PDB_Fri_Oct_10_10_43_19_2025/create_pdb_compatible.out.
==================================
Inside checkCharSetViolations()...
==================================
File /d01/oracle/VIS/19.3.0/dbs/VIS_PDBDesc.xml exists.
Generating SQL file : /d01/oracle/VIS/19.3.0/appsutil/log/TXK_CREATE_PDB_Fri_Oct_10_10_43_19_2025/check_char_set_violations.sql
SQL output file : /d01/oracle/VIS/19.3.0/appsutil/log/TXK_CREATE_PDB_Fri_Oct_10_10_43_19_2025/check_char_set_violations.out
==========================
Inside executeSQLFile()...
==========================
Executing the SQL...
Execute SYSTEM command : sqlplus -s /nolog @/d01/oracle/VIS/19.3.0/appsutil/log/TXK_CREATE_PDB_Fri_Oct_10_10_43_19_2025/check_char_set_violations.sql
==============================
Inside searchFileContents()...
==============================
log_file: /d01/oracle/VIS/19.3.0/appsutil/log/TXK_CREATE_PDB_Fri_Oct_10_10_43_19_2025/check_char_set_violations.out
pattern: ERROR|WARNING
=============================
Could not find the pattern...
=============================
EXIT STATUS: 0
No CHARACTER violations in the plugged in PDB 'VIS'. Proceed further.
====================================
Inside checkPDBPluginViolations()...
====================================
File /d01/oracle/VIS/19.3.0/dbs/VIS_PDBDesc.xml exists.
Generating SQL file : /d01/oracle/VIS/19.3.0/appsutil/log/TXK_CREATE_PDB_Fri_Oct_10_10_43_19_2025/check_pdb_plugin_violations.sql
SQL output file : /d01/oracle/VIS/19.3.0/appsutil/log/TXK_CREATE_PDB_Fri_Oct_10_10_43_19_2025/check_pdb_plugin_violations.out
==========================
Inside executeSQLFile()...
==========================
Executing the SQL...
Execute SYSTEM command : sqlplus -s /nolog @/d01/oracle/VIS/19.3.0/appsutil/log/TXK_CREATE_PDB_Fri_Oct_10_10_43_19_2025/check_pdb_plugin_violations.sql
==============================
Inside searchFileContents()...
==============================
log_file: /d01/oracle/VIS/19.3.0/appsutil/log/TXK_CREATE_PDB_Fri_Oct_10_10_43_19_2025/check_pdb_plugin_violations.out
pattern: ERROR
=============================
Could not find the pattern...
=============================
EXIT STATUS: 0
No violations for the database 'VIS' to be plugged in. Proceed further.
======================================
Inside checkPDBCaseSensitiveParam()...
======================================
Generating SQL file : /d01/oracle/VIS/19.3.0/appsutil/log/TXK_CREATE_PDB_Fri_Oct_10_10_43_19_2025/get_case_sensitive_param.sql
SQL output file : /d01/oracle/VIS/19.3.0/appsutil/log/TXK_CREATE_PDB_Fri_Oct_10_10_43_19_2025/get_case_sensitive_param.out
Spool File : /d01/oracle/VIS/19.3.0/appsutil/log/TXK_CREATE_PDB_Fri_Oct_10_10_43_19_2025/spool_get_case_sensitive_param.log
==========================
Inside executeSQLFile()...
==========================
Executing the SQL...
Execute SYSTEM command : sqlplus -s /nolog @/d01/oracle/VIS/19.3.0/appsutil/log/TXK_CREATE_PDB_Fri_Oct_10_10_43_19_2025/get_case_sensitive_param.sql
Removing the file: /d01/oracle/VIS/19.3.0/appsutil/log/TXK_CREATE_PDB_Fri_Oct_10_10_43_19_2025/get_case_sensitive_param.sql
==============================
Inside searchFileContents()...
==============================
log_file: /d01/oracle/VIS/19.3.0/appsutil/log/TXK_CREATE_PDB_Fri_Oct_10_10_43_19_2025/get_case_sensitive_param.out
pattern: ERROR
=============================
Could not find the pattern...
=============================
EXIT STATUS: 0
Getting the parameter value.
Parameter _PDB_NAME_CASE_SENSITIVE is set to TRUE.
=======================================
Inside createPDBUsingDescriptorXML()...
=======================================
File /d01/oracle/VIS/19.3.0/dbs/VIS_PDBDesc.xml exists.
==================================
Inside checkPDBAlreadyCreated()...
==================================
Generating SQL file : /d01/oracle/VIS/19.3.0/appsutil/log/TXK_CREATE_PDB_Fri_Oct_10_10_43_19_2025/check_pdb_created.sql
SQL output file : /d01/oracle/VIS/19.3.0/appsutil/log/TXK_CREATE_PDB_Fri_Oct_10_10_43_19_2025/check_pdb_created.out
Spool File : /d01/oracle/VIS/19.3.0/appsutil/log/TXK_CREATE_PDB_Fri_Oct_10_10_43_19_2025/spool_check_pdb_created.log
==========================
Inside executeSQLFile()...
==========================
Executing the SQL...
Execute SYSTEM command : sqlplus -s /nolog @/d01/oracle/VIS/19.3.0/appsutil/log/TXK_CREATE_PDB_Fri_Oct_10_10_43_19_2025/check_pdb_created.sql
Removing the file: /d01/oracle/VIS/19.3.0/appsutil/log/TXK_CREATE_PDB_Fri_Oct_10_10_43_19_2025/check_pdb_created.sql
==============================
Inside searchFileContents()...
==============================
log_file: /d01/oracle/VIS/19.3.0/appsutil/log/TXK_CREATE_PDB_Fri_Oct_10_10_43_19_2025/check_pdb_created.out
pattern: ERROR
=============================
Could not find the pattern...
=============================
EXIT STATUS: 0
Checking for PDB: VIS
================================
Inside genDataTopMappingStr()...
================================
dir_mapping_str: '/d01/oracle/VIS/data', '/d01/oracle/VIS/data'
Generating SQL file : /d01/oracle/VIS/19.3.0/appsutil/log/TXK_CREATE_PDB_Fri_Oct_10_10_43_19_2025/create_pdb_using_desc_xml.sql
SQL output file : /d01/oracle/VIS/19.3.0/appsutil/log/TXK_CREATE_PDB_Fri_Oct_10_10_43_19_2025/create_pdb_using_desc_xml.out
PDB will be created using the existing non-CDB database files.
==========================
Inside executeSQLFile()...
==========================
Executing the SQL...
Execute SYSTEM command : sqlplus -s /nolog @/d01/oracle/VIS/19.3.0/appsutil/log/TXK_CREATE_PDB_Fri_Oct_10_10_43_19_2025/create_pdb_using_desc_xml.sql
==============================
Inside searchFileContents()...
==============================
log_file: /d01/oracle/VIS/19.3.0/appsutil/log/TXK_CREATE_PDB_Fri_Oct_10_10_43_19_2025/create_pdb_using_desc_xml.out
pattern: ERROR|SP2-0027
=============================
Could not find the pattern...
=============================
EXIT STATUS: 0
PDB is successfully created using descriptor XML /d01/oracle/VIS/19.3.0/dbs/VIS_PDBDesc.xml
LOG FILE: /d01/oracle/VIS/19.3.0/appsutil/log/TXK_CREATE_PDB_Fri_Oct_10_10_43_19_2025/create_pdb_using_desc_xml.out.
==============================
Inside convertNonCDBToPDB()...
==============================
Generating SQL file : /d01/oracle/VIS/19.3.0/appsutil/log/TXK_CREATE_PDB_Fri_Oct_10_10_43_19_2025/convert_noncdb_to_pdb.sql
SQL output file : /d01/oracle/VIS/19.3.0/appsutil/log/TXK_CREATE_PDB_Fri_Oct_10_10_43_19_2025/convert_noncdb_to_pdb.out
==========================
Inside executeSQLFile()...
==========================
Executing the SQL...
Execute SYSTEM command : sqlplus -s /nolog @/d01/oracle/VIS/19.3.0/appsutil/log/TXK_CREATE_PDB_Fri_Oct_10_10_43_19_2025/convert_noncdb_to_pdb.sql
===========================
Inside searchSpoolFile()...
===========================
Spool file passed: /d01/oracle/VIS/19.3.0/appsutil/log/TXK_CREATE_PDB_Fri_Oct_10_10_43_19_2025/spool_convert_noncdb_to_pdb.log
EXIT STATUS: 0
PDB conversion completed successfully.
LOG FILE: /d01/oracle/VIS/19.3.0/appsutil/log/TXK_CREATE_PDB_Fri_Oct_10_10_43_19_2025/convert_noncdb_to_pdb.out.
================
Close the PDB...
================
==========================
Inside checkPDBStatus()...
==========================
Generating SQL file : /d01/oracle/VIS/19.3.0/appsutil/log/TXK_CREATE_PDB_Fri_Oct_10_10_43_19_2025/check_pdb_status.sql
SQL output file : /d01/oracle/VIS/19.3.0/appsutil/log/TXK_CREATE_PDB_Fri_Oct_10_10_43_19_2025/check_pdb_status.out
==========================
Inside executeSQLFile()...
==========================
Executing the SQL...
Execute SYSTEM command : sqlplus -s /nolog @/d01/oracle/VIS/19.3.0/appsutil/log/TXK_CREATE_PDB_Fri_Oct_10_10_43_19_2025/check_pdb_status.sql
==============================
Inside searchFileContents()...
==============================
log_file: /d01/oracle/VIS/19.3.0/appsutil/log/TXK_CREATE_PDB_Fri_Oct_10_10_43_19_2025/check_pdb_status.out
pattern: MOUNTED
================
Pattern found...
================
EXIT STATUS: 1
PDB already closed. Do nothing.
==================
Opening the PDB...
==================
Generating SQL file : /d01/oracle/VIS/19.3.0/appsutil/log/TXK_CREATE_PDB_Fri_Oct_10_10_43_19_2025/open_PDB.sql
SQL output file : /d01/oracle/VIS/19.3.0/appsutil/log/TXK_CREATE_PDB_Fri_Oct_10_10_43_19_2025/open_PDB.out
==========================
Inside executeSQLFile()...
==========================
Executing the SQL...
Execute SYSTEM command : sqlplus -s /nolog @/d01/oracle/VIS/19.3.0/appsutil/log/TXK_CREATE_PDB_Fri_Oct_10_10_43_19_2025/open_PDB.sql
==============================
Inside searchFileContents()...
==============================
log_file: /d01/oracle/VIS/19.3.0/appsutil/log/TXK_CREATE_PDB_Fri_Oct_10_10_43_19_2025/open_PDB.out
pattern: ERROR|WARNING
=============================
Could not find the pattern...
=============================
EXIT STATUS: 0
PDB opened successfully.
LOG FILE: /d01/oracle/VIS/19.3.0/appsutil/log/TXK_CREATE_PDB_Fri_Oct_10_10_43_19_2025/open_PDB.out.
=======================
Saving the PDB state...
=======================
Generating SQL file : /d01/oracle/VIS/19.3.0/appsutil/log/TXK_CREATE_PDB_Fri_Oct_10_10_43_19_2025/save_PDB_state.sql
SQL output file : /d01/oracle/VIS/19.3.0/appsutil/log/TXK_CREATE_PDB_Fri_Oct_10_10_43_19_2025/save_PDB_state.out
==========================
Inside executeSQLFile()...
==========================
Executing the SQL...
Execute SYSTEM command : sqlplus -s /nolog @/d01/oracle/VIS/19.3.0/appsutil/log/TXK_CREATE_PDB_Fri_Oct_10_10_43_19_2025/save_PDB_state.sql
==============================
Inside searchFileContents()...
==============================
log_file: /d01/oracle/VIS/19.3.0/appsutil/log/TXK_CREATE_PDB_Fri_Oct_10_10_43_19_2025/save_PDB_state.out
pattern: ERROR
=============================
Could not find the pattern...
=============================
EXIT STATUS: 0
PDB state saved successfully.
LOG FILE: /d01/oracle/VIS/19.3.0/appsutil/log/TXK_CREATE_PDB_Fri_Oct_10_10_43_19_2025/save_PDB_state.out.
Exiting from the script.
Ended: Fri Oct 10 10:53:30 CEST 2025
[oracle@lin7 bin]$ # Run the post PDB script
[oracle@lin7 bin]$ exit
logout
[root@lin7 ~]# su - oracle
Last login: Fri Oct 10 06:41:11 CEST 2025 on pts/2
[oracle@lin7 ~]$ hn=`hostname|awk -F. {'print $1'}`
[oracle@lin7 ~]$ cd /d01/oracle/VIS/19.3.0/appsutil
[oracle@lin7 appsutil]$ . ./txkSetCfgCDB.env dboraclehome=/d01/oracle/VIS/19.3.0
Oracle Home being passed: /d01/oracle/VIS/19.3.0
[oracle@lin7 appsutil]$ (echo apps; echo manager)|perl $ORACLE_HOME/appsutil/bin/txkPostPDBCreationTasks.pl -dboraclehome=/d01/oracle/VIS/19.3.0 \
> -outdir=/d01/oracle/VIS/19.3.0/appsutil/log -cdbsid=VISCDB -pdbsid=VIS \
> -appsuser=apps -dbport=1521 -servicetype=onpremise
stty: 'standard input': Inappropriate ioctl for device
Enter the APPS Password:
stty: 'standard input': Inappropriate ioctl for device
stty: 'standard input': Inappropriate ioctl for device
Enter the SYSTEM Password:
stty: 'standard input': Inappropriate ioctl for device
Script Name : txkPostPDBCreationTasks.pl
Script Version : 120.0.12020000.73
Started : Fri Oct 10 10:53:30 CEST 2025
Log File : /d01/oracle/VIS/19.3.0/appsutil/log/TXK_POST_PDB_Fri_Oct_10_10_53_30_2025/txkPostPDBCreationTasks.log
-----------
Values used
-----------
Database Oracle Home : /d01/oracle/VIS/19.3.0
CDB NAME :
CDB SID : VISCDB
DB Unique Name :
PDB SID : VIS
Database port : 1521
OUT Directory : /d01/oracle/VIS/19.3.0/appsutil/log
APPS Schema Username : apps
Service Type : onpremise
Is RAC? : No
Virtual Hostname :
Logical Hostname :
Scan Hostname :
Scan Port :
Ignore scan details : No
Generate UTL_FILE_DIR : No
Generate password file : Yes
=========================
Validating oracle home...
=========================
Oracle Home: /d01/oracle/VIS/19.3.0 exists.
===========================
Validating out directory...
===========================
Out directory: /d01/oracle/VIS/19.3.0/appsutil/log exists.
=============================
Validating DB service type...
=============================
Service Type: onpremise
Service type is valid.
============================
Inside getDBHostDetails()...
============================
DB Hostname : lin7
DB Domain : fritz.box
Logical hostname is not passed, hence using physical hostname details.
Logical Hostname : lin7
Logical Domain : fritz.box
==========================
Inside setContextName()...
==========================
CONTEXT_NAME: VIS_lin7
=====================
Inside getDBPort()...
=====================
DB Port passed as an argument, using the same.
DB Port: 1521
============================
Inside setFileLocations()...
============================
SYSTEM_PWD_REUSE_FILE: /d01/oracle/VIS/19.3.0/dbs/VISCDB_pwd_reuse_prf.txt
========================
Inside getDBVersion()...
========================
DB_VERSION = db190
=================================
Inside getVirtualHostDetails()...
=================================
Non-RAC configuration, defaulting virtual hostname.
Virtual Hostname : lin7
**** Setting ORACLE_UNQNAME to VISCDB
**** Setting ORACLE_SID to VISCDB
**** Setting TNS_ADMIN to /d01/oracle/VIS/19.3.0/network/admin
===========================
Inside setListenerFlag()...
===========================
Before: START_STOP_LISTENER_FLAG: 0
After: START_STOP_LISTENER_FLAG: 1
===========================
Inside stopPDBListener()...
===========================
Executing SYSTEM command: lsnrctl stop VIS > /d01/oracle/VIS/19.3.0/appsutil/log/TXK_POST_PDB_Fri_Oct_10_10_53_30_2025/lsnrctl_PDB_stop.txt
=============================
Inside checkGridListener()...
=============================
log_file: /d01/oracle/VIS/19.3.0/appsutil/log/TXK_POST_PDB_Fri_Oct_10_10_53_30_2025/lsnrctl_PDB_stop.txt
pattern: TNS-01190
==========================================================
Grid listener not used.
START/STOP of listener failed because of some other issue.
Check the logs for details.
==========================================================
============================
Inside checkListenerLog()...
============================
log_file: /d01/oracle/VIS/19.3.0/appsutil/log/TXK_POST_PDB_Fri_Oct_10_10_53_30_2025/lsnrctl_PDB_stop.txt
Pattern TNS-01101 is found, error will be ignored.
PDB listener stopped.
LOG FILE: /d01/oracle/VIS/19.3.0/appsutil/log/TXK_POST_PDB_Fri_Oct_10_10_53_30_2025/lsnrctl_PDB_stop.txt.
===========================
Inside stopCDBListener()...
===========================
Executing SYSTEM command: lsnrctl stop VISCDB > /d01/oracle/VIS/19.3.0/appsutil/log/TXK_POST_PDB_Fri_Oct_10_10_53_30_2025/lsnrctl_CDB_stop.txt
CDB listener stopped successfully.
================================
Inside generateCDBSqlNetOra()...
================================
Creating the directory: /d01/oracle/VIS/19.3.0/appsutil/log/TXK_POST_PDB_Fri_Oct_10_10_53_30_2025/tns_admin_cdb_bkp
Creating the directory: /d01/oracle/VIS/19.3.0/appsutil/log/TXK_POST_PDB_Fri_Oct_10_10_53_30_2025/tns_admin_cdb_temp
File already exists. Skipping instantiation of sqlnet.ora.
Copying the file
----------------
SOURCE : /d01/oracle/VIS/19.3.0/network/admin/sqlnet.ora
TARGET : /d01/oracle/VIS/19.3.0/appsutil/log/TXK_POST_PDB_Fri_Oct_10_10_53_30_2025/tns_admin_cdb_bkp/sqlnet.ora
==============================
Inside updateCDBSqlNetOra()...
==============================
Updating the IFILE entry...
======================================
Inside generatePDBTNSAdminContent()...
======================================
Creating the directory: /d01/oracle/VIS/19.3.0/appsutil/log/TXK_POST_PDB_Fri_Oct_10_10_53_30_2025/tns_admin_pdb_bkp
Creating the directory: /d01/oracle/VIS/19.3.0/appsutil/log/TXK_POST_PDB_Fri_Oct_10_10_53_30_2025/tns_admin_pdb_temp
Copying the file
----------------
SOURCE : /d01/oracle/VIS/19.3.0/appsutil/template/ad8ilsnr.ora
TARGET : /d01/oracle/VIS/19.3.0/appsutil/log/TXK_POST_PDB_Fri_Oct_10_10_53_30_2025/tns_admin_pdb_temp/listener.ora
===================================
Inside replaceContextVariables()...
===================================
File /d01/oracle/VIS/19.3.0/network/admin/VIS_lin7/listener.ora does not exist.
Copying the file
----------------
SOURCE : /d01/oracle/VIS/19.3.0/appsutil/log/TXK_POST_PDB_Fri_Oct_10_10_53_30_2025/tns_admin_pdb_temp/listener.ora
TARGET : /d01/oracle/VIS/19.3.0/network/admin/VIS_lin7/listener.ora
Copying the file
----------------
SOURCE : /d01/oracle/VIS/19.3.0/appsutil/template/ad8itns.ora
TARGET : /d01/oracle/VIS/19.3.0/appsutil/log/TXK_POST_PDB_Fri_Oct_10_10_53_30_2025/tns_admin_pdb_temp/tnsnames.ora
===================================
Inside replaceContextVariables()...
===================================
File /d01/oracle/VIS/19.3.0/network/admin/VIS_lin7/tnsnames.ora does not exist.
Copying the file
----------------
SOURCE : /d01/oracle/VIS/19.3.0/appsutil/log/TXK_POST_PDB_Fri_Oct_10_10_53_30_2025/tns_admin_pdb_temp/tnsnames.ora
TARGET : /d01/oracle/VIS/19.3.0/network/admin/VIS_lin7/tnsnames.ora
================================
Inside generatePDBSqlNetOra()...
================================
Directory /d01/oracle/VIS/19.3.0/appsutil/log/TXK_POST_PDB_Fri_Oct_10_10_53_30_2025/tns_admin_pdb_bkp already exists.
File /d01/oracle/VIS/19.3.0/network/admin/VIS_lin7/sqlnet.ora does not exist.
Copying the file
----------------
SOURCE : /d01/oracle/VIS/19.3.0/network/admin/sqlnet.ora
TARGET : /d01/oracle/VIS/19.3.0/network/admin/VIS_lin7/sqlnet.ora
File /d01/oracle/VIS/19.3.0/network/admin/VIS_lin7/sqlnet_ifile.ora does not exist.
File /d01/oracle/VIS/19.3.0/network/admin/sqlnet_ifile.ora does not exist.
==============================
Inside updatePDBSqlNetOra()...
==============================
Updating the IFILE entry...
============================
Inside startCDBListener()...
============================
Executing SYSTEM command: lsnrctl start VISCDB > /d01/oracle/VIS/19.3.0/appsutil/log/TXK_POST_PDB_Fri_Oct_10_10_53_30_2025/lsnrctl_CDB_start.txt
CDB listener started successfully.
=============================
Shutting down the database...
=============================
Shutdown mode : IMMEDIATE
Generating SQL file : /d01/oracle/VIS/19.3.0/appsutil/log/TXK_POST_PDB_Fri_Oct_10_10_53_30_2025/shutdown_IMMEDIATE.sql
SQL output file : /d01/oracle/VIS/19.3.0/appsutil/log/TXK_POST_PDB_Fri_Oct_10_10_53_30_2025/shutdown_IMMEDIATE.out
==========================
Inside executeSQLFile()...
==========================
Executing the SQL...
Execute SYSTEM command : sqlplus -s /nolog @/d01/oracle/VIS/19.3.0/appsutil/log/TXK_POST_PDB_Fri_Oct_10_10_53_30_2025/shutdown_IMMEDIATE.sql
==============================
Inside searchFileContents()...
==============================
log_file: /d01/oracle/VIS/19.3.0/appsutil/log/TXK_POST_PDB_Fri_Oct_10_10_53_30_2025/shutdown_IMMEDIATE.out
pattern: ERROR
=============================
Could not find the pattern...
=============================
EXIT STATUS: 0
SQL execution went through successfully.
LOG FILE: /d01/oracle/VIS/19.3.0/appsutil/log/TXK_POST_PDB_Fri_Oct_10_10_53_30_2025/shutdown_IMMEDIATE.out.
========================
Starting the database...
========================
Startup mode : NONE
Generating SQL file : /d01/oracle/VIS/19.3.0/appsutil/log/TXK_POST_PDB_Fri_Oct_10_10_53_30_2025/startup_NONE.sql
SQL output file : /d01/oracle/VIS/19.3.0/appsutil/log/TXK_POST_PDB_Fri_Oct_10_10_53_30_2025/startup_NONE.out
==========================
Inside executeSQLFile()...
==========================
Executing the SQL...
Execute SYSTEM command : sqlplus -s /nolog @/d01/oracle/VIS/19.3.0/appsutil/log/TXK_POST_PDB_Fri_Oct_10_10_53_30_2025/startup_NONE.sql
==============================
Inside searchFileContents()...
==============================
log_file: /d01/oracle/VIS/19.3.0/appsutil/log/TXK_POST_PDB_Fri_Oct_10_10_53_30_2025/startup_NONE.out
pattern: ERROR
=============================
Could not find the pattern...
=============================
EXIT STATUS: 0
SQL execution went through successfully.
LOG FILE: /d01/oracle/VIS/19.3.0/appsutil/log/TXK_POST_PDB_Fri_Oct_10_10_53_30_2025/startup_NONE.out.
================================
Inside setDbDomainParameter()...
================================
Generating SQL file : /d01/oracle/VIS/19.3.0/appsutil/log/TXK_POST_PDB_Fri_Oct_10_10_53_30_2025/get_db_domain.sql
SQL output file : /d01/oracle/VIS/19.3.0/appsutil/log/TXK_POST_PDB_Fri_Oct_10_10_53_30_2025/get_db_domain.out
==========================
Inside executeSQLFile()...
==========================
Executing the SQL...
Execute SYSTEM command : sqlplus -s /nolog @/d01/oracle/VIS/19.3.0/appsutil/log/TXK_POST_PDB_Fri_Oct_10_10_53_30_2025/get_db_domain.sql
==============================
Inside searchFileContents()...
==============================
log_file: /d01/oracle/VIS/19.3.0/appsutil/log/TXK_POST_PDB_Fri_Oct_10_10_53_30_2025/get_db_domain.out
pattern: ERROR
=============================
Could not find the pattern...
=============================
EXIT STATUS: 0
Updating DB_DOMAIN parameter.
LOG FILE: /d01/oracle/VIS/19.3.0/appsutil/log/TXK_POST_PDB_Fri_Oct_10_10_53_30_2025/get_db_domain.out.
==============================
Inside searchFileContents()...
==============================
log_file: /d01/oracle/VIS/19.3.0/appsutil/log/TXK_POST_PDB_Fri_Oct_10_10_53_30_2025/get_db_domain.out
pattern: NOT-EMPTY
================
Pattern found...
================
DB_DOMAIN parameter set. Checking for the parameter file.
==============================
Inside searchFileContents()...
==============================
log_file: /d01/oracle/VIS/19.3.0/appsutil/log/TXK_POST_PDB_Fri_Oct_10_10_53_30_2025/get_db_domain.out
pattern: SPFILE
================
Pattern found...
================
SPFILE is being used. Executing ALTER command.
===============================
Inside setDbDomainInSPFILE()...
===============================
Copying the file
----------------
SOURCE : /d01/oracle/VIS/19.3.0/dbs/spfileVISCDB.ora
TARGET : /d01/oracle/VIS/19.3.0/appsutil/log/TXK_POST_PDB_Fri_Oct_10_10_53_30_2025/spfileVISCDB_bkp.ora
Generating SQL file : /d01/oracle/VIS/19.3.0/appsutil/log/TXK_POST_PDB_Fri_Oct_10_10_53_30_2025/alter_db_domain.sql
SQL output file : /d01/oracle/VIS/19.3.0/appsutil/log/TXK_POST_PDB_Fri_Oct_10_10_53_30_2025/alter_db_domain.out
==========================
Inside executeSQLFile()...
==========================
Executing the SQL...
Execute SYSTEM command : sqlplus -s /nolog @/d01/oracle/VIS/19.3.0/appsutil/log/TXK_POST_PDB_Fri_Oct_10_10_53_30_2025/alter_db_domain.sql
==============================
Inside searchFileContents()...
==============================
log_file: /d01/oracle/VIS/19.3.0/appsutil/log/TXK_POST_PDB_Fri_Oct_10_10_53_30_2025/alter_db_domain.out
pattern: ERROR
=============================
Could not find the pattern...
=============================
EXIT STATUS: 0
DB_DOMAIN set successfully in SPFILE.
LOG FILE: /d01/oracle/VIS/19.3.0/appsutil/log/TXK_POST_PDB_Fri_Oct_10_10_53_30_2025/alter_db_domain.out.
=============================
Shutting down the database...
=============================
Shutdown mode : IMMEDIATE
Generating SQL file : /d01/oracle/VIS/19.3.0/appsutil/log/TXK_POST_PDB_Fri_Oct_10_10_53_30_2025/shutdown_IMMEDIATE.sql
SQL output file : /d01/oracle/VIS/19.3.0/appsutil/log/TXK_POST_PDB_Fri_Oct_10_10_53_30_2025/shutdown_IMMEDIATE.out
==========================
Inside executeSQLFile()...
==========================
Executing the SQL...
Execute SYSTEM command : sqlplus -s /nolog @/d01/oracle/VIS/19.3.0/appsutil/log/TXK_POST_PDB_Fri_Oct_10_10_53_30_2025/shutdown_IMMEDIATE.sql
==============================
Inside searchFileContents()...
==============================
log_file: /d01/oracle/VIS/19.3.0/appsutil/log/TXK_POST_PDB_Fri_Oct_10_10_53_30_2025/shutdown_IMMEDIATE.out
pattern: ERROR
=============================
Could not find the pattern...
=============================
EXIT STATUS: 0
SQL execution went through successfully.
LOG FILE: /d01/oracle/VIS/19.3.0/appsutil/log/TXK_POST_PDB_Fri_Oct_10_10_53_30_2025/shutdown_IMMEDIATE.out.
========================
Starting the database...
========================
Startup mode : NONE
Generating SQL file : /d01/oracle/VIS/19.3.0/appsutil/log/TXK_POST_PDB_Fri_Oct_10_10_53_30_2025/startup_NONE.sql
SQL output file : /d01/oracle/VIS/19.3.0/appsutil/log/TXK_POST_PDB_Fri_Oct_10_10_53_30_2025/startup_NONE.out
==========================
Inside executeSQLFile()...
==========================
Executing the SQL...
Execute SYSTEM command : sqlplus -s /nolog @/d01/oracle/VIS/19.3.0/appsutil/log/TXK_POST_PDB_Fri_Oct_10_10_53_30_2025/startup_NONE.sql
==============================
Inside searchFileContents()...
==============================
log_file: /d01/oracle/VIS/19.3.0/appsutil/log/TXK_POST_PDB_Fri_Oct_10_10_53_30_2025/startup_NONE.out
pattern: ERROR
=============================
Could not find the pattern...
=============================
EXIT STATUS: 0
SQL execution went through successfully.
LOG FILE: /d01/oracle/VIS/19.3.0/appsutil/log/TXK_POST_PDB_Fri_Oct_10_10_53_30_2025/startup_NONE.out.
========================
Inside copyNLSFiles()...
========================
Executing SYSTEM command: perl /d01/oracle/VIS/19.3.0/nls/data/old/cr9idata.pl
Directory /d01/oracle/VIS/19.3.0/nls/data/9idata already exist. Overwriting...
Copying files to /d01/oracle/VIS/19.3.0/nls/data/9idata...
Copy finished.
Please reset environment variable ORA_NLS10 to /d01/oracle/VIS/19.3.0/nls/data/9idata!
Script cr9idata.pl executed successfully.
=================================
Inside createOPatchDBObjects()...
=================================
Generating SQL file : /d01/oracle/VIS/19.3.0/appsutil/log/TXK_POST_PDB_Fri_Oct_10_10_53_30_2025/create_opatch_db_objects.sql
SQL output file : /d01/oracle/VIS/19.3.0/appsutil/log/TXK_POST_PDB_Fri_Oct_10_10_53_30_2025/create_opatch_db_objects.out
==========================
Inside executeSQLFile()...
==========================
Executing the SQL...
Execute SYSTEM command : sqlplus -s /nolog @/d01/oracle/VIS/19.3.0/appsutil/log/TXK_POST_PDB_Fri_Oct_10_10_53_30_2025/create_opatch_db_objects.sql
==============================
Inside searchFileContents()...
==============================
log_file: /d01/oracle/VIS/19.3.0/appsutil/log/TXK_POST_PDB_Fri_Oct_10_10_53_30_2025/create_opatch_db_objects.out
pattern: ERROR
=============================
Could not find the pattern...
=============================
EXIT STATUS: 0
OPATCH directories created successfully.
LOG FILE: /d01/oracle/VIS/19.3.0/appsutil/log/TXK_POST_PDB_Fri_Oct_10_10_53_30_2025/create_opatch_db_objects.out.
**** Setting TNS_ADMIN to /d01/oracle/VIS/19.3.0/network/admin/VIS_lin7 for PDB Connectivity.
===========================
Inside waitForListener()...
===========================
cmd: lsnrctl status VISCDB | tr '[:lower:]' '[:upper:]' | awk '/\"VIS\"/{print;getline;print;}' | grep VISCDB | grep -i READY
INSTANCE "VISCDB", STATUS READY, HAS 1 HANDLER(S) FOR THIS SERVICE...
=============================
Inside checkDBConnection()...
=============================
Generating SQL file : /d01/oracle/VIS/19.3.0/appsutil/log/TXK_POST_PDB_Fri_Oct_10_10_53_30_2025/check_db_connection.sql
SQL output file : /d01/oracle/VIS/19.3.0/appsutil/log/TXK_POST_PDB_Fri_Oct_10_10_53_30_2025/check_db_connection.log
==========================
Inside executeSQLFile()...
==========================
Executing the SQL...
Execute SYSTEM command : sqlplus -s /nolog @/d01/oracle/VIS/19.3.0/appsutil/log/TXK_POST_PDB_Fri_Oct_10_10_53_30_2025/check_db_connection.sql
Removing the file: /d01/oracle/VIS/19.3.0/appsutil/log/TXK_POST_PDB_Fri_Oct_10_10_53_30_2025/check_db_connection.sql
==============================
Inside searchFileContents()...
==============================
log_file: /d01/oracle/VIS/19.3.0/appsutil/log/TXK_POST_PDB_Fri_Oct_10_10_53_30_2025/check_db_connection.log
pattern: ORA-12514
=============================
Could not find the pattern...
=============================
EXIT STATUS: 0
Connection successful.
=====================================
Validating APPS schema credentials...
=====================================
Generating SQL file : /d01/oracle/VIS/19.3.0/appsutil/log/TXK_POST_PDB_Fri_Oct_10_10_53_30_2025/validate_apps_password.sql
SQL output file : /d01/oracle/VIS/19.3.0/appsutil/log/TXK_POST_PDB_Fri_Oct_10_10_53_30_2025/validate_apps_password.log
==========================
Inside executeSQLFile()...
==========================
Executing the SQL...
Execute SYSTEM command : sqlplus -s /nolog @/d01/oracle/VIS/19.3.0/appsutil/log/TXK_POST_PDB_Fri_Oct_10_10_53_30_2025/validate_apps_password.sql
Removing the file: /d01/oracle/VIS/19.3.0/appsutil/log/TXK_POST_PDB_Fri_Oct_10_10_53_30_2025/validate_apps_password.sql
==============================
Inside searchFileContents()...
==============================
log_file: /d01/oracle/VIS/19.3.0/appsutil/log/TXK_POST_PDB_Fri_Oct_10_10_53_30_2025/validate_apps_password.log
pattern: ERROR
=============================
Could not find the pattern...
=============================
EXIT STATUS: 0
Validated APPS credentials.
=======================================
Validating SYSTEM schema credentials...
=======================================
======================================
Inside checkSecCaseSensitiveLogon()...
======================================
Generating SQL file : /d01/oracle/VIS/19.3.0/appsutil/log/TXK_POST_PDB_Fri_Oct_10_10_53_30_2025/get_sec_case_sensitive_logon.sql
SQL output file : /d01/oracle/VIS/19.3.0/appsutil/log/TXK_POST_PDB_Fri_Oct_10_10_53_30_2025/get_sec_case_sensitive_logon.out
==========================
Inside executeSQLFile()...
==========================
Executing the SQL...
Execute SYSTEM command : sqlplus -s /nolog @/d01/oracle/VIS/19.3.0/appsutil/log/TXK_POST_PDB_Fri_Oct_10_10_53_30_2025/get_sec_case_sensitive_logon.sql
==============================
Inside searchFileContents()...
==============================
log_file: /d01/oracle/VIS/19.3.0/appsutil/log/TXK_POST_PDB_Fri_Oct_10_10_53_30_2025/get_sec_case_sensitive_logon.out
pattern: ERROR
=============================
Could not find the pattern...
=============================
EXIT STATUS: 0
Getting the parameter SEC_CASE_SENSITIVE_LOGON.
Parameter SEC_CASE_SENSITIVE_LOGON is set to FALSE.
sec_case_sensitive_logon_flag: FALSE
Generating SQL file : /d01/oracle/VIS/19.3.0/appsutil/log/TXK_POST_PDB_Fri_Oct_10_10_53_30_2025/validate_system_password.sql
SQL output file : /d01/oracle/VIS/19.3.0/appsutil/log/TXK_POST_PDB_Fri_Oct_10_10_53_30_2025/validate_system_password.log
==========================
Inside executeSQLFile()...
==========================
Executing the SQL...
Execute SYSTEM command : sqlplus -s /nolog @/d01/oracle/VIS/19.3.0/appsutil/log/TXK_POST_PDB_Fri_Oct_10_10_53_30_2025/validate_system_password.sql
Removing the file: /d01/oracle/VIS/19.3.0/appsutil/log/TXK_POST_PDB_Fri_Oct_10_10_53_30_2025/validate_system_password.sql
==============================
Inside searchFileContents()...
==============================
log_file: /d01/oracle/VIS/19.3.0/appsutil/log/TXK_POST_PDB_Fri_Oct_10_10_53_30_2025/validate_system_password.log
pattern: ERROR
=============================
Could not find the pattern...
=============================
EXIT STATUS: 0
Validated SYSTEM credentials.
=============================
Inside getADTXKCodeLevel()...
=============================
===============================
Inside getProductCodeLevel()...
===============================
product_code: ad
Generating SQL file : /d01/oracle/VIS/19.3.0/appsutil/log/TXK_POST_PDB_Fri_Oct_10_10_53_30_2025/get_code_level_ad.sql
SQL output file : /d01/oracle/VIS/19.3.0/appsutil/log/TXK_POST_PDB_Fri_Oct_10_10_53_30_2025/get_code_level_ad.out
==========================
Inside executeSQLFile()...
==========================
Executing the SQL...
Execute SYSTEM command : sqlplus -s /nolog @/d01/oracle/VIS/19.3.0/appsutil/log/TXK_POST_PDB_Fri_Oct_10_10_53_30_2025/get_code_level_ad.sql
==============================
Inside searchFileContents()...
==============================
log_file: /d01/oracle/VIS/19.3.0/appsutil/log/TXK_POST_PDB_Fri_Oct_10_10_53_30_2025/get_code_level_ad.out
pattern: ERROR
=============================
Could not find the pattern...
=============================
Removing the file: /d01/oracle/VIS/19.3.0/appsutil/log/TXK_POST_PDB_Fri_Oct_10_10_53_30_2025/get_code_level_ad.sql
EXIT STATUS: 0
Getting the code level...
code_level: C.16
===============================
Inside getProductCodeLevel()...
===============================
product_code: txk
Generating SQL file : /d01/oracle/VIS/19.3.0/appsutil/log/TXK_POST_PDB_Fri_Oct_10_10_53_30_2025/get_code_level_txk.sql
SQL output file : /d01/oracle/VIS/19.3.0/appsutil/log/TXK_POST_PDB_Fri_Oct_10_10_53_30_2025/get_code_level_txk.out
==========================
Inside executeSQLFile()...
==========================
Executing the SQL...
Execute SYSTEM command : sqlplus -s /nolog @/d01/oracle/VIS/19.3.0/appsutil/log/TXK_POST_PDB_Fri_Oct_10_10_53_30_2025/get_code_level_txk.sql
==============================
Inside searchFileContents()...
==============================
log_file: /d01/oracle/VIS/19.3.0/appsutil/log/TXK_POST_PDB_Fri_Oct_10_10_53_30_2025/get_code_level_txk.out
pattern: ERROR
=============================
Could not find the pattern...
=============================
Removing the file: /d01/oracle/VIS/19.3.0/appsutil/log/TXK_POST_PDB_Fri_Oct_10_10_53_30_2025/get_code_level_txk.sql
EXIT STATUS: 0
Getting the code level...
code_level: C.16
numeric_code_level: 16
**** AD_TXK_CODE_LEVEL = 16 ****
====================================
Inside getCompletionPatchStatus()...
====================================
===============================
Inside getProductCodeLevel()...
===============================
product_code: ebssys
Generating SQL file : /d01/oracle/VIS/19.3.0/appsutil/log/TXK_POST_PDB_Fri_Oct_10_10_53_30_2025/get_code_level_ebssys.sql
SQL output file : /d01/oracle/VIS/19.3.0/appsutil/log/TXK_POST_PDB_Fri_Oct_10_10_53_30_2025/get_code_level_ebssys.out
==========================
Inside executeSQLFile()...
==========================
Executing the SQL...
Execute SYSTEM command : sqlplus -s /nolog @/d01/oracle/VIS/19.3.0/appsutil/log/TXK_POST_PDB_Fri_Oct_10_10_53_30_2025/get_code_level_ebssys.sql
==============================
Inside searchFileContents()...
==============================
log_file: /d01/oracle/VIS/19.3.0/appsutil/log/TXK_POST_PDB_Fri_Oct_10_10_53_30_2025/get_code_level_ebssys.out
pattern: ERROR
=============================
Could not find the pattern...
=============================
Removing the file: /d01/oracle/VIS/19.3.0/appsutil/log/TXK_POST_PDB_Fri_Oct_10_10_53_30_2025/get_code_level_ebssys.sql
EXIT STATUS: 0
Getting the code level...
code_level: C.2
AD EBSSYS code level: C.2
numeric_code_level: 2
**** EBSSYS_CODE_LEVEL = 2 ****
**** Setting TNS_ADMIN to /d01/oracle/VIS/19.3.0/network/admin
==================================
Inside compileEBSLOGONTrigger()...
==================================
Generating SQL file : /d01/oracle/VIS/19.3.0/appsutil/log/TXK_POST_PDB_Fri_Oct_10_10_53_30_2025/compile_ebs_logon_trigger.sql
SQL output file : /d01/oracle/VIS/19.3.0/appsutil/log/TXK_POST_PDB_Fri_Oct_10_10_53_30_2025/compile_ebs_logon_trigger.out
==========================
Inside executeSQLFile()...
==========================
Executing the SQL...
Execute SYSTEM command : sqlplus -s /nolog @/d01/oracle/VIS/19.3.0/appsutil/log/TXK_POST_PDB_Fri_Oct_10_10_53_30_2025/compile_ebs_logon_trigger.sql
==============================
Inside searchFileContents()...
==============================
log_file: /d01/oracle/VIS/19.3.0/appsutil/log/TXK_POST_PDB_Fri_Oct_10_10_53_30_2025/compile_ebs_logon_trigger.out
pattern: ERROR
=============================
Could not find the pattern...
=============================
EXIT STATUS: 0
EBS_LOGON trigger compiled successfully.
LOG FILE: /d01/oracle/VIS/19.3.0/appsutil/log/TXK_POST_PDB_Fri_Oct_10_10_53_30_2025/compile_ebs_logon_trigger.out.
======================
Inside setASMFlag()...
======================
Generating SQL file : /d01/oracle/VIS/19.3.0/appsutil/log/TXK_POST_PDB_Fri_Oct_10_10_53_30_2025/get_datafile_location.sql
SQL output file : /d01/oracle/VIS/19.3.0/appsutil/log/TXK_POST_PDB_Fri_Oct_10_10_53_30_2025/get_datafile_location.out
==========================
Inside executeSQLFile()...
==========================
Executing the SQL...
Execute SYSTEM command : sqlplus -s /nolog @/d01/oracle/VIS/19.3.0/appsutil/log/TXK_POST_PDB_Fri_Oct_10_10_53_30_2025/get_datafile_location.sql
==============================
Inside searchFileContents()...
==============================
log_file: /d01/oracle/VIS/19.3.0/appsutil/log/TXK_POST_PDB_Fri_Oct_10_10_53_30_2025/get_datafile_location.out
pattern: ERROR
=============================
Could not find the pattern...
=============================
EXIT STATUS: 0
Getting the datafile location...
ASM_CDB_DATAFILE_LOC: /d01/oracle/VIS/oradata/VISCDB
first_char: /
ASM_FLAG: 0
================================
Inside setSystemCredentials()...
================================
Generating SQL file : /d01/oracle/VIS/19.3.0/appsutil/log/TXK_POST_PDB_Fri_Oct_10_10_53_30_2025/set_system_credentials.sql
SQL output file : /d01/oracle/VIS/19.3.0/appsutil/log/TXK_POST_PDB_Fri_Oct_10_10_53_30_2025/set_system_credentials.out
==========================
Inside executeSQLFile()...
==========================
Executing the SQL...
Execute SYSTEM command : sqlplus -s /nolog @/d01/oracle/VIS/19.3.0/appsutil/log/TXK_POST_PDB_Fri_Oct_10_10_53_30_2025/set_system_credentials.sql
Removing the file: /d01/oracle/VIS/19.3.0/appsutil/log/TXK_POST_PDB_Fri_Oct_10_10_53_30_2025/set_system_credentials.sql
==============================
Inside removeUnwantedInfo()...
==============================
input_file: /d01/oracle/VIS/19.3.0/appsutil/log/TXK_POST_PDB_Fri_Oct_10_10_53_30_2025/set_system_credentials.out
pattern: SYSTEM
==============================
Inside searchFileContents()...
==============================
log_file: /d01/oracle/VIS/19.3.0/appsutil/log/TXK_POST_PDB_Fri_Oct_10_10_53_30_2025/set_system_credentials.out
pattern: ERROR
=============================
Could not find the pattern...
=============================
EXIT STATUS: 0
SYSTEM credentials set successfully.
LOG FILE: /d01/oracle/VIS/19.3.0/appsutil/log/TXK_POST_PDB_Fri_Oct_10_10_53_30_2025/set_system_credentials.out.
**** Required AD/TXK Code Level (Delta 13 or above) is present. Checking COMPLETION patch status.
**** COMPLETION patch is applied. Need EBS_SYSTEM credentials.
stty: 'standard input': Inappropriate ioctl for device
Enter the EBS_SYSTEM Password:
stty: 'standard input': Inappropriate ioctl for device
=======================================
Validating SYSTEM schema credentials...
=======================================
======================================
Inside checkSecCaseSensitiveLogon()...
======================================
Generating SQL file : /d01/oracle/VIS/19.3.0/appsutil/log/TXK_POST_PDB_Fri_Oct_10_10_53_30_2025/get_sec_case_sensitive_logon.sql
SQL output file : /d01/oracle/VIS/19.3.0/appsutil/log/TXK_POST_PDB_Fri_Oct_10_10_53_30_2025/get_sec_case_sensitive_logon.out
==========================
Inside executeSQLFile()...
==========================
Executing the SQL...
Execute SYSTEM command : sqlplus -s /nolog @/d01/oracle/VIS/19.3.0/appsutil/log/TXK_POST_PDB_Fri_Oct_10_10_53_30_2025/get_sec_case_sensitive_logon.sql
==============================
Inside searchFileContents()...
==============================
log_file: /d01/oracle/VIS/19.3.0/appsutil/log/TXK_POST_PDB_Fri_Oct_10_10_53_30_2025/get_sec_case_sensitive_logon.out
pattern: ERROR
=============================
Could not find the pattern...
=============================
EXIT STATUS: 0
Getting the parameter SEC_CASE_SENSITIVE_LOGON.
Parameter SEC_CASE_SENSITIVE_LOGON is set to FALSE.
sec_case_sensitive_logon_flag: FALSE
Generating SQL file : /d01/oracle/VIS/19.3.0/appsutil/log/TXK_POST_PDB_Fri_Oct_10_10_53_30_2025/validate_ebs_system_password.sql
SQL output file : /d01/oracle/VIS/19.3.0/appsutil/log/TXK_POST_PDB_Fri_Oct_10_10_53_30_2025/validate_ebs_system_password.log
==========================
Inside executeSQLFile()...
==========================
Executing the SQL...
Execute SYSTEM command : sqlplus -s /nolog @/d01/oracle/VIS/19.3.0/appsutil/log/TXK_POST_PDB_Fri_Oct_10_10_53_30_2025/validate_ebs_system_password.sql
Removing the file: /d01/oracle/VIS/19.3.0/appsutil/log/TXK_POST_PDB_Fri_Oct_10_10_53_30_2025/validate_ebs_system_password.sql
==============================
Inside searchFileContents()...
==============================
log_file: /d01/oracle/VIS/19.3.0/appsutil/log/TXK_POST_PDB_Fri_Oct_10_10_53_30_2025/validate_ebs_system_password.log
pattern: ERROR
=============================
Could not find the pattern...
=============================
EXIT STATUS: 0
Validated EBS_SYSTEM credentials.
**** Setting TNS_ADMIN to /d01/oracle/VIS/19.3.0/network/admin/VIS_lin7 for PDB Connectivity.
==============================
Inside getEBSCustomTables()...
==============================
Generating SQL file : /d01/oracle/VIS/19.3.0/appsutil/log/TXK_POST_PDB_Fri_Oct_10_10_53_30_2025/get_user_table.sql
SQL output file : /d01/oracle/VIS/19.3.0/appsutil/log/TXK_POST_PDB_Fri_Oct_10_10_53_30_2025/get_user_table.out
==========================
Inside executeSQLFile()...
==========================
Executing the SQL...
Execute SYSTEM command : sqlplus -s /nolog @/d01/oracle/VIS/19.3.0/appsutil/log/TXK_POST_PDB_Fri_Oct_10_10_53_30_2025/get_user_table.sql
Removing the file: /d01/oracle/VIS/19.3.0/appsutil/log/TXK_POST_PDB_Fri_Oct_10_10_53_30_2025/get_user_table.sql
==============================
Inside searchFileContents()...
==============================
log_file: /d01/oracle/VIS/19.3.0/appsutil/log/TXK_POST_PDB_Fri_Oct_10_10_53_30_2025/get_user_table.out
pattern: ERROR
=============================
Could not find the pattern...
=============================
EXIT STATUS: 0
Getting the user tables.
Creating EBS custom views...
================================
Inside createEBSCustomViews()...
================================
Generating SQL file : /d01/oracle/VIS/19.3.0/appsutil/log/TXK_POST_PDB_Fri_Oct_10_10_53_30_2025/create_utl_file_views.sql
SQL output file : /d01/oracle/VIS/19.3.0/appsutil/log/TXK_POST_PDB_Fri_Oct_10_10_53_30_2025/create_utl_file_views.out
============================
Inside checkTableExists()...
============================
check_table_name = ebs_utlfile_param
Table exists.
============================
Inside checkTableExists()...
============================
check_table_name = ebs_utlfile_param_bk
Table does not exist.
============================
Inside checkTableExists()...
============================
check_table_name = ebs_utlfile_param
Table exists.
============================
Inside checkTableExists()...
============================
check_table_name = ebs_utlfile_param_bk
Table exists.
============================
Inside checkTableExists()...
============================
check_table_name = ebs_utlfile_param2
Table exists.
============================
Inside checkTableExists()...
============================
check_table_name = ebs_utlfile_param2_bk
Table does not exist.
============================
Inside checkTableExists()...
============================
check_table_name = ebs_utlfile_param2
Table exists.
============================
Inside checkTableExists()...
============================
check_table_name = ebs_utlfile_param2_bk
Table exists.
==========================
Inside executeSQLFile()...
==========================
Executing the SQL...
Execute SYSTEM command : sqlplus -s /nolog @/d01/oracle/VIS/19.3.0/appsutil/log/TXK_POST_PDB_Fri_Oct_10_10_53_30_2025/create_utl_file_views.sql
Removing the file: /d01/oracle/VIS/19.3.0/appsutil/log/TXK_POST_PDB_Fri_Oct_10_10_53_30_2025/create_utl_file_views.sql
==============================
Inside searchFileContents()...
==============================
log_file: /d01/oracle/VIS/19.3.0/appsutil/log/TXK_POST_PDB_Fri_Oct_10_10_53_30_2025/create_utl_file_views.out
pattern: ERROR
=============================
Could not find the pattern...
=============================
EXIT STATUS: 0
Table and view created succussfully.
=============================
Inside generateDBCtxFile()...
=============================
Creating the directory: /d01/oracle/VIS/19.3.0/appsutil/log/TXK_POST_PDB_Fri_Oct_10_10_53_30_2025/ctx_bkp
==========================
Inside setADBldXMLEnv()...
==========================
Environment set
ORACLE_HOME : /d01/oracle/VIS/19.3.0
TNS_ADMIN : /d01/oracle/VIS/19.3.0/network/admin/VIS_lin7
ORACLE_SID : VIS
PATH : /d01/oracle/VIS/19.3.0/perl/bin:/d01/oracle/VIS/19.3.0/bin:/usr/bin:/usr/sbin:/d01/oracle/VIS/19.3.0/appsutil/jre/bin:/d01/oracle/VIS/19.3.0/jdk/bin:/usr/ccs/bin:/bin:/usr/bin/X11:/usr/local/bin:/home/oracle/.local/bin:/home/oracle/bin:/usr/local/bin:/usr/bin:/usr/local/sbin:/usr/sbin
LD_LIBRARY_PATH : /d01/oracle/VIS/19.3.0/lib:/usr/X11R6/lib:/usr/openwin/lib:/usr/dt/lib:/d01/oracle/VIS/19.3.0/ctx/lib
DB_LISTENER : VISCDB
DISPLAY : localhost:10.0
Executing SYSTEM command: perl /d01/oracle/VIS/19.3.0/appsutil/bin/adbldxml.pl appsuser=apps servername=lin7.fritz.box
Starting context file generation for db tier..
Using CLASSPATH from /d01/oracle/VIS/19.3.0/jdbc/lib/ojdbc8.jar:/d01/oracle/VIS/19.3.0/appsutil/java:/d01/oracle/VIS/19.3.0/appsutil/java/xmlparserv2.jar:/d01/oracle/VIS/19.3.0/jlib/netcfg.jar:/d01/oracle/VIS/19.3.0/jlib/orai18n.jar:/d01/oracle/VIS/19.3.0/jlib/ldapjclnt19.jar to execute java programs..
Using JVM from /d01/oracle/VIS/19.3.0/appsutil/jre/bin/java to execute java programs..
java_cmd = /d01/oracle/VIS/19.3.0/appsutil/jre/bin/java -classpath /d01/oracle/VIS/19.3.0/jdbc/lib/ojdbc8.jar:/d01/oracle/VIS/19.3.0/appsutil/java:/d01/oracle/VIS/19.3.0/appsutil/java/xmlparserv2.jar:/d01/oracle/VIS/19.3.0/jlib/netcfg.jar:/d01/oracle/VIS/19.3.0/jlib/orai18n.jar:/d01/oracle/VIS/19.3.0/jlib/ldapjclnt19.jar
APPS Password: APPS Password:
The log file for this adbldxml session is located at:
/d01/oracle/VIS/19.3.0/appsutil/log/adbldxml_10101056.log
s_pluggable_database : true
s_pdb_name : VIS
The context file has been created at:
/d01/oracle/VIS/19.3.0/appsutil/VIS_lin7.xml
/d01/oracle/VIS/19.3.0/appsutil/bin/adbldxml.pl is executed successfully.
**** Setting ORACLE_SID to VISCDB
=====================
Inside getDBName()...
=====================
Generating SQL file : /d01/oracle/VIS/19.3.0/appsutil/log/TXK_POST_PDB_Fri_Oct_10_10_53_30_2025/get_db_name.sql
SQL output file : /d01/oracle/VIS/19.3.0/appsutil/log/TXK_POST_PDB_Fri_Oct_10_10_53_30_2025/get_db_name.out
==========================
Inside executeSQLFile()...
==========================
Executing the SQL...
Execute SYSTEM command : sqlplus -s /nolog @/d01/oracle/VIS/19.3.0/appsutil/log/TXK_POST_PDB_Fri_Oct_10_10_53_30_2025/get_db_name.sql
==============================
Inside searchFileContents()...
==============================
log_file: /d01/oracle/VIS/19.3.0/appsutil/log/TXK_POST_PDB_Fri_Oct_10_10_53_30_2025/get_db_name.out
pattern: ERROR
=============================
Could not find the pattern...
=============================
Removing the file: /d01/oracle/VIS/19.3.0/appsutil/log/TXK_POST_PDB_Fri_Oct_10_10_53_30_2025/get_db_name.sql
EXIT STATUS: 0
Getting the value of DB Name...
db_name: VIS
================================
Inside getApplsysSchemaUser()...
================================
Generating SQL file : /d01/oracle/VIS/19.3.0/appsutil/log/TXK_POST_PDB_Fri_Oct_10_10_53_30_2025/get_applsys_schema_user_name.sql
SQL output file : /d01/oracle/VIS/19.3.0/appsutil/log/TXK_POST_PDB_Fri_Oct_10_10_53_30_2025/get_applsys_schema_user_name.out
==========================
Inside executeSQLFile()...
==========================
Executing the SQL...
Execute SYSTEM command : sqlplus -s /nolog @/d01/oracle/VIS/19.3.0/appsutil/log/TXK_POST_PDB_Fri_Oct_10_10_53_30_2025/get_applsys_schema_user_name.sql
==============================
Inside searchFileContents()...
==============================
log_file: /d01/oracle/VIS/19.3.0/appsutil/log/TXK_POST_PDB_Fri_Oct_10_10_53_30_2025/get_applsys_schema_user_name.out
pattern: ERROR
=============================
Could not find the pattern...
=============================
Removing the file: /d01/oracle/VIS/19.3.0/appsutil/log/TXK_POST_PDB_Fri_Oct_10_10_53_30_2025/get_applsys_schema_user_name.sql
EXIT STATUS: 0
Getting the value of APPLSYS Schema User Name...
applsys_schema_user_name: APPLSYS
Updating s_ecx_log_dir and s_bis_debug_log_dir...
==============================
Inside updateECXBISCtxVar()...
==============================
========================
Inside updateCtxVar()...
========================
NAME : s_ecx_log_dir
VALUE : /d01/oracle/VIS/temp/VIS
Value of s_dbcset is AL32UTF8
Character set is not present in the allowed list. Need to add orai18n.jar to the CLASSPATH.
Library orai18n.jar exists.
update_status: 1
Update successful
========================
Inside updateCtxVar()...
========================
NAME : s_bis_debug_log_dir
VALUE : /d01/oracle/VIS/temp/VIS
Value of s_dbcset is AL32UTF8
Character set is not present in the allowed list. Need to add orai18n.jar to the CLASSPATH.
Library orai18n.jar exists.
update_status: 1
Update successful
================================
Inside instantiateTemplates()...
================================
Creating the directory: /d01/oracle/VIS/19.3.0/appsutil/log/TXK_POST_PDB_Fri_Oct_10_10_53_30_2025/actual_files_bkp
File /d01/oracle/VIS/19.3.0/VISCDB_lin7.env does not exist.
===========================
Inside instantiateFile()...
===========================
**************************************************************
File Instantiation:
-------------------
Template: /d01/oracle/VIS/19.3.0/appsutil/template/adcdb_ux_env.tmp
Instantiated location: /d01/oracle/VIS/19.3.0/VISCDB_lin7.env
**************************************************************
Value of s_dbcset is AL32UTF8
Character set is not present in the allowed list. Need to add orai18n.jar to the CLASSPATH.
Library orai18n.jar exists.
Executing SYSTEM command: /d01/oracle/VIS/19.3.0/appsutil/jre/bin/java -classpath :/d01/oracle/VIS/19.3.0/jdbc/lib/ojdbc8.jar:/d01/oracle/VIS/19.3.0/appsutil/java/xmlparserv2.jar:/d01/oracle/VIS/19.3.0/appsutil/java:/d01/oracle/VIS/19.3.0/jlib/netcfg.jar:/d01/oracle/VIS/19.3.0/jlib/ldapjclnt19.jar:/d01/oracle/VIS/19.3.0/jlib/orai18n.jar oracle.apps.ad.autoconfig.InstantiateFile -e /d01/oracle/VIS/19.3.0/appsutil/VIS_lin7.xml -tmpl /d01/oracle/VIS/19.3.0/appsutil/template/adcdb_ux_env.tmp -out /d01/oracle/VIS/19.3.0/VISCDB_lin7.env -promptmsg hide
File instantiation successful.
File /d01/oracle/VIS/19.3.0/appsutil/scripts/VIS_lin7/adcdblnctl.sh does not exist.
===========================
Inside instantiateFile()...
===========================
**************************************************************
File Instantiation:
-------------------
Template: /d01/oracle/VIS/19.3.0/appsutil/template/adcdblnctl_sh.tmp
Instantiated location: /d01/oracle/VIS/19.3.0/appsutil/scripts/VIS_lin7/adcdblnctl.sh
**************************************************************
Value of s_dbcset is AL32UTF8
Character set is not present in the allowed list. Need to add orai18n.jar to the CLASSPATH.
Library orai18n.jar exists.
Executing SYSTEM command: /d01/oracle/VIS/19.3.0/appsutil/jre/bin/java -classpath :/d01/oracle/VIS/19.3.0/jdbc/lib/ojdbc8.jar:/d01/oracle/VIS/19.3.0/appsutil/java/xmlparserv2.jar:/d01/oracle/VIS/19.3.0/appsutil/java:/d01/oracle/VIS/19.3.0/jlib/netcfg.jar:/d01/oracle/VIS/19.3.0/jlib/ldapjclnt19.jar:/d01/oracle/VIS/19.3.0/jlib/orai18n.jar oracle.apps.ad.autoconfig.InstantiateFile -e /d01/oracle/VIS/19.3.0/appsutil/VIS_lin7.xml -tmpl /d01/oracle/VIS/19.3.0/appsutil/template/adcdblnctl_sh.tmp -out /d01/oracle/VIS/19.3.0/appsutil/scripts/VIS_lin7/adcdblnctl.sh -promptmsg hide
File instantiation successful.
===========================
Inside cleanupDBTables()...
===========================
Generating SQL file : /d01/oracle/VIS/19.3.0/appsutil/log/TXK_POST_PDB_Fri_Oct_10_10_53_30_2025/cleanup_db_tables.sql
SQL output file : /d01/oracle/VIS/19.3.0/appsutil/log/TXK_POST_PDB_Fri_Oct_10_10_53_30_2025/cleanup_db_tables.log
==========================
Inside executeSQLFile()...
==========================
Executing the SQL...
Execute SYSTEM command : sqlplus -s /nolog @/d01/oracle/VIS/19.3.0/appsutil/log/TXK_POST_PDB_Fri_Oct_10_10_53_30_2025/cleanup_db_tables.sql
Removing the file: /d01/oracle/VIS/19.3.0/appsutil/log/TXK_POST_PDB_Fri_Oct_10_10_53_30_2025/cleanup_db_tables.sql
==============================
Inside searchFileContents()...
==============================
log_file: /d01/oracle/VIS/19.3.0/appsutil/log/TXK_POST_PDB_Fri_Oct_10_10_53_30_2025/cleanup_db_tables.log
pattern: ERROR
=============================
Could not find the pattern...
=============================
EXIT STATUS: 0
DB tables cleaned successfully.
LOG FILE: /d01/oracle/VIS/19.3.0/appsutil/log/TXK_POST_PDB_Fri_Oct_10_10_53_30_2025/cleanup_db_tables.log.
################# BEGIN AUTOCONFIG RUN #################
Executing SYSTEM command: /d01/oracle/VIS/19.3.0/perl/bin/perl /d01/oracle/VIS/19.3.0/appsutil/bin/adconfig.pl -contextfile=/d01/oracle/VIS/19.3.0/appsutil/VIS_lin7.xml -log=/d01/oracle/VIS/19.3.0/appsutil/log/TXK_POST_PDB_Fri_Oct_10_10_53_30_2025/acfg_log_Fri_Oct_10_10_53_30_2025.log
Log file: /d01/oracle/VIS/19.3.0/appsutil/log/TXK_POST_PDB_Fri_Oct_10_10_53_30_2025/acfg_log_Fri_Oct_10_10_53_30_2025.log
stty: 'standard input': Inappropriate ioctl for device
Enter the APPS user password:
stty: 'standard input': Inappropriate ioctl for device
The log file for this session is located at: /d01/oracle/VIS/19.3.0/appsutil/log/TXK_POST_PDB_Fri_Oct_10_10_53_30_2025/acfg_log_Fri_Oct_10_10_53_30_2025.log
AutoConfig is configuring the Database environment...
AutoConfig will consider the custom templates if present.
Using ORACLE_HOME location : /d01/oracle/VIS/19.3.0
Value of s_dbcset is AL32UTF8
Character set is not present in the allowed list. Need to add orai18n.jar to the CLASSPATH.
Library orai18n.jar exists.
Value of s_dbcset is AL32UTF8
Character set is not present in the allowed list. Need to add orai18n.jar to the CLASSPATH.
Library orai18n.jar exists.
Classpath : :/d01/oracle/VIS/19.3.0/jdbc/lib/ojdbc8.jar:/d01/oracle/VIS/19.3.0/appsutil/java/xmlparserv2.jar:/d01/oracle/VIS/19.3.0/appsutil/java:/d01/oracle/VIS/19.3.0/jlib/netcfg.jar:/d01/oracle/VIS/19.3.0/jlib/ldapjclnt19.jar:/d01/oracle/VIS/19.3.0/jlib/orai18n.jar
Using Context file : /d01/oracle/VIS/19.3.0/appsutil/VIS_lin7.xml
Context Value Management will now update the Context file
Updating Context file...COMPLETED
Attempting upload of Context file and templates to database...COMPLETED
Updating rdbms version in Context file to db19
Updating rdbms type in Context file to 64 bits
Configuring templates from ORACLE_HOME ...
AutoConfig completed successfully.
/d01/oracle/VIS/19.3.0/appsutil/bin/adconfig.pl is executed successfully.
################## END AUTOCONFIG RUN ##################
=================================
Inside getServiceNameFromCtx()...
=================================
Generating SQL file : /d01/oracle/VIS/19.3.0/appsutil/log/TXK_POST_PDB_Fri_Oct_10_10_53_30_2025/get_patch_service_name.sql
SQL output file : /d01/oracle/VIS/19.3.0/appsutil/log/TXK_POST_PDB_Fri_Oct_10_10_53_30_2025/get_patch_service_name.out
Spool File : /d01/oracle/VIS/19.3.0/appsutil/log/TXK_POST_PDB_Fri_Oct_10_10_53_30_2025/spool_get_patch_service_name.log
==========================
Inside executeSQLFile()...
==========================
Executing the SQL...
Execute SYSTEM command : sqlplus -s /nolog @/d01/oracle/VIS/19.3.0/appsutil/log/TXK_POST_PDB_Fri_Oct_10_10_53_30_2025/get_patch_service_name.sql
==============================
Inside searchFileContents()...
==============================
log_file: /d01/oracle/VIS/19.3.0/appsutil/log/TXK_POST_PDB_Fri_Oct_10_10_53_30_2025/get_patch_service_name.out
pattern: ERROR
=============================
Could not find the pattern...
=============================
Removing the file: /d01/oracle/VIS/19.3.0/appsutil/log/TXK_POST_PDB_Fri_Oct_10_10_53_30_2025/get_patch_service_name.sql
EXIT STATUS: 0
Getting the value of s_patch_service_name...
patch_service_name: VIS_ebs_patch
**** Setting TNS_ADMIN to /d01/oracle/VIS/19.3.0/network/admin
================================
Inside startEBSPatchService()...
================================
=========================================
Inside getServiceNameFromDBAServices()...
=========================================
Generating SQL file : /d01/oracle/VIS/19.3.0/appsutil/log/TXK_POST_PDB_Fri_Oct_10_10_53_30_2025/check_dba_services.sql
SQL output file : /d01/oracle/VIS/19.3.0/appsutil/log/TXK_POST_PDB_Fri_Oct_10_10_53_30_2025/check_dba_services.out
==========================
Inside executeSQLFile()...
==========================
Executing the SQL...
Execute SYSTEM command : sqlplus -s /nolog @/d01/oracle/VIS/19.3.0/appsutil/log/TXK_POST_PDB_Fri_Oct_10_10_53_30_2025/check_dba_services.sql
==============================
Inside searchFileContents()...
==============================
log_file: /d01/oracle/VIS/19.3.0/appsutil/log/TXK_POST_PDB_Fri_Oct_10_10_53_30_2025/check_dba_services.out
pattern: ERROR
=============================
Could not find the pattern...
=============================
EXIT STATUS: 0
Getting the service name from dba_services...
=====================
Service name found...
=====================
db_patch_service_name = VIS_ebs_patch
====================================
Inside checkPatchServiceRunning()...
====================================
Generating SQL file : /d01/oracle/VIS/19.3.0/appsutil/log/TXK_POST_PDB_Fri_Oct_10_10_53_30_2025/check_patch_service_status.sql
SQL output file : /d01/oracle/VIS/19.3.0/appsutil/log/TXK_POST_PDB_Fri_Oct_10_10_53_30_2025/check_patch_service_status.out
Spool File : /d01/oracle/VIS/19.3.0/appsutil/log/TXK_POST_PDB_Fri_Oct_10_10_53_30_2025/spool_check_patch_service_status.log
==========================
Inside executeSQLFile()...
==========================
Executing the SQL...
Execute SYSTEM command : sqlplus -s /nolog @/d01/oracle/VIS/19.3.0/appsutil/log/TXK_POST_PDB_Fri_Oct_10_10_53_30_2025/check_patch_service_status.sql
==============================
Inside searchFileContents()...
==============================
log_file: /d01/oracle/VIS/19.3.0/appsutil/log/TXK_POST_PDB_Fri_Oct_10_10_53_30_2025/check_patch_service_status.out
pattern: ERROR
=============================
Could not find the pattern...
=============================
EXIT STATUS: 0
Checking service is active or not.
patch_service_active: 1
Patch service already running. Do nothing.
**** Setting ORACLE_PDB_SID to VIS
File /d01/oracle/VIS/19.3.0/dbs/VISCDB_pwd_reuse_prf.txt does not exist.
**** Resetting ORACLE_PDB_SID to NULL
======================================
Inside checkPDBCaseSensitiveParam()...
======================================
Generating SQL file : /d01/oracle/VIS/19.3.0/appsutil/log/TXK_POST_PDB_Fri_Oct_10_10_53_30_2025/get_case_sensitive_param.sql
SQL output file : /d01/oracle/VIS/19.3.0/appsutil/log/TXK_POST_PDB_Fri_Oct_10_10_53_30_2025/get_case_sensitive_param.out
Spool File : /d01/oracle/VIS/19.3.0/appsutil/log/TXK_POST_PDB_Fri_Oct_10_10_53_30_2025/spool_get_case_sensitive_param.log
==========================
Inside executeSQLFile()...
==========================
Executing the SQL...
Execute SYSTEM command : sqlplus -s /nolog @/d01/oracle/VIS/19.3.0/appsutil/log/TXK_POST_PDB_Fri_Oct_10_10_53_30_2025/get_case_sensitive_param.sql
Removing the file: /d01/oracle/VIS/19.3.0/appsutil/log/TXK_POST_PDB_Fri_Oct_10_10_53_30_2025/get_case_sensitive_param.sql
==============================
Inside searchFileContents()...
==============================
log_file: /d01/oracle/VIS/19.3.0/appsutil/log/TXK_POST_PDB_Fri_Oct_10_10_53_30_2025/get_case_sensitive_param.out
pattern: ERROR
=============================
Could not find the pattern...
=============================
EXIT STATUS: 0
Getting the parameter value.
Parameter _PDB_NAME_CASE_SENSITIVE is set to TRUE.
=======================
Saving the PDB state...
=======================
Generating SQL file : /d01/oracle/VIS/19.3.0/appsutil/log/TXK_POST_PDB_Fri_Oct_10_10_53_30_2025/save_PDB_state.sql
SQL output file : /d01/oracle/VIS/19.3.0/appsutil/log/TXK_POST_PDB_Fri_Oct_10_10_53_30_2025/save_PDB_state.out
==========================
Inside executeSQLFile()...
==========================
Executing the SQL...
Execute SYSTEM command : sqlplus -s /nolog @/d01/oracle/VIS/19.3.0/appsutil/log/TXK_POST_PDB_Fri_Oct_10_10_53_30_2025/save_PDB_state.sql
==============================
Inside searchFileContents()...
==============================
log_file: /d01/oracle/VIS/19.3.0/appsutil/log/TXK_POST_PDB_Fri_Oct_10_10_53_30_2025/save_PDB_state.out
pattern: ERROR
=============================
Could not find the pattern...
=============================
EXIT STATUS: 0
PDB state saved successfully.
LOG FILE: /d01/oracle/VIS/19.3.0/appsutil/log/TXK_POST_PDB_Fri_Oct_10_10_53_30_2025/save_PDB_state.out.
Exiting from the script.
Ended: Fri Oct 10 10:56:54 CEST 2025
[oracle@lin7 appsutil]$ # Modify initialization parameters
[oracle@lin7 appsutil]$ export ORACLE_SID=VISCDB
[oracle@lin7 appsutil]$ sqlplus -S / as sysdba <<EOF
> alter system reset core_dump_dest;
> alter system reset "_pdb_name_case_sensitive";
> alter system set event="10946 trace name context forever, level 8454144" scope=spfile;
> alter system set optimizer_secure_view_merging=false;
> alter system set shared_pool_size=600m scope=spfile;
> alter system set shared_pool_reserved_size=60m scope=spfile;
> alter system set filesystemio_options = 'SETALL' scope=spfile;
> alter system set sec_case_sensitive_logon = false;
> alter session set container=VIS;
> alter system set temp_undo_enabled=false;
> alter session set container=cdb\$root;
> shutdown immediate
> startup
> EOF
alter system reset core_dump_dest
*
ERROR at line 1:
ORA-32010: cannot find entry to delete in SPFILE
System altered.
System altered.
System altered.
System altered.
System altered.
System altered.
System altered.
Session altered.
System altered.
Session altered.
Database closed.
Database dismounted.
ORACLE instance shut down.
ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance
ORACLE instance started.
Total System Global Area 2147480352 bytes
Fixed Size 9179936 bytes
Variable Size 1157627904 bytes
Database Buffers 956301312 bytes
Redo Buffers 24371200 bytes
Database mounted.
Database opened.
[oracle@lin7 appsutil]$ # Run AutoConfig on applications tier
[oracle@lin7 appsutil]$ cat >>/d01/oracle/VIS/fs1/inst/apps/VIS_$hn/ora/10.1.2/network/admin/tnsnames.ora <<EOF
>
> viscdb_$hn.fritz.box=
> (DESCRIPTION=
> (ADDRESS=(PROTOCOL=tcp)(HOST=$hn.fritz.box)(PORT=1521))
> (CONNECT_DATA=(SERVICE_NAME=ebs_VIS)(INSTANCE_NAME=VISCDB)
> )
> )
> EOF
[oracle@lin7 appsutil]$
[oracle@lin7 appsutil]$ sed -i s/'<jdbc_url oa_var=\"s_apps_jdbc_connect_descriptor.*'/' <jdbc_url oa_var=\"s_apps_jdbc_connect_descriptor\"><\/jdbc_url>'/ /d01/oracle/VIS/fs1/inst/apps/VIS_$hn/appl/admin/VIS_$hn.xml
[oracle@lin7 appsutil]$ sed -i s/'<APPLPTMP oa_var=\"s_applptmp\".*'/' <APPLPTMP oa_var=\"s_applptmp\" osd=\"UNIX\">\/d01\/oracle\/VIS\/temp\/VIS<\/APPLPTMP>'/ /d01/oracle/VIS/fs1/inst/apps/VIS_$hn/appl/admin/VIS_$hn.xml
[oracle@lin7 appsutil]$ . /d01/oracle/VIS/EBSapps.env run
E-Business Suite Environment Information
----------------------------------------
RUN File System : /d01/oracle/VIS/fs1/EBSapps/appl
PATCH File System : /d01/oracle/VIS/fs2/EBSapps/appl
Non-Editioned File System : /d01/oracle/VIS/fs_ne
DB Host: lin7.fritz.box Service/SID: VIS
Sourcing the RUN File System ...
[oracle@lin7 appsutil]$ echo apps|$INST_TOP/admin/scripts/adautocfg.sh
stty: 'standard input': Inappropriate ioctl for device
Enter the APPS user password:
stty: 'standard input': Inappropriate ioctl for device
The log file for this session is located at: /d01/oracle/VIS/fs1/inst/apps/VIS_lin7/admin/log/10101057/adconfig.log
wlsDomainName: EBS_domain_VIS
WLS Domain Name is VALID.
AutoConfig is configuring the Applications environment...
AutoConfig will consider the custom templates if present.
Using CONFIG_HOME location : /d01/oracle/VIS/fs1/inst/apps/VIS_lin7
Classpath : /d01/oracle/VIS/fs1/FMW_Home/Oracle_EBS-app1/shared-libs/ebs-appsborg/WEB-INF/lib/ebsAppsborgManifest.jar:/d01/oracle/VIS/fs1/EBSapps/comn/java/classes
Using Context file : /d01/oracle/VIS/fs1/inst/apps/VIS_lin7/appl/admin/VIS_lin7.xml
Context Value Management will now update the Context file
Updating Context file...COMPLETED
Attempting upload of Context file and templates to database...COMPLETED
Configuring templates from all of the product tops...
Configuring AD_TOP........COMPLETED
Configuring FND_TOP.......COMPLETED
Configuring ICX_TOP.......COMPLETED
Configuring MSC_TOP.......COMPLETED
Configuring IEO_TOP.......COMPLETED
Configuring BIS_TOP.......COMPLETED
Configuring CZ_TOP........COMPLETED
Configuring SHT_TOP.......COMPLETED
Configuring AMS_TOP.......COMPLETED
Configuring CCT_TOP.......COMPLETED
Configuring WSH_TOP.......COMPLETED
Configuring CLN_TOP.......COMPLETED
Configuring OKE_TOP.......COMPLETED
Configuring OKL_TOP.......COMPLETED
Configuring OKS_TOP.......COMPLETED
Configuring CSF_TOP.......COMPLETED
Configuring IBY_TOP.......COMPLETED
Configuring JTF_TOP.......COMPLETED
Configuring MWA_TOP.......COMPLETED
Configuring CN_TOP........COMPLETED
Configuring CSI_TOP.......COMPLETED
Configuring WIP_TOP.......COMPLETED
Configuring CSE_TOP.......COMPLETED
Configuring EAM_TOP.......COMPLETED
Configuring GMF_TOP.......COMPLETED
Configuring PON_TOP.......COMPLETED
Configuring FTE_TOP.......COMPLETED
Configuring ONT_TOP.......COMPLETED
Configuring AR_TOP........COMPLETED
Configuring AHL_TOP.......COMPLETED
Configuring IES_TOP.......COMPLETED
Configuring OZF_TOP.......COMPLETED
Configuring CSD_TOP.......COMPLETED
Configuring IGC_TOP.......COMPLETED
AutoConfig completed successfully.
[oracle@lin7 appsutil]$ exit
logout
[root@lin7 ~]# su - oracle
Last login: Fri Oct 10 10:53:30 CEST 2025 on pts/0
[oracle@lin7 ~]$ hn=`hostname|awk -F. {'print $1'}`
[oracle@lin7 ~]$ . /d01/oracle/VIS/EBSapps.env run
E-Business Suite Environment Information
----------------------------------------
RUN File System : /d01/oracle/VIS/fs1/EBSapps/appl
PATCH File System : /d01/oracle/VIS/fs2/EBSapps/appl
Non-Editioned File System : /d01/oracle/VIS/fs_ne
DB Host: lin7.fritz.box Service/SID: VIS
Sourcing the RUN File System ...
[oracle@lin7 ~]$ # Restart applications tier server processes
[oracle@lin7 ~]$ (echo apps; echo apps; echo welcome1)|/d01/oracle/VIS/fs1/inst/apps/VIS_$hn/admin/scripts/adstrtal.sh
You are running adstrtal.sh version 120.24.12020000.11
Enter the APPS username: stty: 'standard input': Inappropriate ioctl for device
Enter the APPS password:
Enter the WebLogic Server password:
stty: 'standard input': Inappropriate ioctl for device
The logfile for this session is located at /d01/oracle/VIS/fs1/inst/apps/VIS_lin7/logs/appl/admin/log/adstrtal.log
Executing service control script:
/d01/oracle/VIS/fs1/inst/apps/VIS_lin7/admin/scripts/jtffmctl.sh start
Timeout specified in context file: 100 second(s)
script returned:
****************************************************
You are running jtffmctl.sh version 120.3.12020000.4
Validating Fulfillment patch level via /d01/oracle/VIS/fs1/EBSapps/comn/java/classes
Fulfillment patch level validated.
Starting Fulfillment Server for VIS on port 9300 ...
jtffmctl.sh: exiting with status 0
.end std out.
.end err out.
****************************************************
Executing service control script:
/d01/oracle/VIS/fs1/inst/apps/VIS_lin7/admin/scripts/adopmnctl.sh start
Timeout specified in context file: 100 second(s)
script returned:
****************************************************
You are running adopmnctl.sh version 120.0.12020000.2
Starting Oracle Process Manager (OPMN) ...
adopmnctl.sh: exiting with status 0
adopmnctl.sh: check the logfile /d01/oracle/VIS/fs1/inst/apps/VIS_lin7/logs/appl/admin/log/adopmnctl.txt for more information ...
.end std out.
.end err out.
****************************************************
Executing service control script:
/d01/oracle/VIS/fs1/inst/apps/VIS_lin7/admin/scripts/adapcctl.sh start
Timeout specified in context file: 100 second(s)
script returned:
****************************************************
You are running adapcctl.sh version 120.0.12020000.6
Starting OPMN managed Oracle HTTP Server (OHS) instance ...
adapcctl.sh: exiting with status 0
adapcctl.sh: check the logfile /d01/oracle/VIS/fs1/inst/apps/VIS_lin7/logs/appl/admin/log/adapcctl.txt for more information ...
.end std out.
.end err out.
****************************************************
Executing service control script:
/d01/oracle/VIS/fs1/inst/apps/VIS_lin7/admin/scripts/adnodemgrctl.sh start -nopromptmsg
Timeout specified in context file: -1 second(s)
script returned:
****************************************************
You are running adnodemgrctl.sh version 120.11.12020000.12
Calling txkChkEBSDependecies.pl to perform dependency checks for ALL MANAGED SERVERS
Perl script txkChkEBSDependecies.pl got executed successfully
Starting the Node Manager...
Refer /d01/oracle/VIS/fs1/inst/apps/VIS_lin7/logs/appl/admin/log/adnodemgrctl.txt for details
NodeManager log is located at /d01/oracle/VIS/fs1/FMW_Home/wlserver_10.3/common/nodemanager/nmHome1
adnodemgrctl.sh: exiting with status 0
adnodemgrctl.sh: check the logfile /d01/oracle/VIS/fs1/inst/apps/VIS_lin7/logs/appl/admin/log/adnodemgrctl.txt for more information ...
.end std out.
*** ALL THE FOLLOWING FILES ARE REQUIRED FOR RESOLVING RUNTIME ERRORS
*** Log File = /d01/oracle/VIS/fs1/inst/apps/VIS_lin7/logs/appl/rgf/TXK/txkChkEBSDependecies_Fri_Oct_10_11_02_25_2025/txkChkEBSDependecies_Fri_Oct_10_11_02_25_2025.log
.end err out.
****************************************************
Executing service control script:
/d01/oracle/VIS/fs1/inst/apps/VIS_lin7/admin/scripts/adalnctl.sh start
Timeout specified in context file: 100 second(s)
script returned:
****************************************************
adalnctl.sh version 120.3.12020000.4
Checking for FNDFS executable.
Starting listener process APPS_VIS.
adalnctl.sh: exiting with status 0
adalnctl.sh: check the logfile /d01/oracle/VIS/fs1/inst/apps/VIS_lin7/logs/appl/admin/log/adalnctl.txt for more information ...
.end std out.
.end err out.
****************************************************
Executing service control script:
/d01/oracle/VIS/fs1/inst/apps/VIS_lin7/admin/scripts/adcmctl.sh start
Timeout specified in context file: 1000 second(s)
script returned:
****************************************************
You are running adcmctl.sh version 120.19.12020000.7
Starting concurrent manager for VIS ...
Starting VIS_1010@VIS Internal Concurrent Manager
Default printer is noprint
adcmctl.sh: exiting with status 0
adcmctl.sh: check the logfile /d01/oracle/VIS/fs1/inst/apps/VIS_lin7/logs/appl/admin/log/adcmctl.txt for more information ...
.end std out.
.end err out.
****************************************************
Executing service control script:
/d01/oracle/VIS/fs1/inst/apps/VIS_lin7/admin/scripts/adadminsrvctl.sh start -nopromptmsg
Timeout specified in context file: -1 second(s)
script returned:
****************************************************
You are running adadminsrvctl.sh version 120.10.12020000.11
Starting WLS Admin Server...
Refer /d01/oracle/VIS/fs1/inst/apps/VIS_lin7/logs/appl/admin/log/adadminsrvctl.txt for details
AdminServer logs are located at /d01/oracle/VIS/fs1/FMW_Home/user_projects/domains/EBS_domain_VIS/servers/AdminServer/logs
adadminsrvctl.sh: exiting with status 0
adadminsrvctl.sh: check the logfile /d01/oracle/VIS/fs1/inst/apps/VIS_lin7/logs/appl/admin/log/adadminsrvctl.txt for more information ...
.end std out.
.end err out.
****************************************************
Executing service control script:
/d01/oracle/VIS/fs1/inst/apps/VIS_lin7/admin/scripts/admanagedsrvctl.sh start forms_server1 -nopromptmsg
Timeout specified in context file: -1 second(s)
script returned:
****************************************************
You are running admanagedsrvctl.sh version 120.14.12020000.12
Starting forms_server1...
Server specific logs are located at /d01/oracle/VIS/fs1/FMW_Home/user_projects/domains/EBS_domain_VIS/servers/forms_server1/logs
admanagedsrvctl.sh: exiting with status 0
admanagedsrvctl.sh: check the logfile /d01/oracle/VIS/fs1/inst/apps/VIS_lin7/logs/appl/admin/log/adformsctl.txt for more information ...
.end std out.
.end err out.
****************************************************
Executing service control script:
/d01/oracle/VIS/fs1/inst/apps/VIS_lin7/admin/scripts/admanagedsrvctl.sh start oafm_server1 -nopromptmsg
Timeout specified in context file: -1 second(s)
script returned:
****************************************************
You are running admanagedsrvctl.sh version 120.14.12020000.12
Starting oafm_server1...
Server specific logs are located at /d01/oracle/VIS/fs1/FMW_Home/user_projects/domains/EBS_domain_VIS/servers/oafm_server1/logs
admanagedsrvctl.sh: exiting with status 0
admanagedsrvctl.sh: check the logfile /d01/oracle/VIS/fs1/inst/apps/VIS_lin7/logs/appl/admin/log/adoafmctl.txt for more information ...
.end std out.
.end err out.
****************************************************
Executing service control script:
/d01/oracle/VIS/fs1/inst/apps/VIS_lin7/admin/scripts/admanagedsrvctl.sh start oacore_server1 -nopromptmsg
Timeout specified in context file: -1 second(s)
script returned:
****************************************************
You are running admanagedsrvctl.sh version 120.14.12020000.12
Starting oacore_server1...
Server specific logs are located at /d01/oracle/VIS/fs1/FMW_Home/user_projects/domains/EBS_domain_VIS/servers/oacore_server1/logs
admanagedsrvctl.sh: exiting with status 0
admanagedsrvctl.sh: check the logfile /d01/oracle/VIS/fs1/inst/apps/VIS_lin7/logs/appl/admin/log/adoacorectl.txt for more information ...
.end std out.
.end err out.
****************************************************
All enabled services for this node are started.
adstrtal.sh: Exiting with status 0
adstrtal.sh: check the logfile /d01/oracle/VIS/fs1/inst/apps/VIS_lin7/logs/appl/admin/log/adstrtal.log for more information ...
[oracle@lin7 ~]$The database of the Oracle E-Business Suite system is now on Oracle 19c with the latest Patch Set Update (PSU) applied and the Application is running again 🙂
Leave a Reply