I have a 2-node RAC working fine on an AIX box. I'm in the process of setting up RMAN to be used with TSM etc...
One of the phases is to verify the connectivity to the target nodes and catalog - performing an rman/target @ blah blah works fine and both db's are registered alongside the necessary parameters - so far so good
When I attempt to test the connection I receive an ORA-12514 error, but the tnsnames.ora is fine and the lsnrctl status and services seems fine
I have tried to provide as much info as possible in the hope that it is a simple fix if you can assist.
- Code: Select all
oracle@rvecrcdrprep > lsnrctl status
LSNRCTL for IBM/AIX RISC System/6000: Version 11.2.0.2.0 - Production on 03-OCT-2012 12:53:26
Copyright (c) 1991, 2010, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=ecrcdrprep.hscni.net)(PORT=1521)))
TNS-01189: The listener could not authenticate the user
oracle@rvecrcdrprep > id
uid=203(oracle) gid=204(oinstall) groups=205(dba),206(oper),208(asmdba),209(asmadmin),210(asmoper)
oracle@rvecrcdrprep > lsnrctl services
LSNRCTL for IBM/AIX RISC System/6000: Version 11.2.0.2.0 - Production on 03-OCT-2012 12:54:01
Copyright (c) 1991, 2010, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=ecrcdrprep.hscni.net)(PORT=1521)))
TNS-01189: The listener could not authenticate the user
oracle@rvecrcdrprep > lsnrctl status
LSNRCTL for IBM/AIX RISC System/6000: Version 11.2.0.2.0 - Production on 03-OCT-2012 12:54:06
Copyright (c) 1991, 2010, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=ecrcdrprep.hscni.net)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER_SCAN1
Version TNSLSNR for IBM/AIX RISC System/6000: Version 11.2.0.2.0 - Production
Start Date 27-SEP-2012 14:40:01
Uptime 5 days 22 hr. 14 min. 4 sec
Trace Level off
Security ON: Local OS Authentication
SNMP ON
Listener Parameter File /mware/oracle/11.2/grid/network/admin/listener.ora
Listener Log File /mware/oracle/11.2/grid/log/diag/tnslsnr/rvecrcdrprep/listener_scan1/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER_SCAN1)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.210.2.126)(PORT=1521)))
Services Summary...
Service "CDRPREP" has 2 instance(s).
Instance "CDRPREP1", status READY, has 1 handler(s) for this service...
Instance "CDRPREP2", status READY, has 1 handler(s) for this service...
Service "CDRPREPXDB" has 2 instance(s).
Instance "CDRPREP1", status READY, has 1 handler(s) for this service...
Instance "CDRPREP2", status READY, has 1 handler(s) for this service...
The command completed successfully
oracle@rvecrcdrprep >
Attempting connection into the database as sys - this will be required for rman backup within RAC
- Code: Select all
oracle@rvecrcdrprep > sqlplus /nolog
SQL*Plus: Release 11.2.0.2.0 Production on Wed Oct 3 12:56:33 2012
Copyright (c) 1982, 2010, Oracle. All rights reserved.
SQL> connect sys/password@cdrprep1 as sysdba
ERROR:
ORA-12514: TNS:listener does not currently know of service requested in connect
descriptor
SQL> connect sys/password@cdrprep2 as sysdba
ERROR:
ORA-12514: TNS:listener does not currently know of service requested in connect
descriptor
But I have no trouble connecting to the database
- Code: Select all
oracle@rvecrcdrprep > sqlplus '/ as sysdba'
SQL*Plus: Release 11.2.0.2.0 Production on Wed Oct 3 12:57:12 2012
Copyright (c) 1982, 2010, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
SQL> select instance_name, status from v$instance;
INSTANCE_NAME STATUS
---------------- ------------
CDRPREP1 OPEN
SQL>
So I checked my tnsnames.ora
- Code: Select all
oracle@rvecrcdrprep > more tnsnames.ora
# tnsnames.ora Network Configuration File: /mware/oracle/11.2/product/11.2.0/dbhome_1/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.
CDRPREP =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = ecrcdrprep.hscni.net)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = CDRPREP)
)
)
CDRPREP2 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = bvecrcdrprep.hscni.net)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = CDRPREP2)
)
)
CDRPREP1 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = rvecrcdrprep.hscni.net)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = CDRPREP1)
)
)
BSORMANCAT =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = oralive1.hpss.n-i.nhs.uk)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = BSORMANCAT)
)
)
$
Then I looked at the listener parameter
- Code: Select all
SQL> show parameter local listener
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
local_listener string (DESCRIPTION=(ADDRESS_LIST=(AD
log_archive_local_first boolean TRUE
parallel_force_local boolean FALSE
SQL>
Having looked through some of the posts in this forum it seems like it may be an issue with the service name within the tnsnames.ora file. Firstly is this the case and second if so, what do I change that to ?
Many thanks in advance
Jnrpeardba
