Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

This is my first time installing Oracle 9i.

I want to create a simple database.

When I go to "Oracle Enterprise Manager Console" and add a database to the tree, I cannot access the database as I don't have a valid username/password.

After a lot of searching, I found that I need to create a new database repository. While I was creating the new repository, it asked for USERNAME, Password, and Service.

username : SYS/sys
Password : change_on_install
service  : <host>:<port>:<SID>
         : SYSDBA

This is not working. I need proper guidance on how to get out of this.

share|improve this question

migrated from stackoverflow.com Jul 24 '12 at 17:21

This question came from our site for professional and enthusiast programmers.

4  
Why are you learning on 9i - why not something slightly more modern, or at least supported? –  Alex Poole Jul 24 '12 at 16:51
3  
look at express version (xe): oracle.com/technetwork/products/express-edition/overview/… –  tbone Jul 24 '12 at 17:08
2  
You should really (I mean really) use a supported version. –  a_horse_with_no_name Jul 24 '12 at 18:27

1 Answer 1

up vote 1 down vote accepted

First, are you really sure that you want to be starting out with a desupported version of the database that is at least 4 major releases out of date? It would seem much more useful to download a more recent version of Oracle from the Oracle Technology Network (OTN) and to start with that. You can get the express edition of Oracle 11.2 completely free and the enterprise edition is free if you just want to learn the product.

Second, when you installed Oracle, it should have prompted you to create a database as part of the installation process. If you chose not to create a database during the installation process, you should run the Database Creation Assistant (DBCA) to create a database now. Note that what lots of products refer to as a "database" is more like a schema in Oracle. In general, you would only have one Oracle database on your machine though that database may have multiple schemas.

What operating system are you using?

share|improve this answer
    
Thanks @Justin. Actually i was in a situation. and i had only oracle 9i with me. But Thanks to god. i came out from the situation. and now i am going to download oracle 11g. :) –  Abdur Rahim Aug 3 '12 at 10:16

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.