Generally, Oracle is connected using the OCI interface of OracleClient (non-JDBC), and the local connection name localname is configured. Once an error occurs during the connection process, we
Generally, we use the Oracle Client (non-JDBC) OCI
Compare the ping commands of tnsping and TCP/IP of Orale:
-----------------------------------------------------------------------------Oracle Net tool (command) tnsping is an OSI Session Layer tool used:
1) Verify the name resolution (name
An access troubleshooting-TNS-03505, ORA-12154, TNS-12560, dynamic registration, firewall, tnsping tracking, tns-03505tnsping
To access the database through Oracle Net, You need to configure the listener and tnsnames. ora. Next, you will encounter a
Today is a cloudy day, God want to down, sleepy always want to sleep ...The amount of ... Don't say much nonsense.Today, I want to do a catalog library, I installed on the virtual machine oracle11g, this is different from the target database,So
"Introduction to the Environment"System environment: Linux + Oracle 11.2.0.4.0 + python 2.7.10"Background description"Requirements: Because of the production database involved more, business boast multiple database use. When the business has some
The previous time to connect to the Oracle database remotely, but do not want to complete the installation of OracleClient on their own computer, so to the Oracle website to download the lightweight Clientinstant client.This thing does not have a
To connect to the Oracle database remotely, but not to fully install the Oracle client on its own computer, the lightweight client instant clients were downloaded to the Oracle website. This thing does not have a graphical interface, all rely on
I had an interesting question today.
Oracle users can tnsping, ordinary users tnsping error
When you tnsping a database with a regular user
tns-03505:failed to resolve name
and tnsping the database with an Oracle user, you can ping it.
tnsping
Suse10sp2 install oracle11g client, create aipcti user, tnspingvsm (vsm is the service name under the client) failed, error: TNS-03505: Failedtoreso
Suse10sp2 install oracle11g client, create aipcti user, tnsping vsm (vsm is the service name under
OracleNet tool (command) tnsping is an OSI Session Layer tool used to verify name resolution (nameresolution, which is the name of an oracle Network Service)
Oracle Net tool (command) tnsping is an OSI Session Layer tool used to verify name
Oracle Net tool (command) tnsping is an OSI Session Layer tool used:
1) Verify the name resolution (name resolution, which is the name of the oracle Network Service)
2) whether the remote listener is enabled
1. Remote tnsping
2. Disable
If you want to set up DG, set listener and TNS service, test tnsping, and Ping fails, the following error is reported.
[Grid @ Rac1 ~] $ Tnsping sharon_st
TNS Ping utility for Linux: Version 11.2.0.3.0-production on 30-jul-2013 22:18:29
Copyright (c)
Does tnsping prove that the Oracle database is available ?, TnspingoracleListener is a server-based network service of Oracle. It is mainly used to listen for connection requests from clients to database servers. Oracle officially defines it as: A
The Listener is an Oracle server-based network service that listens to client connection requests to the database server side. Oracle officially defines it as:A process, listens for incoming client connection requests and manages network traffic
[Root @ Rac1 admin] # tnsping rac2
TNS Ping utility for Linux: Version 11.2.0.3.0-production on 19-jul-2013 20:40: 45
Copyright (c) 1997,201 1, Oracle. All rights reserved.
Used parameter files:/U01/APP/GRID/11.2.0/Network/admin/sqlnet. ora
Today I'm going to do a few Oracle experiments and suddenly discover Oracle that can't connect to the virtual machine, and dynamic listening won't start.
Issue 1: Dynamic listening does not start
Reason:/etc/hosts in the configuration error, the
Oracle TnsPing is correct, pl/SQL ora-12154 cannot resolve the resolution of the specified connection identifier to tnsnames in C: \ oracle \ ora92 \ network \ ADMIN \ SAMPLE. copy the ora file to C: \ oracle \ ora92 \ network \ ADMIN and try again!
1. Check whether the network ping host or IP is healthy and DNS is set correctly2. Check firewall settings3. Check the Listener.log log to see if there is a large number of connections attached.4. Check if the Listener.log log file is too large, if
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.