Net8 problem !!!

Hello ... I have Oracle8i Database server ... on a server without Domain Name .. just a host name (Oracle-Server) and intern IP address (192.168.0.102).

how I can configure the (tnsnames.ora) and (listener.ora) so i can log into the data base from another PC in the same Network ???? IT should be easy ... but it keep saying the there is no listner or adepter error ... !!!!


My tnsnames.ora is:
===========================================
# C:\ORACLE\ORA81\NETWORK\ADMIN\TNSNAMES.ORA Configuration File:C:\Oracle\Ora81\NETWORK\ADMIN\tnsnames.ora
# Generated by Oracle Net8 Assistant

ORACLEDB =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(PORT = 1521)(HOST = Oracle-Server))
)
(CONNECT_DATA =
(SERVICE_NAME = oracledb)
)
)
============================================
My listener.ora is:
============================================
# C:\ORACLE\ORA81\NETWORK\ADMIN\LISTENER.ORA Configuration File:C:\Oracle\Ora81\network\admin\listener.ora
# Generated by Oracle Net8 Assistant

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = Oracle-Server)(PORT = 1521))
)
)
)

ORACLEDB =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = Oracle-Server)(PORT = 1521))
)
)
)

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = C:\Oracle\Ora81)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = oracledb)
(ORACLE_HOME = C:\Oracle\Ora81)
(SID_NAME = ORACLEDB)
)
)

SID_LIST_ORACLEDB =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = C:\Oracle\Ora81)
(PROGRAM = extproc)
)
)
============================================

Thank you all for your time.

Sarmad M. Azad
Førde, Norway

You need to edit the tnsnames.ora file on the client PC that you wish to connect to the Oracle server from. Here is a snippet of a tns file:

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

TEST = #(name of the databse)
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = %your servername here%)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = TEST) # (name of database)
)
)

You can put the IP in the HOST= defintion in the tnsnames.ora file -- that goes on the client system. Also, in case you don't know... use 'tnsping' command to check your tnsnames.ora setup and oranet configuration.

-c

Thank you all ... but what about listener.ora ... so I have to delete it ... or what i have to do with it !!!!


and can I put this (tnsnames.ora) in the sererver ....

and dose that mean that I don't need a domain name ???


sorry it's llok like stuped questions ... but I need to clear some thing in my mind :-)


Thank you alot for your time