03-26-2012
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
Hi, guys !
I usually run this task without even thinking on outcome, because it never failed. But this time when I tried installation of patches for Solaris 8 OS on my old machine, I received this message:
"pkgadd: ERROR: no packages were found in </var/spool/pkg>"
I compared the contents... (5 Replies)
Discussion started by: Deicide5997
5 Replies
2. Solaris
I am trying to install Sun Studio 11 on a Solaris 8 server. It gets through the install of patches then hangs with 20% of the overall install done and 0% of the software install done. It seems to be running /tmp/SolarisNativeToolkit_3.0.2_1 and is hanging. I have made multiple attempts and it... (6 Replies)
Discussion started by: jwilloughby
6 Replies
3. Solaris
Hi,
This is not a question thread, but rather a solution to an issue I have encountered on Solaris 11.
It turns out that pkgadd is not available by default on Solaris 11. The solution is to install it with:
pkg install SUNWpkgcmdsI hope this will save people some time.
Cheers,
... (4 Replies)
Discussion started by: JVerstry
4 Replies
4. UNIX Desktop Questions & Answers
Hey everyone,
I'm using a SPARC based Solaris 10 5/09 machine and want to install PHP support to it. I already have mysql and apache( came with OS, just started the proccess) installed, so this is the last thing before I can get to learning development :) However, there's something I'm not sure... (1 Reply)
Discussion started by: agummad
1 Replies
5. Programming
Hi all.
I'm trying to install Sun Studio on my Ubuntu 10.4 pc because
I wanna use X-Designer (it is a Motif GUI builder), that should be in that suite.
I downloaded the tar package build for linux and installed
the deps. Sun Studio and the Sun C Compiler work fine, but
i cannot find... (0 Replies)
Discussion started by: mghis
0 Replies
6. Solaris
I'm having a little trouble with a Solaris package build/install.
I have the following entries in my prototype file...
# Interfaces file - all versions installed and auto linked to installation type...
f none $OPTDIR/config/interfaces.DEV 0444 $OWNER $GROUP
f none... (0 Replies)
Discussion started by: JerryHone
0 Replies
7. Solaris
Hi,
I am trying to install a simple gcc package on a sparc (solaris 10) machine using the admin file (called admtest), but it is not working. I am getting the "Select package prompt". Can anyone have a look at it and tell me what am i doing wrong.
# cat admtest
mail=root... (5 Replies)
Discussion started by: Mack1982
5 Replies
8. Solaris
Hello this is samiulla. i face this issue. i installed samba with pkgadd after i install i add paths for that.
-bash-3.00# echo $PATH
/usr/sbin:/usr/bin:/usr/ccs/bin:/usr/local/samba/sbin:/usr/local/samba/bin/
-bash-3.00#
when enter this commad smbd -D i got this error
smbd -D... (3 Replies)
Discussion started by: samiulla
3 Replies
9. AIX
I believe pkgadd facility is available on AIX for managing installation of software packages.
How can i get pkgadd facility on AIX machine. which packages i have to install to get pkgadd feature?
:mad: (4 Replies)
Discussion started by: snreddy_gopu
4 Replies
10. Solaris
I have some simple package installations that have worked in previous versions of Solaris just fine. I can install the packages, then install newer versions right over the top without error. In previous versions I had to specify the -G option during the installation in order for this to work.
... (0 Replies)
Discussion started by: moondog25
0 Replies
LEARN ABOUT DEBIAN
dbix::searchbuilder::handle::oracle
DBIx::SearchBuilder::Handle::Oracle(3pm) User Contributed Perl Documentation DBIx::SearchBuilder::Handle::Oracle(3pm)
NAME
DBIx::SearchBuilder::Handle::Oracle - An oracle specific Handle object
SYNOPSIS
DESCRIPTION
This module provides a subclass of DBIx::SearchBuilder::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.
BuildDSN
Customized version of "BuildDSN" in DBIx::SearchBuilder::Handle method.
Takes additional argument SID. Database argument used unless SID provided. Two forms of DSN are generated depending on whether Host
defined or not:
dbi:Oracle:sid=<SID>;host=...[;port=...]
dbi:Oracle:<SID>
Read details in documentation for DBD::Oracle module.
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.
InsertFromSelect
Customization of "InsertFromSelect" in DBIx::SearchBuilder::Handle.
Unlike other DBs Oracle needs:
o id generated from sequences for every new record.
o query wrapping in parens.
NOTE that on Oracle there is a limitation on the query. Every column in the result should have unique name or alias, for example the
following query would generate "ORA-00918: column ambiguously defined" error:
SELECT g.id, u.id FROM ...
Solve with aliases:
SELECT g.id AS group_id, u.id AS user_id FROM ...
KnowsBLOBs
Returns 1 if the current database supports inserts of BLOBs automatically. Returns undef if the current database must be informed of BLOBs
for inserts.
BLOBParams FIELD_NAME FIELD_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).
ApplyLimits STATEMENTREF ROWS_PER_PAGE FIRST_ROW
takes an SQL SELECT statement and massages it to return ROWS_PER_PAGE starting with FIRST_ROW;
DistinctQuery STATEMENTREF
takes an incomplete SQL SELECT statement and massages it to return a DISTINCT result set.
BinarySafeBLOBs
Return undef, as Oracle doesn't support binary-safe CLOBS
DatabaseVersion
Returns value of ORA_OCI constant, see "Constants" in DBI.
SimpleDateTimeFunctions
Returns hash reference with specific date time functions of this database for "DateTimeFunction" in DBIx::SearchBuilder::Handle.
ConvertTimezoneFunction
Custom implementation of "ConvertTimezoneFunction" in DBIx::SearchBuilder::Handle.
Use the following query to get list of timezones:
SELECT tzname FROM v$timezone_names;
Read Oracle's docs about timezone files:
http://download.oracle.com/docs/cd/B14117_01/server.101/b10749/ch4datetime.htm#i1006667
AUTHOR
Jesse Vincent, jesse@fsck.com
SEE ALSO
perl(1), DBIx::SearchBuilder
perl v5.14.2 2011-09-21 DBIx::SearchBuilder::Handle::Oracle(3pm)