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 […]
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)) […]
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: […]
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 […]
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 […]
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 […]
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 […]
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 […]
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 […]