|
jabbok (m)
|
When installing Oracle 10g on Solaris, hw do u avoid running into "out of memory" errors?
|
|
|
|
|
|
landis (m)
|
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.
|
|
|
|
|
|
jabbok (m)
|
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. 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.
|
|
|
|
|
|
landis (m)
|
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
|
|
|
|
|
|
jabbok (m)
|
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" |
|
|
|
|
|
jabbok (m)
|
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 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 (m)
|
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.
|
|
|
|
|
|
jabbok (m)
|
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. 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.
|
|
|
|
|
|
landis (m)
|
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 SUNWil5cs
|
|
|
|
|
|
jabbok (m)
|
Yes am on Solaris 10 i already have "set noexec_user_stack=1" prctl -i project user.oracle returned cannot find projectFor pkg search, d system found this pkg: SUNWi1of but d system returned not found on pkginfo -i SUNWi15cs and pkginfo -i SUNWi1cs. Thanks 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 SUNWil5cs
|
|
|
|
|
|
trillionsG (f)
|
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
|
|
|
|
|
|
jabbok (m)
|
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. 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
|
|
|
|
|
|
trillionsG (f)
|
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.
|
|
|
|
|
|
laceybric (f)
|
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?
|
|
|
|
|
|
jabbok (m)
|
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 your 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. 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?
|
|
|
|
|
|
A-40 (m)
|
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 |
|
|
|
|
|
max4ng
|
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
|
|
|
|
|
|
![Nairaland [Nigerian Forum] Home](http://www.nairaland.com/Themes/default/images/english/home.gif)
Author
