Saturday, May 28, 2011

MoidIITDocID-502: How to create a password file? --Moid

$ orapwd file=$ORACLE_HOME/dbs/orapw$ORACLE_SID password='abc123' ignorecase=Y entries=5 force=y


Starting from 19c, atleast 8 bytes are required for SYS password.

orapwd file=$ORACLE_HOME/dbs/orapw$ORACLE_SID password='abc123'  force=y
OPW-00029: Password complexity failed for SYS user : Password must contain at least 8 characters.

Solution is to add "format=12". See below:
orapwd file=$ORACLE_HOME/dbs/orapw$ORACLE_SID password='abc123'  force=y  format=12


--Moid Muhammad

Monday, May 2, 2011

11g GoldenGate Installation (High Level steps) v1.4 --Moid

Very high level GG installation can be found from the following document.

Click here for the document.

--Moid





Golden Gate
GoldenGate
uni-directional
unidirectional
GG

Followers