Error: ORA-01017 while taking backup on standby database after 12C upgrade

[amit_waghmare2]

Dear Friends,

we were earlier on Oracle 11G, we use to take backup on the standby database with type offline_standby,

for this we have miantained a connection string to primary_db in tnsnames.ora pointing to our primary database and the same is maintained in initSID.sap profile with parameter primary_db

tnsping is happening to that connection string, Also we were able to connect to primary db from syandby sql as "connect SAPSR3/PASSWORD@<connection string>

Now after 12C upgrade all the above tests are working fine, but when we trigger a offline_standby backup from the standby database, we are getting below error

BR0301E SQL error -1017 at location BrDbConnect-3, SQL statement:

'CONNECT /@PIPPRI'

ORA-01017: invalid username/password; logon denied

BR0310E Connect to database instance PIP/PRIMARY failed

BR0280I BRBACKUP time stamp: 2015-09-12 09:41:44

BR0301E SQL error -1017 at location BrDbConnect-3, SQL statement:

'CONNECT /@PIPPRI'

ORA-01017: invalid username/password; logon denied

BR0310E Connect to database instance PIP/PRIMARY failed

Please help us on this.

Thanks

Suresh

[JamesZ]

Hi Suresh,

The problem is the user calling brtools is not able to connect database without password:

'CONNECT /@PIPPRI'

Please check the ops$ user is enable for the database.

Best regards,

James

[Former Member]

Hi James,

As they are on 12c, OPS$ is not available they must have migrated to SSFS.

@Amit, can you confirm same if you have established SSFS in your environment.

And you can execute the same command as mentioned by James. Also do let us know the the kernel version your using.

Also have you migrated "Oracle" User mechanism or still using ora<SID>.

Also just check which ORACLE_HOME your using in Backup tool as you have to modify the oracle_home at the tool end too.

Regards,

Ram

[amit_waghmare2]

Dear Ram,

Yes you are right. As we are on 12C there is no more any OPS$ mechanism and it was working with SSFS.

Already we have configured SSFS as well.

We were able to connect to primary from syandby using "connect SAPSR3/<Password>@PIPPRI

we also have migrated to oracle from ora<dbsid> and oracle_home was also set.

Only issue was standby database was not able to get the SAPSR3 Password for logging in to primary before starting the backup.

Work around we have did: Asper the note 1764043, we have created the BRT$ADM user id and applied the logs in DR, so that it has get created in DR as well,

After that we have copied the security directory available in SAPDATA_HOME dir to DR.

Now in brtools in option "Database user/password (user)" we are giving brt$adm/<password>, then the backup is working.

But i dont think that this is a correct solution, as the password has to be picked from SSFS, as it was happening in the same was in 11G which picks from OPS$

Please update any more hints?

Thanks

Suresh

[Former Member]

Hi AMit,

Can you check below document. and if your using brtools then you need to create the BR$ user in your DB to get them working.

also do refer below oss note.

1914631 - Central Technical Note for Oracle Database 12c Release 1 (12.1)

and which tool your using for the backup and what error your seeing at the tool end.

Let us know the details.

Regards,

Ram