DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Ora-12514

  1. #1
    Join Date
    Aug 2023
    Posts
    8

    Ora-12514

    Good morning,
    I randomly receive ORA-12514 errors on several scheduled tasks.
    There are no errors in the listener log files listener.log and og.xml.
    There are no errors in the alertlog and trace files.

    The hostname is correctly configured in the file listener.ora.
    The ping responds correctly with the hostname .
    The lsnrctl services command responds correctly.

    There are several cases in which the ORA-12514 error occurs
    1) the database listener is not reachable due to errors in the configuration --> this is not the case
    2) the database listener is temporarily unavailable for some reason --> case to be checked
    3) there is no match with the service name --> this is not the case
    4) the database is restarted --> this is not the case
    5) the switch is made to the standby database --> this is not the case
    6) when using a database link --> this is not the case

    What else could I check?

    Thanks in advance

  2. #2
    Join Date
    Aug 2023
    Posts
    8
    I think I have identified the reason for the error.
    In the tnsname.ora files of the clients, the following parameters are set (CONNECT_TIMEOUT=1) and (TRANSPORT_CONNECT_TIMEOUT=1).

    Should I also add the RETRY_COUNT parameter? For example (RETRY_COUNT=3) ?

  3. #3
    Join Date
    Aug 2023
    Posts
    8
    Quote Originally Posted by Yuri View Post
    I think I have identified the reason for the error.
    In the tnsname.ora files of the clients, the following parameters are set (CONNECT_TIMEOUT=1) and (TRANSPORT_CONNECT_TIMEOUT=1).

    Should I also add the RETRY_COUNT parameter? For example (RETRY_COUNT=3) ?
    problem solved by inserting
    (RETRY_COUNT=3)
    (RETRY_DELAY=1)

    This thread can be closed.

    Thanks

  4. #4
    Join Date
    Apr 2011
    Location
    Largo, FL.
    Posts
    42
    Glad you got it sorted.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width