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.
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.
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.
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?
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
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