Home » RDBMS Server » Server Administration » dbua (Oracle 11gR2 , 11.2.0.2 AIX)
dbua [message #524090] Wed, 21 September 2011 14:34 Go to next message
tkmittal1
Messages: 143
Registered: May 2007
Location: Delhi
Senior Member
Hi,

I am trying to upgrade the oracle 9.2.0.8 database in oracle 11.2.0.2. I have installed the new oracle home for 11g and after running the pre-upgrade script and setting the all environment variable like oracle base, oracle home, oracle sid and ora_nls

i am running the dbua but after click on finish button it's do the processing of 2% but after that i get

-------------------------------------------------
ORA-12709 error while loading create
database character set
--------------------------------------------------

Can you please suggest work around for the same

Thanks

Report message to a moderator

Re: dbua [message #524097 is a reply to message #524090] Wed, 21 September 2011 14:41 Go to previous messageGo to next message
Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
 
ORA-12709: error while loading create database character set
 *Cause: Internal error
 *Action:

Is there any other error?
Is there anything in alert.log?
Is there any trace file?

Regards
Michel

Report message to a moderator

Re: dbua [message #524098 is a reply to message #524090] Wed, 21 September 2011 14:42 Go to previous messageGo to next message
Flyby
Messages: 188
Registered: March 2011
Location: Belgium
Senior Member
failover to manual upgrade? dbua can be tricky (like "found file x, will stop").

Report message to a moderator

Re: dbua [message #524103 is a reply to message #524098] Wed, 21 September 2011 14:50 Go to previous messageGo to next message
Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
I (almost) never had any problem with dbua when configuration is correct (juts in 9.0 but this can be count out as this was the worst version Oracle ever delivered).

Regards
Michel

Report message to a moderator

Re: dbua [message #524117 is a reply to message #524098] Wed, 21 September 2011 22:37 Go to previous messageGo to next message
tkmittal1
Messages: 143
Registered: May 2007
Location: Delhi
Senior Member

Thanks for your response

There is no other error and i have just tried to upgrade manually and it' done without any issue but i need to upgrade it through dbua and getting the same message

Please suggest

Report message to a moderator

Re: dbua [message #524118 is a reply to message #524117] Wed, 21 September 2011 22:40 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
open a Service Request with My Oracle Support

Report message to a moderator

Re: dbua [message #524119 is a reply to message #524118] Wed, 21 September 2011 22:55 Go to previous messageGo to next message
tkmittal1
Messages: 143
Registered: May 2007
Location: Delhi
Senior Member
i have just found the message in preupgrade.log

------------------------------------------------------
Database dismounted.
ORACLE instance shut down.
Connected to an idle instance.
select count(*) from v$instance
*
ERROR at line 1:
ORA-01034: ORACLE not available

Connected to an idle instance.
ORACLE instance started.
Total System Global Area 2.3088E+10 bytes
Fixed Size 773384 bytes
Variable Size 1.1409E+10 bytes
Database Buffers 1.1677E+10 bytes
Redo Buffers 1912832 bytes
ORA-12709: error while loading create database character set
------------------------------------------------------

Report message to a moderator

Re: dbua [message #524120 is a reply to message #524119] Wed, 21 September 2011 23:07 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
YES, an error gets reported.

http://surachartopun.com/2009/08/ora-12709-error-while-loading-create.html

Report message to a moderator

Re: dbua [message #524123 is a reply to message #524120] Wed, 21 September 2011 23:20 Go to previous messageGo to next message
tkmittal1
Messages: 143
Registered: May 2007
Location: Delhi
Senior Member
There is no permission issue

Report message to a moderator

Re: dbua [message #524138 is a reply to message #524123] Thu, 22 September 2011 00:50 Go to previous messageGo to next message
Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Michel Cadot wrote on Wed, 21 September 2011 21:41
ORA-12709: error while loading create database character set
 *Cause: Internal error
 *Action:

Is there any other error?
Is there anything in alert.log?
Is there any trace file?

Regards
Michel

Report message to a moderator

Re: dbua [message #524288 is a reply to message #524138] Thu, 22 September 2011 11:53 Go to previous messageGo to next message
tkmittal1
Messages: 143
Registered: May 2007
Location: Delhi
Senior Member
No Alert file generated and no other error. I just found the ORA-12709 in trace file

Report message to a moderator

Re: dbua [message #524289 is a reply to message #524288] Thu, 22 September 2011 12:21 Go to previous message
Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Quote:
No Alert file generated

The alert.log ALWAYS exists. It is created the first you start the instance as your database already exists the alert.log too.

Regards
Michel

Report message to a moderator

Previous Topic: USER ID FETCHING
Next Topic: standby database
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Nov 29 04:33:37 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.