This discussion is archived
8 Replies Latest reply: Apr 18, 2013 4:51 AM by MahirM.Quluzade RSS

Specifying a Network Path in SQL query

Thunder2777 Newbie
Currently Being Moderated
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

Legend

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