Re: 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 <machine: otrsdb, pid: 7301>
         (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 <[email protected]> wrote:
> Hi Amey,
>
>> On Nov 22, 2017, at 7:51 AM, Amey Abhyankar <[email protected]> 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
---------------------------------------------------------------------
OTRS mailing list: otrs - Webpage: http://otrs.org/
Archive: http://lists.otrs.org/pipermail/otrs
To unsubscribe: http://lists.otrs.org/mailman/listinfo/otrs