connecting sqlplus client to a oracle7.3.3 server.

From: dan fong <bikesnow_at_yahoo.com>
Date: Fri, 13 Aug 1999 15:59:40 -0400
Message-ID: <%R_s3.94$6s6.173261312@bigmomma.idirect.com>

I'm attempting to connect, using sqlplus to a remote server on box1 (nt4.0 with oracle server 7.3.3) with my laptop (box2 'client' nt4.0).

on box 2 , i installed sqlplus,plus80,server manger from the oracle 8 cd. i copied the listener,tnsnames,sqlnet from box1 (oraclehome\network\admin\) to box 2's : c:\orant\net80\admin

From box2, 'tnsping80 <servicename of the server >' and it connected. Also tested #net8 easy config tool's loopback test as SYSTEM/MANAGER and this was ok too.

box1 does not have a cman.ora file (used by oracle connection manager).

When i run sqlworksheet from oem (ora enterp manager) on box2, i get 'ORA 12203:TNS:UNABLE TO CONNECT TO DESTINATION'.Also get same problem using sqlplus8.0. Maybe because my hoststring is null. *****Any help would be greatly appreciated.*****

Plus80 and svrmgr30 connects fine on box 1 (using SYSTEM/MANAGER ).Ran it from oraclehome/bin.

i don't think we have 'ora names server' on box1 and i don't know what it's used for. Received on Fri Aug 13 1999 - 14:59:40 CDT