Guys,
OS NT
ver 816.
When i try to access the database on my mchine at home i get the end of file comm error.....
While if at work when on the NT domain it causes no problems.
Why do i get this error??
Note: the tnslsnr is running.
The service/db is running.
what cud be wrong here??
my listener.ora is....
i ran the trace (this is the bottom end of the long trc file..)
-> PARAMETER TABLE LOAD RESULTS FOLLOW <-
Successful parameter table load
-> PARAMETER TABLE HAS THE FOLLOWING CONTENTS <-
LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = LAPTOP_TARRY)(PORT = 1521))) (ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC)(KEY = laptop_tarry)))))
SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (SID_NAME = PLSExtProc) (ORACLE_HOME = D:\orant) (PROGRAM = extproc)) (SID_DESC = (GLOBAL_DBNAME = nick) (ORACLE_HOME = D:\orant) (SID_NAME = nick)))
--- PARAMETER SOURCE INFORMATION ENDS ---
--- LOG CONFIGURATION INFORMATION FOLLOWS ---
Existing log stream is identical to desired "D:\orant\network\log\listener.log"; ignoring alter
--- LOG CONFIGURATION INFORMATION ENDS ---
my listener.ora
is>>>>>>>>>>>
# LISTENER.ORA Network Configuration File: D:\orant\network\admin\listener.ora
# Generated by Oracle configuration tools.
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = LAPTOP_TARRY)(PORT = 1521))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = laptop_tarry))
)
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = D:\orant)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = nick)
(ORACLE_HOME = D:\orant)
(SID_NAME = nick)
)
)
i guess it's got something to with the hostnaming, but what exactly must i do to help it resolve the host name WHEN THE LAPTOP is NOT connected to the network???
Note: In the 8 version i cud change the mode to bequeath and then i could run it without being on network?
Help here?