oraperl SQL*Net V2 connect string
Date: Wed, 24 Aug 94 16:17:44 EST
Message-ID: <9408242015.AA09590_at_slsand.srs.gov.srs.gov>
I am having problems using the SQL*Net V2 connect string in my oraperl
programs. The SQL*Net V1 string works just fine.
I am going between two SUN Sparcstations running SUN OS 4.1.3. I have
verified that the SQL*Net V2 is set up correctly since I created a
database link using the V2 connect descriptor and within SQL Plus I am
able to communicate between the two databases. However, using oraperl
I am unsuccessful.
For SQL*Net V1 I have:
For SQL*Net V2 I have:
$lda = &ora_login("T:slsand:SID7","oracle_user_name","oracle_password");
This works fine
$lda = &ora_login("SLSAND","oracle_user_name","oracle_password");
This does not work fine
In /etc/tnsnames.ora SLSAND is defined. I have used SLSAND to create a database link in SQL.
For example:
In SQL I did the following:
create database link test_v2 connect to bla identified by bla using SLSAND;
Then I could reference any table using SLSAND:
describe emp_at_SLSAND;
This works fine.
So my question is: What seems to be wrong with my syntax for oraperl? Or maybe it's not a syntax problem.
Or will oraperl not support SQL*Net V2 connections? :-(
When running my oraperl program the error that I get is ORA-01034 (ORACLE not available).
I do not get any errors when using SQL Plus.
Thank you in advance,
Debi Henkel
Deborah Henkel
Westinghouse Savannah River Laboratory
Building 773-42A
Aiken, SC 29808
phone: (803) 725-8199
email: deborah.henkel_at_srs.gov
--------------------------------------
Received on Wed Aug 24 1994 - 23:17:44 CEST