OraFAQ Forum: Networking and Gateways » Connecting a client to Oracle

Home » RDBMS Server » Networking and Gateways » Connecting a client to Oracle (11g/r2 (OEL 5.5 running patch 9654983))

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Connecting a client to Oracle [message #471495]

Sun, 15 August 2010 18:04

dsub42
Messages: 72
Registered: April 2010
Location: uk

Member

Hi Im trying to connect a benchmarking application (benchmark factory) from my windows 32bit laptop to Oracle on my linux desktop.

When connecting I am supplying the following details: (im getting the error: ORA 12170 : TNS connect timeout occoured)

User/Schema : matt
Password: ****

Host: 192.168.1.9
Port: 1521

SID: orcl

Connect as : SysDBA

Connect Using: Instant Client (selected from a drop down)

----------------------------------------------------

when i use the following command:
tail -100 /home/matt/app/matt/diag/tnslsnr/localhost/listener/alert/log.xml

i get these results:

[matt@localhost ~]$ tail -100 /home/matt/app/matt/diag/tnslsnr/localhost/listener/alert/log.xml
host_addr='127.0.0.1'>
<txt>15-AUG-2010 23:26:29 * service_update * orcl * 0
</txt>
</msg>
<msg time='2010-08-15T23:26:36.708+01:00' org_id='oracle' comp_id='tnslsnr'
type='UNKNOWN' level='16' host_id='localhost.localdomain'
host_addr='127.0.0.1'>
<txt>15-AUG-2010 23:26:36 * (CONNECT_DATA=(SID=orcl)(CID=(PROGRAM=perl)(HOST=localhost.localdomain)(USER=matt))) * (ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=47677)) * establish * orcl * 0
</txt>
</msg>
<msg time='2010-08-15T23:27:48.913+01:00' org_id='oracle' comp_id='tnslsnr'
type='UNKNOWN' level='16' host_id='localhost.localdomain'
host_addr='127.0.0.1'>
<txt>15-AUG-2010 23:27:48 * (CONNECT_DATA=(SID=orcl)(CID=(PROGRAM=perl)(HOST=localhost.localdomain)(USER=matt))) * (ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=47699)) * establish * orcl * 0
</txt>
</msg>
<msg time='2010-08-15T23:27:49.166+01:00' org_id='oracle' comp_id='tnslsnr'
type='UNKNOWN' level='16' host_id='localhost.localdomain'
host_addr='127.0.0.1'>
<txt>15-AUG-2010 23:27:49 * (CONNECT_DATA=(SID=orcl)(CID=(PROGRAM=perl)(HOST=localhost.localdomain)(USER=matt))) * (ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=47700)) * establish * orcl * 0
</txt>
</msg>
<msg time='2010-08-15T23:29:29.477+01:00' org_id='oracle' comp_id='tnslsnr'
type='UNKNOWN' level='16' host_id='localhost.localdomain'
host_addr='127.0.0.1'>
<txt>15-AUG-2010 23:29:29 * service_update * orcl * 0
</txt>
</msg>
<msg time='2010-08-15T23:30:31.752+01:00' org_id='oracle' comp_id='tnslsnr'
type='UNKNOWN' level='16' host_id='localhost.localdomain'
host_addr='127.0.0.1'>
<txt>15-AUG-2010 23:30:31 * ping * 0
</txt>
</msg>
<msg time='2010-08-15T23:30:31.841+01:00' org_id='oracle' comp_id='tnslsnr'
type='UNKNOWN' level='16' host_id='localhost.localdomain'
host_addr='127.0.0.1'>
<txt>WARNING: Subscription for node down event still pending
</txt>
</msg>
<msg time='2010-08-15T23:30:31.842+01:00' org_id='oracle' comp_id='tnslsnr'
type='UNKNOWN' level='16' host_id='localhost.localdomain'
host_addr='127.0.0.1'>
<txt>15-AUG-2010 23:30:31 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=localhost.localdomain)(USER=matt))(COMMAND=status)(ARGUMENTS=64)(SERVICE=(ADDRESS=(PROTOCOL=TCP)(H OST=localhost.localdomain)(PORT=1521)))(VERSION=186646784)) * status * 0
</txt>
</msg>
<msg time='2010-08-15T23:30:53.474+01:00' org_id='oracle' comp_id='tnslsnr'
type='UNKNOWN' level='16' host_id='localhost.localdomain'
host_addr='127.0.0.1'>
<txt>15-AUG-2010 23:30:53 * service_update * orcl * 0
</txt>
</msg>
<msg time='2010-08-15T23:30:59.475+01:00' org_id='oracle' comp_id='tnslsnr'
type='UNKNOWN' level='16' host_id='localhost.localdomain'
host_addr='127.0.0.1'>
<txt>15-AUG-2010 23:30:59 * service_update * orcl * 0
</txt>
</msg>
<msg time='2010-08-15T23:31:29.475+01:00' org_id='oracle' comp_id='tnslsnr'
type='UNKNOWN' level='16' host_id='localhost.localdomain'
host_addr='127.0.0.1'>
<txt>15-AUG-2010 23:31:29 * service_update * orcl * 0
</txt>
</msg>
<msg time='2010-08-15T23:31:32.475+01:00' org_id='oracle' comp_id='tnslsnr'
type='UNKNOWN' level='16' host_id='localhost.localdomain'
host_addr='127.0.0.1'>
<txt>15-AUG-2010 23:31:32 * service_update * orcl * 0
</txt>
</msg>
<msg time='2010-08-15T23:31:36.976+01:00' org_id='oracle' comp_id='tnslsnr'
type='UNKNOWN' level='16' host_id='localhost.localdomain'
host_addr='127.0.0.1'>
<txt>15-AUG-2010 23:31:36 * (CONNECT_DATA=(SID=orcl)(CID=(PROGRAM=perl)(HOST=localhost.localdomain)(USER=matt))) * (ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=43212)) * establish * orcl * 0
</txt>
</msg>
<msg time='2010-08-15T23:32:29.473+01:00' org_id='oracle' comp_id='tnslsnr'
type='UNKNOWN' level='16' host_id='localhost.localdomain'
host_addr='127.0.0.1'>
<txt>15-AUG-2010 23:32:29 * service_update * orcl * 0
</txt>
</msg>
<msg time='2010-08-15T23:32:49.162+01:00' org_id='oracle' comp_id='tnslsnr'
type='UNKNOWN' level='16' host_id='localhost.localdomain'
host_addr='127.0.0.1'>
<txt>15-AUG-2010 23:32:49 * (CONNECT_DATA=(SID=orcl)(CID=(PROGRAM=perl)(HOST=localhost.localdomain)(USER=matt))) * (ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=43237)) * establish * orcl * 0
</txt>
</msg>
<msg time='2010-08-15T23:32:49.404+01:00' org_id='oracle' comp_id='tnslsnr'
type='UNKNOWN' level='16' host_id='localhost.localdomain'
host_addr='127.0.0.1'>
<txt>15-AUG-2010 23:32:49 * (CONNECT_DATA=(SID=orcl)(CID=(PROGRAM=perl)(HOST=localhost.localdomain)(USER=matt))) * (ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=43238)) * establish * orcl * 0
</txt>
</msg>
<msg time='2010-08-15T23:34:29.469+01:00' org_id='oracle' comp_id='tnslsnr'
type='UNKNOWN' level='16' host_id='localhost.localdomain'
host_addr='127.0.0.1'>
<txt>15-AUG-2010 23:34:29 * service_update * orcl * 0
</txt>
</msg>
[matt@localhost ~]$

