UNC path in oracle script 1

[patrick118]

I have the following question.

We have an oracle server and we have a script on the oracle server that writes something to a scriptfile. If we put the script file export to c:\home the file will be written there no problem.

Problem is i don't want it there. I want it on a other server. I don't want to use drive mappings so just the unc path. Example \\server01\home

How do i put this in a script? Is it possible to use such a notation?

Thank you for your help

Patrick
Netherlands

 

[sem]

This should work.
But is it simpler to post a question than to try it?

Regards, Dima

http://seminihin.narod.ru

 

[patrick118]

We are trying but it doesn't work

That is the problem. Maybe it isn't possible or we are doing something wrong

Patrick

 

[sem]

1. What OS do you use?
2. Does the user who runs that script have sufficient rights to create files there?
3. Does the full file name contain special characters (white spaces etc)


Regards, Dima

http://seminihin.narod.ru

 

[patrick118]

We are using windows 2000 server
User has all rights. (should not be the problem)
There are no special karakters.

We get an error: "ïnvalid path"

But the path does work and if we check it with windos explorer. It has no problems and we are able to put files there and create them. Only oracle says the path is incorrect.

Perhaps there is an sql statement or script to test the connection to the share? I don't know how to make a script that just writes a file there from within oracle

Patrick

 

[sem]

Are we talking about sql*plus and spool command or about utl_file package?


Regards, Dima

http://seminihin.narod.ru

 

[patrick118]

we are talking about UTL_file package

Patrick

 

[sem]

Ok, I've talked about sql*plus

Are you sure that the account of your Oracle server has access to that directory? I mean that normally Oracle is started under local system account that has no network priviledges.
Besides is that path listed in utl_file_dir ?

Regards, Dima

http://seminihin.narod.ru

 

[patrick118]

The directory is also listed in the init.ora. Sama way as in the package.

I don't really understand the local system account. We always use the administrator account on the server to log in and it is logged in.

Is there some way to check what account oracle uses? How do i change it? I think we are almost there because we haven't really looked at the accounts.

So there is a way in oracle to say which user account from windows it should use?

Patrick

 

[sem]

Oracle is started as a service. Its name is normally smth like OracleServiceORCL, where ORCL is replaced by your real SID. Find it in the list of services and look at its properties, namely Log On tab. You may change this account.

Regards, Dima

http://seminihin.narod.ru

 

[sem]

Me again. You must also change an account of Listener appropriately.

Regards, Dima

http://seminihin.narod.ru

 

[patrick118]

I think the Oracle ORCL indeed is a great idea but i don't understand why we should do the same thing with the listener? Can you explain to me why?

We only changed the orcle service with the account and after that we couldn't connect to oracle. Listener error.

But before we actually change the listener we would like to know why we also should change that account.

I really hope you would be able to explain it to me

Patrick
Netherlands

 

[sem]

Just accept this
I can not tell it for sure, but I think that this is related to Windows security.

Regards, Dima

http://seminihin.narod.ru

 

[patrick118]

Just accept it?

There is no system engineer in the world who would accept such an answer. (I'm kidding)

We have a few holidays here so we are not able to work. We will pick to story up on monday. Wíll then try to change the listner as well.

Hope you will be able to help us those days as well

SEM thanks for all the help so far

Patrick