Don't remove the sqlnet.ora file, just properly configure it: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@xxxxxxxxx>
To: "General Red Hat Linux discussion list" <redhat-list@xxxxxxxxxx>
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@xxxxxxxxxx [mailto:redhat-list-bounces@xxxxxxxxxx] 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@xxxxxxxxxx?subject=unsubscribe https://www.redhat.com/mailman/listinfo/redhat-list
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@xxxxxxxxxx?subject=unsubscribe https://www.redhat.com/mailman/listinfo/redhat-list
