If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > Oracle > Neer help connecting to db in 11g

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old
Registered User
 
Join Date: Feb 2013
Posts: 12
Neer help connecting to db in 11g

Ok, this is what I have done
I have virtualbox with a Windows XP pro as a virtual machine, I've installed Oracle 11g and setup a DB, and I can use Sql developer on it (the virtual os) but what Im tring to do next is use Sql developer on the host os, windows 7 Home premium, I can ping to the virtual os, but when I try to connect to the DB I get an error: The network adapter could not establisha a connection
Under :
Hostname I have put localhost and/or the IP of the virtual os
port : 1521
SID : utm (that the sid name Im using)

the listener service is running on windows xp (the virtual os)

Any help would be apreciated
Reply With Quote
  #2 (permalink)  
Old
Registered User
 
Join Date: Aug 2003
Location: Where the Surf Meets the Turf @Del Mar, CA
Posts: 7,597
you have an OS/networking mis-configuration that has NOTHING to do with Oracle.

You can validate the complete network configuration by issuing 8 ping commands

ping <own_hostname>
ping <own_IP#>
ping <other_hostname>
ping <other_IP#>

then to the same from the other system

Realize & understand that any system which is configured as "localhost",
can NOT be accessed by any remote system.
__________________
You can lead some folks to knowledge, but you can not make them think.
The average person thinks he's above average!
For most folks, they don't know, what they don't know.
Don't say, show. Don't promise, prove.
Reply With Quote
  #3 (permalink)  
Old
Registered User
 
Join Date: Feb 2013
Posts: 12
Yes, all pings worked
So now we know is not a network issue, but the last thing you typed was I can not use a localhost installation with a remote system, so my next questions would be
How can I correct this?
Do I need to reinstall Sql 11g and use the server option?

For any help, Thanks...
Reply With Quote
  #4 (permalink)  
Old
Registered User
 
Join Date: Aug 2003
Location: Where the Surf Meets the Turf @Del Mar, CA
Posts: 7,597
>How can I correct this?
at OS level change host configuration such that it has real hostname & routable IP;
something other than localhost & 127.0.0.1
__________________
You can lead some folks to knowledge, but you can not make them think.
The average person thinks he's above average!
For most folks, they don't know, what they don't know.
Don't say, show. Don't promise, prove.
Reply With Quote
  #5 (permalink)  
Old
Registered User
 
Join Date: Feb 2013
Posts: 12
Can you explain a little bit more (or a lor more), please
Would that be on the listener.ora file?
and change the localhost for the name of the virtual machine?

Thanks in advance...
Reply With Quote
  #6 (permalink)  
Old
Registered User
 
Join Date: Aug 2003
Location: Where the Surf Meets the Turf @Del Mar, CA
Posts: 7,597
Since V10 Oracle listener.ora file is NOT required.
Listener will start & run when no listener.ora file exists.
Listener will acquire needed details directly from the Operating System (OS).

These are your systems & OS, so you are free to configure as you require them to be.
__________________
You can lead some folks to knowledge, but you can not make them think.
The average person thinks he's above average!
For most folks, they don't know, what they don't know.
Don't say, show. Don't promise, prove.
Reply With Quote
  #7 (permalink)  
Old
Registered User
 
Join Date: Feb 2013
Posts: 12
No, still the same problem, and as you red on my 1st and 2nd post I can ping to the virtual machine using the ip and hostname, I can see it on my network connection and I even have notworked drives linked on both machines, so again, I dont think is a network problem
Again, under hostname I have put , 192.168.56.101, also changed to virtualxp (that's the host name/ip of my virtual machine) but still have the same error...I can see network activitie on both machines as I click on the test button but still no go...

any other suggestions....?
Reply With Quote
  #8 (permalink)  
Old
Registered User
 
Join Date: Aug 2003
Location: Where the Surf Meets the Turf @Del Mar, CA
Posts: 7,597
while logged onto the DB Server system issue following OS commands

lsnrctl status
lsnrctl service

COPY the results from above, then PASTE all back here
__________________
You can lead some folks to knowledge, but you can not make them think.
The average person thinks he's above average!
For most folks, they don't know, what they don't know.
Don't say, show. Don't promise, prove.
Reply With Quote
  #9 (permalink)  
Old
Registered User
 
Join Date: Feb 2013
Posts: 12
LSNRCTL for 32-bit Windows: Version 11.2.0.1.0 - Production on 24-FEB-2013 14:35
:36

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC15 21)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for 32-bit Windows: Version 11.2.0.1.0 - Produ
ction
Start Date 24-FEB-2013 11:21:58
Uptime 0 days 3 hr. 13 min. 40 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File C:\app\Owner\product\11.2.0\dbhome_1\network\admin \lis
tener.ora
Listener Log File c:\app\owner\diag\tnslsnr\VirtualXP\listener\alert \log
.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\ pipe\EXTPROC1521ipc)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0. 1)(PORT=1521)))
Services Summary...
Service "CLRExtProc" has 1 instance(s).
Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "utm" has 1 instance(s).
Instance "utm", status READY, has 1 handler(s) for this service...
Service "utmXDB" has 1 instance(s).
Instance "utm", status READY, has 1 handler(s) for this service...
The command completed successfully
Reply With Quote
  #10 (permalink)  
