Guidance Required for using ORacle 11G DB instead of MYSql

Ask community to help.

Moderators: Amaradana, TurboPT, TL Developers

Guidance Required for using ORacle 11G DB instead of MYSql

Postby sriv789 » Fri Mar 18, 2016 11:28 am

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 :D 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
TestLink user
 
Posts: 8
Joined: Thu Mar 17, 2016 7:15 pm

Re: Guidance Required for using ORacle 11G DB instead of MYS

Postby sriv789 » Mon Mar 21, 2016 4:43 am

BUMP!!!! anyone? @fman would really appreciate your input dude
sriv789
TestLink user
 
Posts: 8
Joined: Thu Mar 17, 2016 7:15 pm

Re: Guidance Required for using ORacle 11G DB instead of MYS

Postby fman » Mon Mar 21, 2016 9:02 am

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.
fman
Member of TestLink Community
 
Posts: 3012
Joined: Tue Nov 15, 2005 7:19 am

Re: Guidance Required for using ORacle 11G DB instead of MYS

Postby sriv789 » Mon Mar 21, 2016 12:38 pm

fman wrote: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
TestLink user
 
Posts: 8
Joined: Thu Mar 17, 2016 7:15 pm

Re: Guidance Required for using ORacle 11G DB instead of MYS

Postby sriv789 » Thu Mar 24, 2016 12:01 pm

bump!!! for guidance from fman
sriv789
TestLink user
 
Posts: 8
Joined: Thu Mar 17, 2016 7:15 pm

Re: Guidance Required for using ORacle 11G DB instead of MYS

Postby sriv789 » Fri Apr 01, 2016 6:35 am

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.


Image
sriv789
TestLink user
 
Posts: 8
Joined: Thu Mar 17, 2016 7:15 pm

Re: Guidance Required for using ORacle 11G DB instead of MYS

Postby sriv789 » Fri Apr 01, 2016 6:51 am

http://imgur.com/LkBuUrI sorry the image tag did not work
sriv789
TestLink user
 
Posts: 8
Joined: Thu Mar 17, 2016 7:15 pm

Re: Guidance Required for using ORacle 11G DB instead of MYS

Postby sriv789 » Tue Apr 05, 2016 1:44 pm

Bump!!!, please help
sriv789
TestLink user
 
Posts: 8
Joined: Thu Mar 17, 2016 7:15 pm

Re: Guidance Required for using ORacle 11G DB instead of MYS

Postby fman » Wed Apr 06, 2016 5:37 am

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.
fman
Member of TestLink Community
 
Posts: 3012
Joined: Tue Nov 15, 2005 7:19 am

Re: Guidance Required for using ORacle 11G DB instead of MYS

Postby sriv789 » Tue Apr 12, 2016 12:28 pm

fman wrote: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.
sriv789
TestLink user
 
Posts: 8
Joined: Thu Mar 17, 2016 7:15 pm


Return to Installation and configuration



Who is online

Users browsing this forum: No registered users and 3 guests