Forum Stats

  • 3,840,393 Users
  • 2,262,599 Discussions
  • 7,901,261 Comments

Discussions

Autupgrade under Windows pluging into cdb fails.

DarkwingDuck
DarkwingDuck Member Posts: 227 Blue Ribbon

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?

Answers

  • Dejan T.
    Dejan T. Member Posts: 433 Silver Badge

    Hi,

    I had a similar issue - the solution is simple - just use hte directory, where oracle user is allowed to create directories and write into them. You can for example use %ORACLE_HOME%\rdbms\log .

    BR

    Dejan