Home » RDBMS Server » Networking and Gateways » usage of hostname in tnsnames.ora and resolving the same with hosts file on linux platform. (Oracle 10g R2)
usage of hostname in tnsnames.ora and resolving the same with hosts file on linux platform. [message #538288] Thu, 05 January 2012 03:08 Go to next message
snehalgandhi
Messages: 43
Registered: February 2011
Location: Ahmedabad
Member
I am writing hostname in the tnsnames.ora file instead of IP address, also the host file of the server contains proper entry, but still i am not able to connect to database. Can any one guide on the same ?

Entries of tnsnames.ora
=======================
SUNPROD =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = testdb)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SID = oradb)
    )
  )


Entries in hosts file on linux
==============================
192.138.2.66 testdb
Re: usage of hostname in tnsnames.ora and resolving the same with hosts file on linux platform. [message #538290 is a reply to message #538288] Thu, 05 January 2012 03:13 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
but still i am not able to connect to database

This does not give any clue why you cannot connect.

Always COPY AND PASTE what you do and get.

Regards
Michel
Re: usage of hostname in tnsnames.ora and resolving the same with hosts file on linux platform. [message #538291 is a reply to message #538290] Thu, 05 January 2012 03:15 Go to previous messageGo to next message
snehalgandhi
Messages: 43
Registered: February 2011
Location: Ahmedabad
Member
Dear Michel,
I am getting following error.

ERROR:
ORA-12535: TNS:operation timed out

Re: usage of hostname in tnsnames.ora and resolving the same with hosts file on linux platform. [message #538292 is a reply to message #538291] Thu, 05 January 2012 03:22 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
Always COPY AND PASTE what you do and get.

Use SQL*Plus and COPY AND PASTE the connection.

Also post the content of sqlnet.ora.

Regards
Michel

[Updated on: Thu, 05 January 2012 03:23]

Report message to a moderator

Re: usage of hostname in tnsnames.ora and resolving the same with hosts file on linux platform. [message #538293 is a reply to message #538292] Thu, 05 January 2012 03:24 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Also post (copy and paste):
ping testdb
tnsping SUNPROD

Regards
Michel
Re: usage of hostname in tnsnames.ora and resolving the same with hosts file on linux platform. [message #538294 is a reply to message #538292] Thu, 05 January 2012 03:25 Go to previous messageGo to next message
snehalgandhi
Messages: 43
Registered: February 2011
Location: Ahmedabad
Member
Dear Michel,


SQLNET.AUTHENTICATION_SERVICES= (NTS)

NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME)
Re: usage of hostname in tnsnames.ora and resolving the same with hosts file on linux platform. [message #538295 is a reply to message #538294] Thu, 05 January 2012 03:33 Go to previous messageGo to next message
snehalgandhi
Messages: 43
Registered: February 2011
Location: Ahmedabad
Member
Ping Output
=================
C:\Documents and Settings\devlop>ping testdb

Pinging testdb [191.9.200.6] with 32 bytes of data:

Reply from 191.9.200.6: bytes=32 time<10ms TTL=128
Reply from 191.9.200.6: bytes=32 time<10ms TTL=128
Reply from 191.9.200.6: bytes=32 time<10ms TTL=128
Reply from 191.9.200.6: bytes=32 time<10ms TTL=128

Ping statistics for 191.9.200.6:
Packets: Sent = 4, Received = 4, Lost = 0 (0% loss),
Approximate round trip times in milli-seconds:
Minimum = 0ms, Maximum = 0ms, Average = 0ms


tnsping output
==============
C:\Documents and Settings\devlop>ping testdb

Pinging testdb [191.9.200.6] with 32 bytes of data:

Reply from 191.9.200.6: bytes=32 time<10ms TTL=128
Reply from 191.9.200.6: bytes=32 time<10ms TTL=128
Reply from 191.9.200.6: bytes=32 time<10ms TTL=128
Reply from 191.9.200.6: bytes=32 time<10ms TTL=128

Ping statistics for 191.9.200.6:
Packets: Sent = 4, Received = 4, Lost = 0 (0% loss),
Approximate round trip times in milli-seconds:
Minimum = 0ms, Maximum = 0ms, Average = 0ms

===================================================
Note: Please ignore the ip address....
Re: usage of hostname in tnsnames.ora and resolving the same with hosts file on linux platform. [message #538296 is a reply to message #538295] Thu, 05 January 2012 03:38 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
tnsping output

This is not a tnsping output.

Also, use SQL*Plus and COPY AND PASTE the connection.

Regards
Michel


Re: usage of hostname in tnsnames.ora and resolving the same with hosts file on linux platform. [message #538298 is a reply to message #538296] Thu, 05 January 2012 03:48 Go to previous messageGo to next message
ramoradba
Messages: 2456
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
Quote:
192.138.2.66 testdb

Quote:
C:\Documents and Settings\devlop>ping testdb

Pinging testdb [191.9.200.6] with 32 bytes of data:

Reply from 191.9.200.6: bytes=32 time<10ms TTL=128



Difference ?


Sriram
Re: usage of hostname in tnsnames.ora and resolving the same with hosts file on linux platform. [message #538299 is a reply to message #538298] Thu, 05 January 2012 03:58 Go to previous messageGo to next message
snehalgandhi
Messages: 43
Registered: February 2011
Location: Ahmedabad
Member
Please ignore the IP address as 200.6 is the real one, 2.66 is a fake IP i just wrote in the query.
Re: usage of hostname in tnsnames.ora and resolving the same with hosts file on linux platform. [message #538301 is a reply to message #538299] Thu, 05 January 2012 03:59 Go to previous messageGo to next message
snehalgandhi
Messages: 43
Registered: February 2011
Location: Ahmedabad
Member
Ping testdb
=============
C:\Documents and Settings\devlop>ping testdb

Pinging testdb [191.9.200.6] with 32 bytes of data:

Reply from 191.9.200.6: bytes=32 time<10ms TTL=128
Reply from 191.9.200.6: bytes=32 time<10ms TTL=128
Reply from 191.9.200.6: bytes=32 time<10ms TTL=128
Reply from 191.9.200.6: bytes=32 time<10ms TTL=128

Ping statistics for 191.9.200.6:
Packets: Sent = 4, Received = 4, Lost = 0 (0% loss),
Approximate round trip times in milli-seconds:
Minimum = 0ms, Maximum = 0ms, Average = 0ms


tnsping output
===============
C:\Documents and Settings\devlop>tnsping sunprod

TNS Ping Utility for 32-bit Windows: Version 9.2.0.1.0 - Production on 05-JAN-20
12 14:57:11

Copyright (c) 1997 Oracle Corporation. All rights reserved.

Used parameter files:
E:\oracle\ora92\network\admin\sqlnet.ora


Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)
(HOST = testdb)(PORT = 1521))) (CONNECT_DATA = (SID = oradb)))
OK (70 msec)
Re: usage of hostname in tnsnames.ora and resolving the same with hosts file on linux platform. [message #538303 is a reply to message #538301] Thu, 05 January 2012 04:01 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Now in the same window show the connection with SQL*Plus.

Regards
Michel
Re: usage of hostname in tnsnames.ora and resolving the same with hosts file on linux platform. [message #538305 is a reply to message #538303] Thu, 05 January 2012 04:02 Go to previous messageGo to next message
snehalgandhi
Messages: 43
Registered: February 2011
Location: Ahmedabad
Member
SQL> @sunp
Connecting to SUN prod
ERROR:
ORA-12535: TNS:operation timed out


Warning: You are no longer connected to ORACLE.

Re: usage of hostname in tnsnames.ora and resolving the same with hosts file on linux platform. [message #538308 is a reply to message #538305] Thu, 05 January 2012 04:04 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I don't know what you have in your script.
Post "connect .....@sunprod" (fourth time).

Regards
Michel
Re: usage of hostname in tnsnames.ora and resolving the same with hosts file on linux platform. [message #538310 is a reply to message #538308] Thu, 05 January 2012 04:06 Go to previous messageGo to next message
snehalgandhi
Messages: 43
Registered: February 2011
Location: Ahmedabad
Member
Sorry michel i could not understand your query.
[
prompt Connecting to SUN prod
conn prod/prod@sunprod;
]
Re: usage of hostname in tnsnames.ora and resolving the same with hosts file on linux platform. [message #538315 is a reply to message #538308] Thu, 05 January 2012 04:19 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
Quote:
conn prod/prod@sunprod;
Is the semicolon causing your problem? It shouldn;t be there.
Re: usage of hostname in tnsnames.ora and resolving the same with hosts file on linux platform. [message #538316 is a reply to message #538310] Thu, 05 January 2012 04:20 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Post the complete SQL*Plus session from the SAME window than you executed the tnsping and WITHOUT any script JUST the command "connect".

Regards
Michel
Re: usage of hostname in tnsnames.ora and resolving the same with hosts file on linux platform. [message #538321 is a reply to message #538316] Thu, 05 January 2012 04:33 Go to previous messageGo to next message
snehalgandhi
Messages: 43
Registered: February 2011
Location: Ahmedabad
Member
tnsping
========
C:\Documents and Settings\devlop>tnsping sunprod

TNS Ping Utility for 32-bit Windows: Version 9.2.0.1.0 - Production on 05-JAN-20
12 15:58:10

Copyright (c) 1997 Oracle Corporation. All rights reserved.

Used parameter files:
E:\oracle\ora92\network\admin\sqlnet.ora


Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)
(HOST = testdb)(PORT = 1521))) (CONNECT_DATA = (SID = oradb)))
OK (30 msec)

sql*plus
========
SQL> conn prod/prod@sunprod
ERROR:
ORA-12535: TNS:operation timed out


Warning: You are no longer connected to ORACLE.

Re: usage of hostname in tnsnames.ora and resolving the same with hosts file on linux platform. [message #538322 is a reply to message #538321] Thu, 05 January 2012 04:35 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I can't believe this has been executed in the same window.

Regards
Michel

[Updated on: Thu, 05 January 2012 04:35]

Report message to a moderator

Re: usage of hostname in tnsnames.ora and resolving the same with hosts file on linux platform. [message #538323 is a reply to message #538322] Thu, 05 January 2012 04:37 Go to previous messageGo to next message
snehalgandhi
Messages: 43
Registered: February 2011
Location: Ahmedabad
Member
Dear Michel,
I am executing tnsping in the command prompt of windows
and "connect" in SQL *PLUS session....
Please explain how to combine both.
Re: usage of hostname in tnsnames.ora and resolving the same with hosts file on linux platform. [message #538324 is a reply to message #538323] Thu, 05 January 2012 04:42 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
and "connect" in SQL *PLUS session....

sqlplus executed in the same window than tnsping?

Copy and paste the whole DOS session.

Regards
Michel
Re: usage of hostname in tnsnames.ora and resolving the same with hosts file on linux platform. [message #538325 is a reply to message #538324] Thu, 05 January 2012 04:44 Go to previous messageGo to next message
snehalgandhi
Messages: 43
Registered: February 2011
Location: Ahmedabad
Member
C:\Documents and Settings\devlop>tnsping sunprod

TNS Ping Utility for 32-bit Windows: Version 9.2.0.1.0 - Production on 05-JAN-20
12 16:09:15

Copyright (c) 1997 Oracle Corporation. All rights reserved.

Used parameter files:
E:\oracle\ora92\network\admin\sqlnet.ora


Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)
(HOST = testdb)(PORT = 1521))) (CONNECT_DATA = (SID = oradb)))
OK (30 msec)

C:\Documents and Settings\devlop>sqlplus

SQL*Plus: Release 9.2.0.1.0 - Production on Thu Jan 5 16:09:25 2012

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

Enter user-name: prod@sunprod
Enter password:
ERROR:
ORA-12505: TNS:listener could not resolve SID given in connect descriptor


Enter user-name:

Re: usage of hostname in tnsnames.ora and resolving the same with hosts file on linux platform. [message #538327 is a reply to message #538325] Thu, 05 January 2012 04:47 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
See, this is not the same error.
Now your remote listener is not listening for the SID "oradb".

Note if I ask you to do something this is not to bother you but to diagnose so, please, do EXACTLY what is asked without trying to understand or interpret it.

Regards
Michel

[Updated on: Thu, 05 January 2012 04:49]

Report message to a moderator

Re: usage of hostname in tnsnames.ora and resolving the same with hosts file on linux platform. [message #538331 is a reply to message #538327] Thu, 05 January 2012 04:56 Go to previous messageGo to next message
snehalgandhi
Messages: 43
Registered: February 2011
Location: Ahmedabad
Member
Ok. I will...

Now i am giving another scenario...
where SID is ashima and host is payroll
=========================================================
Below is the tnsping and sqlplus output...

C:\Documents and Settings\devlop>tnsping sunprod

TNS Ping Utility for 32-bit Windows: Version 9.2.0.1.0 - Production on 05-JAN-20
12 16:16:58

Copyright (c) 1997 Oracle Corporation. All rights reserved.

Used parameter files:
E:\oracle\ora92\network\admin\sqlnet.ora


Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)
(HOST = payroll)(PORT = 1521))) (CONNECT_DATA = (SID = ashima)))
TNS-12535: TNS:operation timed out

C:\Documents and Settings\devlop>sqlplus

SQL*Plus: Release 9.2.0.1.0 - Production on Thu Jan 5 16:18:25 2012

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

Enter user-name: prod@sunprod
Enter password:
ERROR:
ORA-12535: TNS:operation timed out


Enter user-name:
Re: usage of hostname in tnsnames.ora and resolving the same with hosts file on linux platform. [message #538332 is a reply to message #538331] Thu, 05 January 2012 05:21 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
TNS-12535: TNS:operation timed out

Quote:
ORA-12535: TNS:operation timed out

This is consistent; what did you expect?

Regards
Michel
Re: usage of hostname in tnsnames.ora and resolving the same with hosts file on linux platform. [message #538333 is a reply to message #538332] Thu, 05 January 2012 05:42 Go to previous messageGo to next message
snehalgandhi
Messages: 43
Registered: February 2011
Location: Ahmedabad
Member
What could be the reason for this error, though i get proper ping response.
Re: usage of hostname in tnsnames.ora and resolving the same with hosts file on linux platform. [message #538338 is a reply to message #538333] Thu, 05 January 2012 05:57 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
though i get proper ping response

Nothing in what you posted shows it.

Regards
Michel

[Updated on: Thu, 05 January 2012 05:58]

Report message to a moderator

Re: usage of hostname in tnsnames.ora and resolving the same with hosts file on linux platform. [message #538362 is a reply to message #538315] Thu, 05 January 2012 09:12 Go to previous messageGo to next message
ramoradba
Messages: 2456
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
John Watson wrote on Thu, 05 January 2012 15:49
Quote:
conn prod/prod@sunprod;
Is the semicolon causing your problem? It shouldn;t be there.


It`s not an issue all the time....
SQL*Plus: Release 10.2.0.3.0 - Production on Thu Jan 5 20:30:34 2012

Copyright (c) 1982, 2006, Oracle.  All Rights Reserved.


Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

dev> conn sriram/sriram@ind;
Connected.
ind> 



@OP

Quote:
C:\Documents and Settings\devlop>tnsping sunprod

TNS Ping Utility for 32-bit Windows: Version 9.2.0.1.0 - Production on 05-JAN-20
12 16:16:58

Copyright (c) 1997 Oracle Corporation. All rights reserved.

Used parameter files:
E:\oracle\ora92\network\admin\sqlnet.ora


Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)
(HOST = payroll)(PORT = 1521))) (CONNECT_DATA = (SID = ashima)))
TNS-12535: TNS:operation timed out

Quote:
C:\Documents and Settings\devlop>tnsping sunprod

TNS Ping Utility for 32-bit Windows: Version 9.2.0.1.0 - Production on 05-JAN-20
12 16:09:15

Copyright (c) 1997 Oracle Corporation. All rights reserved.

Used parameter files:
E:\oracle\ora92\network\admin\sqlnet.ora


Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)
(HOST = testdb)(PORT = 1521))) (CONNECT_DATA = (SID = oradb)))
OK (30 msec)

C:\Documents and Settings\devlop>sqlplus

SQL*Plus: Release 9.2.0.1.0 - Production on Thu Jan 5 16:09:25 2012

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

Enter user-name: prod@sunprod
Enter password:
ERROR:
ORA-12505: TNS:listener could not resolve SID given in connect descriptor


Enter user-name:


Two different hosts and two different errors.
On both servers ....

1) Any firewall installed ?
2) Does your server allow you on 1521 ?
3) Are you able to connect to DB on server rather than client ?

Sriram Sanka

Re: usage of hostname in tnsnames.ora and resolving the same with hosts file on linux platform. [message #538374 is a reply to message #538362] Thu, 05 January 2012 11:17 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
The first thing is "does ping work" but OP did not answer this and he did not answer since my last post more than 5 hours ago, I think this was the right point.

Regards
Michel
Re: usage of hostname in tnsnames.ora and resolving the same with hosts file on linux platform. [message #538413 is a reply to message #538374] Thu, 05 January 2012 19:44 Go to previous messageGo to next message
ramoradba
Messages: 2456
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
Yes ! I agree with your point ,Its should be a first hint .But I thought OP answered Your question ...
Quote:
What could be the reason for this error, though i get proper ping response.

And both ping and tnsping works for him ( for testdb) (listener refusing it) But on "host=payroll" tnsping failed.

Now I am confused with these two hosts.For which DB host that we should respond ?

Sriram Sanka
Re: usage of hostname in tnsnames.ora and resolving the same with hosts file on linux platform. [message #538425 is a reply to message #538413] Thu, 05 January 2012 22:44 Go to previous messageGo to next message
snehalgandhi
Messages: 43
Registered: February 2011
Location: Ahmedabad
Member
My Actual problem is i am not able to connect to database through client by using hostname in tnsnames.ora, though i have created a host file on the linux server(database server).

My tnsnames entry is as below:
SUNPROD =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = payroll)(PORT = 1521))
)
(CONNECT_DATA =
(SID = ashima)
)
)

Re: usage of hostname in tnsnames.ora and resolving the same with hosts file on linux platform. [message #538427 is a reply to message #538425] Thu, 05 January 2012 22:50 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>My Actual problem is i am not able to connect to database through client by using hostname in tnsnames.ora,
100% devoid of actionable details!
my car won't go.
Tell me how to make my car go.

COPY & PASTE command (below) & complete results

sqlplus scott/tiger@SUNPROD
Re: usage of hostname in tnsnames.ora and resolving the same with hosts file on linux platform. [message #538428 is a reply to message #538427] Thu, 05 January 2012 22:53 Go to previous messageGo to next message
snehalgandhi
Messages: 43
Registered: February 2011
Location: Ahmedabad
Member
Dear BlackSwan,
It is not the case that i have not tried anything on the same issue.

SQL> conn prod/prod@sunprod
ERROR:
ORA-12535: TNS:operation timed out

above shown is the error given when i tried to connect to database from client, in the previous post i have given tnsnames entry....
Re: usage of hostname in tnsnames.ora and resolving the same with hosts file on linux platform. [message #538429 is a reply to message #538428] Thu, 05 January 2012 22:57 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
On DB server issue following commands

lsnrctl status
lsnrctl service

COPY commands & results then PASTE all back here.
Re: usage of hostname in tnsnames.ora and resolving the same with hosts file on linux platform. [message #538430 is a reply to message #538429] Thu, 05 January 2012 23:06 Go to previous messageGo to next message
ramoradba
Messages: 2456
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
1) Please stick to the host "payroll"
2) please provide some clues like whether you are able to ping payroll from client?
3) Execute the following from clients
ping <payroll ip address>
tnsping SUNPROD

4) execute following at DB server
lsnrctl status
lsnrctl service
5) check whether DB was up or in shutdown mode ?

Sriram

Re: usage of hostname in tnsnames.ora and resolving the same with hosts file on linux platform. [message #538431 is a reply to message #538430] Thu, 05 January 2012 23:29 Go to previous messageGo to next message
snehalgandhi
Messages: 43
Registered: February 2011
Location: Ahmedabad
Member
Dear BlankSwan

output of lsnrctl status
=========================
[oracle@payroll etc]$ lsnrctl status listener1

LSNRCTL for Linux: Version 10.2.0.4.0 - Production on 06-JAN-2012 10:50:30

Copyright (c) 1991, 2007, Oracle. All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC2)))
STATUS of the LISTENER
------------------------
Alias LISTENER1
Version TNSLSNR for Linux: Version 10.2.0.4.0 - Production
Start Date 30-NOV-2011 11:18:22
Uptime 36 days 23 hr. 32 min. 8 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /opt/oracle/product/10.2.0.1/network/admin/listener.ora
Listener Log File /opt/oracle/product/10.2.0.1/network/log/listener1.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC2)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=191.9.200.14)(PORT=1521)))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "ashima" has 2 instance(s).
Instance "ashima", status UNKNOWN, has 1 handler(s) for this service...
Instance "ashima", status READY, has 1 handler(s) for this service...
Service "ashimaXDB" has 1 instance(s).
Instance "ashima", status READY, has 1 handler(s) for this service...
Service "ashima_XPT" has 1 instance(s).
Instance "ashima", status READY, has 1 handler(s) for this service...
Service "workpyrl" has 2 instance(s).
Instance "workpyrl", status UNKNOWN, has 1 handler(s) for this service...
Instance "workpyrl", status READY, has 1 handler(s) for this service...
Service "workpyrlXDB" has 1 instance(s).
Instance "workpyrl", status READY, has 1 handler(s) for this service...
Service "workpyrl_XPT" has 1 instance(s).
Instance "workpyrl", status READY, has 1 handler(s) for this service...
The command completed successfully
[oracle@payroll etc]$


output of lsnrctl service
========================
[oracle@payroll etc]$ lsnrctl service listener1

LSNRCTL for Linux: Version 10.2.0.4.0 - Production on 06-JAN-2012 10:52:53

Copyright (c) 1991, 2007, Oracle. All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC2)))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:0 refused:0
LOCAL SERVER
Service "ashima" has 2 instance(s).
Instance "ashima", status UNKNOWN, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:44251 refused:0
LOCAL SERVER
Instance "ashima", status READY, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:1651 refused:0 state:ready
LOCAL SERVER
Service "ashimaXDB" has 1 instance(s).
Instance "ashima", status READY, has 1 handler(s) for this service...
Handler(s):
"D000" established:0 refused:0 current:0 max:1022 state:ready
DISPATCHER <machine: payroll, pid: 7799>
(ADDRESS=(PROTOCOL=tcp)(HOST=payroll)(PORT=45850))
Service "ashima_XPT" has 1 instance(s).
Instance "ashima", status READY, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:1651 refused:0 state:ready
LOCAL SERVER
Service "workpyrl" has 2 instance(s).
Instance "workpyrl", status UNKNOWN, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:7461 refused:0
LOCAL SERVER
Instance "workpyrl", status READY, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:231 refused:0 state:ready
LOCAL SERVER
Service "workpyrlXDB" has 1 instance(s).
Instance "workpyrl", status READY, has 1 handler(s) for this service...
Handler(s):
"D000" established:0 refused:0 current:0 max:1022 state:ready
DISPATCHER <machine: payroll, pid: 7859>
(ADDRESS=(PROTOCOL=tcp)(HOST=payroll)(PORT=38451))
Service "workpyrl_XPT" has 1 instance(s).
Instance "workpyrl", status READY, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:231 refused:0 state:ready
LOCAL SERVER
The command completed successfully
[oracle@payroll etc]$
Re: usage of hostname in tnsnames.ora and resolving the same with hosts file on linux platform. [message #538432 is a reply to message #538431] Thu, 05 January 2012 23:32 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
tail -100 /opt/oracle/product/10.2.0.1/network/log/listener1.log

post results from command above
Re: usage of hostname in tnsnames.ora and resolving the same with hosts file on linux platform. [message #538433 is a reply to message #538432] Thu, 05 January 2012 23:39 Go to previous messageGo to next message
snehalgandhi
Messages: 43
Registered: February 2011
Location: Ahmedabad
Member
I have configured two IP address 191.9.200.7 & 191.9.200.14 on the same server and at present 200.7 is not in use (disabled).
Re: usage of hostname in tnsnames.ora and resolving the same with hosts file on linux platform. [message #538434 is a reply to message #538433] Thu, 05 January 2012 23:50 Go to previous message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>I have configured two IP address 191.9.200.7 & 191.9.200.14 on the same server and at present 200.7 is not in use (disabled).
are you bragging or complaining?
are you closer to solution?
Why do you NOT provide requested details?
Previous Topic: Listener Dynamic Registration
Next Topic: ERROR ORA-01034 ORACLE not available, ORACLE database is not started ?
Goto Forum:
  


Current Time: Thu Mar 28 11:30:07 CDT 2024