Alibabacloud.com offers a wide variety of articles about tns service name oracle odbc, easily find your tns service name oracle odbc information here online.
Oracle listening service forced shutdown cannot start TNS identification Problem Solving Problem description: a while ago, when I went home while working on the project, I found that I could not connect to PLSQL. Then I found that tnslistener was not started, go to the service list and start it manually. Failed to star
the operating system's perspective to access real Example name, must pass ORACLE_SID. Under Winnt, Oracle_sid still needs to exist in the registration Table.And the Oracle_sid must match the value of the instance_name, otherwise you will receive a Error, on UNIX platform, is "ORACLE not available", on Winnt platform, is "TNS: Protocol Adapter Error".DB instance
Problem Description:
A while back home after the project to find that can not connect Plsql, after looking at service Discovery Tnslistener not started, and then go to the list of services to manually start. Discovery could not be started
Solution:
The reason for this problem is because of your machine IP changes. Open DOC Environment Input ipconfig look at the current machine assigned IP,
Modify D:\oracle
Original posts by
QingyunPublished on 2010-6-21 15:44When writing PL/SQL, there is a very important point of attention;Like what:BeginUpdate a SQL Server table @dblink name ...;Update a table for an oracle ...;EndThis PL/SQL execution will error:The error message is:-----------------------------------------------------------------Execution failed: ORA-02054: Transaction processing 2.12.27634 a pro
SIDIn the Oracle installation directory, such as D:/oracle/product/10.2.0/db_1/dbs, look at the file name such as Spfileorcl.ora, then is ORCL, that is, the file name is "spfile******." ORA, the kind of "* * * *" is SIDD:/oracle/product/10.2.0/oradata/sid Folder ...or d:/
parameter service_names is also registered as the service name, so a database can have multiple service names.
When you connect to an Oracle8i, 9i, or 10g server on an Oracle8i client, the host string should use the service name.
4. net
1) database name DB_NAMEThe internal mark of the Oracle database. It also exists in the binary control file and parameter file pfile. Therefore, it cannot be modified after the database is installed.You can see it in pfile.DB_NAME = ora9i # ora9i can be any nameIts role: After the database is installed, DB_NAME must be used in the physical structure file directory of the database. For example, put the pfile
" is used primarily in Sql*plus, which is used on the client," database aliases " are used primarily when some development tools connect to an Oracle server.There is also the service Name of the data source, like when you configure ODBC,They are all the same, pointing to a small piece of text in the client Tnsnames.or
Today when configuring the Oracle Net Manager Configuration service naming is always unable to configure, the previously configured service name is not displayed, and then click the Green Add button does not respond, because I previously modified the Oracle\product\10.2.0\db
service Name of the data source, like when you configure ODBC,They are all the same, pointing to a small piece of text in the client Tnsnames.ora file1, in the Sql/plus in the landing, with User/[email protected]***, then, this * * * is the host string.2, the user and password when setting up ODBC must be a legitimate
, you can have more than one name, name casually, called the dog eggs, Cui Huadu does not matter.If you do not specify, the default is db_name. Db_domain, Global_name.The database, and Oracle_sid, is telling the OS system what I call this example. These easy-to-confuse names, you have to remember,They do not refer to the database, that is, the example, there are two things, nothing else. The specific
Today, colleagues, there is a database connection failure problem, together Baidu a bit, the results finally solved, the following is a number of popular knowledge reproduced.1, Query database name: Select Name,dbid from v$database; or command line: Show parameter db_name;2. Query instance Name: Select instance_name from v$instance; or command line: Show paramete
Quickly view the information of the database connected to the Oracle service name: the specific operation command and result information are as follows :--------------------------------------------------
Quickly view the information of the database connected to the Oracle service
Quick View of the database connected by the Oracle service name:
The specific operation command and result information are as follows:
------------------------------------------------------------------
C: \ Documents ents and Settings \ Administrator> tnsping lsxy
TNS Ping Utility for 32-bit Windows: Version 11.2.0
In fact, is not a trap, just do not pay attention to, it is easy to configure errors.
This article describes the possible errors caused by load_balance and failover coordination.
When the service name is configured with both Load_balance and failover:
Testrac =
(DESCRIPTION =
(Address_list =
(address = (PROTOCOL = TCP) (HOST = 172.25.198.224) (PORT = 1521))
(address = (PROTOCOL = TCP) (HOST = 172.25.
In the team development, everyone in the general team only need to install a client, there is no need to install an Oracle database server, and the database server is shared, at this time, we need to configure the client. There are two ways to configure a client: The first is to use NET configuration Assistant, and the second is to use Net Manager, both of which are available from the Start menu, and individuals prefer to use NET configuration Assista
/*Obtain the Oracle service name1. Query the registry and obtain the Oracle Installation root directoryFor example, HKEY_LOCAL_MACHINE \ SOFTWARE \ oracle \ ORACLE_HOME REG_SZ E: \ oracle \ ora92Find the location of the Oracle
Solution to service failure after Oracle changes the machine name
After the machine name is changed in Oracle, the service cannot be started normally. You can do the following: 1. in the orac
Configure tnsnames for the local oracle NET service name. oracle local NET service name configuration tnsnames. the ora file has strict format requirements. Today, a service
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.