Problem in archiving log files from Primary to Standby.

[Former Member]

Hi Friends,

When I am trying to check standby archive destination I am getting error message as:

SQL> select destination,status,error from v$archive_dest where dest_id=2;

DESTINATION

--------------------------------------------------------------------------------

STATUS  ERROR

--------- -----------------------------------------------------------------

Error Message:

KP7_STBY

ERROR  ORA-12154: TNS:could not resolve the connect identifier specified

I am able to tnsping from primary & standby servers. I did recovery in standby successfully,copied standby control file from primary and mounted as standby database suuccessfully. But I am getting the error as shown above. Plz suggest the solution.

initKP7.ora file---------------------------------

*._B_TREE_BITMAP_PLANS=FALSE

*._IN_MEMORY_UNDO=FALSE

*._INDEX_JOIN_ENABLED=FALSE

*._OPTIM_PEEK_USER_BINDS=FALSE

*._OPTIMIZER_MJC_ENABLED=FALSE

*._SORT_ELIMINATION_COST_RATIO=10

*._TABLE_LOOKUP_PREFETCH_SIZE=0

*.audit_file_dest='/oracle/KP7/saptrace/audit'

*.compatible='11.2.0'

*.control_file_record_keep_time=30

*.control_files='/oracle/KP7/origlogA/cntrl/cntrlKP7.dbf','/oracle/KP7/origlogB/cntrl/cntrlKP7.dbf','/oracle/KP7/sapdata1/cntrl/cntrlKP7.dbf'

*.db_block_size=8192

*.db_cache_size=1103584296

*.db_name='KP7'

*.db_recovery_file_dest='/oracle/KP7/oraflash'

*.db_recovery_file_dest_size=30000M

*.diagnostic_dest='/oracle/KP7/saptrace'

*.fal_client='PRIM'

*.fal_server='KP7_STBY'

*.FILESYSTEMIO_OPTIONS='setall'

*.job_queue_processes=1

*.log_archive_dest_1='LOCATION=/oracle/KP7/oraarch/KP7arch'

*.log_archive_dest_2='SERVICE=KP7_STBY reopen=60 ARCH NOAFFIRM'

*.log_archive_dest_state_2='enable'

*.log_archive_format='%t_%s_%r.dbf'

*.log_checkpoints_to_alert=true

*.max_dump_file_size='20000'

*.open_cursors=2000

*.parallel_execution_message_size=16384

*.parallel_threads_per_cpu=1

*.pga_aggregate_target=1471445729

*.processes=150

*.query_rewrite_enabled='false'

*.recyclebin='off'

*.remote_login_passwordfile='exclusive'

*.remote_os_authent=true

*.replication_dependency_tracking=false

tnsnames.ora file---------------------------------------------------------------

KP7.WORLD=

  (DESCRIPTION =

    (ADDRESS_LIST =

        (ADDRESS =

          (COMMUNITY = SAP.WORLD)

          (PROTOCOL = TCP)

          (HOST = 192.168.0.115)

          (PORT = 1521)

        )

    )

    (CONNECT_DATA =

       (SID = KP7)

       (GLOBAL_NAME = KP7.WORLD)

    )

  )

KP7_STBY.WORLD=

(DESCRIPTION =

(ADDRESS_LIST = (ADDRESS = (COMMUNITY = SAP.WORLD)

(PROTOCOL = TCP) (HOST = 192.168.0.116) (PORT = 1521))

)

(CONNECT_DATA =

(SID=KP7)

(GLOBAL_NAME=KP7.WORLD)

)

)

PRIM.WORLD=

(DESCRIPTION =

(ADDRESS_LIST = (ADDRESS = (COMMUNITY = SAP.WORLD)

(PROTOCOL = TCP) (HOST = 192.168.0.115) (PORT = 1521))

)

(CONNECT_DATA =

(SID=KP7)

(GLOBAL_NAME=KP7.WORLD)

)

)

Thanks in advance.

Regards,

Sunil K Talluri.

[former_member182657 · Accepted solution]

Hi Sunil,

Kindly follow SAP Note   443867 - ORA-12154 Collective SAP note

Regards,

Gaurav

[Former Member · Accepted solution]

Thankyou

[Former Member]

Hi Friends,

Thanks everyone for your help. I got resolved with the issue. Its a problem in my side regarding space alignment.

Any how I got more information regarding the issue (Archiving Logs) by your support.

Once again thanks every one.

Regards,

Sunil K Talluri.

[Former Member]

Hi,

check the connectivity between the Primary and Standby machines.

[thiago_cavalheiro]

Hi Sunil,

Please check the article bellow:

  1701375 - ORA-12154 connecting to Standby database

Let us know whether you were able to resolve the issue.

Best regards,

Thiago

[former_member182657]

Hi Sunil,

Kindly share the resolution of issue and if resolved please close the thread.

Regards,

Gaurav

[former_member188883]

Hi Sunil,

ERROR  ORA-12154: TNS:could not resolve the connect identifier specified

Please check whether listener is running and listening to same service or not.

For further guidelines refer to link below

ORA-12154: TNS tips

Regards,

Deepak Kori

[Former Member]

Thank You

[former_member188883]

Hi Sunil,

Please share whether the issue is resolved ?

Regards,

Deepak Kori