Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Autupgrade under Windows pluging into cdb fails.

DarkwingDuckDec 14 2021

Im try to Plug in an noncdb into an CDB by autoupgrade.
Configfile locks like this:
global.autoupg_log_dir=T:\TEMP\uptemp
upg1.log_dir=T:\TEMP\uptemp
upg1.dbname=TRY
upg1.sid=TRY
upg1.start_time=NOW
upg1.source_home=P:\app\oracle\product\19c\home2
upg1.target_home=P:\app\oracle\product\19c\home2
upg1.target_version=19
upg1.restoration=no
upg1.upgrade_node=WINUP
upg1.target_cdb=HAUS19
upg1.target_pdb_name=R19PDB3
P:\app\oracle\autoupgrade>java -jar autoupgrade.jar -version
build.hash 081e3f7
build.version 21.3.211115
build.date 2021/11/15 11:57:54
build.max_target_version 21
build.supported_target_versions 12.2,18,19,21
build.type production

P:\app\oracle\autoupgrade>java -version
java version "1.8.0_311"
Java(TM) SE Runtime Environment (build 1.8.0_311-b11)
Java HotSpot(TM) 64-Bit Server VM (build 25.311-b11, mixed mode)

at line 1:
ORA-65026: XML metadata file error : LPX-00202: could not open "T:\TEMP\uptemp\TRY\101\noncdbtopdb\R19PDB3.xml" (error 0)
ORA-06512: at "SYS.DBMS_PDB", line 13
ORA-06512: at line 1
] [TRY]]
2021-12-14 23:00:20.261 ERROR Dispatcher failed: AutoUpgException [UPG-3001#java.sql.SQLException: Errors executing [exec dbms_pdb.describe(pdb_descr_file => 'T:\TEMP\uptemp\TRY\101\noncdbtopdb\R19PDB3.xml');
BEGIN dbms_pdb.describe(pdb_descr_file => 'T:\TEMP\uptemp\TRY\101\noncdbtopdb\R19PDB3.xml'); END;
*

The Problem is, that the database (running under the user "oracle") has no access to the directory containing the xml file.
The strange thing is:
I gave oracle access to directory T:\TEMP\uptemp and enabled inheritance.
Autoupgrade (running as Administrator) creates two directories:
cfgtoollogs - here, Oracle gets the rights by inheritance.
try (the SID of the datebase) - here, inheritance does NOT work, oracle gets no rights.
Therefore the xml File can not be acccessed.

Any ideas?

Comments

Post Details

Added on Dec 14 2021
1 comment
331 views