Re: [otrs] How to configure OTRS 5s Patch Level 23 & Oracle 12c DB on different systems?

Hello Rene & Roy, Thanks for the updates. I am getting error when trying to test remote Oracle DB connectivity from otrs server using 'sqlplus' command. I am done with compiling Oracle drivers. I want to use those Oracle DB scripts to create tables. I am able to connect to respective Oracle DB from Windows machine using sqlplus developer software. Output of lsnrctl on Oracle 12c system as follows = ------------------------------------------------------------- [oracle@otrsdb ~]$ lsnrctl services LSNRCTL for Linux: Version 12.1.0.2.0 - Production on 30-NOV-2017 18:03:57 Copyright (c) 1991, 2014, Oracle. All rights reserved. Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=otrsdb)(PORT=1521))) Services Summary... Service "otrsdb.abc.com" has 1 instance(s). Instance "otrsdb", status READY, has 1 handler(s) for this service... Handler(s): "DEDICATED" established:13 refused:0 state:ready LOCAL SERVER Service "otrsdbXDB.abc.com" has 1 instance(s). Instance "otrsdb", status READY, has 1 handler(s) for this service... Handler(s): "D000" established:7 refused:0 current:0 max:1022 state:ready DISPATCHER (ADDRESS=(PROTOCOL=tcp)(HOST=otrsdb.abc.com)(PORT=22820)) Service "pdbotrsdb.abc.com" has 1 instance(s). Instance "otrsdb", status READY, has 1 handler(s) for this service... Handler(s): "DEDICATED" established:13 refused:0 state:ready LOCAL SERVER The command completed successfully -------------------------------------------------------------------- I am getting multiple errors. [ Example: ORA-12154: TNS:could not resolve the connect identifier specified] can some1 tell me exact command? Thanks & Regards, Amey. On 22 November 2017 at 20:14, Roy Kaldung wrote:

Hi Amey,

...

On Nov 22, 2017, at 7:51 AM, Amey Abhyankar wrote:

Is it fine if I proceed with OTRS 5.0.24 installation now [using RPM package] or I need to roll back & do the OTRS installation 1st & then compile Oracle drivers?

For a fresh installation I recommend the following steps:

- Install and configure the operating system that you have a access with the sqlplus client to the database for otrs - Install DBD::Oracle (usually via cpan, I never saw an RPM for this, let me know if you find one) - Install the OTRS RPM (5.0.24)

AFAIK, the OTRS installer only works with MySQL and you have to install and configure some parts on your own:

- Populate the database via sqplus with the following files: - scripts/database/otrs-schema.oracle.sql - scripts/database/otrs-initial_insert.oracle.sql - scripts/database/otrs-schema-post.oracle.sql - Configure Kernel/Config.pm to use DBD::Oracle - Check database access with the command bin/otrs.Console.pl Maint::Database::Check - Choose another SystemID than 10 ;-)

Now you should be ready to go.

- Roy

--------------------------------------------------------------------- OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/mailman/listinfo/otrs