RE: sqlplus connect errors 1034/27101/svr4...
Hi Les, Check to see if you have enough semaphores available (/etc/system) for the cumulative number of PROCESSES for all your db's on the server. - Jerry -Original Message- Sent: Sunday, February 23, 2003 9:09 AM To: Multiple recipients of list ORACLE-L Looked over some websites and still couldn't figure out why I was getting these errors. I made sure my variables were set and still could not connect. Any ideas? I'm running oracle 8.1.7 on solaris 9 (USparc10). Let me know if you need more info. error 1034: Oracle not avail. error 27101: shared memory realm does not exit svr4 error :2: No such file of directory -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Les Ayudo 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Cunningham, Gerald 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).
sqlplus connect errors 1034/27101/svr4...
Looked over some websites and still couldn't figure out why I was getting these errors. I made sure my variables were set and still could not connect. Any ideas? I'm running oracle 8.1.7 on solaris 9 (USparc10). Let me know if you need more info. error 1034: Oracle not avail. error 27101: shared memory realm does not exit svr4 error :2: No such file of directory -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Les Ayudo 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).
Re: sqlplus connect errors 1034/27101/svr4...
Les Ayudo wrote: Looked over some websites and still couldn't figure out why I was getting these errors. I made sure my variables were set and still could not connect. Any ideas? I'm running oracle 8.1.7 on solaris 9 (USparc10). Let me know if you need more info. error 1034: Oracle not avail. error 27101: shared memory realm does not exit svr4 error :2: No such file of directory Les, If ORACLE_SID and ORACLE_HOME are correctly set, then the only thing I can think of is that the setuid bit of the oracle executable ($ORACLE_HOME/bin/oracle) is not set. Should look like this : $ ls -l $ORACLE_HOME/bin/oracle -rwsr-s--x1 oracle dba -- Regards, Stephane Faroult Oriole Software -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephane Faroult 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).
Re: sqlplus connect errors 1034/27101/svr4...
yes, it looks like the setuid bit is correctly set...Any other suggestions? - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Sunday, February 23, 2003 6:38 AM Les Ayudo wrote: Looked over some websites and still couldn't figure out why I was getting these errors. I made sure my variables were set and still could not connect. Any ideas? I'm running oracle 8.1.7 on solaris 9 (USparc10). Let me know if you need more info. error 1034: Oracle not avail. error 27101: shared memory realm does not exit svr4 error :2: No such file of directory Les, If ORACLE_SID and ORACLE_HOME are correctly set, then the only thing I can think of is that the setuid bit of the oracle executable ($ORACLE_HOME/bin/oracle) is not set. Should look like this : $ ls -l $ORACLE_HOME/bin/oracle -rwsr-s--x1 oracle dba -- Regards, Stephane Faroult Oriole Software -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephane Faroult 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Les Ayudo 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).
Re: sqlplus connect errors 1034/27101/svr4...
Les Ayudo wrote: yes, it looks like the setuid bit is correctly set...Any other suggestions? Hmmph ... Is your database started ?... -- Regards, Stephane Faroult Oriole Software -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephane Faroult 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).
Re: sqlplus connect errors 1034/27101/svr4...
I've seen this error before a long time ago and can't remember exactly what I did (should start keeping a database, no pun intended). Have you been able to start this database at all ( can you start / stop it using svrmgrl )? If not, are there other databases running on this system (probably not on a sparc10)?. If so, try shutting one down and then try starting this one. If that works it is almost certain to be a kernel parameter too low for the oracle settings ( or too little memory ). Also, because of the last line of the error, is it possible the install of the oracle software wasn't clean. I'd try running it again to make sure everything was linked ok. I think there is way to simply relink, but I'm not sure what that is off the top of my head. A metalink search or a web search may point you to that. Hope something in this heap of guessing helps. [EMAIL PROTECTED] 02/23/03 08:08AM Looked over some websites and still couldn't figure out why I was getting these errors. I made sure my variables were set and still could not connect. Any ideas? I'm running oracle 8.1.7 on solaris 9 (USparc10). Let me know if you need more info. error 1034: Oracle not avail. error 27101: shared memory realm does not exit svr4 error :2: No such file of directory -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Les Ayudo 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Darrell Landrum 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).