rman target / issue

[Roshan]

Hi,

environment details:
Oracle Database 12c

I have enabled threaded execution on my production database. Whenever I connect as sys, I have to specify the password.

I am having an issue with the backup script. Each time I have to specify the password. I have created a password file in $ORACLE_HOME/dbs, I still get same password prompt.

Can you please advise how I can bypass the password prompt?

archicom>rman target sys

Recovery Manager: Release 12.1.0.2.0 - Production on Thu Oct 5 10:59:12 2017

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

target database Password:
connected to target database:

Regards,

Roshan

[ErmanArslansOracleBlog]

Hi Roshan,

password file doesn't provide you the ability to bypass password prompt.

You can bypass the password prompt by passing the password through the command line.

Here is an example for you:

rman TARGET SYS/oracle@trgt NOCATALOG

[Roshan]

I tried it, still failing

archicom>rman target sys/BqagUr$Ch1X@ARCHI NOCATALOG

Recovery Manager: Release 12.1.0.2.0 - Production on Thu Oct 5 13:14:59 2017

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

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00554: initialization of internal recovery manager package failed
RMAN-04005: error from target database:
ORA-01017: invalid username/password; logon denied

[ErmanArslansOracleBlog]

Do you have a valid/proper password file in place?
Test it.
You can test it using Toad sysdba connection.
password file should let you connect to the db using sysdba remotely.
first test this, and fix the password file problem, then you will be able to connect using the above rman command