exp, oracle error 1017 encountered

[Vandy02]

I am tring to exp a database.
The username and pwd are correct and the user has exp database privileges..

I am stumped...do you have any idea?


Vandy

 

[SantaMufasa]

Vandy,

Until you post a copy-and-paste of your "exp" command and error message(s), we will be stumped, as well.

Mufasa
(aka Dave of Sandy, Utah, USA @ 21:05 (27Feb04) UTC (aka "GMT" and "Zulu"), 14:05 (27Feb04) Mountain Time)

 

[Vandy02]

exp full=y

then it asks for:
username:
password:

then I get the error

note I am using the dos prompt

 

[SantaMufasa]

Vandy,

You still didn't paste a copy of your error message, so we can't troubleshoot it directly. When you say, "the user has exp database privileges...", how do you know that? What grant did the user receive to make that happen? Could you please paste the results of these two queries:

select grantee,privilege from dba_sys_privs where grantee = '<your exporting user>';
select grantee,granted_role from dba_role_privs where grantee = '<your exporting user>';

Thanks,

Mufasa
(aka Dave of Sandy, Utah, USA @ 21:43 (27Feb04) UTC (aka "GMT" and "Zulu"), 14:43 (27Feb04) Mountain Time)

 

[Vandy02]

1* select grantee,privilege from dba_sys_privs where grantee = 'SYSTEM'
SQL> /

GRANTEE PRIVILEGE
------------------------------ ----------------------------------------
SYSTEM UNLIMITED TABLESPACE



1* select grantee,granted_role from dba_role_privs where grantee = 'SYSTEM'
SQL> /

GRANTEE GRANTED_ROLE
------------------------------ ------------------------------
SYSTEM DBA
SYSTEM CONNECT
SYSTEM RESOURCE
SYSTEM EXP_FULL_DATABASE
SYSTEM IMP_FULL_DATABASE
SYSTEM AQ_ADMINISTRATOR_ROLE

 

[Vandy02]

The error message

Microsoft Windows [Version 5.2.3790]
(C) Copyright 1985-2003 Microsoft Corp.

C:\Documents and Settings\Administrator>exp

Export: Release 9.2.0.1.0 - Production on Fri Feb 27 15:32:47 2004

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.


Username: system
Password:

EXP-00056: ORACLE error 1017 encountered
ORA-01017: invalid username/password; logon denied
Username:
Password:

 

[SantaMufasa]

Vandy,

Now that you posted the error message, I can tell you that the problem is not privileges -- it is that you are using the wrong password for user "SYSTEM". "Invalid username/password" means just that. Since your query shows that user, "SYSTEM" exists, then the only other possible issues is that the password your entered for SYSTEM does not match what Oracle thinks is the password. If you are the DBA for the Oracle server/database, then you have the right to change the password to something you know. "connect / as sysdba" and change the password for SYSTEM to something you know, then try the "exp" again. It should work next time.

Mufasa
(aka Dave of Sandy, Utah, USA @ 06:26 (28Feb04) UTC (aka "GMT" and "Zulu"), 23:26 (27Feb04) Mountain Time)

 

[Vandy02]

thanks..got this part to work...I posted yet another problem...keeps stoppong export on exporting statistics..

thanks again though for the help..