Solutions for Oracle ORA-28002 and ORA-27101
Running an Oracle database is great, because it is stable and just runs, but sometimes you are hit with unexpected errors when you restart your machine. Thought, I know Oracle quite well, I’m always surprised at some things. Here are two errors (and solution) I was just confronted with:
ORA-27101: shared memory realm does not exist
To be honest, I don’t know why I was confronted with this error, since we haven’t changed anything to the machine or to the environment variables. Metalink suggest to check that the ORACLE_HOME and ORACLE_SID are correct. Funny thing is that this system runs for over a year without a change to the path, nevertheless I checked the ORACLE_HOME path and sure enough I had trailing slash at the end.
So, the solution was to see that ORACLE_HOME does NOT have a trailing slash.
echo $ORACLE_HOME /opt/oracle/product/11/ <--- WRONG! echo $ORACLE_HOME /opt/oracle/product/11 <--- CORRECT!
Remember to log out of your current shell session in order to reapply the new settings.
ORA-28002: the password has expired
Now, this error caught be even worse, because it happened right within a production environment. Also, here I was unaware of this setting. In any case, Oracle seams to want you to reset your password after one year or so. In case, you want to disable this on a user without changing the users password you need to issue the following commands in sqlplus:
alter profile {user} limit password_verify_function null;
This will set the verification for this user to null. If you want to do this for every user in your system you would use this (this is applied to the DEFAULT profile):
alter profile DEFAULT limit password_verify_function null;
Once done you can then reset the password for the user with the same password or with another one with:
alter user {user} identified by {password};
Exit sqlplus and your changes should have been applied.
Scotasya http://11111kljbghy.com xiii 222222 [url=http://33333hdhkji.com]333333[/url] Norivini
Granesus finasteride, under, drug valium, psych, buy ambien without a prescription, noted, clomiphene, dun, effexor, liz, Austrene
Anglorcas nexium, saves, wellbutrin, ashley, buy valium online without a prescription, nash, generic meridia, :-t, cheap propecia, lungs, Amatror
Romavius zoloft, faust, buy diazepam no prescription, lg, order lorazepam, grist, cheap klonopin, joey, buy vicodin, sticky, Indison
Ethia propecia canada cheap, influential, effexor, mixes, zolpidem, sews, nexium, wink, generic meridia, clone, Byzasova
Terralon wellbutrin generic, costs, imitrex coupon, keyyvsg, generic effexor, teens, valium, subtle, ambien cr, lunge, Swaneos
Salenona <a href="#top”>http://my.speedtv.com/ktrush, crew,<a href="#top”>http://my.speedtv.com/wbailey, debug, <a href="#top”>http://my.speedtv.com/daikens, yearn, <a href="#top”>http://my.speedtv.com/dehunt, nate, <a href="#top”>http://my.speedtv.com/bhuson, khz, Ferretana
Wonderful blog! I really love how it’s easy on my eyes and also the info are well written. I am wondering how I can be notified whenever a new post has been made. I have subscribed to your rss feed which must do the trick! Have a nice day!
Thanks to your info, I am going to be checking in..thanks
I absolutely adore reading your articles, the form of writing is extraordinary.This article as usual was educational, I have had to bookmark your site and subscribe to your feed in feedmaker. Your website looks great.
Dear admin, thnx for sharing this blog post. I found it wonderful. Most effective regards, Victoria…
You have a great article here, truly informative. Very well written I will be bookmarking this website and subscribing to your feed so i can regularly read content of this quality.
Hey – nice blog, just looking around some sites, seems a fairly nice platform you are applying. I’m currently using WordPress for a few of my blogs but shopping to change one of them over to a platform similar to yours as a trial run. Something in particular you’d recommend about it?
Do you do guest posting? I think it’d be great for you to do a guest spot on my blog, let me know if you’re game.
I’ve bookmarked, Dugg, and I joined the RSS subscription. Thanks!
Very insightful piece of info. Never thought that t’was dis easy after all. I’d spent a good deal of my time luking for someone to run this post clearly
Great resource. I really enjoyed your site!
Just wanna commentabout this article, after reading whole of this it make me to have new vision about one important event, hope I can read more good news again from you so I bookmark your website.