Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux 
After the STANDBY Database is installed and the necessary configurations were made, when INSTANCEs wanted to be START, one of the INSTANCEs opened and the other did not open with the following error.
ORA-48141: error creating directory during ADR initialization
Things to do in this case can be found below.
After the STANDBY Database is installed and the necessary configurations were made, start INSTANCEs.
1 2 3 4 5 6 7 8 9 10 11 12 | [oracle@standby1 ~]$ srvctl start database -d standby PRCR-1079 : Failed to start resource ora.standby.db CRS-5017: The resource action "ora.standby.db start" encountered the following error: ORA-48141: error creating directory during ADR initialization [/u01/app/oracle/diag/rdbms/standby/primary2/alert] ORA-48189: OS command to create directory failed Linux-x86_64 Error: 13: Permission denied Additional information: 2 . For details refer to "(:CLSN00107:)" in "/u01/11.2.0/grid/log/standby2/agent/crsd/oraagent_oracle/oraagent_oracle.log". CRS-2674: Start of 'ora.standby.db' on 'standby2' failed CRS-2632: There are no more servers to try to place resource 'ora.standby.db' on that would satisfy its placement policy [oracle@standby1 ~]$ |
We understood that there was a problem with directory authorizations from error. Perform the necessary checks on both NODEs and fix the wrong one by changing directory authorizations.
Finaly, start the instances;
1 2 3 4 | [oracle@standby1 ~]$ srvctl start database -d standby [oracle@standby1 ~]$ srvctl status database -d standby Instance primary1 is running on node standby1 Instance primary2 is running on node standby2 |
