Tags » Data Guard

orapwd gives OPW-00029 Password complexity failed in #Oracle 12.2

When I tried to create a password file for a 12.2 database, it initially failed with my favorite (simple) password:

$ orapwd file=$ORACLE_HOME/dbs/orapwprima password=oracle

OPW-00029: Password complexity failed for SYS user : Password must contain at least 8 characters. 123 more words

Oracle Multitenant 12.2 – the big challenge of PDB hot cloning in MAA environments

One of Oracle’s key features introduced with Multitenant 12.2 is the possibility to clone pluggable databases while they are open for read / write operations. This is really a great feature – and as long as you work in a standalone container database it works perfect. 1,334 more words


Data Guard Broker Failover


Primary database is down

Log into the Data Guard Broker on standby node and check the configuration (dgmgrl sys/<password>)

Issue the failover command.

Modify the listener.ora file on the new primary node to allow it to listen for connections from the old primary. 242 more words

AWR Warehouse and Data Guard - Conclusions

Unfortunately AWR Warehouse and Data Guard do not work together seamlessly, however by understanding some of the implementation details, and following some simple steps you can help to mitigate most problems that may be encountered. 362 more words

AWR Warehouse

AWR Warehouse and Data Guard (Part Four)

After a brief interlude I wanted to follow up on something I noticed on John Hallas’s blog.

He mentioned that specifying a shared location for the extract metadata did not work, and was waiting on a fix for bug number 21826657. 647 more words

AWR Warehouse

AWR Warehouse and Data Guard (Interlude)

Note, in preparing next entry, I reviewed the results from previous entries and found that although extracts were being transferred successfully they had all failed to load; I should have noticed they had status 4 (IMPORT_FAILED), in the load metadata table. 527 more words

AWR Warehouse

Archive Logs in $ORACLE_HOME/dbs

This has been happening over the years but I couldn’t figure out why….finally found this article on My Oracle Support (MOS):  Setup Local archiving on standby to Prevent Logs sent to $ORACLE_HOME/dbs (on both GRID and SQLPLUS) (Doc ID 1271095.1) 204 more words