listener does not currently know of service requested in connect descriptor
- 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