Solved

Access Oracle Database accross different server

Posted on 2001-07-26
4
192 Views
Last Modified: 2013-12-27
I would like to access Oracle v7.x Database which is sitting in Sun Solaris 2.6 from a different server which is Sun Sparc 5.7,
what are the setting that I need to setup in order for me to access the database thru a login into Sun Sparc 5.7?
/etc/hosts? /etc/services? sqlhosts? or any files in network/admin?

I managed to access Oracle v8.x Database which is sitting at the same server (which is Sun Sparc 5.7) by setting the .profile add on the ORACLE_BASE, ORACLE_SID, ORACLE_DOC & ORACLE_HOME.
0
Comment
Question by:cmlee0789
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
4 Comments
 
LVL 5

Expert Comment

by:paulqna
ID: 6322298
You can add an entry in your tnsnames.ora (and make sure all parameters are correct). Next is to connect to the instance like :

as a dba user (not root)

$ ORACLE_SID=SIDINTNSNAMESDOTORA
$ sqlplus user/pass

and do a

SQL> select * from v$instance

to make sure you've connected to the correct database.
0
 
LVL 9

Expert Comment

by:dbalaski
ID: 6332866
This is easy to do -- please assign some points to the question and I'll be happy to explain the answer.

dBalaski
0
 
LVL 2

Expert Comment

by:Kong
ID: 6336782
Edit the file: $ORACLE_HOME/network/admin/tnsnames.ora add the required information, you could get away with copying and pasting the info in the tnsnames.ora file in your Sol 2.6 box. eg:

orcl =
 (DESCRIPTION =
        (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.1)(PORT = 1521))
        (CONNECT_DATA = (SID = orcl))
 )
0
 
LVL 2

Accepted Solution

by:
Kong earned 90 total points
ID: 6336787
For clarification, I meant editing the file in the Sol 2.7 box...
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Using libpcap/Jpcap to capture and send packets on Solaris version (10/11) Library used: 1.      Libpcap (http://www.tcpdump.org) Version 1.2 2.      Jpcap(http://netresearch.ics.uci.edu/kfujii/Jpcap/doc/index.html) Version 0.6 Prerequisite: 1.      GCC …
Every server (virtual or physical) needs a console: and the console can be provided through hardware directly connected, software for remote connections, local connections, through a KVM, etc. This document explains the different types of consol…
Learn how to get help with Linux/Unix bash shell commands. Use help to read help documents for built in bash shell commands.: Use man to interface with the online reference manuals for shell commands.: Use man to search man pages for unknown command…
Learn how to navigate the file tree with the shell. Use pwd to print the current working directory: Use ls to list a directory's contents: Use cd to change to a new directory: Use wildcards instead of typing out long directory names: Use ../ to move…

691 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question