Tnsnames. ora Listener Configuration File details

Http://hi.baidu.com/yjdzh/blog/item/67e11162278ce6dae7113a80.html

 

 

Listener Configuration File
To enable external processes such as the cams background program to access the Oracle database
Set the Oracle network server environment to configure the Oracle network server environment through the configuration
Listener. ora sqlnet. ora and tnsnames. ora
That is, the Listener Configuration File. In this section, the other two files are described in the following two sections.
The storage path of listener. ora is $ ORACLE_HOME/Network/admin.
The following is an example
Listener = # listener name
(Description_list =
(Description =
(Address_list =
(Address = (Protocol = IPC) (Key = EXTPROC ))
)
(Address_list =
(Address =
(Protocol = TCP)
(Host = localhost. localdomain)
(Port = 1521 ))
)
)
(Description =
(Protocol_stack =
(Divsentation = GIOP)
(Session = raw)
)
(Address =
(Protocol = TCP)
(Host = localhost. localdomain)
(Port = 2481 ))

)
)

Sid_list_listener = # Name of the listener defined above in the naming rule sid_list _ +
(Sid_list =
(Sid_desc =
(Sid_name = plsextproc1)
(ORACLE_HOME =/u01/APP/Oracle/product/8.1.7)
(Program = EXTPROC)
)
(Sid_desc =
(Global_dbname = CAMs)
(ORACLE_HOME =/u01/APP/Oracle/product/8.1.7)
(Sid_name = CAMs)
)
(Sid_desc =
(Global_dbname = OID)
(ORACLE_HOME =/u01/APP/Oracle/product/8.1.7)
(Sid_name = OID)
)
)

& Description
1 The Listener. ora file defines a listener whose default name is listener.
By default, this listener uses TCP/IP as the Protocol address and the port number is 1521 and runs in the cams application.
The listener defined in the listener file uses this default name and uses the default protocol TCP/IP.
And the default port number 1521. The Listener file to be configured and the sqlnet. ora and
Use the following command to start the listener defined in the listener file after the tnsnames. ora File
Up
$ LSNRCTL start
The command to stop the listener is
$ LSNRCTL stop
The command to monitor the current status of the listener is
$ LSNRCTL status
When the lsnrctl status Command has the following output results:
Status of the listener
------------------------
Alias listener
Version tnslsnr for Linux: Version 8.1.7.4.0-Production
Start date 17-Jan-2004 19:00:08
Uptime 31 days 15 hr. 27 min. 59 Sec
The listener is running. Otherwise, the listener has stopped the background program of the cams system.
The normal running of the sequence depends not only on the running of the database instance but also on the running of the Database Listener
Run if the listener is not started, even if the database has started the cams background program
Working properly
2 As shown in (address = (Protocol = IPC) (Key = EXTPROC)
The IPC Protocol address is automatically set during database installation for external process calls.
No changes required

3. There is a sid_list_listener segment at the end of the listener file to define the listener.
Which database instances provide the Monitoring Service. Take the cams instance as an example.
The service information is
(Sid_desc =
(Global_dbname = CAMs) # Database Name
(ORACLE_HOME =/u01/APP/Oracle/product/8.1.7)
(Sid_name = CAMs) # database instance name
)

1.2.5 sqlnet. ora File
The path for storing the sqlnet. ora file is $ ORACLE_HOME/Network/admin.
Examples

Names. default_domain = localdomain
Names. directory_path = (tnsnames, onames, hostname)
& Description
Names. default_domain specify the network domain name names. directory_path
Specify the priority of naming metthods when resolving the client connection identifier
Descending Order from left to right in the cams application.
Saved Value

1.2.6 tnsnames. ora File
The storage path of the tnsnames. ora file is below $ ORACLE_HOME/Network/admin.
Is an example
Oid. localdomain =
(Description =
(Address_list =
(Address = (Protocol = TCP) (host = localhost. localdomain) (Port =
1521 ))
)
(CONNECT_DATA =
(SERVICE_NAME = OID)
)
)
Cams. localdomain =
(Description =
(Address_list =
(Address = (Protocol = TCP) (host = localhost. localdomain) (Port =
1521 ))
)
(CONNECT_DATA =
(SERVICE_NAME = CAMs)
)
)
Instanchttp.localdomain =
(Description =
(Address_list =
(Address = (Protocol = TCP) (host = localhost. localdomain) (Port =

1521 ))
)
(CONNECT_DATA =
(Server = shared)
(SERVICE_NAME = modose)
(Divsentation = http: // admin)
)
)
Extproc_connection_data.localdomain =
(Description =
(Address_list =
(Address = (Protocol = IPC) (Key = EXTPROC ))
)
(CONNECT_DATA =
(SID = plsextproc1)
(Divsentation = Ro)
)
)
　

& Description
The tnsnames. ora file defines one or more network service net service cams instance pairs.
The network service is
Cams. localdomain =
(Description =
(Address_list =
(Address =
(Protocol = TCP)
(Host = localhost. localdomain)
(Port = 1521 ))
)
(CONNECT_DATA =
(SERVICE_NAME = CAMs)
)
)
Note that the address item contains three sub-parameters.

Protocol: default protocol TCP

HOST: IP Address

Port: port. The default value is 1521.

Cams. localdomain is the data name

Make sure that a corresponding address item also contains the same three sub-parameters in the listener file.
And the sub-parameter values are equal. In addition, the value of SERVICE_NAME must be true.
The value of the sid_name parameter under the sid_desc item in the listener file is equal

 

 

 

Http://topic.csdn.net/u/20090310/23/BD468E7C-9E19-4C99-8BF9-F0D8E3D6A662.html

 

This article is
Http://topic.csdn.net/u/20090303/15/0bec0070-e387-4611-aac8-721df3207b33.html
.
PHP verification code, which only provides the digital verification code recognition technology for specific locations and fonts. This article attempts to identify the rotating font, the numbers and letter verification codes of the character sticks, and further enhances the Noise Removing function and the BMP-to-JPEG function, the learning function is also added (manual support is required ).
In the previous article <PHP verification code recognition (preliminary)>, I talked about how to identify simple verification. Here, the simple verification code is composed of digits and letters in a unified format, the position of each appearance is fixed. This article will continue to study the verification code in depth. The purpose of this recognition is that the verification code consists of characters and numbers. The verification code is rotated (either left or right) and its position is not fixed, there is a adhesion between characters, and the verification code has stronger interferon. The method described in this article is not a omnipotent solution, and providing Code cannot directly solve your problem. Here is only a solution. The readers can solve the problem by themselves, the verification code has nothing to do with the specific programming language. Here we only use the PHP language to implement the verification code. The method described here can be implemented in any language.

This article describes the steps involved in the verification code recognition process.

For example, the subsequent explanations are all centered on this figure.
I. When we get a verification code, the first thing we need to do at first glance is binarization. The verification code part is represented by 1, and the background part is represented by 0. The recognition method is very simple. We can print the RGB color of the image on which the verification code is displayed, and then analyze its regular pattern through the RGB code, we can easily tell that the R value of the above image is greater than 120, and the values of G and B are less than 80. Therefore, based on this rule, we can easily binarization the image above. Let's look at the two images recognized in the first article.

It seems complicated. The background color of each verification code image is different, and the color of each verification code number is different. It seems difficult to binarization. In fact, we can easily print out the RGB values. No matter how the color of the verified digit changes, the RGB value of the digit is always less than 125.

Original URL: http://blog.csdn.net/ugg/archive/2009/03/09/3972368.aspx
Code download: http://download.csdn.net/source/1084418

Welcome to shoot bricks