9 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi I have a question regarding Oracle connection using the below code
${ORACLE_HOME}/bin/sqlplus -s $user/$pwd@$sid <<!EOF 1>> $v_log_dir/$v_job_log.out 2>> $v_log_dir/$v_job_log.err
/
prompt stored procedure beginning . . .
exec xx_interface_pkg.pr_xx_clms_out($datayears,$keepmonths);
... (3 Replies)
Discussion started by: smilingraja
3 Replies
2. Shell Programming and Scripting
I've a Centralized Server which can connect to all Oracle Databases.
When I was trying the below code it doesn't work, But tnsping was working fine.
#!D:/perl5/bin/perl.exe
use DBI;
my $dbh = DBI->connect('dbi:Oracle:QBDIWCE', 'IDUSER', 'SECRET123#' ) || die( $DBI::errstr . "\n" ) ;
... (1 Reply)
Discussion started by: ilugopal
1 Replies
3. Shell Programming and Scripting
Hi,
Oracle 9.2
Solaris 10
From the shell script ........How can we verify whether oracle connection is successful or not ?
Shell script will prompt the user to enter the oracle schema username, password and tns name.
So, *how to verify whether oracle connection has been established or... (14 Replies)
Discussion started by: milink
14 Replies
4. Shell Programming and Scripting
Hi all,
Will I be able to connect to oracle using UBUNTU. If so, can any one provide me the steps. I want to try table archival and sql loader using control files. Please do help.
Thanks,
Raaga (1 Reply)
Discussion started by: Raaga
1 Replies
5. Shell Programming and Scripting
My problem is this....:eek:
Platform=Sun Solaris UNIX / Oracle 10g
1) I'm trying to SSH from my local system A to remote system B
2) Once connected, I need to sudo to ID that has the ability to connect to the Oracle database
3) Then run a script that connects via sqlplus and... (2 Replies)
Discussion started by: khand67
2 Replies
6. Shell Programming and Scripting
Hi,
For connecting to oracle my script is using the command
sqlplus username/password@db_instance_name.For this to work i am setting ORACLE_HOME,TNS_ADMIN and ORACLE_SID in a seperate script.My question is,could we make a connection to oracle just by the command
sqlplus... (4 Replies)
Discussion started by: DILEEP410
4 Replies
7. Shell Programming and Scripting
Hi all
In my script i am getting two variables year and month from oracle by making two connections. In the first connection i am getting varaibel year and again i am making another connection and getting month variable from oracle.
Is there any way i can get two field values from oracle and... (1 Reply)
Discussion started by: vasuarjula
1 Replies
8. Windows & DOS: Issues & Discussions
I am attempting to access an Oracle 9i database located on a Solaris server from an XP client. The server is running Oracle 9i9.2.0.1.0 and the XP is Oracle client 9i 9.2.0.1.0. When I start a listener on the server, the listener starts but I receive a message “The listener supports no services”. I... (3 Replies)
Discussion started by: jkuchar747
3 Replies
9. UNIX for Advanced & Expert Users
Requirements:
Using a shell script I have to check the 4 values from a table in Oracle and then store the result as "Y" in a Unix variable if the values are desired and "N" if the values are not desired.
Explanation:
There is a table abc in oracle which has 4 fields. if all the four values... (2 Replies)
Discussion started by: decci_7
2 Replies