Solved

Access Oracle Database accross different server

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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
create user in TSM 7 590
AIX print queues constantly going down 11 490
UNiX Script filesystem space usage 19 68
Linux hostname change 2 55
Installing FreeBSD… FreeBSD is a darling of an operating system. The stability and usability make it a clear choice for servers and desktops (for the cunning). Savvy?  The Ports collection makes available every popular FOSS application and packag…
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 …
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…
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.

920 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

16 Experts available now in Live!

Get 1:1 Help Now