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).
