Database Administration (MOSC)

MOSC Banner

Password file, copy from primary

edited Mar 27, 2019 9:46AM in Database Administration (MOSC) 11 commentsAnswered

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center