Friday, September 18, 2020

    Oracle SQLCL

    The blog post provides information on how to resolve the issue of Oracle SQLCL 18.2

    Oracle SQLCL 18.2:

    The TNSPING utility in the SQLCL 18.2 tool determines if the listener of service in an Oracle network can be successfully reached.

    If the connection between a client and a server (or between servers) can be successfully established with the TNSPING utility, the full time (in milliseconds) it is expected to take to access the Oracle web service will appear.

    - Advertisement -

    If it cannot, a message will appear where you can see the reason for the error. This way, you can see the network error that has occurred without having to be connected to a database.

    Use the following command to verify connectivity:


    Where the address is a TNS entry or a JDBC connection string.

    - Advertisement -

    For example:

    TNSPING [email protected]


    TNSPING localhost: 1521 / test
    SQL> tnsping
    ping: 18ms
    SQL> tnsping
    ORA-12505, TNS: listener does not currently know of SID given in connect descriptor
    ping: -1ms

    It means if you are using exact and perfect code then you can not get any issue during establishing the connection.

    Consider Reading to these articles:

    - Advertisement -
    - Advertisment -

    Most Popular

    ORA-01194: file 1 needs more recovery to be consistent

    The blog post explains how to restore and recover database using until cancel with error ORA-01194

    How to enable Archivelog

    This blog post explains how to enable archive log mode in Oracle database for newest versions.

    Shared vs Static Library Performance

    The article explains the benefits of a shared library and static library usage in application building for improving application performance.

    Migration methods of Oracle Database

    Blog post explains which tricks and methods are simple to perform migration of small and large Oracle database

    Recent Comments