RE: Reading network share oracle on windows
From: Patterson, Joel <jpatterson_at_entint.com>
Date: Wed, 19 Jun 2013 18:32:48 -0400
Message-ID: <C1117B1AA0340645894671E09A7891F715123A4D07_at_EIHQEXVM2.ei.local>
The J:\ drive is a shared drive on the source computer by an administrator on the source computer. The mapping to J: was done on the dest computer using the credentials of the source computer. Thanks Jeff... but the parameter still exists and should be able to serve as an example like any other parameter you can set to point to a drive. This one points to %ORACLE_HOME%\RDBMS. What parameter can I use instead? It is standard edition so no data guard. I have tried all combinations of using J: or just UNC The mapping looks like this in Explorer, with the drive last <archivedir>(\\machinename)(J:)<file:///\\machinename)(J:)> Joel Patterson
Database Administrator
904 928-2790
Date: Wed, 19 Jun 2013 18:32:48 -0400
Message-ID: <C1117B1AA0340645894671E09A7891F715123A4D07_at_EIHQEXVM2.ei.local>
The J:\ drive is a shared drive on the source computer by an administrator on the source computer. The mapping to J: was done on the dest computer using the credentials of the source computer. Thanks Jeff... but the parameter still exists and should be able to serve as an example like any other parameter you can set to point to a drive. This one points to %ORACLE_HOME%\RDBMS. What parameter can I use instead? It is standard edition so no data guard. I have tried all combinations of using J: or just UNC The mapping looks like this in Explorer, with the drive last <archivedir>(\\machinename)(J:)<file:///\\machinename)(J:)> Joel Patterson
Database Administrator
904 928-2790
From: Jeffrey Beckstrom [mailto:JBECKSTROM_at_gcrta.org]
Sent: Wednesday, June 19, 2013 3:41 PM
To: Patterson, Joel; oracle-l_at_freelists.org
Subject: Re: Reading network share oracle on windows
This doesn't answer your question, but my 11.2 docs state the parameter is deprecated and retained for backward compatibility only.
Jeffrey Beckstrom
Database Administrator
Greater Cleveland Regional Transit Authority
Information Systems
1240 W. 6th Street
Cleveland, Ohio 44113
>>> "Patterson, Joel" <jpatterson_at_entint.com<mailto:jpatterson_at_entint.com>> 6/19/13 3:33 PM >>>
11g on windows 2008. Oracle is running as an admin account. From sqlplus same account can spool a file successfully. Does anyone know what I am missing to set the parameter successfully?
alter system set standby_archive_dest='J:\'
*
ERROR at line 1:
ORA-02097: parameter cannot be modified because specified value is invalid ORA-16032: parameter STANDBY_ARCHIVE_DEST destination string cannot be translated ORA-09291: sksachk: invalid device specified for archive destination OSD-04018: Unable to access the specified directory or device. O/S-Error: (OS 3) The system cannot find the path specified.
Joel Patterson
Senior Oracle Database Administrator
jpatterson_at_entint.com<mailto:jpatterson_at_entint.com<mailto:jpatterson_at_entint.com%3cmailto:jpatterson_at_entint.com>>
Office: 904 928-2790
Enterprise Integration Corporation / https://access.seg.att.com/redir/?56Wr2rXXxJ6WtXCzAsyratY9OxfBPhU02-4VgDO-6zUTvAXTLuZXTKrKrH7r7-nfbAaJMJUatz_DOFeD00jryrwUSyOehs7nvjpdIndwLZgB0yq80qoH4Gq8a4ZzVEwH7r7-q8aMd41yk4aCa6y0TfM-ub7Xa1J4SyyrhKDuVEVppdR2Vtu5QW
7601 Centurion Parkway | Jacksonville, FL 32256
-- Joel Patterson Sr. Database Administrator | Enterprise Integration Phone: 904-928-2790 | Fax: 904-733-4916 https://access.seg.att.com/redir/?56Wr2rXXxJ6WtXCzAsyratY9OxfBPhU02-4VgDO-6zUTvAXTLuZXTKrKrH7r7-nfbAaJMJUatz_DOFeD00jryrwUSyOehs7nvjpdIndwLZgB0yq80qoH4Gq8a4ZzVEwH7r7-q8aMd41yk4aCa6y0TfM-ub7Xa1JcSyyrhKDuVEVppdDk_mtFVX [https://access.seg.att.com/redir/?ETjojvvsdETjLsQszAjo0eiatQ-m9RDkwToHY-nPjO3qJc846n1S3k9Oxfai8MSrsvcK8Y8H4jiWqf00nMDa4-nMQv6XYDuZXTLuZPtPtoXo_OVVsxlK5L1jIvY-l9QU02rsjs76QmhObwWXWr9JyVI5_G4E4jh03j5oBjh1gDIvd45oXo_Ph1m1EwciwxkNgQg6V-7PNo_pgdICQkjqdQXTd7bb9LPtT0GB5hw1 [https://access.seg.att.com/redir/?ETjojvvsdETjLsQszAjo0eiatQ-m9RDkwToHY-nPjO3qJc846n1S3k9Oxf9ANknSTzdqBku4ly9Ftd7w09TrugHkHO-bqh-C3k9_5qcGun3ojYz7pOH34QkSnQkQnS664SkjhYrLOtXTLuZXTdTdRzJz_bDBO5mUmY5eN_PVkDjw09JNdMsrhp78K3HLFICSbCMn-Eiwhd40dclyld452uNYQglzJz_d45o6y0Na25j53h0rDUvf5zZB0SMrhhdETjLsQsIICV2sf [https://access.seg.att.com/redir/?2ztdxdZZMSzteZPhOehdw0V8FTjVoDmti3tyLPVvdf8dGQMwgps7odgDa4YCj5gioBevNhUhm8CBQTvAXTLuZXTKrKrH7r7-nfbAaJMJUatz_DOFeD00jryrwUSyOehs7nvjpdIndwLZgB0yq80qoH4Gq8a4ZzVEwH7r7-q8aMd41yk4aCa6y0TfM-ub7Xa1JYSyyrhKDuVEVppdYGv_TWCcgiiZ <https://access.seg.att.com/redir/?adQS4TTT3qdQXTd78V4S03CoBevNVv0cd4ev2sEjd7NK_9TLuZXTLsTsTmeSfYKun8lrxrMkX7_fBite00CT4T1NJ5AsyUeK-COroKr1vWxa14Qg0QNm9kQgk9X7Ph1meSfYQglwq834E8lckd41KvxYYmfSk3rxJ54SzteZPhOOOru4t6 [https://access.seg.att.com/redir/?krFI9LLK6QrFTKqehO9I0795eWvb4WPGgrIl-vbVFV1JmC423bwX1G4VgDAOoG5pga-w6MhUhm8CBQTvAXTLuZXTKrKrH7r7-nfbAaJMJUatz_DOFeD00jryrwUSyOehs7nvjpdIndwLZgB0yq80qoH4Gq8a4ZzVEwH7r7-q8aMd41yk4 aCa6y0TfM-ub7Xa1IsrhhdETjLsQsIICNbZ8 <https://access.seg.att.com/redir/?1hKCMC--UrhKDuVEV78CM0hYE5vgB3BYnmS1r4nANPxasiFQOSAPhYrLOtXTLuZXTdTdRzJz_bDBO5mUmY5eN_PVkDjw09JNdMsrhp78K3HLFICSbCMn-Eiwhd40dclyld452uNYQglzJz_d45o6y0Na25j53h0rDUvf5zZB0SYrhhdETjLsQsIIC_UQ9yNq2lx34 [https://access.seg.att.com/redir/?krFI9LLK6QrFTKqehO9I0795eWvb4WPGgrIl-vbVFV1JmC423bwX1G4VgDAOoG1WJwBIxWf2aN4QKCXYDuZXTLuZPtPtoXo_OVVsxlK5L1jIvY-l9QU02rsjs76QmhObwWXWr9JyVI5_G4E4jh03j5oBjh1gDIvd45oXo_Ph1m1EwciwxkNgQg6V-7PNo_pgdCzASyyrhKDuVEVppdKN-2 <https://access.seg.att.com/redir/?adQS4TTT3qdQXTd78V4S02blrCSg_BYrFYs3eDJ_lQd19E-dTVeZXTLuZXCXCWNSN_BPOV2Hsbu2Do_VYGjFM04SUCUedEIzAn1RTQSjr5Pob_k9g8Cy06CaNaCy2xfo-q8aNSN_Cy2I3h0oB12FyxEwdPYfDyN-OwrhKrhhdETjLsQsIICRB0JtOB9Q4Xr This message (and any associated files) is intended only for the use of the addressee and may contain information that is confidential, subject to copyright or constitutes a trade secret. If you are not the intended recipient, you are hereby notified that any dissemination, copying or distribution of this message, or files associated with this message, is strictly prohibited. If you have received this message in error, please notify us immediately by replying to the message and deleting it from your computer. Messages sent to and from us may be monitored. Any views or opinions presented are solely those of the author and do not necessarily represent those of the company. [v.1.1] -- https://access.seg.att.com/redir/?56Wr2rXXxJ6WtXCzAsyr01eN_PVkDjw0e02mQz-lzJz_bDCXYDuZXTLuZPtPtoXo_OVVsxlK5L1jIvY-l9QU02rsjs76QmhObwWXWr9JyVI5_G4E4jh03j5oBjh1gDIvd45oXo_Ph1m1EwciwxkNgQg6V-7PNo_pgdEECQkjqdQXTd7bb9IGFbuaKm . -- Joel Patterson Sr. Database Administrator | Enterprise Integration Phone: 904-928-2790 | Fax: 904-733-4916 www.entint.com<http://www.entint.com/> [http://i1202.photobucket.com/albums/bb367/Entint/signaturev61.jpg]<http://www.entint.com/> [http://i1202.photobucket.com/albums/bb367/Entint/th_FaceBook1.jpg]<http://www.facebook.com/pages/Enterprise-Integration/212351215444231> [http://i1202.photobucket.com/albums/bb367/Entint/th_Twitter1.jpg] <http://twitter.com/#!/entint> [http://i1202.photobucket.com/albums/bb367/Entint/th_LinkedIn1.jpg] <http://www.linkedin.com/company/18276?trk=tyah> [http://i1202.photobucket.com/albums/bb367/Entint/th_YouTube1.jpg] <http://www.youtube.com/user/ValueofIT> This message (and any associated files) is intended only for the use of the addressee and may contain information that is confidential, subject to copyright or constitutes a trade secret. If you are not the intended recipient, you are hereby notified that any dissemination, copying or distribution of this message, or files associated with this message, is strictly prohibited. If you have received this message in error, please notify us immediately by replying to the message and deleting it from your computer. Messages sent to and from us may be monitored. Any views or opinions presented are solely those of the author and do not necessarily represent those of the company. [v.1.1] -- http://www.freelists.org/webpage/oracle-lReceived on Thu Jun 20 2013 - 00:32:48 CEST
