[2 days left] What’s wrong with your cloud strategy? Learn why multicloud solutions matter with Nimble Storage.Register Now

x
?
Solved

how to connect pl/sql to a database

Posted on 2011-03-15
8
Medium Priority
?
371 Views
Last Modified: 2014-02-06
i have installed oracle 10g and plsql developer in my system .my operating system is windows 7 .
  Please guide me how to create a database and connect pl/sql to it.
0
Comment
Question by:vijuhansda
[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
8 Comments
 
LVL 77

Accepted Solution

by:
slightwv (䄆 Netminder) earned 100 total points
ID: 35146547
Did you not build a database when you installed Oracle?  Check your services or in task manager look for oracle.exe using a lot of memory.


If you don't have one running, you should have a database configuration assistant in your program groups.  That will let you build a database.
0
 
LVL 77

Expert Comment

by:slightwv (䄆 Netminder)
ID: 35146554
I should verify: you installed the Oracle server and not the client, correct?
0
 
LVL 1

Assisted Solution

by:tropically
tropically earned 100 total points
ID: 35300676
There is a lot to consider in creating a database
But to get you started  on windows

start -> all_programs -> oracle -> configuration and migration tools -> Database Configuration Assistant.

This will guide you through the database creation steps.

Documentation for reading.
http://download.oracle.com/docs/cd/B19306_01/server.102/b14231/create.htm


PlSQL Developer:
Pl/SQL developer prompts you for your login information on startup.
If you have bypassed this, then you can go to   "Sessions" menu bar and select Logon.


Any help let us know.
0
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 
LVL 2

Expert Comment

by:jhacharya
ID: 37356679
when you say you installed 10g? was that the express version from oracle?
0
 
LVL 23

Expert Comment

by:Steve Wales
ID: 39840604
I've requested that this question be closed as follows:

Accepted answer: 25 points for tropically's comment #a35300676
Assisted answer: 25 points for amit_n_panchal's comment #a35365508

for the following reason:

This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
0
 
LVL 77

Expert Comment

by:slightwv (䄆 Netminder)
ID: 39840605
http:#a35365508 is a blind link.  It should not be part of the solution.

http:#a35300676 is a reference to the database configuration assistant which is mentioned in the first post, http:#a35146547

It should be a split between http:#a35146547 and http:#a35300676
0

Featured Post

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.

Question has a verified solution.

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

Working with Network Access Control Lists in Oracle 11g (part 2) Part 1: http://www.e-e.com/A_8429.html Previously, I introduced the basics of network ACL's including how to create, delete and modify entries to allow and deny access.  For many…
From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
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.
This video shows how to copy an entire tablespace from one database to another database using Transportable Tablespace functionality.

656 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