ORA-01017 while configuring 11g data guard

When configuring data guard using DGMGRL utility

add database ‘boston’
as connect identifier is boston
maintained as physical;

I would get ORA-01017 invalid username/password error…

I realized that this is related to case sensitive passwords in 11g…

I had  sec_case_sensitive_log =false  but I copied  orapw  file from primary which was already there.

The trick is to generate orapw file wiht option  IGNORECASE=YES .Then just copy files to standby servers under $ORACLE_HOME/dbs ( every server )

I  cuould not find any note on metalink explaining this issue..  ( not as of today )

Advertisement
Comments
4 Responses to “ORA-01017 while configuring 11g data guard”
  1. chet says:

    You need to pass these by me before posting so I can help out with spelling errors!

  2. Tom says:

    I think wordpress has spellcheck : )

  3. oraclue says:

    I am just an immigrant..( probably did not spell word immigrant correctly ):)

  4. coskan says:

    better this way. its not your fault its fault of English. i have a dream in which people read as they write.

Leave a Reply

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

Gravatar
WordPress.com Logo

Please log in to WordPress.com to post a comment to your blog.

Twitter picture

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

Facebook photo

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

Connecting to %s