Solved

Access Oracle Database accross different server

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

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

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…
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…

747 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

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now