Solaris system and database migration help

10 More Discussions You Might Find Interesting

1. Solaris

Migration of Solaris 10 on physical host to Solaris Zones

Hi All Kindly let me know how can I move Solaris 10 OS running update 10 on physical machine to another machine solaris zone running Solaris 10 update 11

2. Shell Programming and Scripting

UNIX file system to Linux file system migration

We would be migrating UNIX file system to Linux file system. We do have many directory and sub directories with files. after migrating unix to linux file system , i want to make sure all the files has been copied ? What would be the best approach to validate directory ,sub-directory and file...

3. Linux

Migration from solaris to linux

Hi, Currently I can able to access php script from solaris. I want to access from Linux I have done the following things: 1) I have copied all the scripts from solaris to linux. 2) I have installed php,mysql,apache. I tried with http://Hostname/username/test.php . This is not working ....

4. Solaris

redirect solaris database from linux database..

hi.. i have a need .. my php runs on my linux redhat box with mysql.. i want my php code to refer another mysql database which is in solaris 10 x86... can u tell me the procedure .. how it can be done through php .. sorry am new to php... is it possible to redirect from linux mysql to...

5. Solaris

Solaris printing system migration

Hello folks, I'm currently working on migration of printing system from one server to another (namely from Sol 9 to Sol 10). I would like ask if is possible to manage migration via simple copying /etc/printers.conf file and folder /etc/lp to the new server??? I'm not sure if printers...

6. Shell Programming and Scripting

Connect to remote database from solaris system

Hi, i need to connect to a oracle database available in a remote PC (reachable from the host solaris server). I have added the tnsnames of that remote DB in to the tnsnames.ora file of the host solaris server. Am able to ping that IP. How do i connect to that DB for running sql...

7. Solaris

Migration from solaris 8 to 10

Hello, We have upgraded our system from SunOS 5.8 to Solaris 10. I would like to know if the applications (written in c, c++, pro*c, java,..) running on the 5.8 can run on the Solaris 10 without code modification or the need to be recompiled ? thanks you for your help.

8. UNIX for Advanced & Expert Users

Solaris migration

Hi , There is going to be a server migration from Solaris 8.0 to Solaris10.0. Could anyone give me some tips and documents regarding the steps to be remembered,tips to be followed etc. like syntax differences any new changes to the existing commands and tools we use whatever the...

9. Solaris

Migration Solaris 5.8 to 10

Hi, it is necessary to make the migration of Solaris 5.8 for Solaris 10, would like to know which the best form to execute this task, if to be able to say me where I can arrange some manual that helps me to make this task. Thanks :o

10. UNIX for Advanced & Expert Users

Database Migration

Hi All, This question is mainly to get help from u all experts for a database vendor change we are in the process of migrating our database vendor from INFORMIX to ORACLE to run on SOLARIS 9.4 box. Hence we need to work out on our applications which all are written in native 4GL (an easy...

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)

Solaris