Go Premium for a chance to win a PS4. Enter to Win


Remote Logins to Oracle 11g database

Posted on 2011-02-28
Medium Priority
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
  • 3
  • 3
  • 2

Accepted Solution

Chakravarthi Ayyala earned 1000 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 78

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.

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.


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 78

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 78

Assisted Solution

by:slightwv (䄆 Netminder)
slightwv (䄆 Netminder) earned 1000 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

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Question has a verified solution.

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

I remember the day when someone asked me to create a user for an application developement. The user should be able to create views and materialized views and, so, I used the following syntax: (CODE) This way, I guessed, I would ensure that use…
Background In several of the companies I have worked for, I noticed that corporate reporting is off loaded from the production database and done mainly on a clone database which needs to be kept up to date daily by various means, be it a logical…
This video shows setup options and the basic steps and syntax for duplicating (cloning) a database from one instance to another. Examples are given for duplicating to the same machine and to different machines
This video shows how to Export data from an Oracle database using the Original Export Utility.  The corresponding Import utility, which works the same way is referenced, but not demonstrated.
Suggested Courses

916 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