• Article Type: General
• Product: Aleph
• Product Version: 20, 21, 22, 23

Description:
In looking in the /exlibris1/backup/logs directory, we are seeing the following error messages associated with our ora_cold, ora_hot, and ora_archive backup jobs:

In ora_cold we see the following:
Copyright (c) 1982, 2007, Oracle. All rights reserved.
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00554: initialization of internal recovery manager package failed
RMAN-04005: error from target database:
ORA-12514: TNS:listener does not currently know of service requested in connect descriptor
>>>rman_set_config ... bstatus=1
>>> 22-11-2009 00:15:44

>>>Error in rman_set_config ... bstatus=1

and in ora_hot we see this:
BKP_TYPE = ora_hot
SLOT = a2

BKP_USER = aleph
BKP_DB = libcat.alephp
BKP_UDIR = /exlibris/aleph/a20_1
BKP_DIR = /exlibris1/backup_files/
RM_USER = aleph_dba

ORACLE_HOME = /exlibris/app/oracle/product/11
ORACLE_SID = alephp
HOST = libcat
OS = Linux
su = /bin/su -f

ERROR:
ORA-01031: insufficient privileges

SP2-0640: Not connected
setenv: Too many arguments.

Finally, in ora_archive we have this:

BKP_TYPE = ora_archive
SLOT = a3

BKP_USER = aleph
BKP_DB = libcat.alephp
BKP_UDIR = /exlibris/aleph/a20_1
BKP_DIR = /exlibris1/backup_files/
RM_USER = aleph_dba

ORACLE_HOME = /exlibris/app/oracle/product/11
ORACLE_SID = alephp
HOST = libcat
OS = Linux
su = /bin/su -f

Recovery Manager: Release 11.1.0.7.0 - Production on Wed Nov 11 10:15:01 2009

Copyright (c) 1982, 2007, Oracle. All rights reserved.

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00554: initialization of internal recovery manager package failed
RMAN-04005: error from target database:
ORA-12514: TNS:listener does not currently know of service requested in connect descriptor
>>>rman_set_config ... bstatus=1
>>> 11-11-2009 10:15:01

>>>Error in rman_set_config ... bstatus=1

Resolution:

The backup script is getting the service name which it is trying to match to the service name in /exlibris/app/oracle/product/12r1/network/admin/tnsnames.ora from the sysdba service_names parameter:

aleph@ils(a23_1):~/a23_1/alephm>sqlplus aleph_dba/aleph_dba as sysdba
...
...
sys@ALEPH23> show parameter service_names

NAME---------------TYPE----VALUE
service_names--string---aleph23.xxxxold.yyy.edu

Since this was *clearly* a carry-over of the old hostname. We did the following to correct it:

sys@ALEPH23> alter system set service_names = 'aleph23.xxxxnew.yyy.edu' scope=both;

System altered.

NOTE 1:  See this article if the message is, instead: "TNS:could not resolve the connect identifier specified".

NOTE 2:  

Note:  The permission error is a separate problem.  See these articles in regard to permission errors:
 
  https://knowledge.exlibrisgroup.com/...ent_privileges

  https://knowledge.exlibrisgroup.com/...sion_denied%22
 

• Article last edited: 10/8/2013