Sponsored Content
Top Forums UNIX for Advanced & Expert Users Connect to database through FTP server Post 302956733 by sparks on Friday 2nd of October 2015 03:19:39 PM
Old 10-02-2015
Connect to database through FTP server

Hi All

I need to run a query on a remote database through a shell script. I have the query, I have the script ready. I have the details of the database server I need to connect to.
Now my problem here is , the server where I run the shell script is an FTP server.
->I do not have Oracle installed on it.
->when I execute sqlplus command - says no command found

How do I connect to the database and run the query? I searched forms but all the servers in question have oracle installed. But I don't have on mine.

I have the username and password, Port, Hostname, IP. So is there a way I can connect to the database and execute my query ?

FTP Linux server : GNU/Linux
Database : Oracle

Any help is much appreciated!!

Thanks in Advance!
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

ftp script not able to connect to ftp server.

I have the following ftp script to get files from a remote location. However, on running the script I find that I am not even able to connect to ftp server. I am able to connect to ftp server using other GUI ftp tools like WS_FTP using the same IP. IP used here is a dummy IP. What can go... (3 Replies)
Discussion started by: gram77
3 Replies

2. AIX

ftp connect in passive mode , ftp settings

how to connect to ftp server in passive mode? ftp server.abc and how can i see ftp settings, doesn't exist some ftpd.conf there is some other file where i check the options and configurations of ftp server? Thanks (3 Replies)
Discussion started by: prpkrk
3 Replies

3. Shell Programming and Scripting

How to connect to FTP server which requires SSL authentication?

Hello, I tried searching through lot of threads for a solution but couldn't fetch the exact solution, so I am creating a new thread. I am trying to connect to a FTP server 1) using a simple FTP command, it gives the error : 534 Policy requires SSL. Login failed. 2) using SFTP... (19 Replies)
Discussion started by: amitshete
19 Replies

4. UNIX for Advanced & Expert Users

Unable to use FTP command to connect from one server to another

Hi, I have two unix servers A and B. from A i am trying to use the ftp command to connect to B but I am getting the "ftp: connect: A remote host refused an attempted connect operation." I checked the following things : 1.) Unix Server details for A and B after running the command uname -a... (3 Replies)
Discussion started by: mick_000
3 Replies

5. Linux

Generate public key to connect from one ftp server to other server

How to generate public key to connect from one ftp server to other server to use in scripting. (0 Replies)
Discussion started by: sridhardwh
0 Replies

6. UNIX for Advanced & Expert Users

Public key to connect from one ftp server to other server

How to generate public key to connect from one ftp server to other server to use in scripting. (1 Reply)
Discussion started by: sridhardwh
1 Replies

7. Linux

Unable to connect to Server machine from a client machine using ftp service

Hi, Could you please help me with the below issue.. I'm running RHEL6 OS on both server (192.168.0.10) and client machines (192.168.0.1). I'm trying to connect to server from the client machine using ftp service. I have installed vsftpd daemon on both the machines. I'm getting... (4 Replies)
Discussion started by: raosr020
4 Replies

8. Shell Programming and Scripting

Connect to FTP find files and export them to another server

Hi I'm trying to make script that will connect to FTP Server than find files that contain word HIGH in name and than export them to another server. Can anyone tell me if something like this is possible? Thanks :) (7 Replies)
Discussion started by: steve87bg
7 Replies

9. Shell Programming and Scripting

Not able to connect to new FTP server

Hi All, We have done new FTB setup. I am not able to to connect to this new target server. Here is the new setup to send files to the FTB : - Login : FTB-TAN-DEV-SAP - Protocol : SFTP - Port : 54322 - Hostname : ftb-dev.apj.hp - Env : DEV - Target ID : 3225 I tried connecting to the... (5 Replies)
Discussion started by: ROCK_PLSQL
5 Replies

10. AIX

Connect to database server and execute sql

I have a requirement and below is the detail. Create a shell script and needs to run in server "a". Connect to teradata database server "b". execute the .sql file from server "a" Save the output of the query to a file in server "a" Schedule this shell script to run every day for every 4... (1 Reply)
Discussion started by: MadhuSeven
1 Replies
ccr(8)							      System Manager's Manual							    ccr(8)

Name
       ccr - remote console carrier requester

Syntax
       ccr [ options ] node

Description
       The  command  establishes  a logical connection between your ULTRIX system and the console carrier server on a remote system.  enables your
       terminal to act as the console for a remote unattended system.  For example, your terminal can act as the console for  a  Digital  Ethernet
       Communications Server (DECSA) and its resident software.  The node is the name or address of the target node.  A node name consists of from
       one to six alphanumeric characters.  A node address consist of two decimal integers (n.n), where the first  indicates  the  network  number
       (1-63), and the second indicates the node address (1-1023).

       You  can  use  to  force  a  crash if a server node becomes unresponsive.  To determine how to force a crash, see the documentation for the
       respective server product.

       The requirements for using are as follows:

       o   The host node (that is, your local ULTRIX node) and the remote node must be on the same Ethernet.

       o   If your server product is a DECSA, the console carrier server image (plutocc.sys) and its loader file (plutowl.sys) must be located	in
	   on  your  ULTRIX node. The pluocc.sys and plutowl.sys files are not need, nor is any loading done for other servers.  For more details,
	   see the installation guide for the particular server product.

       <CTRL/D> exits from console carrier mode and terminates

Options
       -c   Uses the specified circuit to connect to the target node.

       -h   Uses the specified address (next argument) as the Ethernet address of the target node.

       -n   Uses the next argument as the target node ID.

       -p   Uses the specified service password (next arguments) in accessing the target node.

Examples
       # /etc/ccr -c qna-0 -n dallas <RET>
       ccr: Remote console reserved
	    .
	    .
	    .
       <CTRL/D>
       ccr: Remote console released
       #

Restrictions
       You must have superuser privileges to run

Diagnostics
       The command can return the following diagnostic messages:

       ccr: Remote console reserved
       The command has successfully connected to the remote console server and your terminal is now capable of acting as a console for the  remote
       node.

       ccr: Remote console released
       Your connection with the remote console server has been terminated and you are no longer in console carrier mode.

       ccr: Remote console already in use
       The remote console server that you are attempting to connect to is already reserved by another user.

       ccr: Permission denied
       You do not have the necessary privileges to run (You must be a superuser.)

       ccr: Hardware address required
       The  command  is unable to locate the hardware address of the remote node to which you are attempting to connect.  A remote node's hardware
       address must be defined either in the command line, or in its nodes database entry.  (Nodes database entries are defined with the command.)

       ccr: No node entry in database
       The command does not recognize the remote node to which you are attempting to connect, since the node-id that you specified is not  defined
       in the nodes database.  (Nodes database entries are defined with the command.)

Files
       Console carrier server image

       Console carrier server loader

See Also
       addnode(8), getnode(8), load(8), remnode(8), trigger(8)
       Guide to Local Transport Servers

																	    ccr(8)
All times are GMT -4. The time now is 06:51 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy