Solved

Access Oracle Database accross different server

Posted on 2001-07-26
4
190 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
  • 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

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

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

Hello fellow BSD lovers, I've created a patch process for patching openjdk6 for BSD (FreeBSD specifically), although I tried to keep all BSD versions in mind when creating my patch. Welcome to OpenJDK6 on BSD First let me start with a little …
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…
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
In a previous video, we went over how to export a DynamoDB table into Amazon S3.  In this video, we show how to load the export from S3 into a DynamoDB table.

825 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