Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

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

how to connect pl/sql to a database

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
vijuhansda
Asked:
vijuhansda
2 Solutions
 
slightwv (䄆 Netminder) Commented:
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
 
slightwv (䄆 Netminder) Commented:
I should verify: you installed the Oracle server and not the client, correct?
0
 
tropicallyCommented:
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
Veeam and MySQL: How to Perform Backup & Recovery

MySQL and the MariaDB variant are among the most used databases in Linux environments, and many critical applications support their data on them. Watch this recorded webinar to find out how Veeam Backup & Replication allows you to get consistent backups of MySQL databases.

 
Jayesh AcharyaTechnichal ConsultantCommented:
when you say you installed 10g? was that the express version from oracle?
0
 
Steve WalesSenior Database AdministratorCommented:
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
 
slightwv (䄆 Netminder) Commented:
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

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

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