OraFAQ Forum: Server Administration » Upgarding 10g database to 11g

Home » RDBMS Server » Server Administration » Upgarding 10g database to 11g

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Upgarding 10g database to 11g [message #269223]

Fri, 21 September 2007 04:30

rolex.mp
Messages: 161
Registered: February 2007

Senior Member

I have created 10g database in Linux .

Now I want to upgrade it to 11g.

I have installed 11g software in my Linux machine .

I logged in as sysdba and then I did shut down the 10g db . Later I started it up in upgarde mode and tried running catupgrd.sql.

But I got the error as ORA-01722: invalid number

When I looked into catupgrd.sql script I found this information

######################################################################
######################################################################
The following statement will cause an "ORA-01722: invalid number"
error if the database server version is not correct for this script.Shutdown ABORT and use a different script or a different server.
######################################################################
######################################################################
#

SELECT TO_NUMBER('MUST_BE_11_1') FROM v$instance
WHERE substr(version,1,6) != '11.1.0';

So I checked the columns of v$instance

SQL> select instance_name,HOST_NAME,VERSION,STATUS,DATABASE_STATUS,ACTIVE_STATE from v$instance;

INSTANCE_NAME HOST_NAME VERSION STATUS DATABASE_STATUS ACTIVE_ST
----------------
learn11 ap6108rt 10.2.0.1.0 OPEN MIGRATE ACTIVE NORMAL

What should be done to change the version ?

Report message to a moderator