Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

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

Posted on 2012-03-24
6
Medium Priority
?
1,175 Views
Last Modified: 2012-06-27
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
Comment
Question by:chaitu chaitu
[X]
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
6 Comments
 
LVL 23

Assisted Solution

by:David
David earned 400 total points
ID: 37760874
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
 
LVL 16

Assisted Solution

by:Wasim Akram Shaik
Wasim Akram Shaik earned 400 total points
ID: 37761400
---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
 
LVL 1

Expert Comment

by:tdthoa
ID: 37762193
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
Veeam Task Manager for Hyper-V

Task Manager for Hyper-V provides critical information that allows you to monitor Hyper-V performance by displaying real-time views of CPU and memory at the individual VM-level, so you can quickly identify which VMs are using host resources.

 
LVL 20

Author Comment

by:chaitu chaitu
ID: 37762670
"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
 
LVL 1

Expert Comment

by:tdthoa
ID: 37762705
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
 
LVL 77

Accepted Solution

by:
slightwv (䄆 Netminder) earned 1200 total points
ID: 37763930
>>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

Featured Post

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.

Question has a verified solution.

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

This article started out as an Experts-Exchange question, which then grew into a quick tip to go along with an IOUG presentation for the Collaborate confernce and then later grew again into a full blown article with expanded functionality and legacy…
Have you ever had to make fundamental changes to a table in Oracle, but haven't been able to get any downtime?  I'm talking things like: * Dropping columns * Shrinking allocated space * Removing chained blocks and restoring the PCTFREE * Re-or…
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
This video shows how to copy an entire tablespace from one database to another database using Transportable Tablespace functionality.

636 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