If you are shutting down the Oracle Service in Windows then you need to check the shutdown
option that was selected when the service was created. Try either of these commands in dos.
You can either specify the sid name or the service name. Also take a look at the link below to
see the command options.
Hi
I have a mix of solaris 8,9 & 10. I need to have our 6 Solaris servers shutdown buy a script that will be executed by APC network Shutdown software
Im really not sure how I would write a script to shut them down and the following processes?
the processes are
portmapper
seq
seq_api... (1 Reply)
i really dont know any other way to put it besides that Ubuntu 8.04, that i just installed on my computer hangs when it shuts down. the bar depletes the orange like it should, but it never actually shuts down.
anyone know whats going on? (3 Replies)
One of my zone got stuck while rebooting in shutting down state. I tried following
1. Halt the zone with zoneadm -z zone1 halt
2. kill zoneadmd process for that zone and halt the zone
but none helped me. How can i shut it down and restart it ?
---------- Post updated 10-09-09 at 01:54 AM... (0 Replies)
Hey all,
I have attached an image of a problem that I've been having since last night. My computer will be on no more than 5-10 min and I'll get this message that pops up and my computer shutsdown.
I know for a fact my computer is not overheated becasue I will have it off for hours and then... (7 Replies)
on solaris 8 i edited file rc0 in /sbin at last line
ex.
/sbin/sync; /sbin/sync; /sbin/sync
# Unmount file systems. /usr, /var, /var/adm, /var/run are not unmounted by
# umountall because they are mounted by rcS (for single user mode) rather than
# mountall. If this is changed,... (1 Reply)
Hi All, I am pretty new to unix type languages. At work we have a server room with about 50 windows computers in one system and 50 in a unix system. We sometimes have power outages and I don't like the power slam. I wrote a windows batch file using sysinternals help to shutdown the windows... (4 Replies)
Hi there,
I had issue with one of MY FC cards on T4-2 servers so system team replace it and start the machine but when launch FORMAT command so I don't see my shared disks coming from storage controller. i have checked at the Fabric switch so WWN numbers are visible and zones are ok and after... (1 Reply)
Discussion started by: janakors
1 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)