Home » RDBMS Server » Enterprise Manager » OEM 10g to 12c (2 system upgrade process) (Oracle Linux 64bit)
OEM 10g to 12c (2 system upgrade process) [message #592347] Tue, 06 August 2013 11:50 Go to next message
wlirio
Messages: 9
Registered: August 2013
Location: WPB, FL
Junior Member
Helo, I new to the form.
I am also in a bit of a bind with my upgrade.

I am not a DBA but I got assigned to support OEM at the company I work for and was sent to the OEM 12c install and upgrade class provided by Oracle. As with every class things work as designed in a classroom environment but not in the real world.

Following the same procedure I did in class I started working on the 10g to 12c 2 system upgrade. Everything went well until I reached the step to copy the existing database to the new server. The steps say to use DBCA in the existing 10g database and create database template with data. That work perfectly and it created a template about 10 gigs in size.

THe next steps the in the procedure calls for me to copy the template files to the new server 11g and use DBCA and create database using the template I created in the previous step. When DBCA gets to about 40% progress is fails with the errors below:
ORA-01092, ORA-00704 and ORA-39700.
See attached screenshot.

My environment
Source
OEM 10g 10.2.0.5.0
DB 10g 10.2.0.3.0

Target
OEM 12c
DB 11g 11.2.0.1.0

Thanks for your help
Re: OEM 10g to 12c (2 system upgrade process) [message #592351 is a reply to message #592347] Tue, 06 August 2013 13:53 Go to previous messageGo to next message
LKBrwn_DBA
Messages: 439
Registered: July 2003
Location: WPB, FL
Senior Member
You could select the "create scripts" option instead of "create database" and execute them manually.

[Updated on: Tue, 06 August 2013 14:33] by Moderator

Report message to a moderator

Re: OEM 10g to 12c (2 system upgrade process) [message #592352 is a reply to message #592351] Tue, 06 August 2013 14:01 Go to previous messageGo to next message
wlirio
Messages: 9
Registered: August 2013
Location: WPB, FL
Junior Member
I will give that a try.
Re: OEM 10g to 12c (2 system upgrade process) [message #592396 is a reply to message #592352] Wed, 07 August 2013 09:34 Go to previous messageGo to next message
wlirio
Messages: 9
Registered: August 2013
Location: WPB, FL
Junior Member
I launched DBCA this morning and did not see the option to "create Scripts"
My only options available are:
Create a Database
Confugure Database Options
Delete Database
Manage Templates
Re: OEM 10g to 12c (2 system upgrade process) [message #592399 is a reply to message #592396] Wed, 07 August 2013 10:02 Go to previous messageGo to next message
LKBrwn_DBA
Messages: 439
Registered: July 2003
Location: WPB, FL
Senior Member
wlirio wrote on Wed, 07 August 2013 10:34
I launched DBCA this morning and did not see the option to "create Scripts"
My only options available are:
Create a Database
Confugure Database Options
Delete Database
Manage Templates

Are you sure? You have to get to the end ...
./fa/11048/0/

  • Attachment: dbca.jpg
    (Size: 79.50KB, Downloaded 534 times)

[Updated on: Wed, 07 August 2013 10:10] by Moderator

Report message to a moderator

Re: OEM 10g to 12c (2 system upgrade process) [message #592414 is a reply to message #592399] Wed, 07 August 2013 12:24 Go to previous messageGo to next message
wlirio
Messages: 9
Registered: August 2013
Location: WPB, FL
Junior Member
Surprised hahaha yup I only looked at the first screen. Now that I see your screenshot it looks very familiar.
Thanks
Re: OEM 10g to 12c (2 system upgrade process) [message #592416 is a reply to message #592414] Wed, 07 August 2013 12:56 Go to previous messageGo to next message
wlirio
Messages: 9
Registered: August 2013
Location: WPB, FL
Junior Member
Ok scripts generated with no issues. I am no DBA so sorry if my next question sounds dumb Confused
I looked at the contents of the scripts generated and from the look of it all I need to do is execute the em12rep.sh and that will execute the rest of the sql files as it needs them. Is that accurate assumption from my part?
Re: OEM 10g to 12c (2 system upgrade process) [message #592419 is a reply to message #592416] Wed, 07 August 2013 15:56 Go to previous messageGo to next message
LKBrwn_DBA
Messages: 439
Registered: July 2003
Location: WPB, FL
Senior Member
In one of the scripts (probably an sql script) there must be a "STARTUP". just change it to "STARTUP UPGRADE".

[Updated on: Thu, 08 August 2013 00:16] by Moderator

Report message to a moderator

Re: OEM 10g to 12c (2 system upgrade process) [message #592438 is a reply to message #592419] Thu, 08 August 2013 07:09 Go to previous messageGo to next message
wlirio
Messages: 9
Registered: August 2013
Location: WPB, FL
Junior Member
I found the "startup" command in 3 sql files
CloneRmanRestore.sql
startup nomount pfile="/oracle/oraclehomes/admin/em12rep/scripts/init.ora";

cloneDBCreation.sql
startup nomount pfile="/oracle/oraclehomes/admin/em12rep/scripts/initem12repTemp.ora";

postDBCreation.sql
startup ;

Should I change "startup" to "startup upgrade" on all 3 scripts as I show below?

startup upgrade nomount pfile="/oracle/oraclehomes/admin/em12rep/scripts/init.ora";
startup upgrade nomount pfile="/oracle/oraclehomes/admin/em12rep/scripts/initem12repTemp.ora";
startup upgrade;
Re: OEM 10g to 12c (2 system upgrade process) [message #592463 is a reply to message #592438] Thu, 08 August 2013 11:42 Go to previous messageGo to next message
wlirio
Messages: 9
Registered: August 2013
Location: WPB, FL
Junior Member
I ran it with the changes I described above and got this error.
SP2-0714: invalid combination of STARTUP options
going to revert back to just startup and see what I get
Re: OEM 10g to 12c (2 system upgrade process) [message #592473 is a reply to message #592463] Thu, 08 August 2013 13:08 Go to previous messageGo to next message
wlirio
Messages: 9
Registered: August 2013
Location: WPB, FL
Junior Member
I got the error below:
**********************************************
SQL> alter database "em12rep" open resetlogs;
alter database "em12rep" open resetlogs
*
ERROR at line 1:
ORA-01092: ORACLE instance terminated. Disconnection forced
ORA-00704: bootstrap process failure
ORA-39700: database must be opened with UPGRADE option
Process ID: 14033
Session ID: 133 Serial number: 1


SQL> exec dbms_service.delete_service('emrep');
ERROR:
ORA-03114: not connected to ORACLE
**********************************************

I guess I need that upgrade option but how would I add it to the script.
When did this: startup upgrade nomount pfile="/oracle/oraclehomes/admin/em12rep/scripts/initem12repTemp.ora";
It did not like it and gave me this error: SP2-0714: invalid combination of STARTUP options
Re: OEM 10g to 12c (2 system upgrade process) [message #592474 is a reply to message #592473] Thu, 08 August 2013 13:18 Go to previous messageGo to next message
BlackSwan
Messages: 22841
Registered: January 2009
Senior Member
consider to install the same V10 software on the new system.
Verify that the DB ca be opened using the V10 software, then do a clean SHUTDOWN IMMEDIATE.
Next run V11 dbua to upgrade the DB to V11.
Re: OEM 10g to 12c (2 system upgrade process) [message #592475 is a reply to message #592473] Thu, 08 August 2013 13:22 Go to previous message
wlirio
Messages: 9
Registered: August 2013
Location: WPB, FL
Junior Member
attached is the log of the cloneDBCreation.log
Previous Topic: Configure Data Guard with Enterprise Manager
Next Topic: undo tablespace issues
Goto Forum:
  


Current Time: Wed Oct 01 08:52:33 CDT 2014

Total time taken to generate the page: 0.21195 seconds