Autor Wątek: ORA-28000: the account is locked - prośba o pomoc (Przeczytany 7993 razy)

Janus · « **dnia:** Maja 30, 2015, 23:15:17 pm »

Witam,
Przed chwilą przy próbie logowania do Someda otrzymałem taki komunikat:
Brak połączenia z serwerem więc nie mam możliwości pracy w Somedzie

Proszę o pomoc. Co jest przyczyną i jakie jest rozwiązanie tej sytuacji?

Rozwiązanie problemu znalazłem tutaj

: https://hecpv.wordpress.com/2014/10/16/how-to-solve-ora-28001-the-password-has-expired/

Unlock the user account.

SQL> ALTER USER user_name ACCOUNT UNLOCK;

Co było przyczyną blokady???

General SQL error.
ORA-28000: the account is locked
Alias: OraBase

Opis wewnętrzny:
PL-A0407;Brak połączenia z bazą danych! Dalsza praca z systemem jest niemożliwa.

Prawdopodobne powody to: nie uruchomiony serwer bazy danych, brak połączenia z serwerem, nie zainstalowane oprogramowanie BDE lub brak SQLLinks dla serwera.

Szczegóły:
General SQL error.
ORA-28000: the account is locked
Alias: OraBase

Alias: GM
User: gabinet

Forma: TfrmKSPL

Ślad wywołania formy:
\frmKSPL

System operacyjny:
Microsoft Windows 7 Professional Service Pack 1 (build 7601), 64-bit

Wykorzystanie pamięci:   39%
Ilość pamięci fizycznej:   4081752 kB (3986 MB)
Wolnej pamięci fizycznej:   2482812 kB (2424 MB)
Wolnych TLSów:   1014

Wersja programu:
System Informatyczny KS-SOMED

