End of file communication error......

[Tarry]

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?

[Tarry]

pando,sam,jeff,tim,julin,jurij..........?????????????

[julian]

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???

So the laptop is not connected to the network where the DB is in???

[Tarry]

The server/client is on the laptop.
So the db is on this mchine.

[julian]

Let's see the TNSNAMES.ORA file.

[Tarry]

julian,
here's the tnsnames.ora.........

# TNSNAMES.ORA Network Configuration File: D:\orant\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.

NICK.WAGENBORG.COM =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = laptop_tarry)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = nick)
)
)

EXTPROC_CONNECTION_DATA.WAGENBORG.COM =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)

WBSH.WAGENBORG.COM =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = nlwgnts7)(PORT = 1521))
)
(CONNECT_DATA =
(SID = wbsh)
)
)

DMV.WAGENBORG.COM =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = nlwgnts7)(PORT = 1521))
)
(CONNECT_DATA =
(SID = dmv)
)
)

WBDZ.WAGENBORG.COM =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = nlwgnts7)(PORT = 1521))
)
(CONNECT_DATA =
(SID = wbdz)
)
)


AS u can see only nick is on my machine.

[sambavan]

Can you check into the sqlnet.ora file and see whether the any SQLNET.AUTHENTICATION_SERVICES = (NT) then remove it. also make sure that the names.domain had been set to WAGENBORG.COM and NAMES.DIRECTORY_PATH=(TNSNAMES)

Sam

[julian]

tnsnames looks fine. Follow Sam's suggestions and post us with what happened.

[thanigai]

Hi Really funny,
The same thing happened to couple of administrator in 9i Oracle Trg class.
They got ora 03113 end of cumm....error.Everything set correctly.
when they logged out and again logged in to sqlplus it worked...
I also noticed that error in our office while control C ing the shutdown process..
Thanks.
Thanigai.

[Tarry]

sam ,
you were right(i shud have done a little bit of rethinking when i spoke of bequeathing the operation/local process).
I changed the SQLNET.AUTHENTICATION_SERVICES = (NTS) to BEQ and it was fine!(when i undocked my notebook)

sam,julian,

Thanx guys.