Connect to server using sqlplus

I'm trying to connect to our oracle servers using SQLPlus.

I've done a full install of the client software on my dev box. I can now connect to both of our servers (We've got an old one which we are in the process of moving stuff off.) in the stand alone enterprise management console.

SQLPlus still doesn't talk though.

I tried configuring "Local Net Service Name" using the Net Configuration Assistant.
I entered
1. Oracle 8i or later for version. We are running 9.something
2. shman for service name. That's what the database is called and the service name I entered in the management console which works.
3. tcp for protocol
4. webserver for host name. That's the server machine name, using webserver as host name worked in management console.
5. 1521 for port. I checked on the server and there is a listener showing for port 1521

When I run a test it gives me an error.
ORA-12514: TNS:listener could not resolve SERVICE_NAME given in connect descriptor.

The tnsnames.ora file looks like

# TNSNAMES.ORA Network Configuration File: C:\oracle\ora92\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.

SHMAN.MANTEL.LOCAL =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = webserver)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = shman)
)
)

I checked under services on server and there is a service called OracleOraHome92TNSListener running. I checked under Oracle Net Manager and it shows the listener on port 1521.

Any suggestions will be gratefully received.
Cheers,
Pete

I think, you made mistake when you were creating the service, I am not sure that following changes will work or not. Lets try, for example your service name shman and global database name is shman.mantel.local
now make the following changes in your piece of code:

SHMAN =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = webserver)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = SHMAN.MANTEL.LOCAL)
)
)

If it does not work, create your service again with appropriate values.