01-05-2007
grial, Tornado:
You know what. I make it work. The problem is in the $ORACLE_HOME directory. I made a typo as /oracleproduct/. It should be /oracle/product. This is why dbstart can not be found and be started. After I put correct path. It works. Oracle DB, listener, em and isqlplus all automatically started. Anyway, thanks for your help and I have learned a lot from you.
8 More Discussions You Might Find Interesting
1. Cybersecurity
Our systems group is asking if it would be Ok to turn off certain services due to potention security risks. The following are being contemplated.
Service
chargen
daytime
discard
dtspcd
echo
exec
finger
fs
gssd
in.comsat
kcms_server
ktkt_warnd
login
name
rpc.cmsd
rpc.metad... (4 Replies)
Discussion started by: BCarlson
4 Replies
2. UNIX for Advanced & Expert Users
dear all,
i have 2 questions on solaris 10. I noticed telnet/ftp/print services suddenly being stopped on one server. How can i trace this issue and find a resolution. Other issue is i need to enable rsh within the same host. enabled the service rexec and have created the .rhosts and have a + in... (4 Replies)
Discussion started by: earlysame55
4 Replies
3. Solaris
I've installed Solaris 10 (05-08) on a SPARC platform
During the installation I was prompted with the question below. I selected yes to enable remote services.
Does anyone know what services this option enables?
- Enabling remote services ----------------------------------------
Would... (6 Replies)
Discussion started by: soliberus
6 Replies
4. Solaris
We need a DNS Server on DNS 10. What the best product can i buy and install ?
Help me, pls.
Tks all. (1 Reply)
Discussion started by: quan0509
1 Replies
5. Solaris
Hello
We have recently been through an audit of our solaris servers.
All our solaris servers are running version 10.
We have been told to close down all the services and we have closed what we could by using svcadm disable
We only wish to let ssh and the ftp service to run.
Below is a... (3 Replies)
Discussion started by: sollyshah
3 Replies
6. Solaris
I'm looking for help with a legacy system.
I have some obsolete equipment connected to an Ultra 60 running Solaris 5.7 with the binary for a 32 bit driver. The driver is rejected by newer versions of solaris, which run 64 bit kernels.
I hope to reverse engineer the driver so that I can... (0 Replies)
Discussion started by: obsoleteStuff
0 Replies
7. Solaris
Scenario: I have installed a service. When I start it by running /etc/init.d/<service> start it generates a massive amount of audit data (auditd) in /var/audit. So much so that running the service for any length of time is inadvisable due to overhead.
However if I reboot the system the... (6 Replies)
Discussion started by: penguinpanzer
6 Replies
8. Solaris
Hi,
Few services not starting on new build Solaris 11 non-global zone. I uninstalled zone and reinstalled and still same issue, while global zone is working fine.
smpt service is going into maintenance mode and /var/svc/log/network-smtp:sendmail.log shows that it tries and then dead
... (0 Replies)
Discussion started by: solaris_1977
0 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)