Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

Is it possible to get the database details in UNIX?

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Is it possible to get the database details in UNIX?
# 1  
Old 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,
# 2  
Old 06-30-2013
You can check configuration file: tnsnames.ora

This file normally resides in the $ORACLE_HOME/network/admin directory.
# 3  
Old 06-30-2013
Possibly no. You need to contact admins/dba's to get those details.
Username and password are not stored anywhere in config files (at least client config) so you cant guess. instead host,sid and port does store.
# 4  
Old 07-01-2013
Quote:
Originally Posted by clx
Possibly no. You need to contact admins/dba's to get those details.
Username and password are not stored anywhere in config files (at least client config) so you cant guess. instead host,sid and port does store.
You misread OP's requirement. OP does have a username and password. Now OP is interested in knowing the hostname, SID and the port.
# 5  
Old 07-01-2013
I read it correct but its possible that I misunderstood the requirement. So you might be right.

My assumption was, if OP doesn't know the Host, SID and Port how can he figure out the database details from tnsnames.ora since there is no mapping with user-name out there.
# 6  
Old 07-01-2013
Thanks Yoda. This is all i need. I already have the username and password.
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. UNIX for Beginners Questions & Answers

Generic script to load file details(ls -ltr) in to a database.

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

2. Shell Programming and Scripting

How to log file processing details to database table usnig UNIX shell script?

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

3. UNIX for Dummies Questions & Answers

at -l doesnt give details of the scheduled job. How to get the details?

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

4. UNIX for Advanced & Expert Users

UNIX / LINUX OS CPU configuration details

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

5. UNIX for Dummies Questions & Answers

how to check SMTP server details on Unix

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

6. Shell Programming and Scripting

Disk space details from Unix to Outlook

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

7. UNIX for Dummies Questions & Answers

unix path details

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

8. Filesystems, Disks and Memory

how to find out unix server details

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

9. UNIX for Dummies Questions & Answers

Unix Database

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

10. UNIX for Dummies Questions & Answers

IP details for Unix/Linux login clients?

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
Login or Register to Ask a Question