Hendry's "Oracle and SQL Server DBA Stuff"

Oracle and SQL Server Database Solutions for DBA's please visit http://hendrydba.com for the latest posts. Thanks

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

Posted by Hendry chinnapparaj on February 4, 2011

Problem

————–

The OS Authentication fails due to the missing user OPS$ORACLE

Cpsoa1:/u01/oracle> exp /

Export: Release 10.2.0.4.0 – Production on Tue Jan 11 13:52:43 2011

Copyright (c) 1982, 2007, Oracle.  All rights reserved.

EXP-00056: ORACLE error 1017 encountered

ORA-01017: invalid username/password; logon denied

Username:

Password:

Solution

————

create user and grant permission for OS Authentication

CREATE USER OPS$ORACLE

IDENTIFIED EXTERNALLY

DEFAULT TABLESPACE USERS

TEMPORARY TABLESPACE TEMP

PROFILE DEFAULT

ACCOUNT UNLOCK;

— 4 Roles for OPS$ORACLE

–GRANT DATAPUMP_EXP_FULL_DATABASE TO OPS$ORACLE;

GRANT IMP_FULL_DATABASE TO OPS$ORACLE;

–GRANT DATAPUMP_IMP_FULL_DATABASE TO OPS$ORACLE;

GRANT EXP_FULL_DATABASE TO OPS$ORACLE;

ALTER USER OPS$ORACLE DEFAULT ROLE ALL;

— 1 Tablespace Quota for OPS$ORACLE

ALTER USER OPS$ORACLE QUOTA UNLIMITED ON USERS;

Grant create session to OPS$ORACLE;

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

 
%d bloggers like this: