listener trouble?

[Cap2010]

hi,
I have installed 8i lite on W2000. Getting Listener
errors. Unable to connect listener. What is the error?

1) Question is which file are the changes required.
and where?

2) What else is required to start oracle database?

Please help?

Cap2010


Below is the files of
ORA files in 2 different folders


Folder 1
net80/admin
===========
[red]sqlnet.ora[/red]
----------
automatic_ipc = on
TRACE_LEVEL_CLIENT = OFF
SQLNET.EXPIRE_TIME = 0
#sqlnet.authentication_services = (NONE)
names.directory_path = (c:\orant\NET80\ADMIN,c:\WINNT\system32\drivers\etc)
names.default_domain = myDOM
name.default_zone = myDOM
SQLNET.AUTHENTICATION_SERVICES = (ALL)


[red]tnsnames.ora[/red]
------------

Beq-local.world =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(PROTOCOL = BEQ)
(PROGRAM = oracle80)
(ARGV0 = oracle80%available_sid%)
(ARGS = '(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))')
)
)
(CONNECT_DATA = (SID = %available_sid%)
)
)
Tcp-loopback.world =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(PROTOCOL = TCP)
(Host = 127.0.0.1)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = %available_sid%)
)
)
TcpExample.world =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(PROTOCOL = TCP)
(Host = Production1)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = ORCL)
)
)
SpxExample.world =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(PROTOCOL = SPX)
(Service = Server_lsnr)
)
)
(CONNECT_DATA = (SID = ORCL)
)
)
NmpExample.world =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(PROTOCOL = NMP)
(Server = FinanceServer1)
(Pipe = ORAPIPE)
)
)
(CONNECT_DATA = (SID = ORCL)
)
)
CMExample.world =
(DESCRIPTION=(address_list=
(ADDRESS=
(PROTOCOL=tcp)(PORT=1610)(HOST=CM_SERVER))
(ADDRESS=
(PROTOCOL=tcp)(PORT=1521)(HOST=LSNR_SERVER)))
(CONNECT_DATA=(SID=ORCL))
(SOURCE_ROUTE=yes)
)
extproc_connection_data.world =
(DESCRIPTION =
(ADDRESS =
(PROTOCOL = IPC)
(KEY = EXTPROC%ORACLE_HOME_ID%)
)
(CONNECT_DATA = (SID = extproc)
)
)


Folder 2
net80/tnsapi
============

[red]listener.ora[/red]
------------
################
# Filename......: listener.ora
# Node..........: local.world
# Date..........: 24-MAY-94 13:23:20
################
LISTENER =
(ADDRESS_LIST =
(ADDRESS=
(PROTOCOL= IPC)
(KEY= Anil.anil)
)
(ADDRESS=
(PROTOCOL= IPC)
(KEY= ORCL)
)
(ADDRESS=
(COMMUNITY= TCP.world)
(PROTOCOL= TCP)
(Host= anil)
(Port= 1521)
)
)
STARTUP_WAIT_TIME_LISTENER = 0
CONNECT_TIMEOUT_LISTENER = 10
TRACE_LEVEL_LISTENER = OFF
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = tftp)
(PROGRAM = tftpd)
)
(SID_DESC =
(SID_NAME = orcl)
(PROGRAM = plus80)
)
)
PASSWORDS_LISTENER = (oracle)


[red]tnsnames.ora[/red]
------------
Beq-local.world =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = beq.world)
(PROTOCOL = BEQ)
(PROGRAM = oracle80)
(ARGV0 = oracle80ORCL)
(ARGS = '(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))')
)
)
(CONNECT_DATA = (SID = ORCL)
)
)
Tcp-loopback.world =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = tcp.world)
(PROTOCOL = TCP)
(Host = 127.0.0.1)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = ORCL)
)
)
tftp.world =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = tcp.world)
(PROTOCOL = TCP)
(Host = hostname)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = tftp)
)
)
sfinger.world =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = tcp.world)
(PROTOCOL = TCP)
(Host = hostname)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = sfinger)
)
)

 

[gansen]

Have you started the listener through services.,
Everytime you start the database you have to start the listener.,

Let me know the exact error with error no, so i can help you