03-21-2008
Hi
Actually they are trying to execute an SQL query.. And from the UNIX admin they had mailed me that the SID 1147 is running for 5 hours. Check it ...
But I am not aware of the unix administaration commands.. So can you please help me tou how can i check it in my unix server ...
6 More Discussions You Might Find Interesting
1. UNIX for Advanced & Expert Users
Hi,
if any one understand what does this mean :
SID=${ORACLE_SID:?"$TWO_TASK"}
I have it in a shell script.
Many thanks in advance. (2 Replies)
Discussion started by: big123456
2 Replies
2. Shell Programming and Scripting
Hello
I have multiple accounts that running application that uses unique port number
I want to generate this port from some sid number that stays constant for every user account , is there any place in the system
that generate number that is unique to the account ?
thanks (0 Replies)
Discussion started by: umen
0 Replies
3. UNIX for Dummies Questions & Answers
Hi,
i am working on Tru64 os...
When i try to connect to an Oracle instance, the usual method i follow is
chsxsora1:oracle:PRD1 > . oraenv
ORACLE_SID = ? PRD1
But for one Instance it was not working,
chsxsora2:oracle:TST2 > . oraenv
ORACLE_SID =*= ? TST2
i... (0 Replies)
Discussion started by: saharookiedba
0 Replies
4. Shell Programming and Scripting
Dear All
I am trying to write one shell which will be running through Cron which contain one SQL query. But I want to draw/fetch the Username password and Instance name (required to loging to the database) from one single file to run that SQL query . Also this file contain details of multiple... (2 Replies)
Discussion started by: jhon
2 Replies
5. Shell Programming and Scripting
I was going write a script from following site.
Unix Shell Script to Execute Oracle SQL Query (link removed)
My configuration setting for oracle XE.
export ORACLE_HOME=/usr/lib/oracle/xe/app/oracle/product/10.2.0/server
export PATH=$PATH:$ORACLE_HOME/bin
export ORACLE_SID=XE
but after... (4 Replies)
Discussion started by: pinga123
4 Replies
6. UNIX and Linux Applications
Hi all,
I don't know how many times I've setup samba shares, but... It's been a while since the last time. The SID UID maps used to always seem random. I.E. if I had to move the data to another box, I'd have to note all of the SID / UID relations and write scripts to convert them on the new... (0 Replies)
Discussion started by: mph
0 Replies
LEARN ABOUT DEBIAN
cvm-pgsql
cvm-pgsql(8) System Manager's Manual cvm-pgsql(8)
NAME
cvm-pgsql - PgSQL module
SYNOPSIS
cvm-pgsql
CREDENTIALS
Pass phrase
DESCRIPTION
This module queries a PgSQL database for the account name, compares the stored pass phrase with the given one using crypt(3).
CONFIGURATION VARIABLES
The server hostname, port, database, username, password, and additional options can be controlled by setting $PGHOST, $PGPORT, $PGDATABASE,
$PGUSER, $PGPASSWORD, and $PGOPTIONS respectively, which are parsed by the PgSQL client library.
CVM_MYSQL_POSTQ (optional)
The SQL query to execute after the credentials have been validated, see cvm-sql(7).
CVM_PGSQL_PWCMP (optional)
The password comparison module to use.
CVM_PGSQL_QUERY (optional)
The SQL query to issue to retrieve the row containing the account information from the database.
SEE ALSO
cvm-sql(7), cvm-mysql(8), cvm-pwfile(8), cvm-qmail(8), cvm-unix(8), cvm-vmailmgr(8), cvm-benchclient(8), cvm-checkpassword(8), cvm-test-
client(8)
http://untroubled.org/pwcmp/pwcmp.html
http://untroubled.org/cvm/cvm.html
cvm-pgsql(8)