Old
Registered User
 
Join Date: Feb 2013
Posts: 12
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC15 21)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for 32-bit Windows: Version 11.2.0.1.0 - Produ
ction
Start Date 24-FEB-2013 11:21:58
Uptime 0 days 3 hr. 13 min. 40 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File C:\app\Owner\product\11.2.0\dbhome_1\network\admin \lis
tener.ora
Listener Log File c:\app\owner\diag\tnslsnr\VirtualXP\listener\alert \log
.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\ pipe\EXTPROC1521ipc)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0. 1)(PORT=1521)))
Services Summary...
Service "CLRExtProc" has 1 instance(s).
Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "utm" has 1 instance(s).
Instance "utm", status READY, has 1 handler(s) for this service...
Service "utmXDB" has 1 instance(s).
Instance "utm", status READY, has 1 handler(s) for this service...
The command completed successfully

C:\Documents and Settings\Owner>lsnrctl service

LSNRCTL for 32-bit Windows: Version 11.2.0.1.0 - Production on 24-FEB-2013 14:37
:25

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC15 21)))
Services Summary...
Service "CLRExtProc" has 1 instance(s).
Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:0 refused:0
LOCAL SERVER
Service "utm" has 1 instance(s).
Instance "utm", status READY, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:7 refused:0 state:ready
LOCAL SERVER
Service "utmXDB" has 1 instance(s).
Instance "utm", status READY, has 1 handler(s) for this service...
Handler(s):
"D000" established:0 refused:0 current:0 max:1022 state:ready
DISPATCHER <machine: VIRTUALXP, pid: 568>
(ADDRESS=(PROTOCOL=tcp)(HOST=VirtualXP)(PORT=1033) )
The command completed successfully
Reply With Quote
  #11 (permalink)  
Old
Registered User
 
Join Date: Feb 2013
Posts: 12
THANK YOU VERY MUCH!!!!
Here is my answer
ADDRESS=(PROTOCOL=tcp)(HOST=VirtualXP)(PORT=1033) )
Reply With Quote
  #12 (permalink)  
Old
Registered User
 
Join Date: Feb 2013
Posts: 12
I was using the correct Hostname but the wrong port...
Reply With Quote
  #13 (permalink)  
Old
Registered User
 
Join Date: Aug 2003
Location: Where the Surf Meets the Turf @Del Mar, CA
Posts: 7,597
post excerpt from c:\app\owner\diag\tnslsnr\VirtualXP\listener\alert \log.xml
which shows successful connection from Windows 7 system
__________________
You can lead some folks to knowledge, but you can not make them think.
The average person thinks he's above average!
For most folks, they don't know, what they don't know.
Don't say, show. Don't promise, prove.
Reply With Quote
  #14 (permalink)  
Old
Registered User
 
