| Soumya |
Posted: Apr 12, 2007 03:17:39 AM |
Total Post: 56
Joined: Mar, 2006
|
Hi,
I had a ques ?
I am having a 10g database . In the tnsnames.ora file we do the listener
entry also :
LISTENER_EAUDIT=(address=(protocol=tcp)(host=<IP>)(port=1521))
Is this entry mandatory ? How will it work if I change the
IP address to Hostname ?
Plz let me know...
Thanx
|
|
|
 Ratnaker |
| Posted: Apr 12, 2007 03:50:53 AM |  |
|
Total Post: 136
Joined: Apr, 2007
|
Hi Soumya,
You can change your host name host name can server IP address or server name. This is mandatory
K P Ratnaker
|
|
|
|
|
| Soumya |
| Posted: Apr 12, 2007 05:14:15 AM | |
|
Total Post: 56
Joined: Mar, 2006
|
KP,
thx.. but why is this required & were its used.
|
|
|
|
|
| ramesh |
| Posted: Apr 16, 2007 03:50:26 AM | |
|
Total Post: 16
Joined: Dec, 2006
|
hi
The address portion of the connect descriptor is actually the protocol address of the listener. To connect to a database service, clients first contact a listener process that typically resides on the database server. The listener receives incoming client connection requests and hands these requests to the database server. Once the connection is established, the client and database server communicate directly.
Much like a business address, the listener is configured to accept requests from clients at a protocol address. This address defines the protocol the listener is listening on and any other protocol specific information. For example, the listener could be configured to listen at the following protocol address:
(DESCRIPTION=
(ADDRESS=(PROTOCOL=tcp)(HOST=sales-server)(PORT=1521)))
This example shows a TCP/IP protocol address that specifies the host of the listener and a port number. Clients configured with this same protocol address can send connection requests to this listener
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
