Results 1 to 8 of 8
  1. #1
    Join Date
    Jan 2002
    Location
    west haven
    Posts
    33

    Unanswered: how to centralize configuration of .ora files

    Hello experts,

    I have 2 machines with Windows@K server OS.
    mc W2kOCSVR is the DB server with Oracle 9.0.2 and Oracle clinical DB 4.5
    mc OCMIDTIER is the Webserver on which I installed Oracle 9iAS. - App server

    I have started the DB on W2kOCSVR and it is running fine.
    I am able to TNSPING the database on W2kOCSVR successfully.

    on mc OCMIDTIER, I have many homes and I need to configure the .ora files to make the machines talk to one another.
    home 1 is \Oracle\806 where Oracle forms and reports are installed (Oracle 9iDS)
    Home 2 is \Oracle\iSuites where the appache server is installed

    How do I incorporate the contents of the listener.ora of 2KOCSVR into the listener.ora of the OCMIDTIER. Do I need to do that as per the manual?. Basically how to I point to partition E on W2KOCSVR because there is also a partition E on the machine OCMIDTIER?.

    See listener.ora contents on OCMDITIER
    -------------------------------------
    STARTUP_WAIT_TIME_LISTENER = 0
    CONNECT_TIMEOUT_LISTENER = 10
    #LOGGING_LISTENER = OFF
    TRACE_LEVEL_LISTENER = ADMIN

    LISTENER =
    (DESCRIPTION_LIST =
    (DESCRIPTION = # Local connections.
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = IPC)(KEY = icache))
    )
    )
    (DESCRIPTION = # IIOP Connections.
    (PROTOCOL_STACK = (PRESENTATION = GIOP)
    (SESSION = RAW)
    )
    (ADDRESS = (PROTOCOL = TCP)(HOST = ocmidtier.techobs.com)(PORT = 2481))
    )
    )
    #
    #
    # For secure connections over SSL, uncomment the following lines.
    #
    # (DESCRIPTION = # Secure TCP connections.
    # (ADDRESS =
    # (PROTOCOL = TCPS)(HOST = ocmidtier.techobs.com)(PORT = 2484)
    # )
    # )
    #
    # For secure IIOP connections over SSL, uncomment the following lines.
    #
    # (DESCRIPTION = # Secure IIOP Connections.
    # (PROTOCOL_STACK =
    # (PRESENTATION = GIOP)
    # (SESSION = RAW)
    # )
    # (ADDRESS = (PROTOCOL = TCPS)(HOST = ocmidtier.techobs.com)(PORT = 2482))
    # )
    #
    #Added the lines below from listener.ora of W2KOCSVR (database server)
    #
    # (DESCRIPTION = # General TCP connections
    # (ADDRESS = (PROTOCOL = TCP)(HOST = W2KOCsvr.techobs.com)(PORT = 1521)
    # )
    # )
    #
    # (DESCRIPTION = # IPC connections
    # (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0)
    # )
    # )
    #
    SID_LIST_LISTENER =
    (SID_LIST =
    (SID_DESC =
    (GLOBAL_DBNAME = ocmidtier.techobs.com-icache)
    (ORACLE_HOME = E:\ORACLE\iSuites) # from partition E on OCMIDTIER
    (SID_NAME = icache)
    )
    (SID_DESC =
    (ORACLE_HOME = E:\ORACLE\iSuites) # from partition E on OCMIDTIER
    (SID_NAME = iCache_extproc)
    (PROGRAM = extproc)
    )
    # (SID_DESC =
    # (GLOBAL_DBNAME = octrn.techobs.com)
    # (ORACLE_HOME = E:\oracle\ora92) # from partition E on W2kOCSVR
    # (SID_NAME = octrn)
    # )
    # (SID_DESC =
    # (SID_NAME = PLSExtProc)
    # (ORACLE_HOME = E:\oracle\ora92) # from partition E on W2kOCSVR
    # (PROGRAM = extproc)
    # )
    )

    See contents of SQLNET.ora on all machines
    -------------------------------------------------
    #static sqlnet.ora for Oracle8i Cache v1.0.0.0

    SQLNET.AUTHENTICATION_SERVICES=(NONE)

    names.directory_path = (TNSNAMES, ONAMES, HOSTNAME)
    names.default_domain = techobs.com
    name.default_zone = techobs
    automatic_ipc = off

    # as per INSTALL manual chapter 7.5
    #
    sqlnet.expire_time=5
    trace_level_client=off
    tnsping.trace_level=off
    #
    # end of modification

    tnsping.trace_directory = E:\Oracle\iSuites\network\trace

  2. #2
    Join Date
    Jun 2003
    Location
    West Palm Beach, FL
    Posts
    2,713

    Cool


    You need to create a tnsnames.ora file, put it in a nutral path (maybe like c:\oracle\local\cfg) and set the TNS_ADMIN environment variable to that location.

    The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

  3. #3
    Join Date
    Jan 2002
    Location
    west haven
    Posts
    33

    follow-up to configuring .ora files

    Thank you for your reply. I have a tnsnames.ora. It's just that I did not post it because my main question was regarding the centralizing of the CONTENTS of both the listeners into 1 LISTENER. I am not a DBA and hence I find it difficult to do everything that I read. Hence the request for help before I can use the Oracle CLinical application - my specialty.

    How to I point to my DB in the listener whenthe DB is on a partion on another machine?.

    Contents of tnsnames.ora
    ---------------------------
    # To access iCache from a remote client node, use this as a template for
    # the client side tnsnames.ora entry. Fill in the appropriate host and port
    # for this iCache node.
    #
    # icache_db =
    # (DESCRIPTION =
    # (ADDRESS_LIST =
    # (ADDRESS =
    # (PROTOCOL = TCP)
    # (HOST = <iCache Host Node>)
    # (PORT = <iCache Port Number, 1521>)
    # )
    # )
    # (CONNECT_DATA =
    # (SERVICE_NAME = <iCache Host Node>-icache)
    # )
    # )

    # Internal name for local Oracle8i Cache.
    #
    ora_icache =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = IPC)(KEY = icache))
    )
    (CONNECT_DATA = (SERVICE_NAME = ocmidtier.techobs.com-icache )
    )
    )
    #
    # Descriptive name to connect to cache via OEM performance monitor.
    ocmidtier.techobs.com-icache =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = IPC)(KEY = icache))
    )
    (CONNECT_DATA = (SERVICE_NAME = ocmidtier.techobs.com-icache )
    )
    )
    #
    # Support for external procedures within Oracle8i cache.
    #
    extproc_connection_data =
    (DESCRIPTION =
    (ADDRESS = (PROTOCOL = ipc)(KEY = icache)
    )
    (CONNECT_DATA = (SID = iCache_extproc)(SERVER = DEDICATED)
    )
    )
    #
    # Oracle8i Cache's origin database.
    #
    ora_icache_origin =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS =
    (PROTOCOL = TCP)
    (HOST = ocmidtier.techobs.com)
    (PORT = <originPortNumber>)
    )
    )
    (CONNECT_DATA =
    (SERVICE_NAME = <originServiceName>)
    )
    )
    #
    # Support for mod_ose over normal TCP connections.
    #
    inst1_http =
    (DESCRIPTION =
    (ADDRESS =
    (PROTOCOL = TCP)
    (HOST = ocmidtier.techobs.com)
    (PORT = 2481)
    )
    (CONNECT_DATA =
    (SERVICE_NAME = MODOSE)
    (SERVER = shared)
    (PRESENTATION = http://admin)
    )
    )

    # To support mod_ose over TCP with SSL connections, uncomment
    # the following lines.
    #
    #inst1_https =
    # (DESCRIPTION =
    # (ADDRESS =
    # (PROTOCOL = TCPS)
    # (HOST = ocmidtier.techobs.com)
    # (PORT = 2484)
    # )
    # (CONNECT_DATA =
    # (SERVICE_NAME = MODOSE)
    # (SERVER = shared)
    # (PRESENTATION = http://admin)
    # )
    # )
    #
    # last two below taken from tnsnames.ora of W2KOCSVR
    EXTPROC_CONNECTION_DATA.TECHOBS.COM =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = IPC)(Key = EXTPROC0))
    )
    (CONNECT_DATA = (SID = extproc0))
    )
    #
    OCTRN.TECHOBS.COM =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = w2kocsvr.techobs.com)(PORT = 1521))
    )
    (CONNECT_DATA =
    (SERVICE_NAME = octrn)
    )
    )
    #
    Rep90ocmidtier,Rep90ocmidtier.techobs.com=(ADDRESS =(PROTOCOL=tcp)(HOST=ocmidtier.techobs.com)(PORT=1 949))

  4. #4
    Join Date
    Jun 2003
    Location
    West Palm Beach, FL
    Posts
    2,713

    Cool

    How to I point to my DB in the listener whenthe DB is on a partion on another machine?.

    Listeners are local to each server, you cannot "listen" to an instance from another server.

    But you can consolidate all listeners on same server into one:

    - stop all listeners
    - select the Oracle home to use for the listener
    - Consolidate the listener.ora file into that oracle home listener.ora
    - remove other listeners from the "services" startup, leaving only the
    consolidated one.

    The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

  5. #5
    Join Date
    Jan 2002
    Location
    west haven
    Posts
    33
    Wow!, Thank you so much for that piece of information about listeners. I assumed that when the manual said to centralize the tnenames.ora files, that I had to also centralize the listener.ora files. So, now I know.
    Thank you once again for that VITAL piece of information.

  6. #6
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >Listeners are local to each server, you cannot "listen" to an instance from another server.
    REALLY? Where is this restriction documented?

    Why must the listener be told upon which host the instance resides?
    If you are/were correct, the listener would not need to be told of the hostname of the instance. The listener would know the instance would always be found on "localhost".

    In the example below why must "<iCache Host Node>" be the same system upon which the listener runs?

    # To access iCache from a remote client node, use this as a template for
    # the client side tnsnames.ora entry. Fill in the appropriate host and port
    # for this iCache node.

    icache_db =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS =
    (PROTOCOL = TCP)
    (HOST = <iCache Host Node>)
    (PORT = <iCache Port Number, 1521>)
    )
    )
    (CONNECT_DATA =
    (SERVICE_NAME = <iCache Host Node>-icache)
    )
    )
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  7. #7
    Join Date
    Jan 2002
    Location
    west haven
    Posts
    33

    Listeners are local to

    OK, if listeners are NOT local to each machine, then how can I configure a listener to be centralized. In other words, I have two machine or 3 machines. I need to have the contents of machine1 also in listener of machine 2.

    here is my problem as explained earlier. There are 2 partitions 'E' on each of the machines. I don't know how to actually map them in the listener .ora. See the commenetdd lines. How do I qualify the server ther alongside the partition?.

    SID_LIST_LISTENER =
    (SID_LIST =
    (SID_DESC =
    (GLOBAL_DBNAME = ocmidtier.techobs.com-icache)
    (ORACLE_HOME = E:\ORACLE\iSuites) # from partition E on OCMIDTIER
    (SID_NAME = icache)
    )
    (SID_DESC =
    (ORACLE_HOME = E:\ORACLE\iSuites) # from partition E on OCMIDTIER
    (SID_NAME = iCache_extproc)
    (PROGRAM = extproc)
    )
    # (SID_DESC =
    # (GLOBAL_DBNAME = octrn.techobs.com)
    # (ORACLE_HOME = E:\oracle\ora92) # from partition E on W2kOCSVR
    # (SID_NAME = octrn)
    # )
    # (SID_DESC =
    # (SID_NAME = PLSExtProc)
    # (ORACLE_HOME = E:\oracle\ora92) # from partition E on W2kOCSVR
    # (PROGRAM = extproc)
    # )
    )

  8. #8
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >OK, if listeners are NOT local to each machine, then how can I configure a listener to be centralized.
    I did not state nor did I mean to imply that a single listener can support instances on more than one system.
    The desire to support multiple systems WRT Oracle listener(s) from a single host has made me think how to accomplish this goal.
    You can declare multiple listeners within a single listener.ora file; such as LISTENER_HOSTA, LISTENER_HOSTB, etc. and your problem is solved.
    I suggest you RTFM
    http://oraclesvca2.oracle.com/docs/c...b14212/toc.htm
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

Posting Permissions

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