Can someone post sample of tnsname.ora listener.ora,sqlnet.ora
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

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

Hybrid View

  1. #1
    Join Date
    Jan 2001
    Posts
    3

    Unhappy

    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
    wayne

  2. #2
    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.
    Ramon Caballero, DBA, rcaballe@yahoo.com

  3. #3
    Join Date
    Jan 2001
    Posts
    3

    Unhappy

    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
    wayne

  4. #4
    [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)
    Ramon Caballero, DBA, rcaballe@yahoo.com

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width