RE: [Q] imp/exp error on 9iR2?

The password may not be a problem here.
In 9i, sys must connect 'as sysdba' or 'as sysoper'.

So, use 'sys as sysdba' when prompted for username (without the single quotes).

If you want to use a parfile, then specify userid='sys/password as sysdba'. Those single quotes are needed and notice where 'as sysdba' goes :)

HTH,

• Kirti

-----Original Message-----
Sent: Friday, September 27, 2002 7:43 PM To: Multiple recipients of list ORACLE-L

It would appear you don't know the pw of sys, or maybe the capslock is on ;) If you can sqlplus /nolog can connect and alter the sys pw. Then you will know the sys pw and can use it on imp cmd.

$ sqlplus /nolog

SQL*Plus: Release 8.1.7.0.0 - Production on Fri Sep 27 19:36:42 2002

(c) Copyright 2000 Oracle Corporation. All rights reserved.

SQL> connect / as sysdba
Connected.
SQL> alter user sys identified by "change_on_install"

User altered.

SQL> On Fri, Sep 27, 2002 at 02:51:37PM -0800, dist cash wrote:
> I tried to do full database import use "sys" ID and have error come
> out. for "sqlplus" I can use "sqlplus /nolog" to avoid it, but on
> import/export how to avoid it?
>
>
> RSS::/home/app/oracle/admin/db92/export[173]% imp
>
> Import: Release 9.2.0.1.0 - Production on Fri Sep 27 17:36:13 2002
>
> Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
>
> Username: sys
> Password: change_on_install
>
> IMP-00058: ORACLE error 28009 encountered
> ORA-28009: connection to sys should be as sysdba or sysoperUsername:
> Password:
>
> IMP-00058: ORACLE error 1017 encountered
> ORA-01017: invalid username/password; logon deniedUsername:
>
>
> Thanks.
>
>
>
>
>
>
> _________________________________________________________________
> Chat with friends online, try MSN Messenger: http://messenger.msn.com
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: dist cash
> INET: mccdba_at_hotmail.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).

-- 
===============================================================
Ray Stell   stellr_at_vt.edu     (540) 231-4109     KE4TJC    28^D
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ray Stell
  INET: stellr_at_cns.vt.edu

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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Deshpande, Kirti
  INET: kirti.deshpande_at_verizon.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).