![]() ![]()
Input Directory d = /u01/app/oracle/product/12102/racdb/rdbms/adminĪnalyzing file /u01/app/oracle/product/12102/racdb/rdbms/admin/catupgrd.sql Note the follwing step will take some time racdb]$ $ORACLE_HOME/perl/bin/perl $ORACLE_HOME/rdbms/admin/ -d $ORACLE_HOME/rdbms/admin -c 'PDB1' catupgrd.sqlĪrgument list for Key software oracle olr cannot be opened.error 2 upgrade#SQL> alter pluggable database PDB1 open upgrade SQL> create pluggable database pdb1 using '/stage/pdb1.xml' file_name_convert=('/oradata/CDB1/pdb1', '/oradata/CDB2/pdb1') PENDINGĪPEX mismatch: PDB installed version 4.2.0.00.27 CDB installed version 4.2.5.00.08 PENDINGĪs we use the same ASM datafile we don't need to use file_name_convert running create pluggable database SQL> create pluggable database pdb1 using '/home/oracle/RAC/UPGRADE/pdb1.xml' PDB's version does not match CDB's version: PDB's version 12.1.0.0.0. SQL>select message, status from pdb_plug_in_violations where type like '%ERR%' > Compatibiltiy Check will result in "NO" - but obviously the plugin operation will work Check pdb_plug_in_violations Pdb_descr_file => '/home/oracle/RAC/UPGRADE//pdb1.xml', SQL> alter session set container=CDB$ROOT Ĭompatible CONSTANT VARCHAR2(3) := CASE DBMS_PDB.CHECK_PLUG_COMPATIBILITY( ![]() SQL> alter pluggable database PDB1 unplug into '/home/oracle/RAC/UPGRADE/pdb1.xml' SQL> alter pluggable database PDB1 close immediate instances=all SQL> PRE-UPGRADE RESULTS for PDB1 alter sesstion set container=CDB$ROOT Run preugrd script on PDB1 and prepare for plugin UPGRADE]$ sqlplus sys/sys as sysdba SQL> select INST_ID, CON_ID, DBID, CON_UID, GUID, NAME, OPEN_MODE, RESTRICTED from gv$pdbs where NAME='PDB1' When running preupgrd.sql in a CDB, make sure all the PDBs are opened. Switch to your source 12.1.0.1 Oracle Home. tmp and run the UPGRADE]$ cp /u01/app/oracle/product/12102/racdb/rdbms/admin/preupgrd.sql UPGRADE]$ cp /u01/app/oracle/product/12102/racdb/rdbms/admin/utluppkg.sql. Now copy preupgrd.sql and utluppkg.sql from the new home into a temp directory eg. Preferably, this should be a temp directory. > Create an empty Container database : dbname : cdbn Run preupgrade scripts in 12.1.0.1 PDB ( no impact to our production env ) Copy preupgrd.sql and utluppkg.sql from the rdbms/admin directory of the new Oracle home where you installed Oracle Databaseġ2c to a directory that is accessible when you connect to your source database, which is the database to be upgraded. Create a new CDB database ( no impact to our production env ) After OUI finishes run /u01/app/oracle/product/12102/racdb/root.sh on all nodes Run any fixup scripts if there are fixable ~]# /tmp/CVU_12.1.0.2.0_oracle/runfixup.shĪll Fix-up operations were completed ~]# ssh ~]# /tmp/CVU_12.1.0.2.0_oracle/runfixup.shĪll Fix-up operations were completed successfully. ![]() Key software oracle olr cannot be opened.error 2 install#Run OUI and install 12.0.1.2 by using software ONLY database]$ database]$. Install 12.1.0.2 software ( no impact to our production env ) Create new ORACLE_HOME on all custer nodes and install 12.1.0.2 ~]# mkdir -p ~]# chown oracle:oinstall ~]# chmod 775 /u01/app/oracle/product/12102/racdb
1 Comment
7/2/2023 03:11:56 pm
En iyi istanbul ilan sitesi burada. https://istanbul.escorthun.com/
Reply
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |