1 2 Previous Next 15 Replies Latest reply: Nov 20, 2012 4:33 PM by 300230 Go to original post RSS
      • 15. Re: Reg Voting disk
        300230
        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