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: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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 [EMAIL PROTECTED] (540) 231-4109 KE4TJC 28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ray Stell INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
