tns service name oracle odbc

Error: ORA-12154: TNS: unable to process service name The cause of this error is different from that of Baidu. My client programs can be executed normally in different directories, however, an error occurs in one of the directories, so I think there is a problem in the directory path. Since it is a path, it can only be caused by the special characteristics of th

Error description The operating system is Win7 x64,oracle server is oracle11g x64, the client is ORACLE10GR2 x86. Connection is normal using Pl-sql developer Using the system ODBC connection is OK. It is important to note that the 64-bit system starts with the 64-bit ODBC data Source Manager by default, and the default point is to the server connection

This article will explain a case of ORA-12162 error caused by the absence of the system environment variable oracle_sid. I hope you will think about it.1. Get General Expression Information about ORA-12162 error messages[Oracle @ asdlabdb01 ~] $ OerrOra 1216212162,000 00, "TNS: net service name is incorrectly specified

ORA-12162: TNS: net service name is incorrectly specified how to solve the error ?, Ora-12162tns "ORA-12162: TNS: net service name is incorrectly specified" appears today when you log on to sqlplus using an

Platform: Oracle 9i + Windows 2003 Fault performance: ORA-12154: TNS: cocould not resolve service name Data guard has been operating normally before. This error was reported suddenly. Archiving cannot be completed, but the tnsping Sid is used. No problem, and no problem with the listener. Because

Sometimes how to configure tnsnames. ora has a ora-12154 TNS: failed to handle service name errors! In fact, the configuration strings vary according to the Oracle version. For example, the content of the sqlnet. ora file of oracle8.1.5 is as follows: Path: orant \ net80 \ admin \ sqlnet. oratrace_level_client = Off #

Http://www.cnblogs.com/xh3/archive/2007/04/21/722217.htmlVery strange a problem, in the network environment to configure the client, unexpectedly how can not even on the host, read a lot of posts, most are repairChanged the configuration in the Tnsnames.ora file, but tried a lot of it, and finally opened the file in Sqlnet.ora found the problem,# sqlnet. ORA Network Configuration File:f:\oracle\ora90\network\admin\sqlnet.ora# Generated by

After several days of PLSQL, I finally solved this problem and shared it with my friends who needed it. Servers: windowsserver2008 (64-bit OS) and win7 (64-bit OS) Oracle version: 10.2.0 Problem: netmanger test successful after oracle is installed, PLSQL shows ora-12154 TNS after connecting to database after installation: unable to process

About Oracle "ORA-12514 TNS Listener does not currently recognize request service in connection descriptor" errorReason:The listener server name is not specified in Listener.ora.Here's how to solve the idea:Try 1, start the database by restarting the service, and the connect

Label:Recently there was a problem when I installed Oracle,Oracle 11g Ora-12514:tns: The listener does not currently recognize the requested service in the connection descriptorPreviously installed Oracle many times Online search a lot of methods or can not solve, and finall

When oracle was installed, the machine name was host = user49561.After modification, start the oracletnslisener service in the control panel service and immediately stopUse the command line tool instead:LSNRCTLStartTip: Tnslsnr for 32-bit windows: Version 9.2.0.1.0-ProductionSystem parameter file is D: \

Ora-12514:tns after installation of Oracle reboot: Listener does not currently recognize the requested service in the connection descriptor (normal before reboot)After the installation is complete with Plsql login normal.Under DOS command lineInput SqlplusUser name: System as SYSDBAPassword:Then type: shutdownTips:Ora-

off.Since no listener is specified in the Listener.ora, we can specify the listener instance name in the Listener.ora file so that the problem should be connected. Re-register the listener information.The steps are as follows:在oracle服务器Oracle安装目录（我的在D:\app\qichunlin\product\11.2.0\dbhome_1\network\admin Display content is# listener.ora Network Configuration Fi

method 3: query in the parameter file. Although both database instance names and ORACLE_SID are oracle instances, they are different. Instance_name is an oracle database parameter. ORACLE_SID is the environment variable of the operating system. ORACLD_SID is used to interact with the operating system. That is to say, the Instance name accessed from the operating

Create a database test1. Open the Oracle Net Manager2. Service Naming: TestTCPIP Host: 127.0.0.1 Port: 15213. Listening programsSelect a listening locationNetwork address: localhostPort: 1521Select Database ServiceGlobal database name Sid:test4. Stop the monitoring service to start the monitoring

To enable Oracle clients to connect properly to an Oracle server with a firewall, it is not enough to open a 1521 or custom listening port alone. The server installed Windows2003, and opened the system from the firewall, found in the connection on the firewall opened on the listening port 1521 still unable to connect, reported TNS connection Timeout error. Then

Label:1. Locate the Listener.ora listening file, in the exact location: D:\app\Administrator\product\11.2.0\dbhome_1\NETWORK\ADMIN\listener.ora 2. Found in the Lisener.ora file (Sid_desc =(Sid_name = Clrextproc)(Oracle_home = D:\app\Administrator\product\11.2.0\dbhome_1)(program = Extproc)(Envs = "Extproc_dlls=only:d:\app\administrator\product\11.2.0\dbhome_1\bin\oraclr11.dll")) Copy the following section and modify it appropriately. (The Scarlet Letter part is your SID, where Global_dbname is

This error occurs when connecting to the server from the client, ora12541-TNS: No listener Then, start the oracleorahome92tnslistener service on the server and display "The oracleorahome92tnslistener service cannot be started on the local computer. Error 3: The specified path cannot be found ". The path in the service

, and ORACLE_SID is an environment variable for the operating system. In the database connection process, ORACLE_SID must be consistent with the value of instance_name, otherwise error: Under UNIX: Oracle not available Win under: TNS: Protocol Adapter error The database instance name is also the Oracle server identity