bmfloyd

Thanks a lot.

Next time I go back to solaris (probably next month) I will remember "sysdef |grep -i shmseg".

Of course, my problem was very urgent, and I worked with probably false values (Oracle documentation says "change this value if it's smaller than xxx", and at this moment I had no idea if the value was smaller than yyy).

Let me know if you have a problem. Right now got a machine (sparc) working with Oracle 9.2 with next parameters:

set shmsys:shminfo_shmmax=2147483648

set shmsys:shminfo_shmmin=1

set shmsys:shminfo_shmmni=100

set shmsys:shminfo_shmseg=10

And another one with 10.2:

set shmsys:shminfo_shmmax=4294967295

set shmsys:shminfo_shmmin=1

set shmsys:shminfo_shmmni=1024

set shmsys:shminfo_shmseg=1024

As you can see, the second machine defers a lot from the first one, but both are working properly while met requirements of the Oracle RDBMS version.

 

Good luck.

Hi,I've been messing with Vista last six months on a very good PC (P4/1.5Gb) and the experience was really bad. It's not a notice that Windows Vista has become one of the worst MS creations, finally I've returned to XP. But, for somehow, I've received a DVD of Windows Server 2008 and thought what if I try it as a workstation?Found the time and did it. Well, Server 2008 is not a rival of Vista, it's a rival of XP!WS2008 installed just with the necessary for a desktop it's a very good option if you want the Vista look & feel and the stability of XP. Some overviews:PROS:- Good recognition of devices and easy installation of drivers.- Much better look than XP.- MUCH better performance than Vista.- Resources consumption less than what one can think about a Server SO.- Very (VERY) stable.- If used for Windows sysadmin tasks, it's probably the best value.CONS:- Compatibility: some apps. like MS Live/Messenger were very difficult to configure, but works at last. Some others, like Outlook Connector for Lotus, never worked, or at least, I've couldn't.- More system space consumption: 2008 took ~1Gb. more of disk space than XP.If someone wants to try, I suggest first using a virtual machine (like VMWare) and works with compatibility with some apps. In the meantime, I'm waiting to get a copy of Windows 7 Beta...

I have problems when installing Oracle on Solaris. The database files are correctly copied, but the instance does not startup, in the alert file I have a message saying that the the shm parameters are not correct.How is it possible to know the current value of SHMMNI, SHMSEG, SHMMAX etc..., really reading them from the solaris kernel ?
I inserted some values in /etc/system, but how to know if these new values have been taken into account ?
The Oracle documentation says "ask the system administrator". Unfortunately, I am currently the solaris sytem administrator !

Yordan, at this time I'm pretty sure you solved your problem and you are now a good Solaris Sysadmin

As a guest said, the command 'sysdef' will tell you what you're looking for. Using it in conjuction with 'grep' it's very useful. For example: 'sysdef | grep SHMMNI' will tell you the current value for Shared Memory Identifiers.

Now, as you must know, these values are on the file '/etc/system' and it's VERY important before modifying this critical file to make a copy: 'cp -p /etc/system /etc/system.orig'. This way you can go back anytime if changes were disruptive and your system isn't booting properly. You can boot on Admin mode (init 1), and undo any change on '/etc/system' file.

Hope this helps somebody.