Listener

How to Resolve ORA-12514: TNS:listener does not currently know of service requested in connect descriptor

Posted on
ORA-12514 Let’s see how we reproduce TNS-12514. First of all, we have to make sure the listener is running well. C:\Users\ed>tnsping compdb TNS Ping Utility for 64-bit Windows: Version 12.1.0.1.0 – Production on 22-JUL-2014 19:24:04 Copyright (c) 1997, 2013, Oracle.  All rights reserved. Used parameter files: C:\oracle\app\client\ed\product\12.1.0\client_1\network\admin\sqlnet.ora Used TNSNAMES adapter to resolve the alias Attempting […]
Listener

How to Resolve TNS-12541: TNS:no listener

Posted on
TNS-12541 Let’s see how we reproduce TNS-12541. C:\Users\ed>tnsping compdb TNS Ping Utility for 64-bit Windows: Version 12.1.0.1.0 – Production on 22-JUL-2014 19:20:06 Copyright (c) 1997, 2013, Oracle.  All rights reserved. Used parameter files: C:\oracle\app\client\ed\product\12.1.0\client_1\network\admin\sqlnet.ora Used TNSNAMES adapter to resolve the alias Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = primary01)(PORT = 1521)) […]
Listener

How to Resolve TNS-12546: TNS:permission denied + Solaris Error: 13: Permission denied

Posted on
TNS-12546 I got TNS-12546: TNS:permission denied when I tried to start listener as oracle. oracle@solaris11vm:~$ lsnrctl startLSNRCTL for Solaris: Version 11.2.0.4.0 – Production on 31-JAN-2018 21:01:57Copyright (c) 1991, 2013, Oracle.  All rights reserved.Starting /u01/app/oracle/product/11.2.0/dbhome_1/bin/tnslsnr: please wait…TNSLSNR for Solaris: Version 11.2.0.4.0 – ProductionSystem parameter file is /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.oraLog messages written to /u01/app/oracle/diag/tnslsnr/solaris11vm/listener/alert/log.xmlListening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost)(PORT=1521)))Error listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))TNS-12546: […]
Listener

How to Resolve TNS-01106: Listener using listener name listener has already been started

Posted on
TNS-01106 I setup multiple listeners to listen different databases in listener.ora, but when I tried to start the LISTENER2, I got TNS-01106 like this: [grid@primary01 ~]$ lsnrctl start listener2 … TNS-01106: Listener using listener name listener has already been started Rationale: Key Name Collision I know LISTENER is running, but how could it be relavent […]
Listener

How to Resolve The listener supports no services

Posted on
The Listener Supports Services
The listener supports no services I newly created a database called SMALLDB, but I can’t see any service registered with the new LISTENER2 which is listening to incoming connections from port 1522. The listener showed “The listener supports no services”. This message tells us that the listener is working fine, but no service registers with […]
Listener

How to Resolve TNS-12518 + TNS-12560 on Windows Server

Posted on
Found repeated Oracle TNS error messages in listener log during peak-hours on Windows Server 2008. … 19-Oct-2010 05:32:10 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=ORCL11)(CID=(PROGRAM=C:ap001client.exe)(HOST=WIN3451)(USER=EDCHEN))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.1.2.3)(PORT=49874)) * establish * ORCL11 * 12518 TNS-12518: TNS:listener could not hand off client connection ORA-12560: TNS:protocol adapter error … The error pattern combined with TNS-12518 and TNS-12560, and it repeated itself until some […]
Listener

How to Resolve ORA-12519: TNS:no appropriate service handler found (DBD ERROR: OCIServerAttach)

Posted on
Found an error when trying to connect to the database by dbconsole, which may be in Enterprise Manager or Grid Control. The status of Agent Connection to Instance showed failed.ORA-12519 in Agent Connection to Instance (English Version)ORA-12519 in Agent Connection to Instance (Chinese Version)The very first guess in my mind was that an inappropriate service […]
Listener

How to Resolve ORA-12537:TNS:connection closed

Posted on
ORA-12537 Error Pattern 1: File Permission After installing 11g RAC, we can test the database access, it would be successful via SCAN. But when we directly access on specific node, we found the connection failed on the second node with an error: ORA-12537:TNS:connection closed Generally speaking, the listener belongs to user grid, and the database […]
Listener

How to Remotely Connect a NOMOUNT Database

Posted on
Users who belong to OSDBA or OSOPER can access a database in any states on local host if OS authentication is ON in the listener. It’s probably not a problem on local, but remote or external access would be an issue to connect to the database. Normally, you cannot connect to a nomount state database […]