• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar
  • Skip to footer navigation

The Geek Diary

  • OS
    • Linux
    • CentOS/RHEL
    • Solaris
    • Oracle Linux
    • VCS
  • Interview Questions
  • Database
    • oracle
    • oracle 12c
    • ASM
    • mysql
    • MariaDB
  • DevOps
    • Docker
    • Shell Scripting
  • Big Data
    • Hadoop
    • Cloudera
    • Hortonworks HDP

How to upgrade RMAN catalog SCHEMA from 11g to 12.1.0.2 without upgrading the catalog database

by admin

Question: Our rman catalog database is 11.2.0.3 right now, do I need to upgrade the database to 12.1.0.2 first, and then upgrade the catalog to 12.1.0.2?

The version of the RMAN catalog database does not need to match that of the recovery catalog. Therefore you can upgrade the RMAN catalog without upgrading the RMAN database. This is true of any version of the database, not only 12c.

If you are intending to upgrade the catalog schema to 12c then you need to run these 2 scripts:

@$ORACLE_HOME/rdbms/admin/dbmsrmansys.sql
@$ORACLE_HOME/rdbms/admin/dbmsrmanvpc.sql 

If you are only upgrading the RMAN catalog, but not the database itself you’ll need to do this:

1. set your environment to a 12.1.0.2 $ORACLE_HOME.

2. connect to the RMAN catalog via an Oracle Net alias. For example:

$ sqlplus sys@RMANDEV as sysdba

SQL*Plus: Release 12.1.0.2.0 Production on Wed Jan 21 10:44:26 2015

Copyright (c) 1982, 2014, Oracle.  All rights reserved.

Enter password: 

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SYS@RMANDEV> SELECT name from v$database;

NAME
---------
RMANDEV


SYS@RMANDEV> host echo $ORACLE_HOME
/opt/app/oracle/product/12.1.0/db_1

SYS@RMANDEV> @$ORACLE_HOME/rdbms/admin/dbmsrmansys.sql 
alter session set "_ORACLE_SCRIPT" = true
                 *
ERROR at line 1:
ORA-02248: invalid option for ALTER SESSION

PL/SQL procedure successfully completed.
PL/SQL procedure successfully completed.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.

alter session set "_ORACLE_SCRIPT" = false
                 *
ERROR at line 1:
ORA-02248: invalid option for ALTER SESSION

The ORA-02248 error can be ignored. This “_ORACLE_SCRIPT” is a 12c parameter and will only work in a 12c database.

Filed Under: oracle, Oracle 11g, oracle 12c, RMAN

Some more articles you might also be interested in …

  1. How to limit access to oracle database so that only 1 user per schema is connected ( 1 Concurrent user per schema)
  2. How to Enable Fast-Start Failover using Enterprise Manager
  3. Patching and Upgrading Databases in Oracle Data Guard Configuration
  4. ORA-65208: Lockdown profile P1 does not exist
  5. Oracle Data Guard Command Line Reference (Cheat Sheet)
  6. TRUNCATE TABLE not releasing space from tablespace
  7. How to Move tables and indexes to a different tablespace
  8. Unable to create spfile for Oracle ASM instance
  9. Auditing with Oracle Database Vault Reports
  10. How to get datafile information when PDB is Mounted/Read-Write/Restricted Mode

You May Also Like

Primary Sidebar

Recent Posts

  • vgextend Command Examples in Linux
  • setpci command – configure PCI device
  • db_load command – generate db database
  • bsdtar command – Read and write tape archive files

© 2022 · The Geek Diary

  • Archives
  • Contact Us
  • Copyright