This discussion is archived
4 Replies Latest reply: Dec 3, 2012 4:24 AM by Sunny kichloo RSS

ORA-28001: the password has expired

977082 Newbie
Currently Being Moderated
Good morning friends, I am new to the forum and starting to tinker with the oracle,

here with a call to the gig w / change password of a user that has expired

linux server with oracle

wanted to know how to change the password on this guy, as I am new at this and oracle production to posting p / not do shit hehe

ORA-28001: the password has expired

if anyone can help, I thank



Mensagempor julian on Thu, 29 Nov 2012 3:11 pm
I configured the tnsnames.ora here in my oracle on linux

But I can not connect to the server, what am I doing wrong?

oracle @ zeus ~ / app/oracle/product/11.2.0/dbhome_1/network/admin $ sqlplus / nolog

SQL * Plus: Release 11.2.0.1.0 Production on Thu Nov 29 16:09:38 2012

Copyright (c) 1982, 2009, Oracle. All rights reserved.

SQL> connect system
Enter password:
ERROR:
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux-x86_64 Error: 2: No such file or directory
Process ID: 0
Session ID: 0 Serial number: 0


SQL>



Dedalus admin # sqlplus

SQL * Plus: Release 11.2.0.1.0 Production on Thu Nov 29 16:17:53 2012

Copyright (c) 1982, 2009, Oracle. All rights reserved.

Enter user-name: system
Enter password:
ERROR:
ORA-28000: the account is locked

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points