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?

[Webinar] Streamline your web hosting managementRegister Today

x
 
slightwv (䄆 Netminder)Connect With a Mentor 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
 
DavidConnect With a Mentor Senior 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 ShaikConnect With a Mentor Commented:
---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
The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

 
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
 
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
All Courses

From novice to tech pro — start learning today.