Hi there,

I have just been told that to get a connection to my local database while disconnected from the network I should add an IPC entry into my LISTENER file.

Unfortunately this was all I was told and I haven't been able to get it to work, I have added a copy of my LISTENER file.

If anyone can help I would be most grateful.

################
# Filename......: listener.ora
# Node..........: local.world
# Date..........: 24-MAY-94 13:23:20
################
LISTENER =
(ADDRESS_LIST =
(ADDRESS=
(PROTOCOL= IPC)
(KEY= oracle.world)
)
(ADDRESS=
(PROTOCOL= IPC)
(KEY= ORCL)
)
(ADDRESS=
(COMMUNITY= NMP.world)
(PROTOCOL= NMP)
(SERVER= tonnera)
(PIPE= ORAPIPE)
)
(ADDRESS=
(COMMUNITY= TCP.world)
(Host = tonnera)
(PROTOCOL= TCP)
(Port= 1521)
)
(ADDRESS=
(COMMUNITY= TCP.world)
(Host = 127.0.0.1)
(PROTOCOL= TCP)
(Port= 1521)
)
(ADDRESS=
(COMMUNITY= TCP.world)
(Host = tonnera)
(PROTOCOL= TCP)
(Port= 1526)
)
(ADDRESS=
(COMMUNITY= SPX.world)
(PROTOCOL= SPX)
(Service= tonnera_lsnr)
)
(ADDRESS=
(COMMUNITY= ipc.world)
(PROTOCOL= SPX)
(Service= tonnera_lsnr)
)
)
STARTUP_WAIT_TIME_LISTENER = 0
CONNECT_TIMEOUT_LISTENER = 10
TRACE_LEVEL_LISTENER = OFF
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = test)
)
(SID_DESC =
(SID_NAME = eolq)
)
)

PASSWORDS_LISTENER = (oracle)