Very true... But * IF * John's solution does not work
then reason for mentioned error is because U probably
ran "CATEXP.sql" AGAIN after running CATPROC.SQL.
Anyway to correct this simply run
"%oracle_home%\rdbms\admin\CATRM.SQL" script connected
as SYS or INTERNAL.
If CATEXP.SQL was rerun after CATPROC.SQL (this runs
CATRM.SQL) the modification made to the
EXP_FULL_DATABASE role by CATRM.SQL no longer exist
since CATEXP.SQL drops and creates the
EXP_FULL_DATABASE role. The privileges granted to
the role by CATRM.SQL are necessary to export the
resource manager objects.
OraCop
- John Thomas <oracle_at_toronto.demon.co.uk> wrote:
> 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).
>
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: OraCop
INET: oracop_at_yahoo.com
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).
Received on Tue Nov 26 2002 - 19:28:47 CST