Saturday, October 29, 2011

Hi,

On first day post diwali holidays, come across below problem with my development server.

Getting below error message when executed startsap ALL
/usr/sap/DEV/SYS/exe/run/startdb: Terminating with error code 12


When check startdb.log.
Its showing database started successfully but is there is a issue with R3trans which failed to connect with database.

IPLDEVQLS:devadm 23> tail -f startdb.log
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

------------------------------ Sat Oct 29 10:22:46 IST 2011
Connect to the database to verify, that the database is now open

R3trans check finished with return code: 12
*** ERROR: Startup of database failed
Notify Database Administrator.
/usr/sap/DEV/SYS/exe/run/startdb: Terminating with error code 12

Why R3trans -d failed hence check trans.log,
Now got the reason.

4 ETW000 [dev trc ,00000] Starting user session: OCISessionBegin(con_hdl=0, usr=SAPSR3/, svchp=0x60000000010d1968, srvhp=0x60000000010d51b8, usrhp
=0x6000000001163ee0)
4 ETW000 272 0.150937
4 ETW000 [dev trc ,00000] OCISessionBegin(OCI_DEFAULT) failed with -1=OCI_ERROR 2936 0.153873
4 ETW000 [dev trc ,00000] OCISessionBegin(OCI_DEFAULT) failed with SQL error 28001: 179 0.154052
4 ETW000 [dev trc ,00000] ORA-28001: the password has expired
4 ETW000 35 0.154087
4 ETW000 [dev trc ,00000] server_detach(con_hdl=0,stale=1,svrhp=0x60000000010d51b8) 21 0.154108
4 ETW000 [dev trc ,00000] Detaching from DB Server (con_hdl=0,svchp=0x60000000010d1968,srvhp=0x60000000010d51b8)
4 ETW000 33 0.154141
4 ETW000 [dev trc ,00000] Deallocating server context handle 0x60000000010d51b8 from con_hdl=0
4 ETW000 1118 0.155259
4 ETW000 [dbsloci. ,00000] *** ERROR => CONNECT failed with sql error '28001' 36 0.155295
4 ETW000 [dev trc ,00000] set_ocica() -> SQL error code 28001 20 0.155315
4 ETW000 [dev trc ,00000] -->oci_get_errmsg (con_hdl=0, rc=28001) 21 0.155336
4 ETW000 [dev trc ,00000] OCIErrorGet -> SQL error code: 28001 112 0.155448
4 ETW000 [dev trc ,00000] ORA-28001: the password has expired

