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?
LVL 20
chaitu chaituAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Oracle Database

From novice to tech pro — start learning today.

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.