RE: Help req immediate ....error in production

  • From: "Fernandes, Aldrin" <afernand@xxxxxxxx>
  • To: <ora-apps-dba@xxxxxxxxxxxxx>
  • Date: Tue, 24 Mar 2009 16:51:34 -0600

Check the disk space for the database/archivelogs, with the database
redologs unable to switch. 

Aldrin Fernandes

-----Original Message-----
From: ora-apps-dba-bounce@xxxxxxxxxxxxx
[mailto:ora-apps-dba-bounce@xxxxxxxxxxxxx] On Behalf Of James Morrow
Sent: Tuesday, March 24, 2009 5:48 PM
To: ora-apps-dba@xxxxxxxxxxxxx
Subject: RE: Help req immediate ....error in production

Validate that you can login as APPS using sqlplus.  Odds are that either
the APPS account is locked due to failed logins or maybe the archiver
may be stuck...  So that is where I would start...

-- James

-----Original Message-----
From: "dba.young young" <dba.young@xxxxxxxxx>
To: ora-apps-dba@xxxxxxxxxxxxx
Sent: 3/24/09 4:00 PM
Subject: Help req immediate ....error in production

Hi Gurus,
                  kindly help here.....

*All of a sudden all service components in production have stopped with
error including the workflow mailer.*

FNDSM log file has the following error in the log file ;


Cause:  reg_db_info failed due to ORA-01012: not logged on.
The SQL statement being executed at the time of the error was: begin
FND_CP_FNDSM.register_fndsm_db(:o, :c, :i); end;  and was executed from
the file &ERRFIL E.
24-MAR-2009 16:52:24 - ORACLE error 1012 in init_cartridge
Cause:  init_cartridge failed due to ORA-01012: not logged on.
The SQL statement being executed at the time of the error was: begin
FND_CP_GSM_IPC.Init_Cartridge; end;  and was executed from the file
&ERRFILE.
The call to function StartProcess in cartridge AQCART has failed.
24-MAR-2009 16:52:24 - ORACLE error 1012 in reg_db_info

Kindly give your solutions ASAP as this is production & is critical.

Thanks for your help in advance.

Regards,
Young.





This email contains confidential information that is proprietary to EPCOR and 
its subsidiary companies in all respects.  This information is intended only 
for the person(s) named in the destination address.  Unauthorized distribution, 
copying or disclosure is strictly prohibited.  If you receive this e-mail in 
error please delete it immediately.

Other related posts: