kernel params

[michael_210]

Hi Steven
Dont musunderstand me I am VERY grateful for any help. I was just adding what steps have been taken in trying to improve the situation..
Im a big fan of this forum !!!

Based on comments: I have the oracle data in a separate array on /dev/u06 devided in multple lvols. the Oracle binaries live on /dev/vg00 on the server.

would it be better to reorganize th data into
several vg's.. such as /dev/u06, /dev/u07 etc.

also if i increase shmmax would this allow increase in oracle SGA. (shmmax is currently 0x04000000
or increase max_threads_proc (current 256).
thanks
Mike

[T G Manikandan]

I am not sure why you want to do this.
If you want to distribute the Oracle data to new file systems then things are fine like you can rename the datafiles and logfiles to a new location so that the I/O can be distributed.
If you want to move the Oracle binaries then there should be some reason?
Are you lacking in space on the existing file system?
Why you want to move the Oracle binaries to a new location.
Ofcourse
Yes it is possible ,but make sure that you really want to move this.



1.If you want to move your oracle binaries into a new volume group
yes you can create a new filesystem move your Oracle binaries there and probably make a link to the existing location.

Like if the Oracle is now installed at /opt/oracle at vg00 then you can create a new volume group vg07 create a file system like /xxx and probably do a

ln -s /xxx/oracle /opt/oracle
so that the PATH is not changed for ORACLE_HOME.
There is no problem in doing this unless you have good knowledge about handling the situation.

//Backup everthing before the change//
database as well as the existing OS.


REvert