Linux and UNIX Man Pages

Linux & Unix Commands - Search Man Pages

apache::session::oracle(3) [suse man page]

Session::Oracle(3)					User Contributed Perl Documentation					Session::Oracle(3)

NAME
Apache::Session::Oracle - An implementation of Apache::Session SYNOPSIS
use Apache::Session::Oracle; #if you want Apache::Session to open new DB handles: tie %hash, 'Apache::Session::Oracle', $id, { DataSource => 'dbi:Oracle:sessions', UserName => $db_user, Password => $db_pass, Commit => 1 }; #or, if your handles are already opened: tie %hash, 'Apache::Session::Oracle', $id, { Handle => $dbh, Commit => 1 }; DESCRIPTION
This module is an implementation of Apache::Session. It uses the Oracle backing store and no locking. See the example, and the documentation for Apache::Session::Store::Oracle for more details. USAGE
The special Apache::Session argument for this module is Commit. You MUST provide the Commit argument, which instructs this module to either commit the transaction when it is finished, or to simply do nothing. This feature is provided so that this module will not have adverse interactions with your local transaction policy, nor your local database handle caching policy. The argument is mandatory in order to make you think about this problem. This module also respects the LongReadLen argument, which specifies the maximum size of the session object. If not specified, the default maximum is 8 KB. AUTHOR
This module was written by Jeffrey William Baker <jwbaker@acm.org>. SEE ALSO
Apache::Session::File, Apache::Session::Flex, Apache::Session::DB_File, Apache::Session::Postgres, Apache::Session perl v5.12.1 2007-09-28 Session::Oracle(3)

Check Out this Related Man Page

Apache::Session::Postgres(3pm)				User Contributed Perl Documentation			    Apache::Session::Postgres(3pm)

NAME
Apache::Session::Postgres - An implementation of Apache::Session SYNOPSIS
use Apache::Session::Postgres; #if you want Apache::Session to open new DB handles: tie %hash, 'Apache::Session::Postgres', $id, { DataSource => 'dbi:Pg:dbname=sessions', UserName => $db_user, Password => $db_pass, Commit => 1 }; #or, if your handles are already opened: tie %hash, 'Apache::Session::Postgres', $id, { Handle => $dbh, Commit => 1 }; DESCRIPTION
This module is an implementation of Apache::Session. It uses the Postgres backing store and no locking. See the example, and the documentation for Apache::Session::Store::Postgres for more details. USAGE
The special Apache::Session argument for this module is Commit. You MUST provide the Commit argument, which instructs this module to either commit the transaction when it is finished, or to simply do nothing. This feature is provided so that this module will not have adverse interactions with your local transaction policy, nor your local database handle caching policy. The argument is mandatory in order to make you think about this problem. AUTHOR
This module was written by Jeffrey William Baker <jwbaker@acm.org>. SEE ALSO
Apache::Session::File, Apache::Session::Flex, Apache::Session::DB_File, Apache::Session::Postgres, Apache::Session perl v5.10.1 2010-10-18 Apache::Session::Postgres(3pm)
Man Page

15 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Unix Oracle

Through a shell script ... I am invoking sql plus.. Code is as follows... echo " set feedback off verify off pagesize 0 select column from table " | sqlplus -s/@dbname | read var_col Now if oracle throws an exception for above select statement ...then how can i catch it ?... (15 Replies)
Discussion started by: dhananjaysk
15 Replies

2. UNIX for Dummies Questions & Answers

Inactive Session

Hi, I am new to forum, I am wondering anyone can help me ? Is there a command to tell whether a particular process is already inactive, so I can issue a kill command to end it. I have been encountering scenerio whereby users always shutdown abnormally by closing the windows, and my application... (12 Replies)
Discussion started by: lowtaiwah
12 Replies

3. UNIX for Advanced & Expert Users

Capturing Oracle Shutdown error

Hi, Iam calling 3 sql scripts through one shell script 'rmia.sh'. Till now this was working fine, but last time while calling the SQL scripts, Oracle was down. But amazingly the exit status was '0' (success)!!! Below is the shell code: #!/usr/bin/ksh -x assign_file asql a.sql 1... (15 Replies)
Discussion started by: ganapati
15 Replies

4. Shell Programming and Scripting

piping oracle output to a file?

