[rt-users] problem with rt-3.2.1 & oracle.

[Dean]

Hiya

Just having a prob creating the schema on a non-local oracle database.
I have had this working before with a local database, so it's probably
something obvious that I'm missing.. - but since moving the db onto
another box it's a no go. It lookslike it's not seeing the
--with-db-host, but the correct host is appearing in RT_Config.

./configure --prefix=/export/rt/rt-3.2.1 --with-db-type=Oracle
--with-db-host=rtdbhost  --with-db-dba=RTUSER  --with-db-database=RTDB
--with-db-rt-user=RTUSER  --with-db-rt-pass=rtpass
--with-web-user=httpd --with-web-group=httpd

[configure and make install run without error]

 make initialize-database
/usr/bin/perl //export/rt/rt-3.2.1/sbin/rt-setup-database --action
init --dba rtuser --prompt-for-dba-password
In order to create a new database and grant RT access to that database,
this script needs to connect to your Oracle instance on rtdbhost as RTUSER.
Please specify that user's database password below. If the user has no database
password, just press return.

Password: DBI connect('RTDB','RTUSER',...) failed: ORA-12541: TNS:no
listener (DBD ERROR: OCIServerAttach) at
//export/rt/rt-3.2.1/sbin/rt-setup-database line 80
Failed to connect to dbi:Oracle:RTDB as RTUSER: ORA-12541: TNS:no
listener (DBD ERROR: OCIServerAttach) at
//export/rt/rt-3.2.1/sbin/rt-setup-database line 80, <STDIN> line 1.
*** Error code 255
make: Fatal error: Command failed for target `initialize-database'

Any help is greatly appreciated.

--
 D