ORA-12514 means that the listener cannot find any matched service with yours, so it cannot establish the connection with the database for you. As a result, it responds ORA-12514 to alert the failed connection. As a DBA, I have seen several kinds of ORA-12514 in different scenarios and solved them by different means. Here I […]
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 […]
I have two error patterns on ORA-12560, one is related to ORACLE_SID problem, the other is related to the limitation of PROCESSES. ORA-12560 due to Incorrect ORACLE_SID First of all, allow me reproduce the error ORA-12560 for you. Check the instance name and current status. C:\Users\Administrator>sqlplus / as sysdba SQL*Plus: Release 12.2.0.1.0 Production on Thu […]
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 […]
