This discussion is archived
1 2 Previous Next 15 Replies Latest reply: Nov 20, 2012 2:33 PM by 300230 Go to original post RSS
  • 15. Re: Reg Voting disk
    300230 Newbie
    Currently Being Moderated
    Hi All,
    Finally we have successfully Installed the Clusterware and RAC database.
    OS: is Windows 2008
    Oracle: 11.2.0.3.
    RAC with ASM.
    During this past month we had multiple issues but figured out one at a time.
    The current issue is as under:
    The current Production is, (OS windows 2003, Oracle 10.1.0.4 non-ASM)
    The Future Production is, (OS windows 2008, Oracle 11.2.0.3 ASM)
    So you see all three catagories are different, OS, version of Oracle and non-ASM to ASM.
    The software is installed, we have the database which is working.
    The question is we want to move the data from the current to the future.
    We used DATAPUMP but it failed with errors as below.

    ****************************************************
    Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
    With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
    Data Mining and Real Application Testing options
    Master table "SYS"."SYS_IMPORT_FULL_01" successfully loaded/unloaded
    Starting "SYS"."SYS_IMPORT_FULL_01": "sys/********@ractest1 AS SYSDBA" full=y directory=DATAPUMP_IMPORT dumpfile=DEVLEXPORT_NOV202012.dmp logfile=devlimport_nov202012.log
    Processing object type DATABASE_EXPORT/TABLESPACE
    ORA-31684: Object type TABLESPACE:"TEMP" already exists
    ORA-39083: Object type TABLESPACE failed to create with error:
    ORA-01119: error in creating database file 'O:\ORADATA\DEVL\BUSOBJ01.DBF'
    ORA-27040: file create error, unable to create file
    OSD-04002: unable to open file
    O/S-Error: (OS 3) The system cannot find the path specified.
    Failing sql is:
    ****************************************************
    I would appriciate any help...

    Thanks to all...

    As we proceed I will keep you all updated.

    Thanks

    Habeeb
1 2 Previous Next

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points