Password file, copy from primary
Bonjour,
I am trying to build a standby database in Oracle 12c, 12.1.0.2.0 to be exact. In a RAC environment with 2 nodes for the primary and 2 nodes for the standby.
I create a password file on the primary database :
orapwd file=orapwPRIMARY1 password=mypassword entries=10 force=y
I then copy the file on each node, renaming the file to fit the current node. For instance, on the standby node use to duplicate the database, I choose orapwSTANDBY1.
Then, to start my database I do :
sqlplus sys/mypassword@STANDBY1 as sysdba
I endup with this :
SQL*Plus: Release 12.1.0.2.0 Production on Tue Jun 14 21:40:57 2016