Can someone post sample of tnsname.ora listener.ora,sqlnet.ora

[waynewan]

I can't start the oracle intelligent agent to use the OEM.
I think something must be wrong in my .ora files.

If someone can use OEM,
can you post some sample files
of tnsnames.ora,listener.ora,sqlnet.ora,snmp_rw.ora,services.ora
for me to reference ?

I use oracle 8.0.6 oem 1.6 on NT.

Thanks

[rcaballe]

I don't have 8.0 anymore (only 8.1.6 and 8.1.7) :D
Anyway, the best way is deleting all *.ora (SQLNET.ORA, TNSNAMES.ORA, LISTENER.ORA)
Delete means backup and then delete.
And enter to the Net8 Assistant (Not the Easy)
If that doesn't work, check the nmi*.log to see what's happening.

[waynewan]

I found that I can't start the oracle intelligent agent
on the server side by using NT services or command "lsnrctl80
dbsnmp_start".
(Is that intelligent agent need to start up with "oracle SNMP agent" ?
And also I can't find the oracleSNMPPeerMasterAgent in the NT services
or
any Master.cfg in the Net8/admin directory.
Is that mean I haven't install the oracle SNMP agent ?
)

I have checked that the listener had already started and the "oem"
and "orcl" entries does exist in the E:\orant\net80\admin\listener.ora file


The following is the error log when I start the intelligent agent.

nmiconfig.log
=============
DBSNMP for 32-bit Windows: release 8.0.6 - Production on 10-JAN-01 18:28:42
Warning : Skipping OracleTNSListener80 : Couldnot find corresponding listener definition in {E:\orant\net80\admin\listener.ora}
Warning : No Listener found for SID OEM1. OEM1 will be skipped
Warning : No Listener found for SID ORCL. ORCL will be skipped

snmp_ro.ora
===========
snmp.visibleservices = ()
ifile = E:\orant\net80\admin\snmp_rw.ora

The file services.ora and snmp_rw.ora is empty.

listnere.ora
========
# E:\ORANT\NET80\ADMIN\LISTENER.ORA Configuration File:E:\orant\net80\admin\listener.ora
# Generated by Oracle Net8 Assistant

LISTENER =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = oracle.world))
(ADDRESS = (PROTOCOL = IPC)(KEY = wan.world))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
(ADDRESS = (PROTOCOL = NMP)(SERVER = WAN)(PIPE = ORAPIPE))
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = wa01ssc)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = wa01ssc)(PORT = 1526))
(ADDRESS = (PROTOCOL = IPC)(KEY = ORCL))
(ADDRESS = (PROTOCOL = IPC)(KEY = OEM1))
)

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = wan)
(SID_NAME = ORCL)
)
(SID_DESC =
(SID_NAME = extproc)
(PROGRAM = extproc)
)
(SID_DESC =
(SID_NAME = OEM1)
)
)

#PASSWORDS_LISTENER= (oracle)

tnsnames.ora
==========

WA01SSC_OEM1.WORLD =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = wa01ssc)(PORT = 1521))
(CONNECT_DATA = (SID = oem1)(GLOBAL_NAME = wan.world))
)

WA01SSC_ORCL.WORLD =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = wa01ssc)(PORT = 1521))
(CONNECT_DATA = (SID = ORCL)(GLOBAL_NAME = wan.world))
)

sqlnet.ora
========
E:\ORANT\NET80\ADMIN\SQLNET.ORA Configuration File:E:\orant\net80\admin\sqlnet.ora
# Generated by Oracle Net8 Assistant

NAME.DEFAULT_ZONE = world

NAMES.DEFAULT_DOMAIN = world

#sqlnet.authentication_services = (NONE)

SQLNET.EXPIRE_TIME = 0

SQLNET.ENCRYPTION_SERVER = requested

SQLNET.ENCRYPTION_CLIENT = requested

NAMES.DIRECTORY_PATH= (TNSNAMES, HOSTNAME)

==========================================================
D:\users>lsnrctl80 status

LSNRCTL80 for 32-bit Windows: Version 8.0.6.0.0 - Production on
07-Jan-01 19:00:22

(c) Copyright 1999 Oracle Corporation. All rights reserved.

Connecting to (ADDRESS=(PROTOCOL=IPC)(KEY=oracle.world))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR80 for 32-bit Windows: Version
8.0.6.0.0 - Production
Start Date 07-Jan-01 16:06:20
Uptime 0 days 2 hr. 54 min. 3 sec
Trace Level off
Security off
SNMP OFF
System parameter file is E:\orant\NET80\admin\listener.ora
Log messages written to E:\orant\NET80\log\listener.log
Services Summary...
OEM1 has 1 service handler(s)
ORCL has 1 service handler(s)
extproc has 1 service handler(s)
The command completed successfully
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Configure:
oracle 8.0.6
oem 1.6
OS - NT40

[rcaballe]

[url]http://metalink.oracle.com/metalink/plsql/ml2_documents.showFrameDocument?p_database_id=NOT&p_id=1016341.102[/url]
It's about 8.1.5, could work for you.
Backup each file before modify.
(I hope you have Metalink)