Howto install Gitora on Windows

#1

Hi!
installing gitora on windows machine Got errors during DB installation tasks
on windows: (DB resides on different machine, RHEL).
there were various errors during the installation:
(gave SYS credentionals as required during installation)

Error :PLS-00201: identifier ‘DBMS_OBFUSCATION_TOOLKIT’ must be declared
Error :PLS-00201: identifier ‘DBMS_SQL’ must be declared

Error :PLS-00905: object GITORA.BDF_MAINFRAME_QRY is invalid
Error :PLS-00905: object GITORA.BDF_APPLICATION_QRY is invalid
Error :PLS-00905: object GITORA.BDF_SUPPORT is invalid

later on
ORA-06508: PL/SQL: could not find program unit being called: "GITORA.EDITOR"
ORA-06512: at “GITORA.BDF_PANELDTLINS_GEN”, line 20

DB version is oracle 11.2.0.3

Please advice what to do to proceed with installation

#2

Hi Alexander,

DBMS_OBFUSCATION_TOOLKIT and DBMS_SQL packages are somehow missing in your database or GITORA doesn’t have necessary privileges.

Could you send us the installation log file?

Regards
Serdar Gokcen

#3

We’ve sent an error report so you should have one. (today while using windows installation and yesterday when installing on RHEL)

as for permissions - no - we do have required objects. more over - we even granted sysdba to getora user during installation process so it should get required permissions during recompilation phase of installation.

when we tried to recompile manually - we received errors that tables are missing, etc.

I can send more detailed logs but please clarify email for it. (currently see no option for that)

#4

Please send the detailed logs to gitora {at} theformspider.com.

Regards
Serdar

#5

Hi guys,

Did you able to solve this? I also got a similar problem, db installation says some of the objects of GITORA is invalid.

18:03:18 INFO - Executing postInstall scripts
18:03:18 INFO - C:\Users\oozkol\AppData\Local\Temp\Formspider7652126755619050838tmp\engine_db\postInstall.sql
18:03:18 INFO - engine install fail debug
18:03:19 INFO - INSTALLATION FAILED
18:03:19 INFO - Exception stack trace:
ORA-04063: package body “GITORA.EDITOR” has errors
ORA-06508: PL/SQL: could not find program unit being called: "GITORA.EDITOR"
ORA-06512: at “GITORA.BDF_PANELDTLINS_GEN”, line 20
ORA-06512: at line 2

oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:445)
oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:879)
oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:450)
oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:192)
oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531)
oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:193)
oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:1026)
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1329)
oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:1909)
oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1871)
oracle.jdbc.driver.OracleStatementWrapper.execute(OracleStatementWrapper.java:318)
com.bui.installer.util.SQLScriptRunner.executeLine(SQLScriptRunner.java:136)
com.bui.installer.util.SQLScriptRunner.execute(SQLScriptRunner.java:71)
com.bui.installer.tasks.EngineInstallTask.handlePostInstallation(EngineInstallTask.java:261)
com.bui.installer.tasks.EngineInstallTask.installEngine(EngineInstallTask.java:162)
com.bui.installer.tasks.EngineInstallTask.execute(EngineInstallTask.java:73)
com.bui.installer.gui.panels.InstallationPanel$3.doInBackground(InstallationPanel.java:194)
org.jdesktop.swingworker.SwingWorker$1.call(SwingWorker.java:276)
java.util.concurrent.FutureTask.run(Unknown Source)
org.jdesktop.swingworker.SwingWorker.run(SwingWorker.java:315)
java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
java.lang.Thread.run(Unknown Source)

18:03:19 INFO - Rolling back changes
18:03:28 INFO - Roll back finished

#6

No at this moment. Gitora team says they’ll come back with resolution in the end of the week.
I believe it is related to db security and public synonyms which are missing due security configuration of latest db release.