RE: Reading network share oracle on windows
- From: "Patterson, Joel" <jpatterson@xxxxxxxxxx>
- To: "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 20 Jun 2013 10:22:25 -0400
I have this now... I was fighting a fight where I was being told it could be
done when deep down inside I knew they did not give me what I asked for.
(Originally it was domain admin, then settled on domain account that could run
on all machines as administrator). However, the accounts I received were
not... of course as the domains where spelled differently. So since its been 8
years and I was spooling from sqlplus and had a time limit I got stuck on why
oracle on the same account could not see the drive.
Somewhere through all this and with your help I realized why I just simply ask
for the domain admin in the first place automagically. I just didn't remember
all the details -- (Oracle recommends a domain administrator --Note 145843.1).
Now that 'they' have come around, it is still to late to implement that in time
(change control, etc), so a little batch file will go with it to do the copy to
local, and then come back to it as they have agreed to make it happen.
Thanks for everyones help.
Joel Patterson
Database Administrator
904 928-2790
--
Joel Patterson
Sr. Database Administrator | Enterprise Integration
Phone: 904-928-2790 | Fax: 904-733-4916
http://www.entint.com/
http://www.entint.com/
http://www.facebook.com/pages/Enterprise-Integration/212351215444231
http://twitter.com/#!/entint http://www.linkedin.com/company/18276?trk=tyah
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]
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of Patterson, Joel
Sent: Wednesday, June 19, 2013 6:33 PM
To: Jeffrey Beckstrom; oracle-l@xxxxxxxxxxxxx
Subject: RE: Reading network share oracle on windows
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
Databae Administrator
904 928-2790
From: Jeffrey Beckstrom [mailto:JBECKSTROM@xxxxxxxxx]
Sent: Wednesday, June 19, 2013 3:41 PM
To: Patterson, Joel; oracle-l@xxxxxxxxxxxxx
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@xxxxxxxxxx<mailto:jpatterson@xxxxxxxxxx>> 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@xxxxxxxxxx<mailto:jpatterson@xxxxxxxxxx<mailto:jpatterson@xxxxxxxxxx%3cmailto:jpatterson@xxxxxxxxxx>>
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]
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
