Home » RDBMS Server » Server Administration » Upgarding 10g database to 11g
Upgarding 10g database to 11g [message #269223] Fri, 21 September 2007 04:30 Go to next message
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 ?
Re: Upgarding 10g database to 11g [message #269230 is a reply to message #269223] Fri, 21 September 2007 04:56 Go to previous message
Michel Cadot
Messages: 64102
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You didn't follow the documentation.
Re-read it and follow EXACTLTY the instructions.

Regards
Michel
Previous Topic: Not able to startup db in nomount mode after 10g_home installation
Next Topic: Oracle and 64bit AMD processor
Goto Forum:
  


Current Time: Fri Dec 02 19:01:29 CST 2016

Total time taken to generate the page: 0.14496 seconds