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:
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:
Does anyone know what could be wrong? I’ve checked all permissions,
I’ve dropped and re-added the DB in case I screwed up the NLS stuff;
everything seems to be set up OK.
========== ==========
== The statements and opinions expressed here are my own and do not ==
== necessarily represent those of Oracle Corporation. ==
========== ==========
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:
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:
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.
Hope this helps you going, if not I might be able to help, just let me
know.
Thanks for the help, Joop.
I tried that, but it didn’t work. Then I dumped my %ENV just before for
the call to DBI->connect() and realized I had a typo in ORACLE_HOME.
Just like the error message told me…
========== ==========
== The statements and opinions expressed here are my own and do not ==
== necessarily represent those of Oracle Corporation. ==
========== ==========