HI
Could u pls help on this issue.
Presently we are using the following versions
Perl version -------- perl, v5.6.1 built for sun4-solaris
DBD::ORACLE --------- 1.15
DBI version ---------- 1.28
ORACLE -------- oracle 10.2.0.2
THE BELOW CODE WAS WORKING FINE WITH ORACLE 9.2.0.8
use DBI;
print "hi";
print "\n";
print "\n befor connecting to test server \n";
# oracle 9i testing for foxtrot
$dbh = DBI->connect("dbi:Oracle:servername",'username','password',
{RaiseError => 1, AutoCommit => 1}) or
die "Can't connect to database $DBI::errstr\n";
# Put together your query string
my $sql = 'select * from db_intf where intf_id=22816 ';
# Instead you could do $dbh->do($sql) or execute
$sth = $dbh->prepare($sql);
$sth->execute();
print "\n connected";
print"\n";
while (@rows = $sth->fetchrow_array()) {
# You can access a specific field like this: $rows[0];
print "@rows\t";
}
print "\n";$sth->finish();
$dbh->disconnect();
print "\n DISconnected";
print"\n";
We have migrated the oracle from 9.2.0.8 to 10g (10.2.0.2)
And I used the same code as above, I got the below error
install_driver(Oracle) failed: Can't load
'/usr/local/lib/perl5/site_perl/5.6.1/sun4-solaris/auto/DBD/Oracle/Oracl
e.so' for module DBD::Oracle: ld.so.1:
perl: fatal:
/usr/local/opt/oracle/product/ldcnmd/lib32/libclntsh.so.9.0: Permission
denied at /usr/local/lib/perl5/5.6.1/sun4-solaris/DynaLoader.pm line
206.
at (eval 1) line 3
Compilation failed in require at (eval 1) line 3.
Perhaps a required shared library or dll isn't installed where expected
at a.pl line 25
could u plz let me know, what I have to do for this error.
Should I change the DBI and DBD versions for compatibility with oracle
10g.
if, so what driver versions are compatible with oracle 10g + perl 5.6.1
And also how to complile the DBD:Oracle driver
Early response is highly appreciated.
Thanks in Advance
Thanks & Regards
Ravi
________________________________
From: Sachin Deshmukh
Sent: Tuesday, January 23, 2007 7:07 PM
To: RaviChandra Chelikam
Cc: G Ramana
Subject: G RamanaRE: Regarding Oracle 10g Upgrade
Awaiting for your findings...
________________________________
From: G Ramana
Sent: Tuesday, January 23, 2007 6:47 PM
To: Sachin Deshmukh
Cc: RaviChandra Chelikam
Subject: RE: Regarding Oracle 10g Upgrade
Sachin,
Following activities are done since last 2 days.
1. Oracle10g Express edition installed successfully on my machine.
2. Exported CNM data from ldncnm7 schema on dev server to local machines
3. Imported CNM data in oracle successfully but all temporary tables are
getting invalid because oracle installer don't have licensee (Partitions
not supported)
4. Created all table spaces for LD database
5. Created all users using by CNM like ldncnm7_app_be,.....etc
Need more time to execute all database objects are getting to valid
state
Need to work on following activities
1. Need to again install oracle10g licensee version
2. Need to Work on compilation of database objects
3. Need to connect and test application with oracle10g
after complete above activities I can give the correct analysis to you.
Thanks & Regards,
Ramana GYV
________________________________
From: Sachin Deshmukh
Sent: Friday, January 19, 2007 12:10 PM
To: G Ramana; RaviChandra Chelikam
Subject: Regarding Oracle 10g Upgrade
Ramana/Ravi:
Let me know the exact impact of Oracle 10g upgrade on CNM Application.
Following are some of the things which needs to be considered :
- Do we need to modify the DB Scripts
- Do we need to upgrade the Oracle driver which is used by perl
scripts
if yes, then what all changes are required in the existing
perl scripts
- Do we need to upgrade our JDBC driver (UI Module) for Oracle 10g
database
if yes then what all changes are required in the UI module
- Do we need some configuration for the Oracle Queues
- Is there any feature of Oracle 9i which CNM App is using but not
supported by Oracle 10g
These are some of the basic areas to be considered but you need to
consider all the area which has dependency on database.
Ravi, you have to take care of BE & UI modules & Ramana needs to
investigate into DB scripts, Queues and anything specific to DB
features, configuration, compatibility.
You need to go through the documentation provided for Oracle 10g DB.
Let me know your finding by 24th Jan EOD.
Regards,
Sachin Deshmukh
============================================================================================================================
Tech Mahindra, formerly Mahindra-British Telecom.
Disclaimer:
This message and the information contained herein is proprietary and
confidential and subject to the Tech Mahindra policy statement, you may review
at <a
href="http://www.techmahindra.com/Disclaimer.html";>http://www.techmahindra.com/Disclaimer.html</a>
externally and <a
href="http://tim.techmahindra.com/Disclaimer.html";>http://tim.techmahindra.com/Disclaimer.html</a>
internally within Tech Mahindra.
============================================================================================================================
