Hello Carsten,

I did not have time to actually test if it actually works as designed, but the installer does check for DB existence, prior to attempting its creation [1].

Could you provide more information as to exactly how you entered the setup param (hostname, db name), how your user accounts are setup, and more detailed info on the ORA-01031 you got, specifically on which line it occured. Then I can try to reproduce the problem.

[1] https://github.com/dregad/mantisbt/blob/oracle/admin/install.php#L556-L620

Hello Damien,

We use: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

Steps to reproduce:
1) Create a new schema:
==== start schema creation ====
create bigfile tablespace MANTIS_DATA;
create bigfile tablespace MANTIS_INDX;

create user MANTIS_ADMIN identified by xxx
default tablespace MANTIS_DATA;

grant connect, resource to MANTIS_ADMIN;
revoke unlimited tablespace from MANTIS_ADMIN;

alter user MANTIS_ADMIN quota unlimited on MANTIS_DATA;
alter user MANTIS_ADMIN quota unlimited on MANTIS_INDX;

create user MANTIS_APP identified by xxx;
grant create session to mantis_app;
==== end schema creation ====

2) add the TNS description to your tnsnames.ora
==== start TNS description ====
cg.mydbsrv =
(DESCRIPTION =
(ADDRESS =
(PROTOCOL = TCP)(HOST = mydbsrv-vip)(PORT = 1521)
)
(CONNECT_DATA =
(SERVICE_NAME = cg.mydbsrv.mydomain.com)
)
)
==== end TNS description ====

3) start the web service and open http://mymantis/admin/install.php

4) Fill the form:
Type of Database -> Oracle
Hostname (for Database Server) -> cg.mydbsrv (TNS description)
Username (for Database) -> MANTIS_APP
Password (for Database) -> <PW MANTIS_AP>
Database name (for Database) -> MANTIS_ADMIN
Admin Username (to create Database if required) -> MANTIS_ADMIN
Admin Password (to create Database if required) -> <PW MANTIS_ADMIN>
Print SQL Queries instead of Writing to the Database -> no selected

5) Press "Install/Upgrade database"
Output:
Create database if it does not exist: BAD - Does administrative user have access to create the database? ( ORA-01031: insufficient privileges )

Attempting to connect to database as user: POSSIBLE PROBLEM - Database user doesn't have access to the database ( ORA-12545: Connect failed because target host or object does not exist )

Regards,
Carsten

Hello Damien,

I've discussed this topic with our DBA shortly. In our setup the admin user don't have the permissions to create users nor grant permissions. Thereby the automatic setup is failing in such case. Normally you'll get ORA-01920 if the user wants to create an existing user twice. Now I got ORA-01031 due lack of permissions.

From my perspective are there three different approaches to "solve" this bug:
1) Skip creating users and granting permissions if admin user == database name
2) Ignore ORA-01031 and ORA-01920 and try to create the database objects
3) Print a warning message and extend the documentation to create the database objects outside the install script.

Regards,
Carsten