Login or Register to Ask a Question and Join Our Community


UNIX for Dummies Questions & Answers

Oracle on UNIX box

 
Thread Tools Search this Thread
Top Forums UNIX for Dummies Questions & Answers Oracle on UNIX box
# 1  
Old 11-19-2008
Data Oracle on UNIX box
Hi all,
How to find the usage of Oracle database which is on unix box? Specifically I need to where does this Oracle db stores its data. Please help me

Thanks in advance!!!
GeethaSmilie
# 2  
Old 11-19-2008
The installation log may help you. It is generally located at $ORACLE_BASE/oraInventory/logs
# 3  
Old 11-19-2008
Hi,
You could start by reading up on the fine documentation available on the Oracle site where You download it or accompanied with Your install media?

Otherwise I know that Oracle can have some ideas about their own partition, is that what You are thinking about?

/Lakris
# 4  
Old 11-19-2008
Get a list of filenames
Code:
sqlplus -s username@dbname/password << EOF
set pages 0
set feed off

spool t.lis
select FILE_NAME 
   from DBA_DATA_FILES;
exit
EOF

# 5  
Old 11-20-2008
Thanks JIM Smilie
 
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

How to COnnect to Oracle database from UNIX Box

I am trying to connect to Oracle Databse from UNIX box using sqlplus command. But i get sqplus not found message. $ sqlplus sqlplus: not found I have searched in forums and all are suggesting to set environment varaibles...can somebody tell me what variables to set and how to set.and the... (12 Replies)
Discussion started by: angelarosh
12 Replies

2. Shell Programming and Scripting

ftp file starting with particular name on Windows box to Unix box using shell script

Hello all ! I'm trying to write a shell script (bash) to ftp a file starting with particular name like "Latest_" that is present on a Windows box to UNIX server. Basically I want to set this script in the cron so that daily the new build that is posted on the Windows box can be downloaded to the... (2 Replies)
Discussion started by: vijayb4u83
2 Replies

3. UNIX for Advanced & Expert Users

Copy file from unix box to another unix box

Hi, I am new for perl scripting, I need a script to copy a log file /test/test_yyyymmdd.dat from one unix box to another unix box location /check/check1/ at daily 2:00AM, please let me know how to do that...... Regards, Ann (8 Replies)
Discussion started by: fabrine
8 Replies

4. Shell Programming and Scripting

how to compare all files in one unix box has been to copied to another unix box

Hi our unix admin has copied all files from one unix box to new unix box. We just need to confirm that all the file systems are copied properly. How to validate. (9 Replies)
Discussion started by: sravanreddym
9 Replies

5. UNIX for Dummies Questions & Answers

I need an scp command from a unix box to a windows box.

scp file="myfile.txt" todir="user@somehost:(M:drive:/somepath/)"/ Not sure I need it to go to a specific drive on the windows box (1 Reply)
Discussion started by: xgringo
1 Replies

6. Shell Programming and Scripting

Moving files from Unix box to a windows box

Hi All, I need a little help .I want to transfer a file from unix box to a windows box,but the problem i'm facing is that in windows box FTP is not enabled and currently it is nearly impssible to change setting on windows box,i can not use the ftp method ,in my shell script to transfer the file.... (2 Replies)
Discussion started by: Preet
2 Replies

7. UNIX for Dummies Questions & Answers

Running UNIX commands remotely in Windows box from Unix box – avoid entering password

I am able to run the UNIX commands in a Windows box from a UNIX box through "SSH" functionality. But whenever the SSH connection is established between UNIX and Windows, password for windows box is being asked. Is there a way to avoid asking password whenever the SSH connection is made? Can I... (1 Reply)
Discussion started by: D.kalpana
1 Replies

8. UNIX for Dummies Questions & Answers

Not able to install Oracle Workgroup Server on SCO Unix 5.0.2 box

After having to replace a video card and having a corrupt root directory, I had to wipe out and reinstall my SCO OpenServer Enterprise System 5.0.2. because nothing would work for the root password. I am now trying to reinstall the Oracel Workgroup Server SCO v7.1.5.2 and it tells me I need to... (1 Reply)
Discussion started by: sheilaj1
1 Replies

9. UNIX for Advanced & Expert Users

How to FTP a file generated at UNIX Box to NT Box

Hi all, I am generating a file on the Unix machine , now i want to FTP the same file to the NT machine. how can i do that and the application currently upon which i am working is a JAVA based application. I need your help. regards Ruchir (2 Replies)
Discussion started by: Ruchir
2 Replies

10. UNIX for Advanced & Expert Users

VPN client (windows Box),and Server (Unix Box)

If I want to access unix box via VPN tunnel,from windows box. What sould I configure on the windows client PC, and what should I enable on the Unix Server box ? I am using Solaris V10 intel platform, and I am using windows XP, and 2003 for client (0 Replies)
Discussion started by: zillah
0 Replies
Login or Register to Ask a Question