-------------------------------------------------------

I have been told client is not getting to the listener because listener is only listening on 127.0.0.1

unless & until DB server is configured with a routable IP#, no remote client will succeed.

How do I do this though?? .. .im pretty new to all this.... can someone please help me?

Report message to a moderator

Re: Connecting a client to Oracle [message #471496 is a reply to message #471495]

Sun, 15 August 2010 18:12

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

post content of listener.ora

Report message to a moderator

Re: Connecting a client to Oracle [message #471497 is a reply to message #471496]

Sun, 15 August 2010 18:16

dsub42
Messages: 72
Registered: April 2010
Location: uk

Member

# listener.ora Network Configuration File: /home/matt/app/matt/product/11.2.0/dbhome_1/network/admin/listener.ora
# Generated by Oracle configuration tools.

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
)
)

ADR_BASE_LISTENER = /home/matt/app/matt

Report message to a moderator

Re: Connecting a client to Oracle [message #471498 is a reply to message #471497]

Sun, 15 August 2010 18:18

dsub42
Messages: 72
Registered: April 2010
Location: uk

Member

if this helps ... when i switch to root and run ifconfig.. i get the following output...

[matt@localhost dbs]$ su -
Password:
[root@localhost ~]# ifconfig
eth0 Link encap:Ethernet HWaddr 00:19:66:5E:78:FD
inet addr:192.168.1.9 Bcast:192.168.1.255 Mask:255.255.255.0
inet6 addr: fe80::219:66ff:fe5e:78fd/64 Scope:Link
UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1
RX packets:7311 errors:0 dropped:0 overruns:0 frame:0
TX packets:3932 errors:0 dropped:0 overruns:0 carrier:0
collisions:0 txqueuelen:1000
RX bytes:1947896 (1.8 MiB) TX bytes:1812920 (1.7 MiB)
Interrupt:217 Base address:0x4000

lo Link encap:Local Loopback
inet addr:127.0.0.1 Mask:255.0.0.0
inet6 addr: ::1/128 Scope:Host
UP LOOPBACK RUNNING MTU:16436 Metric:1
RX packets:1864 errors:0 dropped:0 overruns:0 frame:0
TX packets:1864 errors:0 dropped:0 overruns:0 carrier:0
collisions:0 txqueuelen:0
RX bytes:2216120 (2.1 MiB) TX bytes:2216120 (2.1 MiB)

[root@localhost ~]#

Report message to a moderator

Re: Connecting a client to Oracle [message #471499 is a reply to message #471497]

Sun, 15 August 2010 18:19

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
It is doing what it is configured to do.
If you want it to listen on a different hostname or port#, then change listener.ora

Report message to a moderator

Re: Connecting a client to Oracle [message #471500 is a reply to message #471499]

Sun, 15 August 2010 18:20

dsub42
Messages: 72
Registered: April 2010
Location: uk

Member

Change to what though? Please could you help, im totally useless with oracle networking stuff...

Iv read and read today and got nowhere...

I want to keep everything set up as it is I simply want to be able to connect from the client app on my laptop

Report message to a moderator

Re: Connecting a client to Oracle [message #471502 is a reply to message #471500]

Sun, 15 August 2010 18:37

dsub42
Messages: 72
Registered: April 2010
Location: uk

Member

Anyone.....?

Report message to a moderator

Re: Connecting a client to Oracle [message #471732 is a reply to message #471502]

Tue, 17 August 2010 01:39

John Watson
Messages: 8929
Registered: January 2010
Location: Global Village

Senior Member

Hi, dsub42. I could give you the answer! But do you think you could feedback on your Flash Cache question first? If it is now working, how is it performing?
[edit - changed to "flash cache"]

[Updated on: Tue, 17 August 2010 01:49]

Report message to a moderator

Previous Topic:	ORA-12560: TNS:
Next Topic:	ORA-12154: TNS:could not resolve service name

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 19 01:30:13 CDT 2024