Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: How to access Oracle table using sqlplus
Special Forums UNIX and Linux Applications How to access Oracle table using sqlplus Post 302206315 by robotronic on Tuesday 17th of June 2008 12:52:38 PM
Old 06-17-2008
Your request isn't clear. I've understood that you have two servers, server1 and server2. On both of them there's installed an Oracle Database Server.

Regardless of the server from which you are invoking sqlplus, the destination database is determined by the last part of the connect string, that is "@dns1".

This alias is translated into four pieces of information:
- Destination address of the remote server
- Destination port (default: 1521)
- Protocol (usually TCP)
- Service Name or SID of the remote database

Assuming you're using local naming method, all these informations are stored in a file called "tnsnames.ora", that by default resides in "$ORACLE_HOME/network/admin" of the server from which you are invoking sqlplus.

Look into it and search for the entry called "dns1": here you can verify which is the real destination db server you're connecting to.

If you need to connect to the other server, you need another entry in this file, pointing to the second destination server.
 

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

LEARN ABOUT ULTRIX

ntp.conf

ntp.conf(5)							File Formats Manual						       ntp.conf(5)

Name
       ntp.conf - Network Time Protocol configuration file

Description
       The  file  is the configuration file for the Network Time Protocol (NTP) daemon, This file must be configured on your system before running
       Any host names that you specify in the file must have an entry in the file, or an entry in the master database, if the  database  is  being
       served to your system by BIND/Hesiod or Yellow Pages.

       The file has four entry formats:

       trusting no
	    This entry guarantees that your system synchronizes only to the NTP servers identified in the peer and server entries specified.  Dig-
	    ital recommends that all systems include the entry.

       peer server
	    This entry identifies server as one of the NTP servers that your system trusts, and from which your system will accept  time  synchro-
	    nization.	 Your  system  may  also  provide time synchronization to this server.	Servers can be identified by host name or internet
	    address.

	    NTP servers should be configured with entries.

       server server
	    This entry identifies server as one of the NTP servers that your system trusts, and from which your system will accept  time  synchro-
	    nization.	Your  system  can  not	provide  time  synchronization to this server.	Servers can be identified by host name or internet
	    address.

	    NTP clients should be configured with entries.

       peer   /dev/null       LOCL    1       -5      local
	    This entry identifies your system as a local reference clock.  A local reference clock is the most accurate system clock available	at
	    your  site.   If you receive time synchronization from the Internet NTP service, you should not include this entry on any of your sys-
	    tems.  At most, one system in a set of nodes running should be identified as a local reference clock.

	    A host which specifies this entry should not specify any or entries.

Examples
       This is a sample configuration file for an NTP client which receives time synchronization from the NTP servers: and Lines beginning with  a
       number sign (#) are comments.
       #
       #	       NTP  Configuration File
       #	This file is mandatory for the ntpd daemon
       #
       #
       #
       #   **  A L L  **
       #
       #  "trusting no" prevents this host from synchronizing
       #   to any host that is not listed below.  It is recommended
       #   that all hosts include the line "trusting no".
       #
       trusting no
       #
       #
       #    **	S E R V E R  **
       #
       #  If you are configuring a server, use "peer" entries to
       #  synchronize to other NTP servers.  For example, server1,
       #  server2, and server3.
       #
       #peer	      server1
       #peer	      server2
       #peer	      server3
       #
       #
       #
       #
       #    **	C L I E N T  **
       #
       #  If you are configuring a client, use "server" entries to
       #  synchronize to NTP servers.  For example, server1, server2,
       #  and server3.
       #
       server	      server1
       server	      server2
       server	      server3
       #
       #
       #
       #    **	L O C A L   R E F E R E N C E	C L O C K  **
       #
       #  If you are configuring a local reference clock, include the
       #  following entry and the "trusting no" entry ONLY.
       #
       #peer	 /dev/null LOCL 1    -5   local
       #

See Also
       ntp(1), ntpd(8), ntpdc(8)
       RFC 1129--Internet time synchronization:  The Network Time Protocol
       Introduction to Networking and Distributed System Services

																       ntp.conf(5)
All times are GMT -4. The time now is 09:33 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy