Re: [Q] ORACLE 9i remote export "insufficient previlege"?

I think you need a password file on the 9i server to connect remotely with SYSDBA privilege.

Go to $ORACLE_HOME/dbs and use orapwd. You may need to set an init.ora parameter along the lines of remote_password_exclusive or shared depending upon whether you want multiple users (or was it databases?) using the same file to log in remotely as well...

Cheers,

John Thomas

In message <F001.0050C720.20021126112527_at_fatcity.com>, dist cash <mccdba_at_hotmail.com> writes
>I am doing the ORACLE 9iR2 database test and tried to export form a 8i
>computer to 9iR2 server. I got "ORA-01031: insufficient privileges".
>
>my export parfile on 8i server is:
>
>
>userid='sys/passwd1_at_db92 as sysdba'
>file=/tmp/exp_db8i_full.dmp
>buffer=64000000
>compress=n
>grants=y
>indexes=y
>rows=y
>feedback=10000
>constraints=y
>consistent=y
>log=exp_db8i_full.log
>full=y
>
>
>
>
>I got:
>
>Export: Release 8.1.7.2.0 - Production on Tue Nov 26 14:02:57 2002
>
>(c) Copyright 2000 Oracle Corporation. All rights reserved.
>
>
>EXP-00056: ORACLE error 1031 encountered
>ORA-01031: insufficient privileges
>Username:
>
>
>Does anyone know why??
>
>Thanks.
>
>_________________________________________________________________
>The new MSN 8: smart spam protection and 2 months FREE*
>http://join.msn.com/?page=features/junkmail
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: John Thomas
  INET: oracle_at_toronto.demon.co.uk

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).