Lista modułów (139):
ADVAPI32.dll      6.1.7601.18839      Base: 0x74DB0000
api-ms-win-downlevel-advapi32-l1-1-0.dll      6.2.9200.16492      Base: 0x74EF0000
api-ms-win-downlevel-advapi32-l2-1-0.dll      6.2.9200.16492      Base: 0x74CC0000
api-ms-win-downlevel-normaliz-l1-1-0.dll      6.2.9200.16492      Base: 0x74F90000
api-ms-win-downlevel-ole32-l1-1-0.dll      6.2.9200.16492      Base: 0x750C0000
api-ms-win-downlevel-shell32-l1-1-0.dll      6.2.9200.16492      Base: 0x737A0000
api-ms-win-downlevel-shlwapi-l1-1-0.dll      6.2.9200.16492      Base: 0x77390000
api-ms-win-downlevel-shlwapi-l2-1-0.dll      6.2.9200.16492      Base: 0x6C570000
api-ms-win-downlevel-user32-l1-1-0.dll      6.2.9200.16492      Base: 0x757B0000
api-ms-win-downlevel-version-l1-1-0.dll      6.2.9200.16492      Base: 0x750D0000
apphelp.dll      6.1.7601.18777      Base: 0x724C0000
BANTAM.DLL      1.0.0.8      Base: 0x4E8E0000
bcrypt.dll      6.1.7600.16385      Base: 0x74C60000
borlndmm.dll      5.0.6.18      Base: 0x41000000
CFGMGR32.dll      6.1.7601.17621      Base: 0x76CE0000
CLBCatQ.DLL      2001.12.8530.16385      Base: 0x75110000
comctl32.dll      5.82.7601.18201      Base: 0x6C310000
comctl32.dll      6.10.7601.18807      Base: 0x72950000
comdlg32.dll      6.1.7601.17514      Base: 0x757C0000
credssp.dll      6.1.7601.18839      Base: 0x73790000
CRYPTBASE.dll      6.1.7600.16385      Base: 0x74D30000
cryptdll.dll      6.1.7600.16385      Base: 0x723C0000
CRYPTSP.dll      6.1.7601.18741      Base: 0x71DF0000
cscapi.dll      6.1.7601.17514      Base: 0x723B0000
dbghelp.dll      6.1.7601.17514      Base: 0x72740000
DEVOBJ.dll      6.1.7601.17621      Base: 0x75840000
DNSAPI.dll      6.1.7601.17570      Base: 0x72560000
DSROLE.DLL      6.1.7600.16385      Base: 0x72430000
fwpuclnt.dll      6.1.7601.18283      Base: 0x72460000
GDI32.dll      6.1.7601.18778      Base: 0x74F00000
IDAPI32.DLL      5.1.1.1      Base: 0x4BDE0000
IDR20009.DLL      5.1.1.1      Base: 0x4C9E0000
ieframe.dll      11.0.9600.17801      Base: 0x72B00000
iertutil.dll      11.0.9600.17801      Base: 0x753D0000
IMM32.DLL      6.1.7601.17514      Base: 0x751D0000
IPHLPAPI.DLL      6.1.7601.17514      Base: 0x72930000
kernel32.dll      6.1.7601.18839      Base: 0x75620000
KERNELBASE.dll      6.1.7601.18839      Base: 0x76B90000
KSConect.DLL      16.0.2.26      Base: 0x02440000
KSPL.EXE      18.0.6.662      Base: 0x00400000
KSPLKonfig.DLL      18.1.0.1229      Base: 0x037A0000
KSPLRes.DLL      17.1.6.1558      Base: 0x034B0000
KSPLRtl.dll      18.1.2.801      Base: 0x03850000
LOGONCLI.DLL      6.1.7601.17514      Base: 0x72840000
LPK.dll      6.1.7601.18768      Base: 0x75610000
mlang.dll      6.1.7600.16385      Base: 0x6C3D0000
mpr.dll      6.1.7600.16385      Base: 0x72060000
MSCTF.dll      6.1.7601.18731      Base: 0x76A10000
mshtml.dll      11.0.9600.17801      Base: 0x67D90000
MSIMG32.DLL      6.1.7600.16385      Base: 0x73AC0000
msv1_0.DLL      6.1.7601.18839      Base: 0x723E0000
MSVCP80.dll      8.0.50727.6195      Base: 0x73870000
MSVCR80.dll      8.0.50727.6195      Base: 0x737D0000
msvcrt.dll      7.0.7601.17744      Base: 0x76AE0000
mswsock.dll      6.1.7601.18254      Base: 0x725B0000
napinsp.dll      6.1.7600.16385      Base: 0x72610000
NETAPI32.dll      6.1.7601.17887      Base: 0x728B0000
netutils.dll      6.1.7601.17514      Base: 0x728A0000
NLAapi.dll      6.1.7601.18685      Base: 0x72620000
normaliz.DLL      6.1.7600.16385      Base: 0x75750000
NSI.dll      6.1.7600.16385      Base: 0x751C0000
ntdll.dll      6.1.7601.18839      Base: 0x773C0000
OCI.DLL      11.2.0.1      Base: 0x10000000
odbc32.DLL      6.1.7601.17514      Base: 0x71340000
odbcint.dll      6.1.7600.16385      Base: 0x71420000
ole32.dll      6.1.7601.17514      Base: 0x76820000
oleaut32.dll      6.1.7601.18679      Base: 0x76F30000
oledlg.dll      6.1.7600.16385      Base: 0x6C410000
olepro32.dll      6.1.7601.17514      Base: 0x6C3B0000
oraasmclnt11.dll      11.2.0.2      Base: 0x08DB0000
oracell11.dll      11.1.0.6      Base: 0x08E20000
OraClient11.Dll      11.2.0.2      Base: 0x61C20000
oracommon11.dll      11.2.0.2      Base: 0x60FA0000
oracore11.dll      11.2.0.1      Base: 0x60870000
orageneric11.dll      11.2.0.2      Base: 0x07250000
orahasgen11.dll      11.2.0.1      Base: 0x08920000
oraldapclnt11.dll      10.1.4.0      Base: 0x62530000
oran11.dll      11.2.0.2      Base: 0x07F80000
oranbeq11.dll      11.2.0.2      Base: 0x08FB0000
orancds11.dll      11.2.0.2      Base: 0x07230000
orancrypt11.dll      11.2.0.2      Base: 0x071C0000
oranhost11.dll      11.2.0.2      Base: 0x07210000
oranl11.dll      11.2.0.2      Base: 0x070C0000
oranldap11.dll      11.2.0.2      Base: 0x07140000
oranls11.dll      11.1.0.6      Base: 0x60A80000
orannzsbb11.dll      11.0.0.1      Base: 0x627F0000
oranro11.dll      11.2.0.2      Base: 0x08390000
orantcp11.dll      11.2.0.2      Base: 0x06C40000
orantns11.dll      11.2.0.2      Base: 0x083F0000
oraocr11.dll      11.2.0.1      Base: 0x62AB0000
oraocrb11.dll      11.2.0.1      Base: 0x08D10000
oraocrutl11.dll      11.2.0.1      Base: 0x62B70000
OraPlc11.Dll      11.1.0.6      Base: 0x63060000
oraplp11.dll      11.1.0.6      Base: 0x63080000
orapls11.dll      11.1.0.6      Base: 0x084D0000
oraslax11.dll      11.1.0.6      Base: 0x63420000
orasnls11.dll      11.1.0.6      Base: 0x63430000
orasql11.dll      11.1.0.6      Base: 0x63520000
oraunls11.dll      11.1.0.6      Base: 0x63690000
orauts.dll      11.2.0.1      Base: 0x60EB0000
oravsn11.dll      11.2.0.2      Base: 0x636B0000
oraxml11.dll      11.1.0.6      Base: 0x63750000
orazt11.dll      11.1.0.1      Base: 0x60000000
oraztkg11.dll      11.1.0.1      Base: 0x08420000
pnrpnsp.dll      6.1.7600.16385      Base: 0x725F0000
profapi.dll      6.1.7600.16385      Base: 0x750B0000
PSAPI.DLL      6.1.7600.16385      Base: 0x74FA0000
rasadhlp.dll      6.1.7600.16385      Base: 0x724A0000
RICHED20.DLL      5.31.23.1230      Base: 0x6C1A0000
RPCRT4.dll      6.1.7601.18532      Base: 0x765E0000
RpcRtRemote.dll      6.1.7601.17514      Base: 0x72450000
rsaenh.dll      6.1.7600.16385      Base: 0x71DB0000
SAMCLI.DLL      6.1.7601.17514      Base: 0x72830000
sechost.dll      6.1.7601.18839      Base: 0x751A0000
Secur32.dll      6.1.7601.18839      Base: 0x737C0000
security.dll      6.1.7600.16385      Base: 0x72440000
SETUPAPI.dll      6.1.7601.17514      Base: 0x75230000
shell32.dll      6.1.7601.18762      Base: 0x75990000
SHLWAPI.dll      6.1.7601.17514      Base: 0x76BE0000
SQLORA32.DLL      5.1.0.4      Base: 0x4D5E0000
srvcli.dll      6.1.7601.17514      Base: 0x72880000
SspiCli.dll      6.1.7601.18839      Base: 0x74D40000
urlmon.dll      11.0.9600.17801      Base: 0x766D0000
user32.dll      6.1.7601.17514      Base: 0x74FB0000
USERENV.dll      6.1.7601.17514      Base: 0x75730000
USP10.dll      1.626.7601.18454      Base: 0x76C40000
UxTheme.dll      6.1.7600.16385      Base: 0x6E0D0000
version.dll      6.1.7600.16385      Base: 0x72AF0000
WININET.dll      11.0.9600.17801      Base: 0x76D10000
winmm.dll      6.1.7601.17514      Base: 0x728D0000
WINNSI.DLL      6.1.7600.16385      Base: 0x72920000
winrnr.dll      6.1.7600.16385      Base: 0x72550000
winspool.drv      6.1.7601.17514      Base: 0x6C430000
wkscli.dll      6.1.7601.17514      Base: 0x72870000
WLIDNSP.DLL      7.250.4225.0      Base: 0x72520000
WS2_32.dll      6.1.7601.17514      Base: 0x76EF0000
wship6.dll      6.1.7600.16385      Base: 0x72510000
wshtcpip.dll      6.1.7600.16385      Base: 0x724B0000
wsock32.dll      6.1.7600.16385      Base: 0x72910000