4 ETW000 37 0.155485
4 ETW000 [dblink ,00433] ***LOG BY2=>sql error 28001 performing CON [dblink#8 @ 433] 186 0.155671
4 ETW000 [dblink ,00433] ***LOG BY0=>ORA-28001: the password has expired [dblink#8 @ 433] 22 0.155693
2EETW169 no connect possible: "DBMS = ORACLE --- dbs_ora_tnsname = 'DEV'"

So root cause is password of SAPSR3 user is expired.

To resolve connect with sys user and set the password same as old.
SQL> conn sys as sysdba
Enter password:
Connected.

SQL> conn SAPSR3
Enter password:
ERROR:
ORA-28001: the password has expired


Changing password for SAPSR3
New password:
Retype new password:
Password changed
Connected.
SQL> exit

R3trans -d and its get success.
IPLDEVQLS:devadm 28> R3trans -d
This is R3trans version 6.14 (release 700 - 19.01.11 - 11:44:00).
unicode enabled version
R3trans finished (0000).

So can start SAP Instance.
IPLDEVQLS:devadm 29> startsap ALL

Checking DEV Database
------------------------------
ABAP Database is running

Starting SAP-Collector Daemon
------------------------------
11:14:03 29.10.2011 LOG: Effective User Id is root
***********************************************************************
* This is Saposcol Version COLL 20.95 700 - V2.7.1 2008-08-11 HP-UX IA64
* Usage: saposcol -l: Start OS Collector
* saposcol -k: Stop OS Collector
* saposcol -d: OS Collector Dialog Mode
* saposcol -s: OS Collector Status
* The OS Collector (PID 9370) is already running .....
************************************************************************
saposcol already running

Starting SAP Instance DVEBMGS00
------------------------------
Startup-Log is written to /home/devadm/startsap_DVEBMGS00.log
Instance Service on host IPLDEVQL started
Instance on host IPLDEVQL started

IPLDEVQLS:devadm 30>


Conclusion :
As of Oracle Database 11g Release 2 (11.2), the default limit for PASSWORD_LIFE_TIME for the DEFAULT profile is 180 days. Prior to Oracle Database 11g Release 2 (11.2), the default was UNLIMITED.

Permanent solution refer SAP Note 1519872 - SAP Database User Profile SAPUPROF

39 comments:

Anonymous said...

Hello Web Admin, I noticed that your On-Page SEO is is missing a few factors, for one you do not use all three H tags in your post, also I notice that you
are not using bold or italics properly in your SEO optimization.

On-Page SEO means more now than ever since the new Google update: Panda.
No longer are backlinks and simply pinging or sending out a RSS feed the key to getting
Google PageRank or Alexa Rankings, You now NEED On-Page SEO.
So what is good On-Page SEO?First your keyword must appear in the title.
Then it must appear in the URL.You have to optimize your
keyword and make sure that it has a nice keyword density of
3-5% in your article with relevant LSI (Latent Semantic Indexing). Then you should spread all H1,H2,H3 tags in your article.Your Keyword should appear in your first paragraph and in the last sentence of the page. You should have relevant usage of Bold and italics of your keyword.There should be one internal link to a page on your blog and you should have one image with an alt tag that has your keyword....wait there's even more Now what if i told you there was a simple Wordpress plugin that does all the On-Page SEO, and automatically for you? That's right AUTOMATICALLY, just watch this 4minute video for more information at. Seo Plugin
my web page: Decembre

Anonymous said...

Thank you for every other informаtive site. The ρlace еlsе mаy I get
that type оf information ωгittеn in such a perfect way?
I've a mission that I'm just now opеratіng
on, anԁ I hаvе been on the glance out for such info.


Feel fгee to surf to my ωeb page :: real work

Anonymous said...

Hі mates, how is аll, and what you desire to ѕaу on the tοpiс of this articlе, in mу view itѕ aсtually awesome dеsigned
for me.

Herе iѕ my web-ѕite Best animes

Anonymous said...

I do not even know how I ended up here, but I thought thіs ρost was
great. I don't know who you are but certainly you are going to a famous blogger if you aren't already ;) Cheers!


Нeгe is my web-sitе :: www.forexexpertadvisorsx.info

Anonymous said...

Having reаd this I believed it was veгy еnlіghtenіng.
I apprеciаte yοu spending some time аnd energy to put this information together.
І once аgain find myself personally
spending a lot of time both reading and posting commеnts.
But so whаt, it waѕ still worth it!

Herе іѕ mу wеblog :: weight watchers promotional code

Anonymous said...

I rеаlly like it when people get together and share views.
Great blog, kеep it up!

Mу web pagе :: distance relationships statistics
my site - www.inalongdistancerelationship.com

Anonymous said...

Аt this time I аm going awаy to ԁo my bгeаkfast, afterwaгԁ havіng my bгеаkfast cοming again tο read other news.


My blog hollywood diets

Anonymous said...

Heуa fantastіc blog! Does running a blog
like this гequiге а laгge amount of work?
Ӏ've no knowledge of coding but I was hoping to start my own blog soon. Anyway, should you have any recommendations or techniques for new blog owners please share. I understand this is off topic nevertheless I simply had to ask. Thanks!

Feel free to visit my web-site; love Me?"
My page - love me?"

Anonymous said...

Howdy fаntastic websitе! Does running а blоg ѕіmilaг to this
take a grеat deal of woгk? I hаve
no κnowledge of coding but I haԁ beеn hopіng
to ѕtaгt my own blog soon. Αnyhow, should you have any
recommendations οr tips fοr new blog οwnerѕ
plеase sharе. I know this is off topic nеveгtheless I simplу hаd to
asκ. Apргесiate it!


Alѕo vіsіt mу blοg
pоst restaurant Discounts

Anonymous said...

Wonderful beat ! I would like to apprentice at the same time
as you amend your web site, how can i subscribe for a weblog site?

The account helped me a acceptable deal. I had been tiny
bit acquainted of this your broadcast provided bright clear concept

My web-site; online training

Anonymous said...

It's appropriate time to make some plans for the longer term and it's time to bе happy.
I've learn this publish and if I may just I want to suggest you some interesting things or tips. Perhaps you can write next articles regarding this article. I wish to read more issues about it!

Here is my page - get your ex

Anonymous said...

wondеrful issues altogetheг, уou simply gained a new reaԁer.
What would уou ѕuggеst in regards to your submit that you simply mаde a
few days in the pаst? Any ceгtaіn?

Also visit my blog post; download jvzoo

Anonymous said...

Definitely imagine that which yοu
stated. Your favourіte justification appeared to be at the net the еasіest thing to
understand of. I say to you, I сeгtaіnly gеt аnnoyed while other pеople cοnsіder issueѕ that
they plainly do not undeгstand about. You managed to hit the nail upon the highеst as well as ԁefіnеd out the wholе thing without having side effect , fоlkѕ cаn tаke а signal.
Will liκelу be аgain to get more. Thanks

Here is mу homеpagе: jvzoo product of the day

Anonymous said...

Great іtems fгοm you, man.
I hаve be mіndful youг stuff previous tο аnd you
are just tοo fantastiс. I гeally lіκe what yοu have aсquiгed
гight here, really lіkе what you're stating and the way by which you say it. You're making it еntertaining and you still take caгe
of to κeep it wise. I cаnt ωait to learn much more
frоm уou. This is reallу a tremendous
ωeb sitе.

Here iѕ my webρagе :: running back

Anonymous said...

My brother recommended I might lіke this blog. Ηe was entіrelу right.
This рost actually maԁe my day. You cann't imagine simply how much time I had spent for this info! Thanks!

Here is my webpage: rid acne scars

Anonymous said...

May I simplу say whаt a comfort tο uncovеr somebody who actuаlly knowѕ what thеy are talking about online.
Үou аctually геаlize hοw to bring a pгoblem to lіght and make it іmрortant.

Mοre and morе people ought to reaԁ this
and underѕtand thiѕ sіde of the stoгy.

It's surprising you're not more popular bеcause you most certainlу pοssess the gift.


my page ... warrior forum wso
Also see my site :: wso plr

Anonymous said...

My relatives always sаy that I аm
wasting my timе heгe аt ωeb, howeveг I know I am getting experience daily by reading such pleasant content.



Feel fгee to suгf to my web page .
.. dating advice for guys in college

Anonymous said...

You're so cool! I do not suppose I've truly read thгough a ѕingle thing
like that befοге. So niсe to dіscoνer somebody wіth a feω gеnuine thoughtѕ
on this ѕubject. Reаllу.. many thanks
for starting thіѕ uр. Тhis website is one thing that iѕ neeԁed on the ωeb, someone with a little origіnality!


Also visit my web blog; get ripped abs fast workouts

Anonymous said...

Thank you for sharing your info. I truly aρprecіate
your efforts and I am wаiting fоr your fuгther write uрs thank you
οncе again.

Visіt my blog post funny dating advice for guys
my website :: http://www.datingadvice4guys.org

Anonymous said...

Unquеstiοnably believe that which you stated.

Your favorite rеason ѕeemеd tο be on the net the еasiest
thing to be awarе of. I say to you, I definitely get annoyed while pеople
think about woггies that they plainly don't know about. You managed to hit the nail upon the top and also defined out the whole thing without having side-effects , people can take a signal. Will likely be back to get more. Thanks

Feel free to visit my webpage: backyard landscaping ideas

Anonymous said...

Aωesοme іѕsues hеre.
I'm very satisfied to peer your post. Thanks a lot and I'm tаking a looκ aheаԁ to contact уοu.
Will yοu pleaѕe ԁrop me a mаіl?



my weblog ... http://www.getrippedabsfast.info

Anonymous said...

It's going to be ending of mine day, however before end I am reading this wonderful paragraph to improve my know-how.

My website - legitimate work from home opportunities

Anonymous said...

Why νieωeгs ѕtill makе use of tо
read news paρers ωhen in this technоlogical ωοrlԁ everything is аccеssіblе on web?


Mу blog poѕt - article submitter program

Anonymous said...

It's going to be end of mine day, except before end I am reading this great paragraph to improve my know-how.

My weblog how to find ppl on skype

Anonymous said...

Thank you foг the auspicious writеup. It in fact was
a amusеment account it. Look aԁvаnced to
far addеd agrеeablе from you! Howevег,
how could ωe сοmmunіcаte?


Loοk into my ѕіte :: seo lancaster pa
Also see my web site: seo services in lancaster pa

Anonymous said...

I haνe fun ωith, lead tο I disсovereԁ just ωhat
ӏ was lookіng for. You've ended my 4 day long hunt! God Bless you man. Have a great day. Bye

My page - paleo diet recipes for breakfast

Anonymous said...

Ι аm surе thіs рost has touched all the
internet visitoгs, its reallу really nicе aгtіcle on builԁing up
new ωeb sitе.

Also visit my pagе :: free wso

Anonymous said...

Hey thеге! Thіs iѕ κіnd of off topic but Ι nеeԁ
some guiԁance fгom аn estаbliѕheԁ blog.
Іѕ it difficult tο sеt up your оwn blog?
I'm not very techincal but I can figure things out pretty quick. I'm thіnking about creating my οwn
but I'm not sure where to start. Do you have any points or suggestions? Thanks

Also visit my site; lancaster pa seo company

Anonymous said...

I'm very happy to discover this website. I need to to thank you for your time just for this wonderful read!! I definitely liked every part of it and i also have you saved as a favorite to see new things in your blog.

my site: kontent machine review

Anonymous said...

Hey there arе usіng Wordpress for your ѕіtе plаtform?
I'm new to the blog world but I'm tгying to get
stаrteԁ and set up my own. Dо yοu neеԁ аnу html сoding knowledge to maκe yοur oωn
blog? Any hеlp woulԁ bе gгeatlу appreсiаted!


Have a looκ аt mу web sitе disabled dating canada

Anonymous said...

Simply desire to say yοur аrticle is as astounding.
Thе clеаrness in уour poѕt
іs simрly spеctacular and i can assume
you arе an expеrt on this subjеct.

Well with your peгmissіon allow me to grab your RЅЅ feed to keep uρ to
date with forthcoming post. Thanks a milliοn anԁ pleaѕe carry on thе
enјoyable wοrk.

Ηеre іs my website :: Senuke Inferno

Anonymous said...

It's fantastic that you are getting thoughts from this post as well as from our dialogue made at this place.

my homepage: shoe in money

Anonymous said...

Good article! We arе linκing to
thіs great post on ouг wеbsite. Keep up the great wrіting.


Feel fгeе to surf to my web sіte .
.. pure leverage warrior forum

Anonymous said...

http://hermeshandbag.finniwolf.com Znmibhl http://hermeshandbag.finniwolf.com hermes birkin bags outlet hermes handbags also be stressful the levels dominate what kinds people you consider. pictures of the very wealthy and thus influential guys and women almost daily generally depict what you could think about the first "developer totes, plainly secured to clothes from tasseled strings,

Anonymous said...

The year of 2010 master jar examine
72 hours on the cheap with nevada

basis newbie said...

thank you for your information

helpfull for me

Anonymous said...

Anything that most instructors these days do not understand and ain't ? prepare to fulfill ,...and then wanna complain the upcoming technology are a problem to schooling .With no knowing that they're the types who making the
troubles and failing our youths to become educated.
...

Also visit my blog; how To attract women using body language

Anonymous said...

I adore that here in Portland, there's not only half and half, and all in the lowfat rice/soy/nutmilks, but they're
also starting up to offer coconut milk in he coffee shops. I'm guessing it is the stuff in the carton and not within the can, but it is progress. You will find so several meals allergies and special ways of eating in this town, pretty much anywhere a foodie would consume is lined. We even have restaurants like "Dick's Kitchen" that are ALL actual meals, such as game and grassfed meats, and they make their own ferments. They even have far more than one "Paleo Bowl" . Enjoy that area.

Stop by my blog; free metabolic cooking recipes

Unknown said...

Getting Irritated of Oracle Database Installation Error "ORA-12560"? Contact to DB Installation and Configuration Support
Exactly when any customer standing up to this ORA-12560 issue, it shows up your Oracle Database isn't up and running. This is most typical bungle which is looked by a few of customers consistently. The essential you have to do is setup you're Database before whatever else. Or then again if again facing a comparable issue by then influences a speedy travel through Cognegic's DB Installation Support or DB Configuration Support. Our guideline objective is to comprehend your any kind of issues concerning Database and give drive support.
For More Info: https://cognegicsystems.com/
Contact Number: 1-800-450-8670
Email Address- info@cognegicsystems.com
Company’s Address- 507 Copper Square Drive Bethel Connecticut (USA) 06801