Monday, November 30, 2020
dbametrix
More

    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 -
    dbametrix

    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:

    tnsping

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

    - Advertisement -
    dbametrix

    For example:

    TNSPING [email protected]

    or

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

    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 -
    dbametrix
    - Advertisment -
    dbametrix

    Most Popular

    Oracle Scheduler Jobs Example

    Blog post explains how to configure job scheduler in Oracle by example with how to manage, delete, drop, disable and enable jobs with how to check history of job if broken and enable.

    Identifying important information in Big Data

    The way in which Big Data technologies have evolved in the real word enterprise goes on to show that even technologists and scientists who might have disparaged the word (Big Data) previously

    Five Reasons Why Database Outsourcing

    The blog post explains why database outsourcing and remote dba support becomes most popular during present time of Covid-19 Pandemic.

    Hardware of Database Server

    The blog post explains how to choose best hardware of your database server for getting high performance and security.

    Recent Comments