1 Reply Latest reply: Apr 23, 2013 6:37 AM by Vikz28 RSS

    Oracle Fail safe - adding a Database

    861037
      Hi

      I am trying to add a 9.2.0.8 database into ORacle Failsafe 3.3.4 and keep getting the following error

      20 01:21:03 FS-10381: GI-XXX-XXX : Creating the resource information for resource SJGWS
      21 01:21:03 > FS-10424: Checking whether the database XXXX is online
      22 01:21:29 > FS-10425: Querying the disks used by the database XXXXX
      23 01:21:30 ** WARNING : FS-10404: The database uses a nonclustered disk in one of the system parameters. Value of parameter is C:\oracle\admin\XXXX\bdump
      24 01:21:30 ** WARNING : FS-10404: The database uses a nonclustered disk in one of the system parameters. Value of parameter is C:\oracle\admin\XXXX\cdump
      25 01:21:30 ** WARNING : FS-10404: The database uses a nonclustered disk in one of the system parameters. Value of parameter is C:\oracle\admin\XXXX\udump
      26 01:21:30 ** ERROR : 0x2: The system cannot find the file specified.

      27 01:21:30 ** ERROR : FS-10711: Failed to create resource OracleHOME92TNSListenerFslsjg-vdb in the cluster
      28 01:21:30 ** ERROR : FS-10040: Failed to create the database resource OracleHOME92TNSListenerFslsjg-vdb
      29 01:21:30 ** ERROR : FS-10778: The Oracle Database resource provider failed to configure the cluster resource SJGWS
      30 01:21:30 ** ERROR : FS-10890: Oracle Services for MSCS failed during the add operation
      31 01:21:30 ** ERROR : FS-10497: Starting clusterwide rollback of the operation
      32 01:21:30 FS-10488: GI-PRD-SJGP6 : Starting rollback of operation

      I have run the database out side of Oracle fail safe with out any problems, and have run the Verify standalone database, again all OK -This machine as had this DB in fail safe before, it was removed and we are now trying to add it back in.

      Can anyone help me resolve this. I have no idea what ERROR : 0x2: The system cannot find the file specified, also are there any other log file produced?

      Thanks
      R
        • 1. Re: Oracle Fail safe - adding a Database
          Vikz28
          The reason you are not able to add database in failsafe is because the location of dump files (highlighted below) mentioned in your log is not in shared drive.

          Value of parameter is C:\oracle\admin\XXXX\bdump+

          Either you have to change the location of dump filess or create the same directory structure on node 2 for the dump files.