06-30-2013
Is it possible to get the database details in UNIX?
Hi,
Sorry i can't find what particular forum should i post my question.
I was given a username and password for the database, but i was not given the hostname, SID and the port to were i can connect to with.
Is there a way for me to get the following details in unix, by the way i am using SunOS.
Thanks,
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
Hi there,
I am wondering if by logging in to a unix system, if it is possible to get the IP address of the machine I am connecting FROM.
I know how I can do this using the name server, but is this possible without a host lookup?:confused:
Thanks,
-ghoti (15 Replies)
Discussion started by: ghoti
15 Replies
2. UNIX for Dummies Questions & Answers
Hi :)
I'm a new unix user and i don't know much things about it.At the moment i've to make a work about unix databases.so i decided to come here and ask for help, if someone could tell me about a site or other mean where i can get some information about this i'll be pleased.
Tanks for any... (3 Replies)
Discussion started by: Briga
3 Replies
3. Filesystems, Disks and Memory
I like to find out Server Drive/Storage Specifications like Drive Size?
Storage Type: Local or SAN ?
Number of Processors:
Processor Speed:
Memory:
please someone help me out how I can get from command line?
Thanks you in advance (4 Replies)
Discussion started by: thopputhurai
4 Replies
4. UNIX for Dummies Questions & Answers
Greetings to everyone,
iam a new unix learner. i just jumped from windows to unix.
in my office iam accessing unix machine thro telnet.
i got this path details after executing the following command echo $PATH
/usr/kerberos/bin:/usr/local/bin:/bin:/usr/bin:/usr/X11R6/bin:/home/mipl/bin.
can... (2 Replies)
Discussion started by: vijayq8
2 Replies
5. Shell Programming and Scripting
Hi Friends,
I am using sun Solaris .
I want to find the disk space (df -k) for the Unix box and the data has to be sent to an email id.
Can u please find me a code that checks the disk space 6 times a day, loads the data into an excel sheet and sends to an email id.
Can u also tell me how to... (2 Replies)
Discussion started by: sridharnr
2 Replies
6. UNIX for Dummies Questions & Answers
Hi All,
I am trying to figure out how to check SMTP server details on Unix enviornment?
I tried using
echo "hello" | sendmail -v abc@xyz.com
and got following error:
-bash: sendmail: command not found
-bash: echo: write error: Broken pipe
Any help will be much appreciated regarding... (2 Replies)
Discussion started by: palak08
2 Replies
7. UNIX for Advanced & Expert Users
Hi,
How to find the cpu configuration details of Cores, Speed MHz, virtual processors for the following servers:
LINUX OS Servers:
Linux 2.6.9-89.0.3.ELsmp #1 SMP Sat Jun 13 07:05:54 EDT 2009 i686 i686 i386 GNU/Linux. (Cores, Speed, Processor)
Linux 2.6.18-164.el5 #1 SMP Tue Aug 18... (5 Replies)
Discussion started by: jagtheesh
5 Replies
8. UNIX for Dummies Questions & Answers
I have scheduled couple of shell scripts to run using 'at' command.
The o/p of at -l is:
$ at -l
1320904800.a Thu Nov 10 01:00:00 2011
1320894000.a Wed Nov 9 22:00:00 2011
1320876000.a Wed Nov 9 17:00:00 2011
$ uname -a
SunOS dc2prcrptetl2 5.9 Generic_122300-54 sun4u sparc... (2 Replies)
Discussion started by: superparticle
2 Replies
9. Shell Programming and Scripting
we are getting files on daily basis.we need to process these files.
i need a unix shell script where we can count
1-The no of files processed
2-No of data/record processed for each files.
The script should log these details into a database table. If there is any error while file... (3 Replies)
Discussion started by: Atul kumar
3 Replies
10. UNIX for Beginners Questions & Answers
All,
I am trying to create a report on the duration of an ETL load from the file arrival to the final dump in to a database for SLA's.
Does anyone have any guidance or ideas on how metadata can be extracted; information of a file: like file name, created timestamp, count of records and load... (1 Reply)
Discussion started by: pradeepp
1 Replies
DROPDB(1) PostgreSQL Client Applications DROPDB(1)
NAME
dropdb - remove a PostgreSQL database
SYNOPSIS
dropdb [ option... ] dbname
DESCRIPTION
dropdb destroys an existing PostgreSQL database. The user who executes this command must be a database superuser or the owner of the data-
base.
dropdb is a wrapper around the SQL command DROP DATABASE [drop_database(7)]. There is no effective difference between dropping databases
via this utility and via other methods for accessing the server.
OPTIONS
dropdb accepts the following command-line arguments:
dbname Specifies the name of the database to be removed.
-e
--echo Echo the commands that dropdb generates and sends to the server.
-i
--interactive
Issues a verification prompt before doing anything destructive.
dropdb also accepts the following command-line arguments for connection parameters:
-h host
--host host
Specifies the host name of the machine on which the server is running. If the value begins with a slash, it is used as the directory
for the Unix domain socket.
-p port
--port port
Specifies the TCP port or local Unix domain socket file extension on which the server is listening for connections.
-U username
--username username
User name to connect as.
-w
--no-password
Never issue a password prompt. If the server requires password authentication and a password is not available by other means such as
a .pgpass file, the connection attempt will fail. This option can be useful in batch jobs and scripts where no user is present to
enter a password.
-W
--password
Force dropdb to prompt for a password before connecting to a database.
This option is never essential, since dropdb will automatically prompt for a password if the server demands password authentication.
However, dropdb will waste a connection attempt finding out that the server wants a password. In some cases it is worth typing -W
to avoid the extra connection attempt.
ENVIRONMENT
PGHOST
PGPORT
PGUSER Default connection parameters
This utility, like most other PostgreSQL utilities, also uses the environment variables supported by libpq (see in the documentation).
DIAGNOSTICS
In case of difficulty, see DROP DATABASE [drop_database(7)] and psql(1) for discussions of potential problems and error messages. The
database server must be running at the targeted host. Also, any default connection settings and environment variables used by the libpq
front-end library will apply.
EXAMPLES
To destroy the database demo on the default database server:
$ dropdb demo
To destroy the database demo using the server on host eden, port 5000, with verification and a peek at the underlying command:
$ dropdb -p 5000 -h eden -i -e demo
Database "demo" will be permanently deleted.
Are you sure? (y/n) y
DROP DATABASE demo;
SEE ALSO
createdb(1), DROP DATABASE [drop_database(7)]
Application 2010-05-14 DROPDB(1)