Script an Oracle Command Line Blackout

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Works on command line but not in script

OSX 10.9 I am building a script that evaluates the difference between 2 files. Here is a command that does not work transparently. Running this command in Terminal yields great results; however when I put that line in a .sh script, I get the errors shown below. Am I doing something silly? ...

2. Shell Programming and Scripting

Need to execute Oracle relocation command in shell script

Hello, I need to execute below command in shell script srvctl relocate service -d $database -s $service -i $avail -t $pref -f and also need to get the errors ,if any,in another file. What's the right way to execute such commands in shell script? Best regards, Vishal

3. UNIX for Dummies Questions & Answers

Ls -1 at Command Line vs in a Shell Script

Hello, I have symbolic links to a bunch of directories (all starting with the letter X) in the cwd. When I run the following on the command line, I get the list as I want it. ls -1 X* > dir.list However when I run it in a shell script like given below, it lists all the files in each of...

4. Shell Programming and Scripting

Difference between command line and script

i have a bit of a unique question. is there a way to know if a script is being run from from the command line or from another script? example: command line: ### ./autorun.sh ERROR: not permitted to run script from the commandline. exiting... but if i put "autorun.sh" into another...

5. Shell Programming and Scripting

SH script, variable built command fails, but works at command line

I am working with a sh script on a solaris 9 zone (sol 10 host) that grabs information to build the configuration command line. the variables Build64, SSLopt, CONFIGopt, and CC are populated in the script. the script includes CC=`which gcc` CONFIGopt=' --prefix=/ --exec-prefix=/usr...

6. Shell Programming and Scripting

UNIX script / Command >>> in one line

Hi Experts, Basically I am a SAP programmer. I don't know much about UNIX. But I got a situation, need to use UNIX script /command in my programming. I searched the forum and found the below code. I would like to pass the below UNIX script in my programming code. But my programming will...

7. Shell Programming and Scripting

Command executes on the command line but not from script

Hello guys, I have the following commands : Command 1: sudo find "../bundlepool" -name "merchandising2.html" -print0 |xargs -0 -I {} cp "rebranding/merchandising2.html" {} Command 2: find "../bundlepool" -name "merchandising2.html" -exec cp rebranding/merchandising2.html {} \; Command 3: ...

8. Shell Programming and Scripting

perl script command line option driven script

could someone show me a sample command line option driven script? i want to see an easy way to write one and how i can execute it using command line options such as typing in read.pl -i <id> -c <cmds> -s <start> -e <end> would read out all the commands run by ID . from start time to...

9. Shell Programming and Scripting

Need help! command working ok when executed in command line, but fails when run inside a script!

Hi everyone, when executing this command in unix: echo "WM7 Fatal Alerts:", $(cat query1.txt) > a.csvIt works fine, but running this command in a shell script gives an error saying that there's a syntax error. here is content of my script: tdbsrvr$ vi hc.sh "hc.sh" 22 lines, 509...

10. UNIX and Linux Applications

Running oracle commands Directly from Command Line

In mysql, I can get what I want from a database without having to log into mysql. works great for me and it is perfect. now, i want to be able to do the same in oracle but I dont know how to. For example, if i want to retrieve information from the mysql database from the command line, i issue...

LEARN ABOUT DEBIAN

apache::session::store::oracle

Apache::Session::Store::Oracle(3pm)			User Contributed Perl Documentation		       Apache::Session::Store::Oracle(3pm)

NAME

       Apache::Session::Store::Oracle - Store persistent data in a Oracle database

SYNOPSIS

	use Apache::Session::Store::Oracle;

	my $store = new Apache::Session::Store::Oracle;

	$store->insert($ref);
	$store->update($ref);
	$store->materialize($ref);
	$store->remove($ref);

DESCRIPTION

       Apache::Session::Store::Oracle fulfills the storage interface of Apache::Session. Session data is stored in a Oracle database.

SCHEMA

       To use this module, you will need at least these columns in a table called 'sessions':

	id varchar2(32)     # or however long your session IDs are.
	a_session long

       To create this schema, you can execute this command using the sqlplus program:

	CREATE TABLE sessions (
	   id varchar2(32) not null primary key,
	   a_session long
	);

       If you use some other command, ensure that there is a unique index on the table's id column.

CONFIGURATION

       The module must know what datasource, username, and password to use when connecting to the database.  These values can be set using the
       options hash (see Apache::Session documentation).  The options are DataSource, UserName, and Password.

       Example:

	tie %hash, 'Apache::Session::Oracle', $id, {
	    DataSource => 'dbi:Oracle:database',
	    UserName   => 'database_user',
	    Password   => 'K00l'
	};

       Instead, you may pass in an already-opened DBI handle to your database.

	tie %hash, 'Apache::Session::Oracle', $id, {
	    Handle => $dbh
	};

       The last option is LongReadLen, which specifies the maximum size of the session object.	If not supplied, the default maximum size is 8 KB.

AUTHOR

       This modules was written by Jeffrey William Baker <jwbaker@acm.org>

       A fix for the commit policy was contributed by Michael Schout <mschout@gkg.net>

SEE ALSO

       Apache::Session, Apache::Session::Store::DBI

perl v5.10.1							    2010-10-18				       Apache::Session::Store::Oracle(3pm)

Shell Programming and Scripting