How to connect to PC #1 (running Oracle) from PC #2 (running Oracle client)

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

ASKER

I do have a home network, and I can remote desktop from PC #2 to PC #1.

I got the local ip address as 192.168.1.9 on PC #1

I then added that to tnsnames on PC #2

# tnsnames.ora Network Configuration File: E:\app\Stephen\product\11.2.0\dbhome_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.

LISTENER_ORCL =
  (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.9)(PORT = 1521))


ORACLR_CONNECTION_DATA =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
    )
    (CONNECT_DATA =
      (SID = CLRExtProc)
      (PRESENTATION = RO)
    )
  )

ORCL =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.9)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = orcl)
    )
  )

Open in new window

but it didn't work :-(

SOLUTION

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

ASKER

different error now . . . :-(

SOLUTION

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

ASKER

>>For a test, drop the firewall on both systems and try
-- if only I knew how to do that . . . I'll google it and let you know.

I also modified the listener file to listen to 192.168.1.9 and not 127.0.0.1, still no luck.

ASKER

Ok, I disabled the local firewall on both, now it says

"TNS listener does not currently know of service requested in connect descriptor"

ASKER CERTIFIED SOLUTION

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

ASKER

worked !!!!!!!!!!!!!!!

So in changing to 192.168.1.9 things got a little out of whack, but the register (and re-boot) must have done the trick !

I'll put the firewalls back on and see if it still works.

Here's the listener status for the record:

LSNRCTL for 64-bit Windows: Version 11.2.0.1.0 - Production on 05-AUG-2014 19:58:48

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for 64-bit Windows: Version 11.2.0.1.0 - Production
Start Date 05-AUG-2014 19:53:18
Uptime 0 days 0 hr. 5 min. 34 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File E:\app\Stephen\product\11.2.0\dbhome_1\network\admin\listener.ora
Listener Log File e:\app\stephen\diag\tnslsnr\Stephen-PC\listener\alert\log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1521ipc)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.9)(PORT=1521)))
Services Summary...
Service "CLRExtProc" has 1 instance(s).
Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "orcl" has 1 instance(s).
Instance "orcl", status READY, has 1 handler(s) for this service...
Service "orclXDB" has 1 instance(s).
Instance "orcl", status READY, has 1 handler(s) for this service...
The command completed successfully

and for fun, my connection from the remote PC:

>>I'll put the firewalls back on and see if it still works.

If it doesn't then you'll need to set up rules to allow at least 1521 through.

Oracle changed things recently so you may not need to add ALL the high-level ports through but in the past you did. I've not been on the network side of things for MANY years so cannot help with the exact rules you'll need to add.

ASKER

I turned the firewall back on, on both PC's, and it didn't work. So I turned it off on PC # 1, and it worked.

Thanks for sticking with this !