maciejj · « **Odpowiedź #1 dnia:** Maja 30, 2015, 23:46:55 pm »

może trzykrotne błędne logowanie po wygaśnięciu hasła?

https://community.oracle.com/thread/586935

Janus · « **Odpowiedź #2 dnia:** Maja 31, 2015, 00:03:27 am »

Cytat: maciejj w Maja 30, 2015, 23:46:55 pm

może trzykrotne błędne logowanie po wygaśnięciu hasła?

https://community.oracle.com/thread/586935

Dzięki za podpowiedź

Hasło zmieniłem już wcześniej na niewygasające.
Co jeszcze mogę zmienić albo poprawić żeby uniknąć takich niespodzianek?
Niżej są informacje o moim koncie.

SQL> SELECT USERNAME,ACCOUNT_STATUS FROM DBA_USERS;

USERNAME ACCOUNT_STATUS
------------------------------ --------------------------------
SYS OPEN
SYSTEM OPEN
ANONYMOUS OPEN
GABINET OPEN
APEX_PUBLIC_USER LOCKED
FLOWS_FILES LOCKED
APEX_040000 LOCKED
OUTLN EXPIRED & LOCKED
XS$NULL EXPIRED & LOCKED
MDSYS EXPIRED & LOCKED
CTXSYS EXPIRED & LOCKED

USERNAME ACCOUNT_STATUS
------------------------------ --------------------------------
XDB EXPIRED & LOCKED
HR EXPIRED & LOCKED

13 rows selected.

SQL>

Sorn · « **Odpowiedź #3 dnia:** Czerwca 01, 2015, 12:26:59 pm »

Można jeszcze wyłączyć blokowanie konta po trzykrotnie błędnym wpisaniu hasła:
ALTER PROFILE DEFAULT LIMIT FAILED_LOGIN_ATTEMPTS UNLIMITED

Aktualności:

Reklama