Friday 6 December 2013

Truncated Error while starting the WebLogic server - Database error -ORA-01033: ORACLE initialization or shutdown in progress

Hi Folks .

Recently I had a problem while starting the webLogic server .Its repeating truncated error and I tried to connect the DB and it is showing the below error.

Environment is my Windows local box - Server 11.1.1.1.7 SOA


From Log:- 
Errors in file C:\ORACLEXE\APP\ORACLE\diag\rdbms\xe\xe\trace\xe_ora_8020.trc  (incident=60191):
ORA-00600: internal error code, arguments: [kcrfr_resize2], [4093640192], [67100672], [], [], [], [], [], [], [], [], []
Incident details in: C:\ORACLEXE\APP\ORACLE\diag\rdbms\xe\xe\incident\incdir_60191\xe_ora_8020_i60191.trc
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details. 
ora-00600 internal error code


While connecting DB below exception:- 

ORA-01033: ORACLE initialization or shutdown in progress.


I had struggled and found the issue with the WL_LLR_ADMINSERVER table in SOAINFRA schema.
When you start the server without nohup you should shutdown the server before closing the server screen(CMD screen) ,If you directly close the CMD window without shutting down the server .it will create some dead threads in the mentioned table in SOAINFRA schema.

Description of  WL_LLR_ADMINSERVER is as follows the below screen.


So Run the script in DB or execute these lines in DB then problem will be solved.

SQL> select * from SOAINFRA_WL_LLR_ADMINSERVER;

XIDSTR
----------------------------------------
POOLNAMESTR
----------------------------------------------------------------
RECORDSTR
------------------------------------------------------------------

JDBC LLR Domain//Server
JDBC LLR Domain//Server
osb_domain//AdminServer

JDBC LLR Version
JDBC LLR Version
1.0

XIDSTR
----------------------------------------
POOLNAMESTR
----------------------------------------------------------------
RECORDSTR
------------------------------------------------------------------

SQL> delete from WL_LLR_ADMINSERVER;
2 rows deleted.

SQL> select * from WL_LLR_ADMINSERVER;
no rows selected

SQL> commit;
Commit complete.

Now start you server .It will be working fine this time.

Remember don't close the server start up screen without shutdown.


Happy Learning......!!!!!!!!!!!!!!!     Fun sharing......!!!!!!!!!!!!!!!!

No comments:

Post a Comment