Skip to main content
ExLibris
  • Subscribe by RSS
  • Ex Libris Knowledge Center

    Aleph Backup: "TNS:listener does not currently know of service ..." TWO_TASK

    • Article Type: General
    • Product: Aleph
    • Product Version: 20

    Description:
    The v20 Ex Libris Backup Package fails on our server....

    idle> Connected.
    idle> idle> Database closed.
    Database dismounted.
    ORACLE instance shut down.
    idle> ORA-12514: TNS:listener does not currently know of service requested in connect descriptor
    idle> ERROR:
    ORA-03114: not connected to ORACLE

    idle> ORA-24324: service handle not initialized
    ORA-01041: internal error. hostdef extension doesn't exist

    Resolution:
    The generic Ex Libris Backup Package is not set up to accommodate a two-task environment, with a separate database server.

    Although the hot backups have been working, cold backups should be done too.

    Ex Libris staff have stated: "We don't provide a method to automate the Aleph Shutdown, in a TWO_TASK environment for Oracle Cold Backup."

    One way to do it, without great checking, is to have crontab on the app server do Aleph shutdown and startup, like :

    00:00 Aleph_shutdown on app server
    00:15 oracle cold backup on db server
    03:00 aleph startup on app server

    However, as a non-OSP site, you need to create such crontab entries, and test them thoroughly. Ex Libris can not be responsible for these.


    • Article last edited: 10/8/2013