As a DBA, I have seen several kinds of ORA-12514 in different scenarios and solved them by different means. Here I divide scenarios that could throw ORA-12514 into several error patterns as below: Common Situations Restart a Database Switchover to Standby Using a Database Link There’s only one thing that can be sure in ORA-12514, […]
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 Usually, TNS-01106 notifies you that the listener you want to start is already started. You don’t have to start it again. If the listener that you want to start is different from the default one, that’s another story. Here is my case: I have setup an additional listener in listener.ora at grid level for […]
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”. In fact, this message tells us that the listener is working fine, but no dynamic […]
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 […]
ORA-12519 in Enterprise Manager Found ORA-12519 when trying to connect to the database by using dbconsole
ORA-12537 Overview There’re several possible causes to raise ORA-12537: Incorrect File Permission White or Black List ORA-12537 Caused by Incorrect File Permission Incorrect file permission will prevent connections from being established. That is to say, potentially successful connections will be interrupted by ORA-12537 due to wrong file permissions, specifically, the execution permission. As a result, […]
Connect an Idle, Nomount or Restricted Database Locally Users who belong to OSDBA or OSOPER can access a database in any states including idle, NOMOUNT or RESTRICT on local host. It’s probably not a problem on local, but remote or external access would be an issue to connect the database. Connect an Idle, Nomount or […]
