both client and server on Sun OS 5.8 ORACLE_HOME and ORACLE_SID in .profile
tnsnames.ora ------------ TRADEDB1 = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = trade-db1)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = TRADEDB1) ) ) INST1_HTTP = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = trade-db)(PORT = 1521)) ) (CONNECT_DATA = (SERVER = SHARED) (SERVICE_NAME = TRADEDB1) (PRESENTATION = http://admin) ) ) sqlnet.ora ---------- # SQLNET.ORA Network Configuration File: /export/home/oracle/product/8.1.7/network/admin/sqlnet.ora # Generated by Oracle configuration tools. NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME) now ?? Regards ------------------------------------------------------- On Sat, 13 Sep 2003 Mladen Gogala wrote : >Which platform & version, how did you define your ORACLE_HOME >and >ORACLE_SID, >did you export them, what do your tnsnames.ora and sqlnet.ora >look like? >This way, I can only tell you to wait for another bus. > >-- >Mladen Gogala >Oracle DBA > > > > > -----Original Message----- > > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] >On > > Behalf Of bhabani s pradhan > > Sent: Friday, September 12, 2003 5:00 PM > > To: Multiple recipients of list ORACLE-L > > Subject: Bus Error (Urgent) > > > > > > Hi All > > > > I am able to connect to my database from a set of different > > clients from different machines. > > > > From one particular machine i am not able to connect to the >DB > > server machine. > > > > ping <db_machine_ip> works fine > > but tnsping <service_name> gives > > > > Bus Error (core dumped) > > > > > > Please help > > > > Thanks and Regards > > > > ___________________________________________________ > > Interior meets Software; Rani Weds Gaurav. > > Rediff Matchmaker strikes another interesting match > > Visit http://matchmaker.rediff.com?1 > > > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.net > > -- > > Author: bhabani s pradhan > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services -- 858-538-5051 >http://www.fatcity.com > > San Diego, California -- Mailing list and web hosting >services > > >--------------------------------------------------------------------- > > To REMOVE yourself from this mailing list, send an E-Mail >message > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') > > and in the message BODY, include a line containing: UNSUB > > ORACLE-L (or the name of mailing list you want to be removed > > from). You may also send the HELP command for other > > information (like subscribing). > > > > > > >Note: >This message is for the named person's use only. It may contain >confidential, proprietary or legally privileged information. No >confidentiality or privilege is waived or lost by any >mistransmission. If you receive this message in error, please >immediately delete it and all copies of it from your system, >destroy any hard copies of it and notify the sender. You must >not, directly or indirectly, use, disclose, distribute, print, or >copy any part of this message if you are not the intended >recipient. Wang Trading LLC and any of its subsidiaries each >reserve the right to monitor all e-mail communications through >its networks. >Any views expressed in this message are those of the individual >sender, except where the message states otherwise and the sender >is authorized to state them to be the views of any such entity. > >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.net >-- >Author: Mladen Gogala > INET: [EMAIL PROTECTED] > >Fat City Network Services -- 858-538-5051 >http://www.fatcity.com >San Diego, California -- Mailing list and web hosting >services >--------------------------------------------------------------------- >To REMOVE yourself from this mailing list, send an E-Mail >message >to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and >in >the message BODY, include a line containing: UNSUB ORACLE-L >(or the name of mailing list you want to be removed from). You >may >also send the HELP command for other information (like >subscribing). ___________________________________________________ Interior meets Software; Rani Weds Gaurav. Rediff Matchmaker strikes another interesting match Visit http://matchmaker.rediff.com?1 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: bhabani s pradhan INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).