Resolving ORACLE ERROR:ORA-20000: the account is locked

From your command prompt, type

sqlplus "/ as sysdba"

Once logged in as SYSDBA, you need to unlock the hr account

SQL> alter user hr account unlock;
SQL> grant connect, resource to hr;

Comments

Post a Comment

Popular posts from this blog

There was a problem saving your changes. Please try again later.

There was a problem saving your changes. Please try again later. When I try to save settings of my facebook app. I got the above error. It occurred when I try to save Secure Canvas URL field. And then I used port number of 443 with my url. For example if my Secure Canvas URL is  https://dl.dropbox.com/u/38102629/index.html?  I added port number and my canvas url is  https://dl.dropbox.com :443 /u/38102629/index.html? And error went away.
Read more

Fatal: LoadModule: error loading module 'mod_sql_mysql.c'

I tried to install proftpd in webmin and I broke ftp in zpanel. I got following error message when I run proftpd command. root@Ubuntu12:~# proftpd Ubuntu12 proftpd[1400]: Fatal: LoadModule: error loading module 'mod_sql_mysql.c': Operation not permitted on line 38 of '/etc/zpanel/configs/proftpd/proftpd-mysql.conf' And I searched everywhere but I couldn't find anything. But following command make my error vanish .  apt-get install proftpd-mod-mysql If it asked what mode, choose 'stand-alone'. root@Ubuntu12:~# proftpd And it must be running.
Read more