Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

12c Standby errored 'ORA-01017: invalid username/password; logon denied'

1002621Jul 5 2016 — edited Jul 12 2016

Hi,

I am creating standby for one of our production in 12c.Strange thing is happening here I though have created standby's earlier for other prod db's on same machine... This time while creating for another one ...it errored out as : 'ORA-01017: invalid username/password; logon denied'

I simply copy it from ASM to /tmp location and then scp it to standby server, thereby changing its name with keyword DG. that is it.

Tried even to create it manually with same password as prod like this..

[oracle@dlp-exa*-ora0*] dbs]$ orapwd file='/u01/app/oracle/product/12.1.0.2/dbhome_1/dbs/orapwDGP4JRNCD' entries=20 sysbackup=y sysdg=y syskm=y

Enter password for SYS:

Enter password for SYSBACKUP:

Enter password for SYSDG:

Enter password for SYSKM:

it is created with correct name :

-rw-r----- 1 oracle oinstall

14336 Jul 5 09:27 orapwDGP4JRNCD

sqlplus sys/**************@DGP4JRNCD-VIP as sysdba

SQL*Plus: Release 12.1.0.2.0 Production on Tue Jul 5 09:27:21 2016

ERROR:

ORA-01017: invalid username/password; logon denied

Can you please help why is this strange behavior.. I am irritated with this unusual thing..

Regards,

Shah

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 9 2016

Added on Jul 5 2016

#database-key-features, #multitenant

7 comments

12,334 views