Re: Unable to connect to destination

Hello:

There are a couple of things that you need to check. 1) Check if the listener is running on your server.

   start > settings > control panel > services    look for something like tnsORCservice, if it is not running start it    If it still does work, go to DOS
   type lsnrctl start
   you should see the service for ORCL
2) I assume that your database is up and running, otherwise start it via SVRMGR
3) You can either use the IP address of the hostname in your TNSNAMES.ORA file
4) I noticed in your LISTENER.ORA file an entry for GLOBAL_DBNAME of PROJECT. Do you have a similar entry
in your initORCL.ora file?
5) the NAMES.ORA file is used for Oracle Nameserver. If you are using a nameserver, then you don't need TNSNAMES.ORA on your clients. 6) Developer 6.0 creates a directory called NETWORK because it uses SQL*NET 2.3 rather than Net*8. Copy the TNSNAMES.ORA from c:\orant\net80\admin to c:\orant\network\admin.

Hope that this helps.

Laurence
Sugar wrote in message <38875429.37D4A940_at_pd.jaring.my>...
>HELP! REALLY in need of HELP!
>
>To all the kind souls out there.
>
>I am having problem getting into the SQL Plus on my server from my
>client.
>
>My developer 6.0 was installed in my client running in Windows NT
>While Oracle 8.0.5 Enterprise edition was installed in my server running
>under Windows NT as well.
>Both client and server are connected in the sense that they can ‘ping’
>each other.
>
>There are few questions that I need to ask… and desperately hoping
>someone to give me a clearer picture.
>1. What is the ‘Host String’ requested when we try to log in to
>SQL*PLUS?
>2. Do I identify the server by the IP address or the name?
>3. What about the ‘HOST’?
>4. I modified the TNSNAME.ORA file on the client side and made few
>modifications as such:
>Tcp-loopback.world =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS =
> (PROTOCOL = TCP)
> (Host = 192.166.166.200)
> (Port = 1521)
> )
> )
> (CONNECT_DATA = (SID = ORCL)
> )
> )
>192.166.166.200 is the IP address for my server while the
>192.166.166.201 is the IP address for my client.
>
>The below is take from SQLNET.ORA
>TRACE_LEVEL_CLIENT = OFF
>#sqlnet.authentication_services = (NONE)
>names.directory_path = (TNSNAMES, HOSTNAME)
>names.default_domain = world
>name.default_zone = world
>automatic_ipc = off
>
>5. Tried connecting a few times but had error:
>a. ORA 1224 – TNS No Listener
>b. ORA -12203: TNS: unable to connect to destination.
>
>So I check the LISTENER.ORA file and it’s as such:
>
># D:\ORANT\NET80\ADMIN\LISTENER.ORA Configuration
>File:d:\orant\net80\admin\listener.ora
># Generated by Oracle Net8 Assistant
>
>PASSWORDS_LISTENER= (oracle)
>
>LISTENER =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = IPC)(KEY = oracle.world))
> (ADDRESS = (PROTOCOL = IPC)(KEY = ORCL))
> (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
> (ADDRESS = (PROTOCOL = NMP)(SERVER = PROJECT)(PIPE = ORAPIPE))
> (ADDRESS = (PROTOCOL = TCP)(HOST = 192.166.166.200)(PORT = 1521)) <=
>added by me
> (ADDRESS = (PROTOCOL = TCP)(HOST = projectserver)(PORT =
>1521)) <= added by me
># (ADDRESS = (PROTOCOL = TCP)(HOST = project)(PORT = 1521)) <=
>commented by me # (ADDRESS = (PROTOCOL = TCP)(HOST = project)(PORT =
>1526)) <= commented by me
> (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
> (ADDRESS = (PROTOCOL = SPX)(SERVICE = project_lsnr))
> (ADDRESS = (PROTOCOL = IPC)(KEY = ORC0))
> (ADDRESS = (PROTOCOL = IPC)(KEY = ORC1))
> )
>
>SID_LIST_LISTENER =
> (SID_LIST =
> (SID_DESC =
> (GLOBAL_DBNAME = project)
> (SID_NAME = ORCL)
> )
> (SID_DESC =
> (SID_NAME = extproc)
> (PROGRAM = extproc)
> )
> (SID_DESC =
> (SID_NAME = ORC0)
> )
> (SID_DESC =
> (SID_NAME = ORC1)
> )
> )
>
>projectserver is the name of my server.
>
>But have some naming conflicts when I check the NAMES.ORA file
>
># D:\ORANT\NET80\ADMIN\NAMES.ORA Configuration
>File:d:\orant\net80\admin\names.ora
># Generated by Oracle Net8 Assistant
>
>NAMES.SERVER_NAME = NS1.fyp.com
>
>NAMES.ADDRESSES =
> (ADDRESS = (PROTOCOL = TCP)(HOST = 192.166.166.200)(PORT = 1521))
>
>The HOST address was modified by me through Notepad.
>
>Can anyone tell me what’s the problem?
>Had been trying for the past 3 days… but to no avail.
>Need help desperately. I have about 1 month to finish my coding.
>
>Please answer me… Don’t hope to change to VB for my development.
>
>Thanks a lot…
>By the way I am a student from UPM…
>
>May God bless you.
>Sugar aka Gloria
>
>
Received on Mon Jan 24 2000 - 19:49:21 CST