Sponsored Content
Top Forums Shell Programming and Scripting How can we hardcode TNS_ADMIN? Post 302519677 by rdhanek on Wednesday 4th of May 2011 04:49:01 PM
Old 05-04-2011
How can we hardcode TNS_ADMIN?

How can we hardcode TNS_ADMIN?

When i try to connect to db with the code below..i get TNS issue. So wpndering if i can hardcode TNS..
HTML Code:
 
<html>
<head>
<title>xxxxxxxxxxxxxx</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<%
  ### Load modules, connect to database
  require 'cgi'
  require 'dbi'
  $dbh = ''
  begin
  $dbh = DBI.connect("DBI:Oracle:dbname", "username", "password")
 
 

5 More Discussions You Might Find Interesting

1. Solaris

i wanto hardcode password for a username to ssh to a server using script

Dear all i want to ssh to a server via running a shell script with a username and i want to hard code the password for that particular username can u help me please Thank u Naree (8 Replies)
Discussion started by: naree
8 Replies

2. Shell Programming and Scripting

mysqldump script without hardcode password

OS: Linux ambglx02 2.6.16.60-0.21-default #1 Tue May 6 12:41:02 UTC 2008 i686 i686 i386 GNU/Linux Shell: bash Currently I have a mysqldump script to backup my mysql database, the command is as below: /opt/novell/mysql/bin/mysqldump --add-drop-table -u root -p -h mydb > /home/john/mydb.sql ... (5 Replies)
Discussion started by: bulkbiz
5 Replies

3. UNIX for Advanced & Expert Users

Change in script to hardcode in a query

HI, In a script i am using a query ${SQLPLUS_SETTINGS} select c.CYCLE_CODE ||'|'|| NEXT_CYCLE_INST ||'|'|| CYCLE_YEAR ||'|'|| to_char(trunc(CYCLE_CLOSE_DATE +1),'DD-MON-YY YY')||'|'|| to_char(ADD_MONTHS(CYCLE_CLOSE_DATE,1),'DD-MON-YYYY') ||'|'|| CYCLE_MONTH FROM PM1_CYCLE_STATE C,... (2 Replies)
Discussion started by: madfox
2 Replies

4. UNIX for Dummies Questions & Answers

Problem with TNS_ADMIN in .profile

Hi! In my .profile I have a line that says export TNS_ADMIN=$HOME I received the .profile file from a colleague who uses it to access SQL*Plus from a UNIX server. When I try the same method he uses I get ORA-12154: TNS:could not resolve the connect identifier specifiedwhich makes me think... (8 Replies)
Discussion started by: Mike Welch
8 Replies

5. Shell Programming and Scripting

Logon to multiple hosts using ssh hardcode password

Hi im trying to write a script to logon to list of servers with same userID. I have no option/plan to implement ssh-keygen sharing between the systems, so i have written script creating 2 files, file1 holds list of hosts host1 host2 host3 file2 has following script for i in `cat file1`... (1 Reply)
Discussion started by: dreamaix
1 Replies
Module::Load(3pm)					 Perl Programmers Reference Guide					 Module::Load(3pm)

NAME
Module::Load - runtime require of both modules and files SYNOPSIS
use Module::Load; my $module = 'Data:Dumper'; load Data::Dumper; # loads that module load 'Data::Dumper'; # ditto load $module # tritto my $script = 'some/script.pl' load $script; load 'some/script.pl'; # use quotes because of punctuations load thing; # try 'thing' first, then 'thing.pm' load CGI, ':standard' # like 'use CGI qw[:standard]' DESCRIPTION
"load" eliminates the need to know whether you are trying to require either a file or a module. If you consult "perldoc -f require" you will see that "require" will behave differently when given a bareword or a string. In the case of a string, "require" assumes you are wanting to load a file. But in the case of a bareword, it assumes you mean a module. This gives nasty overhead when you are trying to dynamically require modules at runtime, since you will need to change the module notation ("Acme::Comment") to a file notation fitting the particular platform you are on. "load" eliminates the need for this overhead and will just DWYM. Rules "load" has the following rules to decide what it thinks you want: o If the argument has any characters in it other than those matching "w", ":" or "'", it must be a file o If the argument matches only "[w:']", it must be a module o If the argument matches only "w", it could either be a module or a file. We will try to find "file.pm" first in @INC and if that fails, we will try to find "file" in @INC. If both fail, we die with the respective error messages. Caveats Because of a bug in perl (#19213), at least in version 5.6.1, we have to hardcode the path separator for a require on Win32 to be "/", like on Unix rather than the Win32 "". Otherwise perl will not read its own %INC accurately double load files if they are required again, or in the worst case, core dump. "Module::Load" cannot do implicit imports, only explicit imports. (in other words, you always have to specify explicitly what you wish to import from a module, even if the functions are in that modules' @EXPORT) ACKNOWLEDGEMENTS
Thanks to Jonas B. Nielsen for making explicit imports work. BUG REPORTS
Please report bugs or other issues to <bug-module-load@rt.cpan.org<gt>. AUTHOR
This module by Jos Boumans <kane@cpan.org>. COPYRIGHT
This library is free software; you may redistribute and/or modify it under the same terms as Perl itself. perl v5.18.2 2013-11-04 Module::Load(3pm)
All times are GMT -4. The time now is 10:41 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy