Developer connection
Date: Tue, 11 Jan 2000 11:51:58 +0530
Message-ID: <85fme7$orb$1_at_news.vsnl.net.in>
utpal wrote in message <7nm22o$3oj$1_at_news.vsnl.net.in>...
>I have installed oracle8 personal.The problem is that my developer does not
>connect to the database.Also Iam have to versions of sqlplus installed.This
>happened when developer got installed,my earlier sql v8.0.3 works fine,but
>the one installed with developer sql version3 does not connect to the
>database.Developer version is 2.1.
>Also I have been told that oracle 8 gives problems on win98,could the above
>problem be because of this,is there any patch available on net.
>Please help!!!!!!
>Thanking all in advance.
>
>1.Developer uses SQL*Net , NOT Net80. So, make sure that sql*net 2.3.4 is
>installed. The bequeath protocol allows SQL*Plus 8 to connect locally by
>bypassing the listener process. However, Dev. needs the listener to connect
>locally
>2. Make sure that you have %oracle_home\network\admin directory
>3. You MUST start the listener (TNSLSNR80.EXE) after the database is
started
>4 Use the SQL*NET Easy config utility to create a new service. In my case,
I
>simply deleted the exisiting 'ORCL' service and created a new one. when
>creating a new service, do not specify Bequeath as the protocol. Select
>TCP/IP instead. Also, you will need to provide the TCP/IP host name which
is
>the computer name where oracle is installed.
>Once done, you should be able to connect from Sql*plus 3.3 as well as
>Developer by specifying user name, password, AND the service name. You
>cannot leave the connect string blank.
>1. Start Personal Oracle Database
>2. Then, I go to Dos prompt and type lsnrctl80.exe
>3. Then, I type START
>listener should be up and running!
>In my case, I have the following files
>tnsnames.ora,sqlnet.ora & listener.ora in C:\orawin95\network\admin
>Also, in the registery, there be an entry like net20=C:\orawin95\network
I tried to Start Listener but got the following message
TNSLSNR80 for 32-bit Windows: Version 8.0.3.0.0 - Production on 11-JAN-00 11:41:21
(c) Copyright 1997 Oracle Corporation. All rights reserved.
System parameter file is C:\ORAWIN95\net80\admin\listener.ora Log messages written to C:\ORAWIN95\net80\log\listener.log
Attempted to listen on:
(DESCRIPTION=(CONNECT_TIMEOUT=10)(ADDRESS=(PROTOCOL=TCP)(Host=UTPAL)(Port=15
21)))
TNS-12545: Connect failed because target host or object does not exist
TNS-12560: TNS:protocol adapter error
TNS-00515: Connect failed because target host or object does not exist
32-bit Windows Error: 1004: Unknown system error
Please help
Thanks in advance
Received on Tue Jan 11 2000 - 07:21:58 CET