Joe Casadonte wrote:
> Having been scared off of using SQLite even for a small system, I've now
> bought some more memory and put Oracle on my home machine. I can't get
> the damn schema set up, instead getting the following error:
>
> # perl sbin/rt-setup-database --dba=reqtrack --dba-password=foobar
> --action init
>
> DBI connect('reqtrack','reqtrack',...) failed: ERROR OCIEnvNlsCreate.
> Check ORACLE_HOME env var, NLS settings, permissions, etc. at
> sbin/rt-setup-database line 105
>
> Failed to connect to dbi:Oracle:reqtrack as reqtrack: ERROR
> OCIEnvNlsCreate. Check ORACLE_HOME env var, NLS settings, permissions,
> etc. at sbin/rt-setup-database line 105.
>
>
> I know that DBI is OK, because I run the following with no problem:
>
> # perl -MDBI -le 'DBI->connect("DBI:Oracle:", "reqtrack", "foobar");'
> #
>
OK, this is a long time ago that I did an Oracle setup from scratch but
something about the error is tickling my memory.
The I do it normally is to make my rt_user a DBA (temporarily) so that I
don't need the --dba argument. Think the problem is in that part.
I seem to remember that rt-setup-database reconnect and that is causing
problems. Could be way of now but my method seems to work all the time.
You're in trouble if you can't grant DBA rights to you rt_user.
Hope this helps you going, if not I might be able to help, just let me know.
Joop
_______________________________________________
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]
Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
Buy a copy at http://rtbook.bestpractical.com
