Syed Saad Ali
Syed Saad Ali

Oracle ACE Pro

Oracle Solution Architect

Oracle E-Business Suite

Oracle Cloud Infrastructure

Oracle Fusion Middleware

Oracle Database Administration

Oracle Weblogic Administration

Syed Saad Ali
Syed Saad Ali

Oracle ACE Pro

Oracle Solution Architect

Oracle E-Business Suite

Oracle Cloud Infrastructure

Oracle Fusion Middleware

Oracle Database Administration

Oracle Weblogic Administration

AppsDBA CV Download CV Contact Me

Month: May 2017

May 14, 2017 ORA-39700: database must be opened with upgrade option
Errors/Workarounds10gErrors/Workarounds11gOracle Database Material

ERROR

ORA-39700: database must be opened with upgrade option

SOLUTION

Step 1: Open with Upgrade Option

SQL> startup upgrade;

 

Step 2: upgrade database – it means run script $ORACLE_HOME/rdbms/admin/catupgrd.sql

SQL> @/u01/app/oracle/product/11.2.0/db_home1/rdbms/admin/catupgrd.sql;
Step 3: Shutdown database and Startup

SQL> shutdown immediate;

SQL> startup;

 

Step 4: Run script $ORACLE_HOME/rdbms/admin/utlrp.sql – for recompile all invalid PL/SQL packages

SQL> @/u01/app/oracle/product/11.2.0/db_home1/rdbms/admin/utlrp.sql

 

 

May 14, 2017 EBS 12.1 and 12.2 certified on IBM AIX 7.2
NEWS AND UPDATES

EBS 12.1 and 12.2 certified on IBM AIX 7.2

By: John Abraham | Director

I am pleased to announce that Oracle E-Business Suite Releases 12.1.3 and 12.2.3 (and later updates to those respective releases) are now certified on AIX 7.2, the latest operating system for the IBM AIX on Power Systems (64-bit) platform.

Installations of E-Business Suite on these operating systems require specific patches to the latest startCD prior to installing, followed by the application of the 12.1.3 RUP or the 12.2.3 RUP (or higher) for EBS 12.1 and 12.2 respectively. Cloning of existing EBS 12.1.3 or 12.2 environments to AIX 7.2 is also certified using the standard Rapid Clone process.

There are specific requirements to upgrade technology components such as the Oracle Database (to 11.2.0.4 or 12.1.0.2) and Fusion Middleware components as necessary. All requirements, known issues, patches needed, etc. are noted in the Installation and Upgrade Notes (IUN) below and must be reviewed and implemented.

The Certifications page (‘Certify’) on My Oracle Support is in the process of being updated with this information.

References

Related Articles

Source: https://blogs.oracle.com/stevenchan/ebs-121-and-122-certified-on-ibm-aix-72

 

 

May 13, 2017 ORA-12720: operation requires database is in EXCLUSIVE mode
Errors/Workarounds10gErrors/Workarounds11gOracle Database Material

ERROR

CREATE CONTROLFILE .................................
   .................................................
CHARACTER SET AL32UTF8;

ERROR at line 1:
ORA-01503: CREATE CONTROLFILE failed
ORA-12720: operation requires database is in EXCLUSIVE mode

SOLUTION

SQL> alter system set cluster_database=FALSE scope=spfile sid='*';
SQL> shutdown immediate; 
SQL>startup nomount;

Now, re-run script for creating controlfile 

CREATE CONTROLFILE .................................
   .................................................
CHARACTER SET AL32UTF8;

Control file created.

Then, change parameter with its old value and restart database.

SQL>alter system set cluster_database=TRUE scope=spfile sid='*';
May 13, 2017 Friday Spotlight: Migrate Virtual Machines from VMware to Oracle VM
NEWS AND UPDATES

Friday Spotlight: Migrate Virtual Machines from VMware to Oracle VM

By: Simon Coter | Director of Product Management

We are very pleased to announce a new whitepaper and tool that help customers migrate virtual machines from VMware to Oracle VM.

More and more customers would like to move away from the high cost and proprietary virtualization solution to the open cloud infrastructure built on Oracle Linux and Oracle VM. In this white paper, we discuss 4 methods to approach what was a painful migration from VMware to Oracle VM; in fact, into this whitepaper you’ll find 4 different main chapters:

  • Migration using Open Virtualization Format (OVA)
  • Migration using data replication
  • Conversion using open-source utilities
  • Automated migration using CLI interfaces

And for each section above you’ll also have a Pros/Cons table that will help to address the migration with the best solution possible.

The “Automated migration tool” is a solution based on a very simple script that it’s able to interact with both VMware CLI and Oracle VM CLI interfaces with the target to automate the export/import job from VMware to Oracle VM.

This script has been released to help our customers to migrate their virtual machines to Oracle VM 3.4. Please feel free to write your ideas or possible improvements for the script on this blog post.

Source: https://blogs.oracle.com/virtualization/migrate-vms-from-vmware-to-ovm

 

 

All Rights Reserved