Win a copy of Murach's Python Programming this week in the Jython/Python forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

Help me out of the Oracle Issue it might stop my studies  RSS feed

Agunbiade Ademola
Ranch Hand
Posts: 35
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I came to JavaRanch I seek for how to download and install Oracle and i did as i was told i downloaded it and install it but one thing left how to long in? Throught the installation i can't find anything like Username only what i can find there is Global Database name and password, during the DataBase Configuration Assistant I can notice the registration prompt me Administrative password which I type in but when I try to long in it prompt me error, I log in like this:

username: sysdba
password: *********

yet It prompt me error of either the user name or the password is incorrect,

this are the errors it prompt me doring installation

[INS-20802]Oracle Net Configuration Assistant failed

The installation of Oracle Database was successful, but some configuration assistant failed, were canceled or skipped
Configure database with Database Control requires a listener to be configure in the current oracle home.You need to run Necta to configure a listener before you can proceed. Otherwise you may choose to continue without Database Control configuration

You can retry configuration this database with Enterprise Manager later by manually running C:\app\ADEBIADE\product\11.2.0\dbhome_3\bin\emca script

For all this files directory error above i discover that those files are in the BIN folder so I copy the directory to my path. please if there is any other way out of this explain to me i think it was my password failing. and my Global Database name is oracl.sysdba
Martin Vajsar
Posts: 3752
Chrome Netbeans IDE Oracle
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
1) Incorrect password:

"sysdba" is a role in Oracle, not a username. You should be able to log in with the "system" username, for which you have specified the password during database creation.

Warning: don't create any tables or views using the "system" account. Create your own account and put all your objects there. System is special, if you put your tables there and load a lot of data in them, you might allocate space to the system tablespace, which is difficult to reverse. If you put all your work under your own account, it is then very easy to throw away everything (just by dropping the user) and start again, but it is more work under the system account. And there are security considerations too.

2) Error during installation:

I believe the files listed are just informational messages about them being installed. As far as I know, they don't belong to the Net Configuration Assistant specifically. If you put these directories in your PATH variable manually, I'd suggest to remove them. It shouldn't hurt, but one never knows.

The Net Configuration Assistant helps you set up listeners and TNSNames; a default listener should be created automatically with your database and you shouldn't need to worry about it now, and the TNSNames are not needed if you connect locally using SQLPlus and other Oracle tools. In any case, you should be able to run the Net Configuration Assistant from your start menu manually, perhaps it will say some more specific error message.

Do you have some tutorial or textbook to follow? Oracle isn't exactly easy to start with.
chris webster
Posts: 2407
Linux Oracle Postgres Database Python Scala
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
If you're going to do a lot of work with Oracle RDBMS, you should also register with the Oracle Technet site where you can find lots of forums, documentation and tips on using Oracle.
It is sorta covered in the JavaRanch Style Guide.
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!