RE: Can't connect to Oracle 8i server on Win 2K from client Win 98, 95

If you're using tnsnames.ora to connect to the database, make sure the tnsnames.ora file on the client matches the listener.ora file on the server. Also check the sqlnet.ora file to make sure tnsnames is specified first. Also, after you verified that, do a tnsping to the target instance from the client command line and see if it is looking on the correct "host" for the instance.

-Scott Stefick

>===== Original Message From ORACLE-L_at_fatcity.com =====
>Hi All,
> I have installed Oracle 8.1.7 on Win 2000 server. I am able to
>connect
>to the server from a Oracle client installed on Win 2K professional but
>cannot connect
>to the server from Oracle client's installed on Win 98, 95. I have tried
>this connection
>from more than one Win 98, 95 machines but I am getting the same error and
>which is:
>
>ERROR:
>ORA-12545: Connect failed because target host or object does not exist.
>
>
>Any help will be appreciated.
>
>thanks
>
>Samar
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>----------------------------------------------------------------------------
>----------------------------
>CONFIDENTIALITY/PROPRIETARY NOTE
>
>This communication is confidential / proprietary and is intended for use
>only by
>the addressee. IGT Solutions Private Limited accepts no responsibility for
>any
>mistransmission of,or interference with, this communication.
>----------------------------------------------------------------------------
>----------------------------
>----- Original Message -----
>To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
>Sent: Tuesday, December 24, 2002 9:03 PM
>
>
>>
>> > select pid from v$process p,v$bgprocess b
>> > where b.paddr = p.addr
>> > and name = 'PMON'
>> >
>> > then "oradebug wakeup nnnnn".
>> >
>> > where nnnnn is the process id
>> >
>> > Let me know if it works for you.
>>
>> Yes, I can do that but it seems like a manual process.I need something
>> automatic.. No?
>>
>> Jared:
>>
>> We can bump up the processes but are worried about scaling. This
>> was not an issue with one user, 2 users knocking the heck out of the app
>> get processes = 50, so I would guess if users went to 100+ there could
>> be an issue. Currently I have processes =100 and we don't get the error.
>> Im looking for a setting that I can assign to have the processes clean
>> up earlier. Ive read a article on Metalink saying processes should not
>> be set to
>> More than v$license
>> More than 200
>> And is os dependant
>>
>>
>> ?
>> Thanks
>> Bob
>> --
>> Please see the official ORACLE-L FAQ: http://www.orafaq.net
>> --
>> Author: Bob Metelsky
>> INET: bmetelsky_at_cps92.com
>>
>> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
>> San Diego, California -- Mailing list and web hosting services
>> ---------------------------------------------------------------------
>> To REMOVE yourself from this mailing list, send an E-Mail message
>> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
>> the message BODY, include a line containing: UNSUB ORACLE-L
>> (or the name of mailing list you want to be removed from). You may
>> also send the HELP command for other information (like subscribing).
>>
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.net
>--
>Author: Samar Saxena
> INET: samar.saxena_at_igtsolutions.com
>
>Fat City Network Services -- 858-538-5051 http://www.fatcity.com
>San Diego, California -- Mailing list and web hosting services
>---------------------------------------------------------------------
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from). You may
>also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: sstefick
  INET: sstefick_at_harper.cc.il.us

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).