Very Computer

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 its 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 whats 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 Dont 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

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