|
|
Sponsored Content
Operating Systems
AIX
Accessing Oracle DB via Shell possible ?
Post 302254307 by cero on Tuesday 4th of November 2008 06:01:39 AM
11-04-2008
sqlplus was available in Oracle 7 too 
Under the assumption, that the collected data is in same format all time,I'd approach this task like this:
- Create the tables using your favorite db-tool (be it sqlplus or whatever) once. Creating tables periodically is usually bad practice.
- Use sqlloader to insert your data into your table periodically via cron. You could use sqlplus and here-docs too, but that might be tricky - depending on your data.
- Write a commandscript for sqlplus that creates a CSV-file or any other excel-readable format to present your data.
This links may help you with the commandline tools oracle provides:
SQL*Loader
SQL*Plus
Under the assumption, that the collected data is in same format all time,I'd approach this task like this:
- Create the tables using your favorite db-tool (be it sqlplus or whatever) once. Creating tables periodically is usually bad practice.
- Use sqlloader to insert your data into your table periodically via cron. You could use sqlplus and here-docs too, but that might be tricky - depending on your data.
- Write a commandscript for sqlplus that creates a CSV-file or any other excel-readable format to present your data.
This links may help you with the commandline tools oracle provides:
SQL*Loader
SQL*Plus
|
|
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi,
Please let me know if anybody is having a solution handy for the below tasks...
It would be helpful if somebody can resolve my query. I am new to unix and oracle environment and looking for some online reference for completing a task.
Task:
Check if the network drive exists
Check... (0 Replies)
Discussion started by: sayydevara
0 Replies
2. Programming
Hi,
consider the following script.
ip='***.***.**.**'
user='****'
pw='******'
ftpresults=`ftp -nv $ip<<EOF
user $user $pw
cd /home/oracle/practice
size $1
bye
EOF`
fname=$1
echo $ftpresults
sqlplus -s tms/tms@dev45 <<"EOF"
insert into remote_file_sizes (file_name,file_size)... (1 Reply)
Discussion started by: ravi raj kumar
1 Replies
3. Shell Programming and Scripting
I am not able to access the aliases in my environment within a Python script. If I pass the alias to os.system(), I get a message saying "sh: x: not found". I've tried sourcing my .bashrc file in the script, but this does not work. I would perfer not to source my or any rc file because this... (9 Replies)
Discussion started by: cooldude
9 Replies
4. AIX
What are we doing ?
1) We ftp a PDF file to Oracle Directory which is on AIX server, using Business Object Server. The ftp account we use is prmtftdv. The oracle directory is owned by "oracle" account on aix. The default file permission is 640.
2) We are trying to read the PDF file using oracle... (1 Reply)
Discussion started by: ssatyaranga
1 Replies
5. Shell Programming and Scripting
Hi,
i want awk to read a file and place it's content into two arrays. When trying to read these arrays with a "for a in ${source_path} "-Loop it gives the right result. But when trying to access directly (/bin/echo ${source_path}) it doesn't work.
I read "all "the awk threads in this forum and... (6 Replies)
Discussion started by: bateman23
6 Replies
6. Shell Programming and Scripting
Hi All,
I have an array in my script.
For example,
array=(file1.xml,file1-summary.xml,file2.xml,file2-summary.xml,file3.xml,file3-summary.xml);
I am accessing the elements of the array by using the following code.
len=${#array
};
while ; do
echo "${array}"
done
I want... (1 Reply)
Discussion started by: ananddr
1 Replies
7. UNIX and Linux Applications
Actually in my application there is an XML file. The password and the user name for the database that I need to access the development box is stored there.
But using some UNIX command I am able to access the raw content of the file and not the decrypted code for that password. When I am applying... (3 Replies)
Discussion started by: nandumishra
3 Replies
8. Programming
i have installd oracle 10 on Solaris 10 now i want to access this database from remote machine.
-bash-3.00$ tnsping 192.168.92.49
TNS Ping Utility for Solaris: Version 10.2.0.2.0 - Production on 17-DEC-2010 21:06:51
Copyright (c) 1997, 2005, Oracle. All rights reserved.
Used parameter... (23 Replies)
Discussion started by: akhaliq22
23 Replies
9. Shell Programming and Scripting
Hi All,
I am not able to access an oracle table even if the table is present. After initial analysis, found that there is a password warning for the specified oracle user. Can you please help me in ignoring the password expiry and access the oracle table ? However, the log file does not store the... (4 Replies)
Discussion started by: tapan8984
4 Replies
10. Linux
I am facing a strange issue in connecting to Oracle database from Linux Machine
- The connectivity is not failing all the time , the failure to success ratio is 1:70.
- Error "ORA-12545: Connect failed because target host or object does not exist"
- Majority of the time the connection... (6 Replies)
Discussion started by: balaji kumar
6 Replies
LEARN ABOUT CENTOS
abrt-retrace-client
ABRT-RETRACE-CLIEN(1) ABRT Manual ABRT-RETRACE-CLIEN(1) NAME
abrt-retrace-client - Handles the communication with Retrace server. SYNOPSIS
abrt-retrace-client <operation> [options] DESCRIPTION
This tool is able to communicate with Retrace server: create a new task, ask about task's status, download log or backtrace of a finished task. Integration with libreport events abrt-retrace-client can be used as an analyzer for application crashes which dump core. Example usage in report_event.conf: EVENT=analyze analyzer=CCpp abrt-retrace-client OPERATIONS
create Creates a new task. Prints task ID and password to stdout. Either -d or -c is required. status Prints task's status to stdout. Both -t and -p are required. log Prints finished task's log to stdout. Both -t and -p are required. backtrace Print finished task's backtrace to stdout. Both -t and -p are required. batch Runs all operations in one step: creates a new task, periodically asks for status (the period is specified by --status-delay option) and downloads the result when finished. If the task was successful backtrace file is saved, otherwise log is printed to stdout. Either -c or -d is required. OPTIONS
-v, --verbose be verbose -s, --syslog log to syslog -k, --insecure allow insecure connection to retrace server --url URL retrace server URL --headers (debug) show received HTTP headers -d, --dir DIR read data from ABRT problem directory -c, --core COREDUMP read data from coredump -l, --status-delay delay for polling operations (seconds) --no-unlink (debug) do not delete temporary archive created in /tmp -t, --task ID ID of the task on server -p, --password PWD password of the task on server AUTHORS
o ABRT team abrt 2.1.11 06/18/2014 ABRT-RETRACE-CLIEN(1)