Skip to Content
avatar image
Former Member

Problem in archiving log files from Primary to Standby.

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

6 Answers

  • Best Answer
    avatar image
    Former Member
    Jun 28, 2014 at 01:58 PM

    Hi Sunil,

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

    Regards,

    Gaurav

    Add comment
    10|10000 characters needed characters exceeded

  • Jun 29, 2014 at 05:33 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jul 01, 2014 at 03:01 PM

    Hi Sunil,

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

    Regards,

    Gaurav

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jul 01, 2014 at 05:20 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jul 01, 2014 at 06:31 PM

    Hi,

    check the connectivity between the Primary and Standby machines.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jul 03, 2014 at 06:40 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded