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