hello guys, before write this article i had been trained for oracle 10g with the pl/sql and oracle form above 10 days and more, in many days i past it. i got some problem like the title said. in the first trained i must to create a new database in oracle 10g, differing with the other database, like MS SQL SERVER we cannot just click next, but some little think we must to concentration in some case, like the password for sys,system,etc (we must focus in this one because if you forgot or not write the password we cannot pass to SQL*PLUS to unlock the scott "user" or create the user to access the database, for the dispensation we must delete the database and create the new one) ,the other one is the unlock check box in the password management, if we don't uncheck for the scott "user" or the other "user" you want to unlock in the SQL*PLUS you can't use that's user because it's will be locked.
in that case you may use SQL*PLUS and login with SYS or SYSTEM and the password is the password that u write for that database when you do the created database wizard. after that i want you to use this step for unlock the user that you want it.
examples, in SQL*PLUS:
SQL> user scott identified by tiger account unlock;
or
SQL> user
if you want to lock the scott "user" with the in SQL*PLUS, use this statement
SQL> --lock scott first
or
SQL> --lock
well, i hope guy's who need this article will be seen it and can solve the problem...
thank's alot for read this article, see you in my next article
Tidak ada komentar:
Posting Komentar