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
