Re: Imp/exp and VNI-2015

From: Alan Searle <aj_searle_at_xxxyahoo.com>
Date: Fri, 02 Sep 2005 08:57:01 +0200
Message-ID: <df8t5v$86t$1@newsreader3.netcologne.de>

Sybrand Bakker schrieb:

> 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)

Yes, these are local accounts and I want to assign the permissions directly. However, with my OS (Win2K Professional), I can't see the privilege 'Log on as batch job'. Does this mean that I need to be running Win2K Server? Or have I missed something?

> Also the Oracle service needs to be running using the LOCAL system > user.

This is the case. I log on as a normal user (with Administrator privilege) and run Oracle with that account.

Many thanks for your help.

Regards,
Alan Searle Received on Fri Sep 02 2005 - 01:57:01 CDT