Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Imp/exp and VNI-2015
On Thu, 01 Sep 2005 18:08:53 +0200, Alan Searle
<aj_searle_at_xxxyahoo.com> wrote:
>
>> I am setting up an Oracle Management Server (9i on Win2K) to test the
>> functionality. This has worked OK but I find that when I try to import
>> a DMP database I get the message VNI-2015.
>>
>> I followed the instructions that were displayed and entered the id of a
>> local user (called 'oracle') to access the node. I restarted the
>> Management Server and tried to log in again but got the same message. I
>> imagine that this is because I need to set up the user with 'log on as
>> batch job'. However, I cannot find this permission or profile in Win2K.
>> Is this because I am running a Win2K professional rather than Win2K
>> server? Or am I looking in the wrong place?
>
>I found the permission 'BATCH' which can be allocated to a group. I
>allocated this to the ORA_DBA group and then restarted the Management
>Server.
>
>But I am still getting the VNI-2015 message. This is a bit confusing
>because the node is a very simple declaration (the local computer) and I
>have tried both my own local account and the 'oracle' account which I
>set up. Both these accounts belong to the ORA_DBA group (under windows)
>and ORA_DBA has 'BATCH' permission.
>
>Does anyone have an idea? What have I missed?
>
>Any tips would be gratefully received.
>
>Regards,
>Alan Searle.
AFAIK the account needs to be a *local* account (as opposed to a
domain account) and the privilege needs to be assigned to the user
*directly* (not via the group)
Also the Oracle service needs to be running using the LOCAL system
user.
-- Sybrand Bakker, Senior Oracle DBAReceived on Thu Sep 01 2005 - 16:42:27 CDT