8 Replies Latest reply: Apr 18, 2013 6:51 AM by Mahir M. Quluzade RSS

    Specifying a Network Path in SQL query

    Thunder2777
      Hi There

      I have created 2 PCs (1 for Primary DB (IT_SERVER), 2 for Standby DB (IT_SERVER2)
      on Oracle VM VirtualBox in order to check my Data Guard configuration.

      I have created a Shared Folder on 2nd PC (IT_SERVER2) for Oracle Standby DB.

      Now when I issue my query from 1st PC (Primary DB) to Create a Parameter file on
      2nd PC Shared Oracle Folder, it returns following errors

      SQL> CREATE PFILE='\\IT_SERVER2\E:\ORACLE\PFILESTLDB2.ORA' FROM SPFILE;
      CREATE PFILE='\\IT_SERVER2\E:\ORACLE\PFILESTLDB2.ORA' FROM SPFILE
      *
      ERROR at line 1:
      ORA-09210: sftopn: error opening file
      OSD-04002: unable to open file
      O/S-Error: (OS 67) The network name cannot be found.

      Then I try this

      SQL> CREATE PFILE=\\IT_SERVER2\'E:\ORACLE\PFILESTLDB2.ORA' FROM SPFILE;
      CREATE PFILE=\\IT_SERVER2\'E:\ORACLE\PFILESTLDB2.ORA' FROM SPFILE
      *
      ERROR at line 1:
      ORA-00911: invalid character

      What to do???

      Regards
      Thunder2777