RE: sqlplus connect errors 1034/27101/svr4...

2003-02-24 Thread Cunningham, Gerald
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...

2003-02-23 Thread Les Ayudo
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...

2003-02-23 Thread Stephane Faroult
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...

2003-02-23 Thread Les Ayudo
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...

2003-02-23 Thread Stephane Faroult
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...

2003-02-23 Thread Darrell Landrum
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).