Remote Logins to Oracle 11g database

Posted on 2011-02-28
Last Modified: 2012-05-11
I have a fresh installation of Oracle 11g database on Windows Server 2008. I want the database to be accessed remotely by users (may be via client EM or something else appropriate). Users are expected to fire queries, create table, etc in the tablespace allocated to them. If they are outside campus they must VPN to organization's network.

I have scripts to create logins for the users. What else do I need to do to enable remote login to the database instance xyz?
Question by:pratz09
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
  • 3
  • 3
  • 2

Accepted Solution

Chakravarthi Ayyala earned 250 total points
ID: 35000397
1. either you need to send them a working tns alias and send it to them and ask them to copy the contents of it to thier tnsnames.ora which exists in their ORACLE_HOME/network/admin directory
they should have Oracle client installed so that they would use netca and create a tns alias, in which case you should give them the DB server host name and the port on which the listener is running and the service name registered with the listener.

2. i would test and give them a tns alias
3. make sure your listener is up and running
LVL 77

Expert Comment

by:slightwv (䄆 Netminder)
ID: 35000411
It depends on the 'tool' they are using.

If sql Developer then they just need to know the ipaddress, port and instance name.

If something like sql*plus, then they will need to Oracle client installed and tnsnames.ora file configured properly.

Expert Comment

by:Chakravarthi Ayyala
ID: 35000426
ya. in either case, they need the listener port, server hostname and service name.

Salesforce Has Never Been Easier

Improve and reinforce salesforce training & adoption using WalkMe's digital adoption platform. Start saving on costly employee training by creating fast intuitive Walk-Thrus for Salesforce. Claim your Free Account Now


Author Comment

ID: 35000467
OKay. But I cannot seem find client for Oracle 11g. Can you please point me to the download page if you happen to find it. I thought, since Oracle 11g OEM is web based, wouldn't client OEM be web based too. I tried hitting the OEM URL from different workstation the same Novel Network, it is not able to hit the database.

May be I need to change IPC to TCP/IP  ?
LVL 77

Expert Comment

by:slightwv (䄆 Netminder)
ID: 35000506
All Oracle downloads are on:

The FULL Oracle client is part of the database server download.  The installer provides you the option.

for just simple things like sqlplus and data drivers like ODBC, I would suggest the Instant Client.

For more GUI type things: SQL Developer.


Author Comment

ID: 35000589
Oh, you mean they will have to download the full 2GB Server file and while installation they can choose to install only the client component ? I found this download page, but then I got confused since none of the download file says "client" or "release2" for 11g. Or you mean Oracle 10g release 2 files will do the trick ?
LVL 77

Assisted Solution

by:slightwv (䄆 Netminder)
slightwv (䄆 Netminder) earned 250 total points
ID: 35000617
>>choose to install only the client component ?

It depends on what you need from the client and what you will want them to do.

SQL Developer requires NO CLIENT.

>>but then I got confused since none of the download file says "client" or "release2" for 11g.

11.2 is 11gR2.  11.1 is 11gR1.  Same for 10g.

>>Or you mean Oracle 10g release 2 files will do the trick ?

I don't recall suggesting any version to download.


Author Comment

ID: 35007566
Sorry guys, got busy in something else. I got the solution.

Featured Post

Technology Partners: 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

Note: this article covers simple compression. Oracle introduced in version 11g release 2 a new feature called Advanced Compression which is not covered here. General principle of Oracle compression Oracle compression is a way of reducing the d…
When it comes to protecting Oracle Database servers and systems, there are a ton of myths out there. Here are the most common.
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.
This video shows how to configure and send email from and Oracle database using both UTL_SMTP and UTL_MAIL, as well as comparing UTL_SMTP to a manual SMTP conversation with a mail server.
Suggested Courses

617 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