0

Oracle 19c + SAP system. On primary side I have a problem when transporting logs to Data Guard side.

Outputs from primary side:

SQL> select status, error from v$archive_dest where dest_id=2;                                                                                                                                      
                                                                                                                                                                                                    
STATUS    ERROR                                                                                                                                                                                     
--------- -----------------------------------------------------------------                                                                                                                         
ERROR     ORA-12154: TNS:could not resolve the connect identifier specified


SQL> show parameter log_archive_dest_2

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_2                   string      SERVICE=DRSIDE NOAFFIRM ASYNC V
                                                 ALID_FOR=(ONLINE_LOGFILES,PRIM
                                                 ARY_ROLE) DB_UNIQUE_NAME=DRSIDE

SQL> show parameter log_archive_dest_state_2                                                                                                                                                        
                                                                                                                                                                                                    
NAME                                 TYPE        VALUE                                                                                                                                              
------------------------------------ ----------- ------------------------------                                                                                                                     
log_archive_dest_state_2             string      ENABLE

Alert log:

TT00 (PID: a number): Error 12154 received logging on to the standby
2021-02-20T15:48:51.144500+03:00
TT00 (PID: a number): Error 12154 received logging on to the standby
2021-02-20T15:53:51.946941+03:00
TT00 (PID: a number): Error 12154 received logging on to the standby
2021-02-20T15:58:52.744327+03:00
TT00 (PID: a number): Error 12154 received logging on to the standby
2021-02-20T16:03:53.549161+03:00
TT00 (PID: a number): Error 12154 received logging on to the standby

I did not make any changes to the tnsnames.ora or listener.ora files.

Edit: I tried to set log_archive_dest_2, I tried to send tnsping (successfully works from primary to disaster and disaster to primary), I tried copying passwordfile from primary to disaster. None of them worked.

Best regards,

Improve this question
11
  • And what did you discover when you googled 'ORA-12154'?
    – EdStevens
    Feb 20, 2021 at 13:57
  • Hi @EdStevens, It's all about tnsnames.ora. I checked and it looks like true. I can send tnsping.
    – jrdba123
    Feb 20, 2021 at 14:06
  • from which machine did you issue a successful tnsping?
    – EdStevens
    Feb 20, 2021 at 14:13
  • @EdStevens from primary side to disaster side.
    – jrdba123
    Feb 20, 2021 at 14:14
  • @EdStevens I checked from disaster side to primary side too. It was successful.
    – jrdba123
    Feb 20, 2021 at 15:12

0

Reset to default

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.