On Wed, 3 Jul 2002 12:00:18 +0100 Ricardo Oliveira <[EMAIL PROTECTED]> wrote:
> Hi, > I'm new with DBI and mod-perl, i'm trying to connect to a database in a > remote computer using DBI:Oracle. When I try a connection locally, the > process runs fine, when I try a connection from a remote computer I got > the following error: > > Couldn't connect to database: Error while trying to retrieve text for > error ORA-12705 (DBD ERROR: OCISessionBegin) > > Can anyone tell me what is happening? What configuration do I have to > set on my machine to connect to the database? The "Error while trying to retrieve text" normally means you don't have ORACLE_HOME set to the Oracle Home directory for a version of Oracle matching the one DBD::Oracle was compiled against. ORA-12xxx errors usually involve network or instance name resolution problems. This one probably is a result of ORACLE_HOME not being set so the SQL*Net libraries can find a tnsnames.ora to resolve the service name with. Since you mention mod-perl, I suspect you are trying to make your remote connection via a webserver. You should first try your script (or the DBI subset of it) from a command prompt in the same server. Once you have that working, make sure the necessary environment variables are also set in the webserver's process. -- Mac :}) ** I normally forward private questions to the appropriate mail list. ** Ask Smarter: http://www.tuxedo.org/~esr/faqs/smart-questions.html Give a hobbit a fish and he eats fish for a day. Give a hobbit a ring and he eats fish for an age.