Hi All... Does anyone know how to pipe the output of a "select" statement from a call to Oracle to a file? ANy ideas woule be greatly appreciated! Code is as below... echo "producing CSV file 2..." sqlplus -s $username/$password@$database<<EOF set serveroutput on size 1000000 set... (13 Replies)
Discussion started by: satnamx
13 Replies

5. Solaris

Urgent Help!!!

Hi all! I have one big problem! Today, I do not log in my server which contains a production Oracle Database, however, it still runs. No console, no telnet, no SSH is to be allowed. I do not understand, really. Google searching, I found that, one action can cause it. It is described like... (12 Replies)
Discussion started by: trantuananh24hg
12 Replies

6. HP-UX

HP-Unix; .net application creates processes

I have a .net application that works with an Oracle database in HP-Unix. Problem: .net application creates Oracle processes that don't close. By default Oracle can work with 200 active processes and after that crashes. I doubled this number and I don't have to many problems. I want: to... (12 Replies)
Discussion started by: NicoMan
12 Replies

7. Shell Programming and Scripting

How to COnnect to Oracle database from UNIX Box

I am trying to connect to Oracle Databse from UNIX box using sqlplus command. But i get sqplus not found message. $ sqlplus sqlplus: not found I have searched in forums and all are suggesting to set environment varaibles...can somebody tell me what variables to set and how to set.and the... (12 Replies)
Discussion started by: angelarosh
12 Replies

8. UNIX for Advanced & Expert Users

Gurus needed to diagnose severe performance degradation

Hi everyone, newbie forum poster here. I'm an Oracle DBA and I require some guidance from the Unix gurus here about how to pinpoint where a problem is within a Solaris 9 system running on an 8 CPU Fujitsu server that acts as our Oracle database server. Our sysadmins are trying their best to... (13 Replies)
Discussion started by: DBA_guy
13 Replies

9. What is on Your Mind?

What do you think of the Oracle-Sun deal?

Sound off with your thoughts on Oracle's acquisition of Sun Microsystems here! (12 Replies)
Discussion started by: Neo
12 Replies

10. Solaris

OPS Center Email Notifications

Hi, Does any one know how to configure email notifications (to exchange) in Oracle Enterprise Manager 11g OPS Center? I have gone through the documentation and have done everything it asked, but still no notifications via email. I get the following error: At the OS level i tried sending email... (20 Replies)
Discussion started by: Mack1982
20 Replies

11. Shell Programming and Scripting

Permission to Oracle server to create a directory in a particular path

i need to give permission to ORACLE SERVER to create a directory in a particular path. How to do it?Oracle server is installed on SOLARIS (16 Replies)
Discussion started by: rafa_fed2
16 Replies

12. Solaris

New Oracle Home

How do I set ORACLE_HOME location? When I type echo $$ORACLE_HOME it gives me /u01/app/oracle//product/10.2.0/dbhome_1 which has been deleted. I just installed Oracle 11g and this is supposed to be a new oracle home /u01/app/oracle/product/11.2.0/dbhome_1 Any help from the community... (21 Replies)
Discussion started by: newborndba
21 Replies

13. UNIX for Advanced & Expert Users

Issue with ftp hanging

I could have sworn I posted on this issue earlier a couple of weeks ago but now cannot find the thread to add some updated info so I guess I'll start from scratch. Running on Oracle Linux 5.6, 64-bit. I have a weekly job that does an ftp 'mget' to copy a bunch of files from a production... (12 Replies)
Discussion started by: edstevens
12 Replies

14. Shell Programming and Scripting

Finding all Oracle SW installations on a host

Hi. I'm trying to find the best way to locate the latest version of Oracle on a Linux host. There could be multiple SW installs or there could be none. It could be a client or a full RDBMS installation. I need to find and set the environment in order to run the sqlplus binary. Rather than just... (14 Replies)
Discussion started by: user052009
14 Replies

15. UNIX for Beginners Questions & Answers

Shmem problem installing Oracle 12 C on Ubuntu 18.04

Hi, I'm a junior programmer. This is my first post here, please excuse me if that's not the correct place :) For days now I've been trying to install Oracle DB 12c R2 on Ubuntu 18.04. I'm at my wits' end. The software itself installs fine and a Listener can be started but I can't start... (15 Replies)
Discussion started by: Marika
15 Replies