Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1241
  • Last Modified:

can i connect to locahost and user as scott in Oracle 11g client

Oracle 11g client was installed in my office PC.can i connect to locahost(as host) and user as scott/tiger and write SQL queries?If yes what is the procedure do i need to follow?
0
chaitu chaitu
Asked:
chaitu chaitu
3 Solutions
 
DavidSenior Oracle Database AdministratorCommented:
Regretfully no.  The Client installation provides a number of utilities and scripts that are useful when connected to a database instance -- but the "server" side software has to be installed, configured, and started / opened somewhere.  That said, many people will install the lite or personal db version on one's PC, in order to practice SQL queries.
0
 
Wasim Akram ShaikCommented:
---can i connect to locahost(as host) and user as scott/tiger??

Can you brief this more, what are you trying to do?? do you mean to say you want to connect to the oracle 11g client using the user scott/tiger and want to practice there???

if your company allows you to do so, then you can go ahead and do it..

for practising as dvz suggested, download the software from oracle site and use it.. then it will be your own property and you don't have to seek any others permission to do any changes..!!!

for connecting to a database and practising/working the better option would be a Toad or SQL Developer, as you would get a gui rather than the SQL* Plus, which is little bit tedious to work out with as it doesn't have a good gui..
0
 
tdthoaCommented:
You can use Easy Connect Naming
* Is enabled by default
* Requires no client-side configuration
* Support only TCP/IP (no SSL)
* Offers no support for advanced connection options such as:
  - Connect-time failover
  - Source routing
  - Load balancing
SQL> CONNECT scott/tiger@{ComputerName/IP}:1521/orcl
0
Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
chaitu chaituAuthor Commented:
"Can you brief this more, what are you trying to do?? do you mean to say you want to connect to the oracle 11g client using the user scott/tiger and want to practice there???"

yes;

"for practising as dvz suggested, download the software from oracle site and use it"
Can you give download url and what is the size?

"for connecting to a database and practising/working the better option would be a Toad or SQL Developer"

by installing oracle 11g client by default SQL Developer was installed to practise SQL queries.

I need some DB user or instance to practise SQL queries.

when i connect to scott/tiger@localhost in SQL developer am getting network adapter cannot connected to localhost.
0
 
tdthoaCommented:
if you connect to remote database in server machine from client side by SQL Developer, you use server's IP , don't use localhost.
0
 
slightwv (䄆 Netminder) Commented:
>>I need some DB user or instance to practise SQL queries.

Like mentioned above but phrased differently:  The client does not create a database.  You need a database to connect to to run queries.

If you have a local database running on your PC, you did not need to install a separate client.

If you do not have a database on another machine to play with, you need a database created somewhere.

I would suggest OracleXE.  It is free and fairly easy to install:
http://www.oracle.com/technetwork/products/express-edition/downloads/index.html?ssSourceSiteId=ocomen
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now