Service Desk Practitioners Forum
cancel
Showing results for 
Search instead for 
Did you mean: 

SD4.5 SP24 AppStartup Problem

Highlighted
Ulto
Member

SD4.5 SP24 AppStartup Problem

Hi Guys,

I need your help please.
I have windows 2003 server, with oracle 9i. I have installed SD4.5 & installed the patch for windows 2003, then I installed the patch 24 & I updated everything (database,client,application server, servicepages..)
I also created an account and established a connection. But when I try to Start Client the SD freezes.
Please find attached the log files, maybe there's something missing.

Please advise.

Regards,

Elias
6 REPLIES
Gurevich
Member

Re: SD4.5 SP24 AppStartup Problem

Thu, 26/02/2009 00:50:11 Connection to service desk repository was not added to the pool because of ORA-01033: ORACLE initialization or shutdown in progress

Thu, 26/02/2009 00:50:11 Failed to open connection to service desk repository.
ORA-01033: ORACLE initialization or shutdown in progress

Thu, 26/02/2009 00:50:11 End session.
Thu, 26/02/2009 00:50:11 Unable to start serverjava.lang.ExceptionInInitializerError: The repository is not loaded
at com.hp.ifc.bus.AppSrvDispatch.invoke(Unknown Source)
at com.hp.ifc.rep.AppRepository.refresh(Unknown Source)
at com.hp.ifc.rep.AppGeneralSettings.initialize(Unknown Source)
at com.hp.ifc.rep.AppGeneralSettings.initialize(Unknown Source)
at com.hp.ifc.rep.AppGeneralSettings.(Unknown Source)
at com.hp.ifc.rep.AppGeneralSettings.(Unknown Source)
at com.hp.ifc.bus.AppServer.startup(Unknown Source)
at com.hp.ifc.bus.AppServer.main(Unknown Source)
at java.lang.reflect.Method.invoke(Native Method)
at com.hp.startup.Bootstrap.runprogram(Unknown Source)
at com.hp.startup.Bootstrap.main(Unknown Source)




Is everything ok with Repository user account? You can check it in app server setings - Database - connection.
Ulto
Member

Re: SD4.5 SP24 AppStartup Problem

hi Gurevich,

Thank you for your reply.

But can you be more specific? what should I do exactly?

Thanks in advance
Gurevich
Member

Re: SD4.5 SP24 AppStartup Problem

1. Run Start Menu\Programs\hp OpenView service desk 4.5\application server\open the server settings editor.lnk
2. Go to Database accounts tab
3. Click Modify
4. Go to Connection tab
5. Click both "test connection" buttons
6. If there will be errors - check accounts.

If everything is OK - problem is somewhere else.
Ulto
Member

Re: SD4.5 SP24 AppStartup Problem

hey,

Thank you for ur help.

The connection was successful.
But i'm still facing the same problem :S...

What should i do?

Gurevich
Member

Re: SD4.5 SP24 AppStartup Problem

1) was it worcking before installing SP24 or this is first-run?
2) try to google "ORA-01033: ORACLE initialization or shutdown in progress"
3) Is app server service running?
4) Try to connect client from another PC?

no more ideas :(
Alexander Kriku
Frequent Visitor

Re: SD4.5 SP24 AppStartup Problem

hi

pay attention to the following lines in logdatabase.txt:
Tue, 24/02/2009 01:58:39 Exception in creating Oracle Database !
Tue, 24/02/2009 01:58:39 ORA-12913: Cannot create dictionary managed tablespace
Tue, 24/02/2009 01:59:43 ORA-00942: table or view does not exist
java.sql.SQLException: ORA-00942: table or view does not exist
Tue, 24/02/2009 02:27:13 ORA-30022: Cannot create segments in undo tablespace
java.sql.SQLException: ORA-30022: Cannot create segments in undo tablespace

etc

looks like that there are some problems with your database: try to search about ORA-12913, ORA-30022

and also logserver.txt shows that you use jre 1.3. try to install jre 1.4

//Add this to "OnDomLoad" event