Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Imp/exp and VNI-2015
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 then wanted to run the import from the command line but find that SQL*plus allows presents me with a logon Window which won't accept the SYS or SYSTEM users (i.e. CONNECT SYS AS SYSDBA). How do I get rid of the login window so that I can work directly at the command prompt? Or what is the syntax to login 'AS SYSDBA'?
I also tried logging in as sysman but this also didn't work.
And when I login as a normal user (with IMPORT / EXPORT permission) I find that the imp and exp commands are not available. Is this because they need to be 'enabled' somewhere? Or are these commands only available to SYS / SYSTEM / SYSMAN ?
And I understand that there is an 'ultra-super user' called 'oracle' how do I find/activate this account? Or, if the account already exists what is the default password?
Any tips would be a great help.
Regards and thanks,
Alan Searle
PS: remove the xxx to send me an e-mail Received on Thu Sep 01 2005 - 08:42:57 CDT