Sponsored Content
Special Forums UNIX and Linux Applications How to access Oracle table using sqlplus Post 302206211 by AngelMady on Tuesday 17th of June 2008 08:43:25 AM
Old 06-17-2008
How to access Oracle table using sqlplus

Hi,

I want to use sqlplus from server1

sqlplus usr1/pass1@dns1

and I want to connect to an Oracle database from a server2.

Unfortunately the database was created on the server1 and on server2.

So when I use the command just like that...it connects to the database from the server2.

Is there a way to connect to the database found on the server2?

thank you in advance for your answers
 

9 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Check the record count in table (table in oracle)

I have requirement: 1) Check the record count in table (table in oracle) 2) If records exists generate the file for existing records and wait for some time (Go to sleep mode) and Again check the record count after 10 min.......... (Loop this process if record count >0). 3) Generate touch... (1 Reply)
Discussion started by: kamineni
1 Replies

2. Shell Programming and Scripting

Check the record count in table (table in oracle)

I have requirement: 1) Check the record count in table (table in oracle) 2) If records exists generate the file for existing records and wait for some time then Go to sleep mode and Again check the record count after 10 min.......... (Loop this process if record count >0). 3) Generate touch... (1 Reply)
Discussion started by: kamineni
1 Replies

3. Shell Programming and Scripting

calling sqlplus, read table return etc

I have korn shell scripts. I want to pass a variable to a script which will execute a a sql script to read a table that contains env. variables. I want to read and then somehow export at unix level variables example for every row selected from the table build export command line field1... (5 Replies)
Discussion started by: TimHortons
5 Replies

4. Shell Programming and Scripting

Formatting Oracle sqlplus output

a job extracts orcle data into unix as flat file. a single record breaks into two record in unix flat file. This is the case only for 6 records out of 60 lack records. (its not single record in two line. but its single record into record. ie., \n come into picture) can you tell me what... (6 Replies)
Discussion started by: Gopal_Engg
6 Replies

5. UNIX for Dummies Questions & Answers

Connecting to Oracle DB using sqlplus

Hi, I am very new to shell scripting and trying to write a simple shell script in which i am trying to achieve the following: 1. Connect to oracle database hosted on a different server 2. fire a query on the oracle db 3. store the output in a variable 4. use this variable for further logic... (1 Reply)
Discussion started by: shrutihardas
1 Replies

6. Shell Programming and Scripting

Connecting to Oracle DB using sqlplus

Hi, I am very new to shell scripting and trying to write a simple shell script in which i am trying to achieve the following: 1. Connect to oracle database hosted on a different server 2. fire a query on the oracle db 3. store the output in a variable 4. use this variable for further logic... (26 Replies)
Discussion started by: shrutihardas
26 Replies

7. Shell Programming and Scripting

Connect to Oracle using sqlplus

I have logged into oracle using SQLPLUS. When I type any kind of query, there is only 1 answer - '2'. What is wrong with it? (1 Reply)
Discussion started by: Subhasis
1 Replies

8. UNIX and Linux Applications

Help in copying table structure to another table with constraints in Oracle

hi, i need to copy one table with data into another table, right now am using create table table1 as select * from table2 i want the constraints of table1 to be copied to table2 also , can anyone give me some solution to copy the constraints also, now am using oracle 10.2.0.3.0... (1 Reply)
Discussion started by: senkerth
1 Replies

9. Shell Programming and Scripting

Truncate table $TABLE -- SQLPLUS

I want to truncate a table using sqlplus where the table name is in shell variable: I am using : sqlplus -s / <<end truncate table $TABLE end (2 Replies)
Discussion started by: IB_88
2 Replies
MONO-SERVER2-ADMIN(8)					User Contributed Perl Documentation				     MONO-SERVER2-ADMIN(8)

NAME
mono-server2-admin - mono-server2 hosts file creator, hosts file is part of the debianized mod_mono package SYNOPSIS
mono-server2-admin.conf [action] [args] OPTIONS Actions: add Use 'add' if you want to create an application and want mono-server2 scripts to manage it del If you want to remove an application Args: --path The path where you have your aspx files, MUST EXISTS!, required only with add action --app The name of your application --libs If you have dlls outside your path, you must use this! --port Needed if you are running multiple virtual hosts in different ports in Apache --vhost If you want to add asp.net support to a virtualhost you must use this. Example: foobar.com DESCRIPTION
mono-server2-admin.conf is a perl tool to adminstrate your ASP.NET webapps that will be executed with mod_mono. When you try to add an application, admin.conf will verify that your path exists, if it is, it will add a directory inside /etc/xsp/conf.d with the name of your app, and also as a file with the filename format: 10_appname. This file will have the information (path, app). So, when mono-xsp-update.conf is executed it will read those dirs and create a debian.webapp in /etc/xsp that the xsp daemon will read, also with a mono-server2-hosts.conf that will have your directory settings with apache directives. Apache will read mono-server2-hosts.conf! AUTHOR
Pablo Fischer <pablo@pablo.com.mx> perl v5.14.2 2012-01-18 MONO-SERVER2-ADMIN(8)
All times are GMT -4. The time now is 01:33 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy