Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Accessing Oracle DB via Shell possible ?
Operating Systems AIX Accessing Oracle DB via Shell possible ? Post 302254279 by zaxxon on Tuesday 4th of November 2008 04:56:16 AM
Old 11-04-2008
AIX 4.2 ... that's old. You got 2 things? You want
a) create/update tables
b) accumulate data and copy it to an Excel sheet


For a)
You did not say what Oracle version you use, but 8 has sqlplus. Not sure if former versions had this tool too. You should look for something like sqlplus on your version and start using this, when you want to be on the shell.

For b)
When you have sqlplus or the sqlplus similar tool, extract the data into a file on your AIX box with an appropriate SQL-query and if that's not enough, maybe work it with shell/awk/sed etc.
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Shell script for accessing a file in the network drive and invoking oracle sql loader

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

accessing unix variables in oracle

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

Accessing aliases within a shell script

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

Problem accessing Oracle Directory on 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

Accessing awk array from shell

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

Accessing arrays in shell scripts

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

Accessing Oracle via encrypted password

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

Oracle accessing from remote host

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

Password Expiry while accessing Oracle table

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

Problem in accessing Oracle Database Server from Linux Machine

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 DEBIAN

make-sqldeveloper-package

MAKE-SQLDEVELOPER-PACKAGE(1)			    Oracle SQL Developer Debian package builder 		      MAKE-SQLDEVELOPER-PACKAGE(1)

NAME

       make-sqldeveloper-package - Oracle SQL Developer Debian package builder

SYNOPSIS

       make-sqldeveloper-package [options] <file>

DESCRIPTION

       make-sqldeveloper-package is a utility that builds a Debian package for Oracle SQL Developer.

       The  Oracle  SQL Developer program is governed by the copyright holder (Oracle USA, Inc.), so you may be limited as to what you can do with
       the resulting package (i.e. no redistribution, etc). This utility will simply help you create the Debian package, it is your responsibility
       to  use	the  resulting package acordingly with the OTN license, a copy of which is included in the created package, that you must agree on
       when downloading the source.

       This utility will require you to download the "Oracle SQL Developer  for  other	platforms"  archive  from  <http://www.oracle.com/technet-
       work/developer-tools/sql-developer/> to create the Debian package from.

OPTIONS

       -b|--build-dir <dir>
	      base directory to build package (autogenerated)

       -e|--email <email>
	      local maintainer email (use DEBEMAIL or auto-generate)

       -i|--install
	      install the generated package - needs root privilege (no)

       -k|--keep-dir
	      keep the build directory (no)

       -l|--revision <number>
	      local revision to append to package version (1)

       -m|--maintainer <name>
	      local maintainer name (use DEBFULLNAME or leave empty)

       -r|--root-command <command>
	      command to gain root privilege for package build (fakeroot)

       -u|--upstream-version <version>
	      force the upstream version (autodetected)

       -h|--help
	      display the help screen

       -v|--version
	      show the program version

       <file> the "Oracle SQL Developer for other platforms" archive from <http://www.oracle.com/technetwork/developer-tools/sql-developer/>

AUTHOR

       make-sqldeveloper-package was written by Lazarus Long <lazarus.long@bigfoot.com>.

       This manual page was written by Lazarus Long <lazarus.long@bigfoot.com>, for the Debian project (but may be used by others).

GNU
								    2012-11-13					      MAKE-SQLDEVELOPER-PACKAGE(1)
All times are GMT -4. The time now is 07:26 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy