Home » RDBMS Server » Server Administration » not able to sccess the oracle 10g server (10g XE)
not able to sccess the oracle 10g server [message #440845] Wed, 27 January 2010 06:06 Go to next message
mohannksr
Messages: 28
Registered: January 2009
Junior Member
Hi,

I have installed oracle 10g XE on my machine.
And my machine's ip address is 10.10.50.50.

username:system
password:xxx

XE =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.10.50.50)(PORT =1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = XE)
)
)
I was able to connect to the above server from my machine.

But when i was trying to connect the above server from my neighbours system i am getting an error

Network adapter could not establish the connection.

Note:when i ping the ip address 10.10.50.50 from my negihbours system in the command prompt

Reply from 10.10.50.50:bytes=32
Reply from 10.10.50.50:bytes=32
Reply from 10.10.50.50:bytes=32
Reply from 10.10.50.50:bytes=32

Could any one help me resolve this error..?
Re: not able to sccess the oracle 10g server [message #440846 is a reply to message #440845] Wed, 27 January 2010 06:08 Go to previous messageGo to next message
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Do you say that ping can't reach your server?

Regards
Michel
Re: not able to sccess the oracle 10g server [message #440847 is a reply to message #440845] Wed, 27 January 2010 06:10 Go to previous messageGo to next message
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Quote:
Network adapter could not establish the connection.

This is an error you can get when you tried to connect to a LOCAL database not a remote one.

Post (that is copy and paste) what you did and what you got with SQL*Plus.

Regards
Michel
Re: not able to sccess the oracle 10g server [message #440848 is a reply to message #440845] Wed, 27 January 2010 06:12 Go to previous messageGo to next message
ramoradba
Messages: 2457
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
Quote:
But when i was trying to connect the above server from my neighbours system i am getting an error

Using(thgrough) what?
Oracle?
does oracle know your neighbours system?

tnsping <servicename> from your neighbours system....

sriram Smile
Re: not able to sccess the oracle 10g server [message #440849 is a reply to message #440846] Wed, 27 January 2010 06:16 Go to previous messageGo to next message
mohannksr
Messages: 28
Registered: January 2009
Junior Member
Reply from 10.10.32.29: bytes=32 time<1ms TTL=128
Reply from 10.10.32.29: bytes=32 time<1ms TTL=128
Reply from 10.10.32.29: bytes=32 time<1ms TTL=128
Reply from 10.10.32.29: bytes=32 time<1ms TTL=128


Ping statistics for 10.10.50.50:
packets: Sent =4,Recieved =4,Lost =0()% loss),
Approximate round trip times in milli-seconds:
Minimum=oms,Maximum=0ms,Average=0ms

The above one was the message i got after ping the ipaddress of my machine from other system.I was able to ping it successfully.

But problem is not able to connect the server installed in my mahcine from other system.....
Re: not able to sccess the oracle 10g server [message #440850 is a reply to message #440849] Wed, 27 January 2010 06:18 Go to previous messageGo to next message
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Quote:
But problem is not able to connect the server installed in my mahcine from other system.....

Quote:
Post (that is copy and paste) what you did and what you got with SQL*Plus.

Regards
Michel
Re: not able to sccess the oracle 10g server [message #440851 is a reply to message #440849] Wed, 27 January 2010 06:19 Go to previous messageGo to next message
ramoradba
Messages: 2457
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
thats what we are asking re read what Michel asked....

Post all from your neighbours sql* plus of what you tried....

did you install oracle in your neighbours system?
tnsping <oracle_service_name> from your neighbours system

sriram Smile
Re: not able to sccess the oracle 10g server [message #440852 is a reply to message #440851] Wed, 27 January 2010 06:20 Go to previous messageGo to next message
ramoradba
Messages: 2457
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
using which method you are trying to connect your sever from your neighbours system?
tnsnames/ezconnect/what?
Don`t say anything show us what you tried....

sriram Smile

[Updated on: Wed, 27 January 2010 06:20]

Report message to a moderator

Re: not able to sccess the oracle 10g server [message #440853 is a reply to message #440852] Wed, 27 January 2010 06:54 Go to previous messageGo to next message
mohannksr
Messages: 28
Registered: January 2009
Junior Member
1.Oracle 10g XE too was installed in my neighbours machine

2.using sqlplus-tnsnames i am trying to connect from my neighbours system

3.connection details in my neighbours tnsnames.ora file

Quote:
XE =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.10.50.50)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = XE)
)
)


4.while ping ip address thourgh command prompt
Quote:

C:\Documents and Settings\u18906>ping 10.10.50.50

Pinging 10.10.50.50 with 32 bytes of data:

Reply from 10.10.50.50: bytes=32 time<1ms TTL=128
Reply from 10.10.50.50: bytes=32 time<1ms TTL=128
Reply from 10.10.50.50: bytes=32 time<1ms TTL=128
Reply from 10.10.50.50: bytes=32 time<1ms TTL=128

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


5.while ping service name thourgh command prompt
Quote:

C:\Documents and Settings\u18906>tnsping XE

TNS Ping Utility for 32-bit Windows: Version 10.2.0.1.0 - Production on 27-JAN-2010 17:55:05

Copyright (c) 1997, 2005, Oracle. All rights reserved.

Used parameter files:
C:\oraclexe\app\oracle\product\10.2.0\server\network\admin\sqlnet.ora


Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 10.10.50.50)(PORT = 1521)) (
CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = XE)))
TNS-12535: TNS:operation timed out

C:\Documents and Settings\u18906>


6.while connecting thorugh sql developer got the attached error
  • Attachment: error.JPG
    (Size: 75.88KB, Downloaded 869 times)
Re: not able to sccess the oracle 10g server [message #440857 is a reply to message #440853] Wed, 27 January 2010 07:57 Go to previous messageGo to next message
ramoradba
Messages: 2457
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
Please post the content of
sqlnet.ora files .

And As Michel said/asked you to post the details from sql * plus(how you are trying to connect to your server using sql * plus ).


sriram Smile
Re: not able to sccess the oracle 10g server [message #440858 is a reply to message #440853] Wed, 27 January 2010 08:05 Go to previous message
joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA
Senior Member
Is your listener up on 10.10.50.50? Post the contents of the listener.ora file on that server.
Previous Topic: ASM Confusions
Next Topic: system01.dbf
Goto Forum:
  


Current Time: Fri Nov 29 11:42:17 CST 2024