DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 12

Thread: Upgrade 10g

  1. 09-01-2005, 11:10 AM #1
    Thomasps
    Thomasps is offline Advisor
    Join Date
    Apr 2001
    Location
    Bangalore, India
    Posts
    727

    Upgrade 10g

    While upgraing 9.2.0.6 database ( in windows ) to 10G, I got the following error

    C:\Documents and Settings\Administrator>sqlplus / as sysdba

    SQL*Plus: Release 10.1.0.2.0 - Production on Thu Sep 1 15:57:33 2005

    Copyright (c) 1982, 2004, Oracle. All rights reserved.


    Connected to:
    Oracle9i Enterprise Edition Release 9.2.0.5.0 - Production
    With the Partitioning, OLAP and Oracle Data Mining options
    JServer Release 9.2.0.5.0 - Production

    SQL> @D:\Oracle\10g\RDBMS\ADMIN\u0902000.sql
    DOC>######################################################################
    DOC>######################################################################
    DOC> The following statement will cause an "ORA-01722: invalid number"
    DOC> error if the database server version is not correct for this script.
    DOC> Shutdown ABORT and use a different script or a different server.
    DOC>######################################################################
    DOC>######################################################################
    DOC>#
    SELECT TO_NUMBER('MUST_BE_10') FROM v$instance
    *
    ERROR at line 1:
    ORA-01722: invalid number


    Disconnected from Oracle9i Enterprise Edition Release 9.2.0.5.0 - Production
    With the Partitioning, OLAP and Oracle Data Mining options
    JServer Release 9.2.0.5.0 - Production
    The script is correct. What could be the problem?
    Thomas Saviour(royxavier@yahoo.com)
    Technical Lead (Databases)
    Thomson Reuters (Markets)

    http://ora600tom.wordpress.com/
    Reply With Quote Reply With Quote
  2. 09-01-2005, 01:35 PM #2
    adewri's Avatar
    adewri
    adewri is offline Oracle Monk
    Join Date
    Nov 2002
    Location
    New Delhi, INDIA
    Posts
    1,796
    If I'm not wrong then you are running the database from Oracle9i software. For manual migration you first need to start the database using the Oracle10g software.
    Amar
    "There is a difference between knowing the path and walking the path."

    Amar's Blog  Get Firefox!
    Reply With Quote Reply With Quote
  3. 09-01-2005, 01:39 PM #3
    pando
    pando is offline Pando & Company
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    did you startup with upgrade option
    Last edited by pando; 09-01-2005 at 01:42 PM.
    Reply With Quote Reply With Quote
  4. 09-02-2005, 04:38 AM #4
    Thomasps
    Thomasps is offline Advisor
    Join Date
    Apr 2001
    Location
    Bangalore, India
    Posts
    727
    C:\Documents and Settings\Administrator>sqlplus / as sysdba

    SQL*Plus: Release 10.1.0.2.0 - Production on Fri Sep 2 09:39:32 2005

    Copyright (c) 1982, 2004, Oracle. All rights reserved.

    Connected to an idle instance.

    SQL> startup upgrade
    ORACLE instance started.

    Total System Global Area 261169040 bytes
    Fixed Size 454544 bytes
    Variable Size 234881024 bytes
    Database Buffers 25165824 bytes
    Redo Buffers 667648 bytes
    Database mounted.
    Database opened.
    SQL> @D:\Oracle\10g\RDBMS\ADMIN\u0902000.sql
    DOC>######################################################################
    DOC>######################################################################
    DOC> The following statement will cause an "ORA-01722: invalid number"
    DOC> error if the database server version is not correct for this script.
    DOC> Shutdown ABORT and use a different script or a different server.
    DOC>######################################################################
    DOC>######################################################################
    DOC>#
    SELECT TO_NUMBER('MUST_BE_10') FROM v$instance
    *
    ERROR at line 1:
    ORA-01722: invalid number


    Disconnected from Oracle9i Enterprise Edition Release 9.2.0.5.0 - Production
    With the Partitioning, OLAP and Oracle Data Mining options
    JServer Release 9.2.0.5.0 - Production
    Above script shows that I starting the database in 10g with "migrate " option. Still...
    Thomas Saviour(royxavier@yahoo.com)
    Technical Lead (Databases)
    Thomson Reuters (Markets)

    http://ora600tom.wordpress.com/
    Reply With Quote Reply With Quote
  5. 09-02-2005, 04:47 AM #5
    adewri's Avatar
    adewri
    adewri is offline Oracle Monk
    Join Date
    Nov 2002
    Location
    New Delhi, INDIA
    Posts
    1,796
    Try running utlu101i.sql file. Copy this file from ORACLE_HOME/rdbms/admin directory to another location outside ORACLE_HOME.

    This script provides information about databases to be upgraded to 10.1

    Have a look here before running this...

    http://download-west.oracle.com/docs....htm#sthref136
    Last edited by adewri; 09-02-2005 at 04:53 AM.
    Amar
    "There is a difference between knowing the path and walking the path."

    Amar's Blog  Get Firefox!
    Reply With Quote Reply With Quote
  6. 09-02-2005, 05:09 AM #6
    Thomasps
    Thomasps is offline Advisor
    Join Date
    Apr 2001
    Location
    Bangalore, India
    Posts
    727
    I did run those scripts before starting the upgrade... See the out put, everything looks fine except the shared pool. Good thing is I re-sized shared pool and restarted database. When I run the utlu101i.sql again, it will give me a higher value again. It happened 3 times...
    SQL> @D:\Oracle\10g\RDBMS\ADMIN\utlu101i.sql
    Oracle Database 10.1 Upgrade Information Tool 09-02-2005 10:05:30
    .
    *************************************************************************
    Database:
    ---------
    --> name: TEST
    --> version: 9.2.0.5.0
    --> compatibility: 9.2.0.0.0
    .
    *************************************************************************
    Logfiles: [make adjustments in the current environment]
    ----------------------------------------------------
    -- The existing log files are adequate. No changes are required.
    .
    *************************************************************************
    Tablespaces: [make adjustments in the current environment]
    ----------------------------------------------------------
    --> SYSTEM tablespace is adequate for the upgrade.
    .... owner: SYS
    .... minimum required size: 207 MB
    .
    *************************************************************************
    Options: [present in existing database]
    ---------------------------------------
    --> Partitioning
    WARNING: Listed option(s) must be installed with Oracle Database 10.1
    .
    *************************************************************************
    Update Parameters: [Update Oracle Database 10.1 init.ora or spfile]
    -------------------------------------------------------------------
    WARNING: --> "shared_pool_size" needs to be increased to at least "201326592
    --> "pga_aggregate_target" is already at "25165824" calculated new value is
    "25165824"
    --> "large_pool_size" is already at "16777216" calculated new value is
    "16777216"
    --> "java_pool_size" is already at "50331648" calculated new value is "50331
    .
    *************************************************************************
    Deprecated Parameters: [Update Oracle Database 10.1 init.ora or spfile]
    -----------------------------------------------------------------------
    -- No deprecated parameters found. No changes are required.
    .
    *************************************************************************
    Obsolete Parameters: [Update Oracle Database 10.1 init.ora or spfile]
    ---------------------------------------------------------------------
    --> "hash_join_enabled"
    --> "log_archive_start"
    .
    *************************************************************************
    Components: [The following database components will be upgraded or installed
    ----------------------------------------------------------------------------
    --> Oracle Catalog Views [upgrade] VALID
    --> Oracle Packages and Types [upgrade] VALID
    .
    *************************************************************************
    .
    *************************************************************************
    SYSAUX Tablespace: [Create tablespace in Oracle Database 10.1 environment]
    --------------------------------------------------------------------------
    WARNING: SYSAUX tablespace is present.
    .... Minimum required size for database upgrade:500 MB
    .... Online
    .... Permanent
    .... Readwrite
    .... ExtentManagementLocal
    .... SegmentSpaceManagementAuto
    .
    *************************************************************************
    Also, the compatibility identified in the script is

    --> name: TEST
    --> version: 9.2.0.5.0
    --> compatibility: 9.2.0.0.0

    So I am running the script u0902000.sql. Again I am getting the error at the SQL

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

    I didn't understand what is the meaning of this SQL..!
    Thomas Saviour(royxavier@yahoo.com)
    Technical Lead (Databases)
    Thomson Reuters (Markets)

    http://ora600tom.wordpress.com/
    Reply With Quote Reply With Quote
  7. 09-02-2005, 05:29 AM #7
    adewri's Avatar
    adewri
    adewri is offline Oracle Monk
    Join Date
    Nov 2002
    Location
    New Delhi, INDIA
    Posts
    1,796
    What does select version FROM v$instance; show ?
    Amar
    "There is a difference between knowing the path and walking the path."

    Amar's Blog  Get Firefox!
    Reply With Quote Reply With Quote
  8. 09-02-2005, 07:29 AM #8
    Thomasps
    Thomasps is offline Advisor
    Join Date
    Apr 2001
    Location
    Bangalore, India
    Posts
    727
    Code:
    SQL> select * from v$version;

BANNER
----------------------------------------------------------------
Oracle9i Enterprise Edition Release 9.2.0.5.0 - Production
PL/SQL Release 9.2.0.5.0 - Production
CORE    9.2.0.6.0       Production
TNS for 32-bit Windows: Version 9.2.0.5.0 - Production
NLSRTL Version 9.2.0.5.0 - Production
    Thomas Saviour(royxavier@yahoo.com)
    Technical Lead (Databases)
    Thomson Reuters (Markets)

    http://ora600tom.wordpress.com/
    Reply With Quote Reply With Quote
  9. 09-02-2005, 07:36 AM #9
    davey23uk
    davey23uk is offline Senior Advisor
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    version from v$instance not v$version
    Reply With Quote Reply With Quote
  10. 09-02-2005, 09:46 AM #10
    Thomasps
    Thomasps is offline Advisor
    Join Date
    Apr 2001
    Location
    Bangalore, India
    Posts
    727
    Woops..
    Sorry

    SQL> select version from v$instance;

    VERSION
    -----------------
    9.2.0.5.0
    Thomas Saviour(royxavier@yahoo.com)
    Technical Lead (Databases)
    Thomson Reuters (Markets)

    http://ora600tom.wordpress.com/
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules

Click Here to Expand Forum to Full Width