Sponsored Content
Top Forums Shell Programming and Scripting error connecting database from perl Post 302136346 by SanjayLinux on Monday 17th of September 2007 07:53:06 AM
Old 09-17-2007
Hammer & Screwdriver

Dileep,
It seems to me some problem with Perl module that properly not installed or might be the lib path (xxxx.so) files in different location.

So why I asked for
#echo $ORACLE_HOME/lib >> /etc/ld.so.conf

Here it will put all the .so files with in /etc/ld.so.conf files.

# ldconfig

After executing the above command it will get affect mean to say it will read all these .so files location.

One suggestion you can verify whether that files (.pm) is existing or not
"/usr/lib/perl5/5.8.0/i586-linux-thread-multi/DynaLoader.pm "

## find / -name DynaLoader.pm

Then compare the location .. If it is not there that mean Your driver DBD perl module didn't compile properly.

~~~Sanjay~~~
 

10 More Discussions You Might Find Interesting

1. UNIX for Advanced & Expert Users

Connecting to a database via UNIX

hello - Is it possible to connect to a database at the command line to an Oracle instance whilst logged in on the unix box i.e. not using a script Cheers (Running Solaris) Also if anyone has any info on how a Citirix ICA client might be helpful here that would be appreciated Cheers (1 Reply)
Discussion started by: penfold
1 Replies

2. UNIX for Dummies Questions & Answers

connecting to a database through a script...if not give an error msg

Hello , i have a problem in writing the shell script.. i have a script already written n just need to make a change in which when the script is not able to connect to the database ..it should print an error msg on the screen. I have already seen previous posts on how to connect to the... (3 Replies)
Discussion started by: sommer_queen
3 Replies

3. Shell Programming and Scripting

Connecting to Oracle Database

if; sql="select username from dba_users where username = '$FromUser';" check_FromUser=`ExecSql "$sql"` I want to connect to Oracle database & check the users in the database, store the value in check_FromUser. First how to connect to Oracle database from the shell script ? Appreciate your... (4 Replies)
Discussion started by: dreams5617
4 Replies

4. Windows & DOS: Issues & Discussions

Client is not connecting to the Database

Hi, Am running my client in Windows and the database (IBM DB2) is in AIX machine. if I open my client its not connecting to the database at first time and failing in a particular SQL Query. But if I close the client and open again then its connecting and the query is also working fine. Don't... (0 Replies)
Discussion started by: mvictorvijayan
0 Replies

5. Shell Programming and Scripting

Connecting to Database

Hi, I want to write a shell script which connects to a Database, executes a set of SQLs and displays a message for every SQL that was run whether any records have been returned or not? Can anyone help me in this regard? Appreciate your help and concern. Thanks, Dave (1 Reply)
Discussion started by: yoursdavinder
1 Replies

6. Shell Programming and Scripting

connecting to different database in sqr

Hi, My requirement is to generate a single text output which fetches data from two different databases. I have two different sqrs to generate text file1(data from db1) and file2(data from db2). can I execute both the sqrs from a single shell script? If yes, pls let me know how to connect to db2... (1 Reply)
Discussion started by: vimalr
1 Replies

7. Shell Programming and Scripting

Connecting to oracle database

Hai i want to connect to oracle database from user input and create a view. ${ECHO} "Debut Creating View" ${ECHO} "Please Enter the User Name:" read user_name ${ECHO} "Please Enter the Connection String:" read con_string ${ECHO} "Please Enter the Password:" read pwd... (3 Replies)
Discussion started by: shenthil76
3 Replies

8. Shell Programming and Scripting

Connecting database

Hi all, In my concern they gave a task to me do cran job like To write a shell script for To connect a database it should execute a query it should save the output of the query after getting the output it should send a mail to you inbox for every one hour I can able to... (8 Replies)
Discussion started by: thelakbe
8 Replies

9. Shell Programming and Scripting

script for connecting database in loops

Hi experts. I have different database and schema and their passwords in one file. In Unix : I want to create the script that connect the sqlplus and execute the select query one by one schema with different database. Ex: password File Format databse schemaname password DB1 name1 ... (1 Reply)
Discussion started by: abhigrkist
1 Replies

10. Solaris

Connecting to Oracle database

Hi guys, long time no typing :D I have problems when I try to connect to Oracle database from SQL Developer which is located on my Windows box. Server is running Solaris 11/11 and Oracle 11 enterprise. I can log in locally with sys account to database, start it up and shut it down but when I... (2 Replies)
Discussion started by: solaris_user
2 Replies
PM_WHICH(1p)						User Contributed Perl Documentation					      PM_WHICH(1p)

NAME
pm_which - find installed modules SYNOPSIS
pm_which [ options ] module(s) Returns the path to the given module(s) OPTIONS -q, --quiet Just print paths -p, --paths Just convert the module name into a relative path -a, --all Print all paths, not just the first one found -n, --namespace Print all modules in the given namespace -m Only print module names, not paths -V Show module version -I libpath Add a path to search (like perl -I) -d, --dump Dump paths that would be searched (@INC by default) -h, --help Print this message -v, --version Print version information - Read modules from stdin, one per line DESCRIPTION
This tool reports the locations of installed perl modules. By default it lists the location of each specified module that would be loaded by require. OPTION DETAILS
quiet Under quiet mode, module names are suppressed and missing modules are not reported. Normal output: $ pm_which Module::One Module::Two Missing::Module Module::One - /path/to/Module/One.pm Module::Two - /path/to/Module/Two.pm Missing::Module - not found Under --quiet: $ pm_which -q Module::One Module::Two Missing::Module /path/to/Module/One.pm /path/to/Module/Two.pm paths In "paths" mode, each module is simply converted into a relative file path. This is possible even when the module is not installed. $ pm_which -p Missing::Module Missing/Module.pm all When the "all" switch is specified, all installed modules will be reported, not just the first one. This is useful for determining when there is a module installed in multiple locations. $ pm_which -a MyModule /path/to/MyModule.pm /home/me/perl/MyModule.pm namespace Arguments are taken as namespaces to search under. $ pm_which -n MyModule MyModule - /path/to/MyModule.pm MyModule::Foo - /path/to/MyModule/Foo.pm MyModule::Foo::Bar - /path/to/MyModule/Foo/Bar.pm -m Disables printing of module paths. This is only really useful in conjunction with --namespace. $ pm_which -nm MyModule MyModule MyModule::Foo MyModule::Foo::Bar -V Prints the version of each module, according to ExtUtils::MakeMaker. $ pm_which -V MyModule MyModule - /path/to/MyModule.pm [ 1.00 ] $ pm_which -Vnm MyModule MyModule [ 1.00 ] MyModule::Foo [ 0.01 ] MyModule::Foo::Bar [ undef ] dump Dumps the paths that would be searched and exits. This is @INC modified by any -I switches. $ pm_which --dump /usr/lib/perl5/site_perl/5.8.6 /usr/lib/perl5/vendor_perl/5.8.6 ... $ pm_which -I lib --dump -I blib/lib lib blib/lib /usr/lib/perl5/site_perl/5.8.6 ... version Prints the version number of the script, plus the version and path of Module::Util that was loaded. EXIT CODES
o 0 - Everything was OK o 1 - Initialisation failed (bad switches?) o 2 - Some modules were not installed SEE ALSO
This utility comes with Module::Util. AUTHOR
Matt Lawrence <mattlaw@cpan.org> perl v5.14.2 2012-06-08 PM_WHICH(1p)
All times are GMT -4. The time now is 05:55 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy