
November 17th, 2003, 02:17 AM
|
|
Registered User
|
|
Join Date: Nov 2003
Posts: 15
Time spent in forums: < 1 sec
Reputation Power: 0
|
|
|
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
|