Hi All,
Below are the details of my environment -
1) Oracle DB version - 12.2.0.2
2) Virtual box version - 6
At primary side - orcl
Installed and created database without selecting container checkbox.
SQL> show parameter db_name
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_name string orcl
SQL> show parameter log_file_name_convert
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_file_name_convert string /u01/app/oracle/oradata/secodb
, /u01/app/oracle/oradata/orcl
SQL> sho parameter db_file_name_convert
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_file_name_convert string /u01/app/oracle/oradata/secodb
, /u01/app/oracle/oradata/orcl
pdb_file_name_convert string
SQL> select name, db_unique_name, open_mode, log_mode from v$database;
NAME DB_UNIQUE_NAME OPEN_MODE LOG_MODE
--------- ------------------------------ -------------------- ------------
ORCL orcl READ WRITE ARCHIVELOG
`
At Standby Side - secodb
Trying to create DataGuard -standby database using new feature dbca -silent but its shows error Auxiliary instance created.
Below are the steps
[root@node2 Desktop]# su - oracle
[oracle@node2 ~]$ ps -ef|grep pmon
oracle 3526 3495 0 07:33 pts/1 00:00:00 grep pmon
[oracle@node2 ~]$ dbca -silent -createDuplicateDB -gdbName orcl -primaryDBConnectionString node1:1521/orcl -sid orcl -createAsStandby -dbUniqueName secodb
Enter SYS user password:
Listener config step
33% complete
Auxiliary instance creation
DBCA Operation failed.
Look at the log file "/u01/app/oracle/cfgtoollogs/dbca/secodb/orcl2.log" for further details.
[oracle@node2 ~]$
While seing the log, found that error occurred at log_file_name_convert but unable to understand it. Since, parameter is correctly entered at primary side.
Below are the log file
[oracle@node2 oracle]$ cd /u01/app/oracle/cfgtoollogs/dbca/secodb/
[oracle@node2 secodb]$ cat orcl2.log
[ 2018-02-14 07:56:07.438 IST ] Listener config step
DBCA_PROGRESS : 33%
[ 2018-02-14 07:56:08.325 IST ] Auxiliary instance creation
[ 2018-02-14 07:56:28.156 IST ] ORA-01678: parameter log_file_name_convert must be pairs of pattern and replacement strings
[ 2018-02-14 07:56:28.279 IST ] DBCA_PROGRESS : DBCA Operation failed.
[oracle@node2 secodb]$ exit
Please highlight my issues so that I can able to configure it...
Regards,
Mayan Kumar..