Guidance Required for using ORacle 11G DB instead of MYSql

[sriv789]

Before i begin, I would like to tell you guys that you have done an amazing job with the test link tool. it is extremely customizable and easy to install. Therefore thanks a bunch for that. Now moving onto the question.

In my organization, Oracle DB is mandatory for all the tools which are used within the organization. hence I'm trying to get testlink to work with it. I know Oracle Sql is not supported officially, I've gone through defects like 3422 and 2724. They did give me a vague idea on how to go on about it. But still i have not been that successful in integrating testlink with sql.

I have installed testlink in IIS on windows 8.1. PHP version is 5.5 and Oracle DB11g is the DB server.

It would be great if you guys could tell me how to make testlink recognize Oracle DB. I have enabled the OCi8 extension in PHP file i have added the PHP installation path to the system Path variables, uncommented all the lines pertaining to OCI8 in the php.ini file. still i get the following error

"Warning!: Your PHP installation don't have the oci8 extension oci8- without it is IMPOSSIBLE to use Testlink.Failed!"

Please tell me or show me the path i need to take in order to make a connection between testlink installation and the Oracle DB server.

[sriv789]

BUMP!!!! anyone? @fman would really appreciate your input dude

[fman]

IMHO your are expecting too much in short time and is wrong approach. do you posted on 18/3/2016 and expect a solution after 3 days when 19 & 20 were week end!
do your company want to use Oracle? Yes, then is your company that have to spend resources to reach the target.

[sriv789]

IMHO your are expecting too much in short time and is wrong approach. do you posted on 18/3/2016 and expect a solution after 3 days when 19 & 20 were week end!
do your company want to use Oracle? Yes, then is your company that have to spend resources to reach the target.

Apologies if i had bumped the thread too early. My intention was to get some sort of response thats why i bumped the thread . Fman if you dont mind can you please specify the correct way/approach to take if my approch is wrong. it would be great if you could do that .

[sriv789]

bump!!! for guidance from fman

[sriv789]

Hey @fman, An update.

I've manged to make the test link installation to detect the oracle server, I've also converted all the existing mysql Create and insert queries to Oracle SQL. Right now I'm stuck in the Create DB step. When tetlink installation tries to create the DB the following error message is displayed please see the screenshot. Can you please advise on how to proceed with this?

TestLink setup will now attempt to setup the database:

Creating connection to Database Server:OK!


Database TBS_PERM_01 does not exist.
Will attempt to create:
Creating database `TBS_PERM_01`:

==============================================================================

DB Access Error - debug_print_backtrace() OUTPUT START

ATTENTION: Enabling more debug info will produce path disclosure weakness (CWE-200)

Having this additional Information could be useful for reporting

issue to development TEAM.

==============================================================================

==============================================================================

Failed! - Could not create database: ! ORA-00911: invalid character

TestLink setup could not create the database, and no existing database with the same name was found.
Please create a database by different way (e.g. from command line), or with different DB root account. Run setup again then.

[sriv789]

http://imgur.com/LkBuUrI sorry the image tag did not work

[sriv789]

Bump!!!, please help

[fman]

1) please stop doing posts that are only noise like => Bump!!! etc, is IMHO very NOT professional approach

2) You can not expect specific help on this for me, because I this is not my priority and I've limited time, and do not have time to spend (and no hw) to install an oracle express or something like that.

3) Have you serached in google for the ORACLE ERROR?, what have you found ?, what about creating the DB just using the scripts using an sql client and not the installer?

please do not do post directed to me without my specific request.

[sriv789]

1) please stop doing posts that are only noise like => Bump!!! etc, is IMHO very NOT professional approach

2) You can not expect specific help on this for me, because I this is not my priority and I've limited time, and do not have time to spend (and no hw) to install an oracle express or something like that.

3) Have you serached in google for the ORACLE ERROR?, what have you found ?, what about creating the DB just using the scripts using an sql client and not the installer?

please do not do post directed to me without my specific request.

Apologies fman, It's called a bumping a thread and i did that to get attention. Thanks for your reply, Ill definitely try this out and get back to you ASAP.