DBA GENESIS

  • Courses

  • Certification

  • Contact

  • Members

  • More

    Use tab to navigate through the menu items.

    Book a mock interview and get instant feedback - Learn More

    To see this working, head to your live site.
    • Categories
    • All Posts
    • My Posts
    gganesh519
    Dec 22, 2021

    Login issue to connect auxiliary database

    in Oracle Data Guard

    Hi Arun/Team,


    Getting the below error while connecting to auxiliary db for cloning the db. i'm entering the exact password as primary server but still facing the issue.

    suggest me to get rid of this issue.


    [oracle@prmdg ~]$ rman TARGET sys@prim


    Recovery Manager: Release 12.2.0.1.0 - Production on Wed Dec 22 18:57:53 2021


    Copyright (c) 1982, 2017, Oracle and/or its affiliates. All rights reserved.


    target database Password:

    connected to target database: PRIM (DBID=89162464)


    RMAN> connect auxiliary sys@stb


    auxiliary database Password:

    RMAN-00571: ===========================================================

    RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

    RMAN-00571: ===========================================================

    RMAN-04006: error from auxiliary database: ORA-01017: invalid username/password; logon denied


    RMAN> connect auxiliary

    dgerror
    .PNG
    Download PNG • 42KB

    sys@stb


    auxiliary database Password:

    RMAN-00571: ===========================================================

    RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

    RMAN-00571: ===========================================================

    RMAN-04006: error from auxiliary database: ORA-01017: invalid username/password; logon denied


    1 comment
    0
    1 Comment

    Share Your ThoughtsSign up to leave a comment.

    A
    Arun Kumar
    Dec 22, 2021
    •

    Re-generate the password file on source DB and copy it again to clone server. Make sure you rename the password file:


    orapwsourcesid


    to


    orapwclonesid

    0
    1 comments
    Similar Posts
    • issue of startup database 19c in Linux
    • Parallel query issues
    • Oracle Database login accounts require passwords to meet complexity requirements.

    support@dbagenesis.com

    • Facebook
    • Instagram
    • Twitter
    • YouTube

    © 2023 Biggest Database Forum by DBA Genesis