remote dba support
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.

    For example:

    - Advertisement -
    dbametrix
    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 issues during establishing the connection.

    When you want to make a strong Oracle DBA career then you should be aware of database services and other database technology. Without having knowledge of Oracle internals, Oracle performance tuning, and skill of Oracle database troubleshooting you can’t be an Oracle DBA expert.

    This expert DBA Team club blog always provides you latest technology news and database news to keep yourself up to date. You should need to be aware of Cloud database technology like DBaaS. All Oracle DBA tips are available in a single unique resource at our orageek. Meanwhile, we are also providing some sql tutorials for Oracle DBA. This is the part of Dbametrix Group and you would enjoy more advanced topics from our partner resource.

    - Advertisement -
    dbametrix
    - Advertisment -
    remote dba services

    Most Popular