Home » Infrastructure » Linux » failures - sql plus
failures - sql plus [message #98735] Wed, 04 September 2002 10:43 Go to next message
Messages: 2
Registered: March 2002
Junior Member
I thought I had everything set up correctly after install. I created a tablespace and users and had no problems using sqlplus after I set each users .bash_profile. After a system reboot none of the automatic startup worked. I ended up logging into sqlplus and manually starting oracle and an instance of my db. Now, if I am using the oracle user I can log into sqlplus using any of the users I've created. But, if I log in under my main account (even though this was working before), I get the following error:

ORA-01034: ORACLE not available
ORA-27123: unable to attach to shared memory segment
Linux Error: 13: Permission denied

I'm not sure what's going on here and I've done a good bit of searching and have not been able to see what the problem is.

Also, I don't know how to automate the startup process so that a reboot doesn't kill oracle.

Can anyone help a newbie?
Re: failures - sql plus [message #98761 is a reply to message #98735] Sun, 10 November 2002 02:06 Go to previous messageGo to next message
Gong Ye LIAO
Messages: 1
Registered: November 2002
Junior Member
The ORA error messages may caused by the limitation
of your system setup value of /proc/sys/kernel/shmmax
(maxima of shared memory)
for example ,you may execute the command line as root:
echo `expr 1024 * 1024 * 1024` > /proc/sys/kernel/shmmax to extend the limitation
of shmmax to 1GB.My system is Debian GNU/Linux 3.0
,so,note that the tip above may not work on your system
anyway,Good luck,I wish I could do something for you.
Re: failures - sql plus [message #98994 is a reply to message #98761] Mon, 23 February 2004 06:42 Go to previous messageGo to next message
Claude Duvallet
Messages: 1
Registered: February 2004
Junior Member
I have the same problem with Oracle 9i under Mandrake 9.2. The solution of increasing shmmax does not work.
Have you any solution ?
Re: failures - sql plus [message #99063 is a reply to message #98994] Fri, 07 May 2004 10:11 Go to previous message
Frank Naude
Messages: 4570
Registered: April 1998
Senior Member

I've just done an Oracle 10g install on Mandrake 9.2.
Here are the commands to increase the kernel

Edit /etc/sysctl.conf and add the following lines:

# Oracle parameters    
kernel.shmmax = 2147483648    
kernel.sem = 250 32000 100 128

You obviously need to reboot before these parameters
will take effect. Fortunately, you can also set them

$ cd /proc/sys/kernel/    
$ echo 2147483648 >shmmax    
$ echo 250 32000 100 128 >sem

Best regards.

Previous Topic: Red Hat 3.0
Next Topic: RedHat 8.0 installation error: unable to probe monitor
Goto Forum:

Current Time: Sat Nov 27 00:23:04 CST 2021