Create a username & password????

[jgoodman00]

OK, as my other posts will prove, I have never used oracle before. I am experimenting with it a little though, because we are thinking of switching to it to store our data (we currently use access). I have bought a couple of books (oracle dba 101 & oracle 8i: a beginners guide). I have now managed to install the enterprise edition with no trouble, & can easily create new databases, or modify existing ones. However I cannot log into any of them. I cannot remember at any stage being asked to enter an administrator username/password. So, I went into the oracle administration assistant for windows NT & have made sure that my user name (james) is shown as a valid database administrator. The help file then says you click on Connect, & are prompted for a username/password. I have never been asked to create a username/password, so how do I find out what it is, or how do I create a new one???


Thanks in advance.... James Goodman
j.goodman00@btinternet.com

 

[karluk]

Most likely you have a database with just the default Oracle ids: internal, sys, and system. The default passwords are

internal - Oracle
sys - change_on_install
system - manager

I fear that you will have other issues as well. In particular you probably need to configure Net8. I would try one of the default ids and see how far you get. We can take it from there.

 

[wushutwist]

You will not need a listener if you are physically on the machine where Oracle is installed. Just set the ORACLESID environment variable and run your favorite program (sqlplus or svrmgr depending on the version of Oracle). This bypasses the need for a listener but as I mentioned it is only for localhost connections. The administrator passwords are as karluk mentioned.

Here is an example in NT on a database named PROD.

C:>  set ORACLESID=PROD
C:>  sqlplus scott/tiger

Wushutwist

 

[Leon1977]

firs log as user->system pass->manager
then create a user for you to use...
make sure you give it a DBA role with admin option...
and change the passwords for internal, sys and system
later because they are default ones and everybody knows them..
leo

 

[raygg]

There are some default users that automatically install with 817 that have DBA role. After you connect to the database start up dba studio - connect - go to security on your db - and drill down into the roles for each user. A couple of them - like dbnsmp and ctx... (I forget the spelling) have passwords that are the same as their names but they also have DBA powers. Change these passwords too.