yes that problem is resolved actually there are two problems: 1] Solaris Error: 12: Not enough space sys admin killed some processes and now other client machines can connect and work on the db
2]tnsping and sqlplus on one particular client machine give Bus Error (core dumped) seems its a disk corruption error (can that be?) from oracle's side where else can i see for this "Bus Error (core dumped)" error. Regards --------------------------------------------------- On Sat, 13 Sep 2003 Mladen Gogala wrote : >Then, you have a problem with the number of processes on the OS >level. The >investigation should continue on the server. > >-- >Mladen Gogala >Oracle DBA > > > > > -----Original Message----- > > From: bhabani s pradhan [mailto:[EMAIL PROTECTED] > > Sent: Friday, September 12, 2003 5:46 PM > > To: Mladen Gogala > > Subject: Re: RE: RE: RE: Bus Error (Urgent) > > > > > > its a 2gig memory > > > > shmsys:shminfo_shmmax=4294967295 > > shmsys:shminfo_shmmin=1 > > > > parameter processes = 150 > > > > and v$process returns 25 > > > > ------------------------------------------- > > > > > > > > On Sat, 13 Sep 2003 Mladen Gogala wrote : > > >You don't have enough oracle processes on the server. >Increase > > >"PROCESSES" > > >parameter. > > >You might need to adjust SHMMAX and SEMMNS in /etc/system > > > > > >-- > > >Mladen Gogala > > >Oracle DBA > > > > > > > > > > > > > -----Original Message----- > > > > From: bhabani s pradhan >[mailto:[EMAIL PROTECTED] > > > > Sent: Friday, September 12, 2003 5:34 PM > > > > To: Mladen Gogala > > > > Subject: Re: RE: RE: Bus Error (Urgent) > > > > > > > > > > > > donot know much about unix > > > > shell variables are exported > > > > > > > > from the client machine it soes not return anything: > > WW_WS> truss > > > > -o /tmp/truss.out -af tnsping tradedb1 WW_WS> > > > > > > > > > > > > > > > > i got this from the listener.log > > > > > > > > 12-SEP-2003 11:24:45 * > > > > > > > >(CONNECT_DATA=(SERVICE_NAME=TRADEDB1)(CID=(PROGRAM=)(HOST=trad > > > > e-host2)(USER=rubix))) > > > > * (ADDRESS=(PROTOCOL=tcp)(HOST=10.10.8.27)(PORT=40838)) >* > > establish > > > > * TRADEDB1 * 12500 > > > > TNS-12500: TNS:listener failed to start a dedicated server >process > > > > TNS-12540: TNS:internal limit restriction exceeded > > > > TNS-12560: TNS:protocol adapter error > > > > TNS-00510: Internal limit restriction exceeded > > > > Solaris Error: 12: Not enough space > > > > > > > > > > > > Regards > > > > =================================================== > > > > > > > > > > > > > > > > On Sat, 13 Sep 2003 Mladen Gogala wrote : > > > > >OK, this seems to have been created with netca. Are >your > > >shell > > > > >variables > > > > >exported? You should do "truss -o /tmp/truss.out -af > > >tnsping > > > > >tradedb1". > > > > >That should tell you where does the error occur. Bus >error > > >means > > > > >that the > > > > >process cannot connect to the server. It's very similar >in > > >nature > > > > >to > > > > >ORA-3113. > > > > >If it was oracle process you were trying to connect, >you'd > > >get an > > > > >oracle > > > > >error, > > > > >but your're getting bus error, which means that the >problem > > >is on > > > > >the OS > > > > >level. > > > > >Turn on tracing (TRACE_LEVEL=ADMIN in sqlnet.ora on >both > > >server > > > > >and client) > > > > >and > > > > >see what that gives you. What else can you tell me? Is > > >there > > > > >anything > > > > >unusual > > > > >in that combination? Did it work before? What has >changed? > > >How > > > > >much > > > > >experience > > > > >do you have with Unix and oracle? > > > > > > > > > >-- > > > > >Mladen Gogala > > > > >Oracle DBA > > > > > > > > > > > > > > > > > > > > > -----Original Message----- > > > > > > From: bhabani s pradhan > > >[mailto:[EMAIL PROTECTED] > > > > > > Sent: Friday, September 12, 2003 5:03 PM > > > > > > To: Multiple recipients of list ORACLE-L > > > > > > Cc: Mladen Gogala > > > > > > Subject: Re: RE: Bus Error (Urgent) > > > > > > > > > > > > > > > > > > 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 > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > >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. > > > > > > > > > > > > > ___________________________________________________ > > > > Interior meets Software; Rani Weds Gaurav. > > > > Rediff Matchmaker strikes another interesting match > > > > Visit http://matchmaker.rediff.com?1 > > > > > > > > > > > > > > > > > > > > > > >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. > > > > > > > ___________________________________________________ > > Interior meets Software; Rani Weds Gaurav. > > Rediff Matchmaker strikes another interesting match > > Visit http://matchmaker.rediff.com?1 > > > > > > > > >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. > ___________________________________________________ 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).
