Solved

Access Oracle Database accross different server

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

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
reinstall 1 92
unix in java example 9 78
looking for unix program to search some keywords in side EAR WAR and JAR files 10 111
SSH to Solaris server (which uses NIS) 1 21
Let's say you need to move the data of a file system from one partition to another. This generally involves dismounting the file system, backing it up to tapes, and restoring it to a new partition. You may also copy the file system from one place to…
Java performance on Solaris - Managing CPUs There are various resource controls in operating system which directly/indirectly influence the performance of application. one of the most important resource controls is "CPU".   In a multithreaded‚Ķ
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.

730 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