Re: Oracle 8i installation on RedHat Linux 7.3

From: Keg (redhat_at_zulu420.com)
Date: 04/21/04

  • Next message: Michael S. Dunsavage: "Re: forgot root password" 
    Date: Wed, 21 Apr 2004 06:13:30 -0700
To: General Red Hat Linux discussion list <redhat-list@redhat.com>

    Nitin Mehta wrote:

    >Thank you, it worked.
    >I can connect from client to my server at linux system now.
    >
    >Thanks a lot again
    >Nitin
    >
    >----- Original Message -----
    >From: "Tobias Speckbacher" <tobias@quova.com>
    >To: "General Red Hat Linux discussion list" <redhat-list@redhat.com>
    >Sent: Friday, April 09, 2004 11:27 PM
    >Subject: RE: Oracle 8i installation on RedHat Linux 7.3I just remembered on windows the file sqlnet.ora in
    >$ORACLE_HOME/network/admin sometimes causes havoc, try moving it to a
    >different name and check your connection again.
    >
    >-Tobias
    >
    >-----Original Message-----
    >From: redhat-list-bounces@redhat.com
    >[mailto:redhat-list-bounces@redhat.com] On Behalf Of Tobias Speckbacher
    >Sent: Friday, April 09, 2004 9:22 AM
    >To: General Red Hat Linux discussion list; General Red Hat Linux
    >discussion list
    >Subject: RE: Oracle 8i installation on RedHat Linux 7.3
    >
    >sounds like either your listener configuration or the tnsnames.ora file
    >on the client side has issues.
    >--
    >redhat-list mailing list
    >unsubscribe mailto:redhat-list-request@redhat.com?subject=unsubscribe
    >https://www.redhat.com/mailman/listinfo/redhat-list
    >
    >
    >
    Don't remove the sqlnet.ora file, just properly configure it:

    You likely only want this in it for your config:
    NAMES.DIRECTORY_PATH= (TNSNAMES)

    Removing this file likely causes defaults to be used (or not), which may
    or may not be the behavior you really want. Look at Oracle's Networking
    document, it covers in great depth all the naming resolution methods and
    etc...

    Then have your data sources defined in
    $ORACLE_HOME/network/admin/tnsnames.ora, here is an example:
    CHEM5 =
      (DESCRIPTION =
        (ADDRESS_LIST =
          (ADDRESS = (PROTOCOL = TCP)(HOST = chem5)(PORT = 1521))
        )
        (CONNECT_DATA =
          (SERVICE_NAME = chem5.mydomain.com)
        )
      )

    Then use tnsping to check your datasources:
    db-0204:~ #tnsping CHEM1

    TNS Ping Utility for Solaris: Version 9.2.0.4.0 - Production on
    21-APR-2004 06:04:53
    Copyright (c) 1997 Oracle Corporation. All rights reserved.
    Used parameter files:
    /u01/app/oracle/product/9.2.0.4/network/admin/sqlnet.ora

    Used TNSNAMES adapter to resolve the alias
    Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS =
    (PROTOCOL = TCP)(HOST = chem5)(PORT = 1521))) (CONNECT_DATA =
    (SERVICE_NAME = chem5.mydomain.com)))
    OK (10 msec)

    Also, I stumbled onto this site a long time ago:
    http://www.puschitz.com/ This guy has dedicated a site to Oracle on Linux.

    Lastly, you don't need to use any naming at all, you can always use an
    explicit connection string with your driver, whether it be jdbc, odbc,
    or any other method. Naming only becomes usefull in large oracle
    environments with scores of databases. When it comes to Oracle
    networking, keep it simple but secure.

    -Chuck 

    -- 
redhat-list mailing list
unsubscribe mailto:redhat-list-request@redhat.com?subject=unsubscribe
https://www.redhat.com/mailman/listinfo/redhat-list
  • Next message: Michael S. Dunsavage: "Re: forgot root password"

    Relevant Pages

    • system() return code always -1 after DBI/DBD local connection
      ... I am attempting to package a common Perl v5.8.6 + DBI ... Oracle 10g client and appears to be able to connect OK ... After making a connection with DBI, ...
      (perl.dbi.users)
    • RE: Oracle Client, stored procedures and Cursor release.
      ... I think there is no many things we can do in the client. ... Usually we can save the resource by closing the connection, ... Or if oracle has provided some system call just ...
      (microsoft.public.dotnet.languages.vb)
    • Re: HELP
      ... Not familiar with specs for Oracle Client, ... ODBC driver). ... >> Connection and Recordset Objects) in order to use ODBC ...
      (microsoft.public.excel.programming)
    • Re: port forwarding
      ... It sounds like you're running into Oracle's port redirection... ... Client reconnects to the indicated IP and port. ... Run Oracle Connection Manager on either machine l or w, ... will require changes to the database connection details, ...
      (SSH)
    • RE: ADO.Net Connection Pooling Problem with Oracle
      ... the CLR is releasing the connection to your database. ... the number of database sessions in Oracle seem to ...
      (microsoft.public.dotnet.framework.adonet)