| failures - sql plus [message #98735] |
Wed, 04 September 2002 10:43  |
tank
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:
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  |
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 #99063 is a reply to message #98994] |
Fri, 07 May 2004 10:11 |
Frank Naude
Messages: 4587
Registered: April 1998
|
Senior Member |
|
|
Hi,
I've just done an Oracle 10g install on Mandrake 9.2.
Here are the commands to increase the kernel
parameters:
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
on-line:
$ cd /proc/sys/kernel/
$ echo 2147483648 >shmmax
$ echo 250 32000 100 128 >sem
Best regards.
Frank
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