Join Date: Feb 2013
Posts: 12
</txt>
</msg>
<msg time='2013-02-24T15:47:55.176-06:00' org_id='oracle' comp_id='tnslsnr'
type='UNKNOWN' level='16' host_id='VIRTUALXP'
host_addr='192.168.56.101'>
<txt>24-FEB-2013 15:47:55 * service_update * utm * 0
</txt>
</msg>
<msg time='2013-02-24T15:48:02.174-06:00' org_id='oracle' comp_id='tnslsnr'
type='UNKNOWN' level='16' host_id='VIRTUALXP'
host_addr='192.168.56.101'>
<txt>24-FEB-2013 15:48:02 * service_update * utm * 0
</txt>
</msg>
<msg time='2013-02-24T15:48:02.933-06:00' org_id='oracle' comp_id='tnslsnr'
type='UNKNOWN' level='16' host_id='VIRTUALXP'
host_addr='192.168.56.101'>
<txt>24-FEB-2013 15:48:02 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=)(USER=Owner))( COMMAND=services)(ARGUMENTS=64)(SERVICE=LISTENER)( VERSION=186646784)) * services * 0
</txt>
</msg>
<msg time='2013-02-24T15:48:19.079-06:00' org_id='oracle' comp_id='tnslsnr'
type='UNKNOWN' level='16' host_id='VIRTUALXP'
host_addr='192.168.56.101'>
<txt>24-FEB-2013 15:48:19 * service_update * utm * 0
</txt>
</msg>
<msg time='2013-02-24T15:48:23.825-06:00' org_id='oracle' comp_id='tnslsnr'
type='UNKNOWN' level='16' host_id='VIRTUALXP'
host_addr='192.168.56.101'>
<txt>24-FEB-2013 15:48:23 * service_update * utm * 0
</txt>
</msg>
<msg time='2013-02-24T15:49:01.765-06:00' org_id='oracle' comp_id='tnslsnr'
type='UNKNOWN' level='16' host_id='VIRTUALXP'
host_addr='192.168.56.101'>
<txt>24-FEB-2013 15:49:01 * service_update * utm * 0
</txt>
</msg>
<msg time='2013-02-24T15:49:28.870-06:00' org_id='oracle' comp_id='tnslsnr'
type='UNKNOWN' level='16' host_id='VIRTUALXP'
host_addr='192.168.56.101'>
<txt>24-FEB-2013 15:49:28 * service_update * utm * 0
</txt>
</msg>
<msg time='2013-02-24T15:49:41.137-06:00' org_id='oracle' comp_id='tnslsnr'
type='UNKNOWN' level='16' host_id='VIRTUALXP'
host_addr='192.168.56.101'>
<txt>24-FEB-2013 15:49:41 * service_update * utm * 0
</txt>
</msg>
<msg time='2013-02-24T15:50:05.546-06:00' org_id='oracle' comp_id='tnslsnr'
type='UNKNOWN' level='16' host_id='VIRTUALXP'
host_addr='192.168.56.101'>
<txt>24-FEB-2013 15:50:05 * service_update * utm * 0
</txt>
</msg>
<msg time='2013-02-24T15:50:08.656-06:00' org_id='oracle' comp_id='tnslsnr'
type='UNKNOWN' level='16' host_id='VIRTUALXP'
host_addr='192.168.56.101'>
<txt>24-FEB-2013 15:50:08 * service_update * utm * 0
</txt>
</msg>
<msg time='2013-02-24T15:50:32.201-06:00' org_id='oracle' comp_id='tnslsnr'
type='UNKNOWN' level='16' host_id='VIRTUALXP'
host_addr='192.168.56.101'>
<txt>24-FEB-2013 15:50:32 * service_update * utm * 0
</txt>
</msg>
<msg time='2013-02-24T15:50:36.670-06:00' org_id='oracle' comp_id='tnslsnr'
type='UNKNOWN' level='16' host_id='VIRTUALXP'
host_addr='192.168.56.101'>
<txt>24-FEB-2013 15:50:36 * service_update * utm * 0
</txt>
</msg>
<msg time='2013-02-24T15:51:13.709-06:00' org_id='oracle' comp_id='tnslsnr'
type='UNKNOWN' level='16' host_id='VIRTUALXP'
host_addr='192.168.56.101'>
<txt>24-FEB-2013 15:51:13 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=__jdbc__)(USER= SYSTEM))(SERVICE_NAME=demoutm)) * (ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1059) ) * establish * demoutm * 12514
</txt>
</msg>
<msg time='2013-02-24T15:51:13.709-06:00' org_id='oracle' comp_id='tnslsnr'
type='UNKNOWN' level='16' host_id='VIRTUALXP'
host_addr='192.168.56.101'>
<txt>TNS-12514: TNS:listener does not currently know of service requested in connect descriptor
</txt>
</msg>
Reply With Quote
  #15 (permalink)  
Old
Registered User
 
Join Date: Feb 2013
Posts: 12
But know I have this problem (well I can live with it), every time I turn on my vitual XP machine, the port changes...
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On