Today I wanted to fine tune an Oracle DB memory consumption. I started to modifying a few parameters in initSID.ora files (links to all of them are in $ORACLE_HOME\/dbs).<\/p>\n
As part of the process I also changed processes parameter. To 20 – I know very stupid idea. I mean, I know now. I did usual dbshut and was about to do dbstart, but I have noticed that some DB processes are running. And they didn’t respond on usual kill command either. So I did second stupid thing – killed them with -9.<\/p>\n
But what was my surprise when I saw following in startup.log: SQL> ERROR: $ORACLE_HOME\/bin\/dbstart: Database instance \"MYDB\" warm started. and it wasn’t possible to login to the DB. Not even using sys user:<\/p>\n I had to ask my colleague and the reason for this behaviour was that there stayed 2 share memory blocks in the memory. Reboot would help, but you can use ipcs tool to delete the blocks:<\/p>\n ------ Shared Memory Segments -------- $ ipcrm -m 4423680 ------ Shared Memory Segments -------- That way, the init*.ora files finally took effect.<\/p>\n","protected":false},"excerpt":{"rendered":" http:\/\/www.dba-oracle.com\/t_ora_00020_maximum_processes_exceeded.htm<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[5],"tags":[],"class_list":["post-336","post","type-post","status-publish","format-standard","hentry","category-database"],"_links":{"self":[{"href":"https:\/\/nax.cz\/index.php?rest_route=\/wp\/v2\/posts\/336","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/nax.cz\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/nax.cz\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/nax.cz\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/nax.cz\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=336"}],"version-history":[{"count":0,"href":"https:\/\/nax.cz\/index.php?rest_route=\/wp\/v2\/posts\/336\/revisions"}],"wp:attachment":[{"href":"https:\/\/nax.cz\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=336"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/nax.cz\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=336"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/nax.cz\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=336"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
\n<\/p>\n
\nORA-00020: maximum number of processes (20) exceeded<\/p>\n
\n<\/code><\/p>\nsqlplus \/ as sysdba<\/code><\/p>\n
\n$ ipcs -m<\/p>\n
\nkey shmid owner perms bytes nattch status
\n0x7d9f3370 4423680 oracle 660 4096 0
\n0x1e6e4598 4620289 oracle 660 4096 0<\/p>\n
\n$ ipcrm -m 4620289
\n$ ipcs -m<\/p>\n
\nkey shmid owner perms bytes nattch status
\n<\/code><\/p>\n