What is TNS and listener?

What is TNS and listener?

The Listener may also be referred to as the “Oracle Net Listener” or the “Oracle TNS Listener”. Transparent Network Substrate (TNS) is the network protocol used by Oracle for connectivity to Oracle Databases.

How do I start the Oracle listener?

To start or stop the listener at the command line:

1. Open a command window.
2. Follow the steps listed in “Configuring the Operating System Environment Variables .”
3. Enter either of the following commands, depending on whether you want to start or stop the listener: lsnrctl start lsnrctl stop.

How do I fix my ORA 12528?

Restarting the Oracle instance can solve transient ORA-12528 errors. Typically (in Oracle 9i and above), when you “shutdown” an Oracle database, that process “unregisters” the database with the LISTENER. Then when you “startup” the database, it “registers” with the LISTENER.

What is TNS service name in ODBC?

Create a TNS (Transparent Network Substrate) Service Name (also called a Net Service Name) on a computer where an Oracle client is installed if the Tivoli Data Warehouse exists on a remote Oracle server. The TNS Service name is needed to create an ODBC connection between the client and the server.

How to fix ora-12528 : TNS : listener?

Enter user-name: sys@ora12c as sysdba Enter password: ERROR: ORA-12528: TNS:listener: all appropriate instances are blocking new connections To solve this problem you need to make static registration of your service in listener.ora. You need to restart listener to make it effective.

What happens if you unregister A TNS listener?

If the “unregister” did not complete properly, then when you go to “startup” the next time, since the LISTENER did not unregister the instance, you receive the error, “ORA-12528: TNS:listener: all appropriate instances are blocking new connections” since an “appropriate” instance is already running. Make sure all parameters are set.

What does Ora 12528 mean in Oracle 10g?

The ORA-12528 is a new error which has begun with Oracle 10g. Restarting the Oracle instance can solve transient ORA-12528 errors. Typically (in Oracle 9i and above), when you “shutdown” an Oracle database, that process “unregisters” the database with the LISTENER. Then when you “startup” the database, it “registers” with the LISTENER.

Which is TNS listener has all appropriate instances?

Instance “devdb”, status BLOCKED, has 1 handler (s) for this service… Service “testdb” has 1 instance (s). Instance “testdb”, status BLOCKED, has 1 handler (s) for this service… The command completed successfully You have to know if the problem come from the listener or from the database.