When installing Oracle 10g on Solaris, hw do u avoid running into "out of memory" errors?

you need to be sure you have atleast 1GB.

your swap should be atleast 1gb.

You should also adjust your kernel parameters; shared memory/semaphores.

Thanks for the reply. I did set all d parameters like "max-shm-memory" .
The size of my physical RAM is .99GB

During the disk layout I also gave swap more than two times the size of my RAM. But the out of memory error keeps coming.

landis:

you need to be sure you have atleast 1GB.

your swap should be atleast 1gb.

You should also adjust your kernel parameters; shared memory/semaphores.

as root and do following:

uname -a

prtconf | grep Mem

pagesize -a

Also copy the exact out of memory message here.

what action was being done when you get this

landis:

as root and do following:

uname -a

prtconf | grep Mem

pagesize -a

Also copy the exact out of memory message here.

what action was being done when you get this

I got this error message while the database configuration assisstant was trying to install. As a matter of fact, and on several attempts it just stops @ 2% and then display the "ORA-27102:out of memory"

these are the results I got when I issued the following commands:

#prtconf | grep Mem
Memory size: 1015MB

pagesize -a
4096
4194304


Kindly let me knw how to use this information to successfully install oracle 10g on my system.
many thanks

landis:

as root and do following:

uname -a

prtconf | grep Mem

pagesize -a

Also copy the exact out of memory message here.

what action was being done when you get this

I suspect your shared memory kernel parameter: oracle makes extensive use of shared memory(processes) and semaphores(locks)

send result of:

grep info_* /etc/system

Once, I review this, we could reset them.

The output:

set shmsys:shminfo_shmmax=4294967295
set shmsys:shminfo_shmmin=1
set shmsys:shminfo_shmmni=100
set shmsys:shminfo_shmseg=10
set semsys:seminfo_semmns=1024
set semsys:seminfo_semmsl=256
set semsys:seminfo_semmni=100


However, prior 2 d editing of /etc/system file, the following command was issued: #projadd -p 102 -c 'eBS benchmark' -U oracle -G dba -K 'project.max-shm-memory=(privileged,10G,deny)' OASB

Also SUNWilcs and SUNWil5cs pkgs were not found on my system. Pls also advise on hw I can add these packages.


Hope to read from you soon.
Many thanks.

landis:

I suspect your shared memory kernel parameter: oracle makes extensive use of shared memory(processes) and semaphores(locks)

send result of:

grep info_* /etc/system

Once, I review this, we could reset them.

Seems you using Solaris10.  can you do:

uname -a

vi /etc/system 
add below if not there.
set noexec_user_stack=1

do:
prctl -i project user.oracle

let me see and we can go ahead to modify your setting as you may have not set:
project.max-shm-ids
project.max-sem-ids
project.max-sem-nsems


That pkg should be there, do:

pkginfo -i SUNWi1of

pkginfo -i SUNWi15cs

it is not SUNWi[b]l[/b]5cs

Yes am on Solaris 10

i already have "set noexec_user_stack=1"

prctl -i project user.oracle returned cannot find project

For pkg search, d system found this pkg: SUNWi1of

but d system returned not found on pkginfo -i SUNWi15cs and pkginfo -i SUNWi1cs.

Thanks

landis:

Seems you using Solaris10. can you do:

uname -a

vi /etc/system
add below if not there.
set noexec_user_stack=1

do:
prctl -i project user.oracle

let me see and we can go ahead to modify your setting as you may have not set:
project.max-shm-ids
project.max-sem-ids
project.max-sem-nsems


That pkg should be there, do:

pkginfo -i SUNWi1of

pkginfo -i SUNWi15cs

it is not SUNWi[b]l[/b]5cs

hi guys am an oracle dba and really don't know a tin about solaris.pls how do i get started.also as a dba i really don't know much cos aint done much pratical i ean i aint worked in an oracle environ b4 wat can i do to be better qualified? thanks

If I understood you well, I believe u want 2 learn Solaris. wwww.forums.sun.com is a good place 2 start. I feel Solaris 10 is the most popular. But if u nd a one 2 one arrangement, we can work on it.

trillionsG:

hi guys am an oracle dba and really don't know a tin about solaris.please how do i get started.also as a dba i really don't know much because aint done much pratical i ean i aint worked in an oracle environ before what can i do to be better qualified? thanks

thanks a lot Jabbok thou d site aint openin.i'd ve liked a one on one tingy but i dont live in Lagos so it wont be easy.Pls could u give me another link that will work.also btwn Solaris and Linux which one is more secured? Thanks.

Am considerin doin Oracle prog but I want to know d benefits it wud b 2 me. I intend workin wit internatnal NGOs not goin in2 d comp per se but hopin d knowledge of Oracle mite b of use in my work.

So wots Oracle all about n where exactly wud it b useful?And is it beta as an added knowledge or beta 2 specialise in it and do d certificatn exam?

Where is d best place 2 take oracle lessons?duratn n course fees?

oracle is a very powerful application for RDBMS(Relational Database Management Systems). Virtually all the top companies and organizations in naija use oracle. The course fees are quite high but all depends on ur financial capability. there are a lot of training centres although most of them dont have enough tutors. However, u can find a DBA and arrange for a 1 on 1 training which I consider to b more effective and timely.

laceybric:

Am considerin doin Oracle prog but I want to know d benefits it would b 2 me. I intend workin wit internatnal NGOs not goin in2 d comp per se but hopin d knowledge of Oracle mite b of use in my work.

So wots Oracle all about n where exactly would it b useful?And is it beta as an added knowledge or beta 2 specialise in it and do d certificatn exam?

Where is d best place 2 take oracle lessons?duratn n course fees?

laceybric:

Am considerin doin Oracle prog but I want to know d benefits it would b 2 me. I intend workin wit internatnal NGOs not goin in2 d comp per se but hopin d knowledge of Oracle mite b of use in my work.

So wots Oracle all about n where exactly would it b useful?And is it beta as an added knowledge or beta 2 specialise in it and do d certificatn exam?

Where is d best place 2 take oracle lessons?duratn n course fees?

Hmm i don't know how many international NGO'S would need a DBA in their organization but you never know first and foremost what kind of work do you do

Its an RDBMS (Relational Database Management System) used to manage data and information about an organization,its employees and its critical information,Its used in virtually every area or sector oil,banking,healthcare, the list is endless you can choose to specialize or add it to your repertoire of qualifications but specialization is usually better because experts is what people are looking for right now

You can either be a Database Administrator or Developer whichever one you prefer

There are lots of places you could try NIIT,Aptech,New Horizons you should budget within 150 to 300 grand depending on which one you would want to go their courses are probably 4 months max

HI, orales is one of the best data management you can thinks of. To be frank with u must companies in Nigeria is using it for their data magement.
I also think it should be more better if you do it with sun Solaris os opperating system which NIIT company are combining the two.
Thanks