Oracle Database Discussions

Hello!

I have "finally" installed an Oracle database on my computer and it seems to work fine. Now I need to use this database from a another computer. I use Win XP Pro on both computers.

Now I will describe the system on my host-computer (where the database is installed):

Global database name: ODB
SID: ODB

After the databaseinstallation I got this TNS descriptor (tnsnames.ora file):
(DESCRIPTION=
(ADDRESS_LIST=
(ADDRESS=(PROTOCOL=TCP)
(HOST=STHLMAMIRMED)
(PORT=1521)))
(CONNECT_DATA=
(SERVER=DEDICATED)
(SERVICE_NAME=ODB)))


Then I created a Listener on the same computer, this is a part of the information from the listener.ora file.
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = STHLMAMIRMED)(PORT = 1521))
)
)
)


With this information I am able to use the database from my host-computer. I am able to create tablespaces and so on...
------------------------------------------------------------------------------------------------------------------

Then on my second computer I installed an Oracle Client. But when I trying to connect to my ODB database (on the host-computer) I got an error "TNS: ...", something telling me that i do not have a TNS. (I use swedish version)

This is a part of the information from my listener.ora file.
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = STHLMAMIRMED)(PORT = 1521))
)
)

And this is the information from the tnsnames.ora file.
ODB_NET_SERVICE.SVMNN.SE =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = STHLMAMIRMED)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = ODB)
)
)

My sqlnet.ora file is almost empty.


Finally the question.
What is wrong with the listener.ora and tnsnames.ora files on my client computer that prevents me connecting to the ODB database on my host-computer?

Is there anything else I forgot?

Hope for a answer..