if i set Oracle home in the command line as
export ORACLE_HOME=/usr/oracle/product/9.2.0; and then checking it by
typing echo $ORACLE_HOME,its getting the correct result.But if i try setting the ORACLE_HOME from a shell script by just including the same line as above,it was not working.Could anybody give me a tip regarding this?
With Regards
Dileep
If you want to set the env variable from a shell script, then you need to source that file i.e.
Hi ,
i am having RedHat AS 4 in my home PC.now i want to access applications remotely i.e from office.
how can i do that.
in short i would like to make my PC as server for doing test's. while I am @ work.
I am using static IP.
leenus (1 Reply)
Hi all,
I just purchased 2 Ultra 10 servers and I want to practice with home networking. I want to create a private network where I can connect both boxes to the internet via broadband using my four port adsl modem/router. My ISP assigns me 192.168 addresses via DHCP and I use the ISP's DNS but... (1 Reply)
Hi.
I have a directory structure built with links. For example: /home/user1 is a link to /var/123/user1
can i set the home variable in the .profile of the user to use a link? or it has to be a "real" directory?
tks (1 Reply)
Hi all,
This is probably a basic question. I had installed a stand-alone library called szip in my home directory, as I don't have the necessary root permission.
I tried to set an environment for both include and lib files in my .cshrc script as
setenv /home/szip/lib
setenv... (3 Replies)
Hello,
I'm planning to set up Oracle 10g RAC at home. I was initaillay planning to get a windows desktop and install Cent OS after wiping out the existing windows OS. I have some questions with regards to this.
1) For setting up RAC, I would have to install an additional NIC besides the one... (2 Replies)
All,
I have to change my ORACLE_HOME in the prodution environment.
I have chaged it in .profile file but when I am typing the command
bash-2.05$ echo $ORACLE_HOME
/apps/oracle/product/10.2.0.4.2011Q1
Instead of Q1 it should show Q3 bcoz I have changed it in .profile file. But at the same... (2 Replies)
Hello,
My question is very basic for the settings to SSH my home PC from work.
Home network two PC:
Internet comes into my house through ISP modem and then the two PCs are connected with the router (Trendnet). The IPs for my PCs are
How to set other stuffs for me to access my home PC from... (5 Replies)
Hi guys...
I have got a old Aix box i.e. 7043 - 150 for home experimenting purposes. I am having some issues to setup the tcpip on it correctly, so that i can access it within the network and also from outside i.e. work.
My setup looks like this:
Modem ----> Apple airport wireless router... (2 Replies)
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)
I am working on learning Linux, and somebody suggested setting up Linux on a separate computer, and searching for answers to whatever may be needed, on a different computer plugged in to the Internet.
I have a Windows 7 PC, plugged in to a cable modem, and an old notebook, Compaq Presario R3000... (5 Replies)
Discussion started by: AdultFoundry
5 Replies
LEARN ABOUT DEBIAN
jifty::dbi::handle::oracle
Jifty::DBI::Handle::Oracle(3pm) User Contributed Perl Documentation Jifty::DBI::Handle::Oracle(3pm)NAME
Jifty::DBI::Handle::Oracle - An oracle specific Handle object
SYNOPSIS DESCRIPTION
This module provides a subclass of Jifty::DBI::Handle that compensates for some of the idiosyncrasies of Oracle.
METHODS
connect PARAMHASH: Driver, Database, Host, User, Password
Takes a paramhash and connects to your DBI datasource.
database_version
Returns value of ORA_OCI constant, see "Constants" in DBD::Oracle.
insert
Takes a table name as the first argument and assumes that the rest of the arguments are an array of key-value pairs to be inserted.
build_dsn PARAMHASH
Takes a bunch of parameters:
Required: Driver, Database or Host/SID, Optional: Port and RequireSSL
Builds a dsn suitable for an Oracle DBI connection
blob_params column_NAME column_type
Returns a hash ref for the bind_param call to identify BLOB types used by the current database for a particular column type. The current
Oracle implementation only supports ORA_CLOB types(112).
apply_limits STATEMENTREF ROWS_PER_PAGE FIRST_ROW
takes an SQL SELECT statement and massages it to return ROWS_PER_PAGE starting with FIRST_ROW;
distinct_query STATEMENTREF
takes an incomplete SQL SELECT statement and massages it to return a DISTINCT result set.
AUTHOR
Jesse Vincent, jesse@fsck.com
SEE ALSO
Jifty::DBI, Jifty::DBI::Handle, DBD::Oracle
perl v5.14.2 2011-04-26 Jifty::DBI::Handle::Oracle(3pm)