password expired

Scripts Diversos para o Oracle SQL*Plus. (Relacionado a ferramenta Oracle SQL*Plus, para questões de SQL, usar o forum SQL)
Post Reply
julian
Rank: Estagiário Sênior
Rank: Estagiário Sênior
Posts: 12
Joined: Tue, 27 Nov 2012 2:55 pm

Good morning friends, I'm new to the forum and I'm starting to mess with Oracle,

to with a call here in the trap to exchange a password of a user who expired
Linux server Oracle
wanted to know how to change the password of this guy, as I am new and the Oracle is in production to posting to not make shit hehe

Select all

ORA-28001: the password has expired
if anyone can Help, I thank
julian
Rank: Estagiário Sênior
Rank: Estagiário Sênior
Posts: 12
Joined: Tue, 27 Nov 2012 2:55 pm

I set the tnnames.ora in my Oracle here on Linux

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

Select all

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>
julian
Rank: Estagiário Sênior
Rank: Estagiário Sênior
Posts: 12
Joined: Tue, 27 Nov 2012 2:55 pm

Select all

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
And now, I block the SYSTEM account !! : x
Trevisolli
Moderador
Moderador
Posts: 2016
Joined: Wed, 12 Jan 2005 3:25 pm
Location: Araraquara - SP
Abraço,

Trevisolli
OCA Oracle PL/SQL Developer Certified Associate
OCP Oracle Forms Developer Certified Professional
Araraquara-SP

Brother, are you performing the instruction directly on the BD server?

Positive case, you can use:

Select all

 
connect / as sysdba; 
and give an alter in the System password.
(the ideal would be to check if, by misunderstanding, this password that expired is not hard code in no process there).
julian
Rank: Estagiário Sênior
Rank: Estagiário Sênior
Posts: 12
Joined: Tue, 27 Nov 2012 2:55 pm

Obirged Trevisolli, I was able to enter the bank and change the password!

vlw
julian
Rank: Estagiário Sênior
Rank: Estagiário Sênior
Posts: 12
Joined: Tue, 27 Nov 2012 2:55 pm

Incredible that it seems, I can not connect on the bank anymore, I set up my tnsnames.ora the same as the server, but this error appears:

Select all

oracle@zeus ~$ sqlplus  
 
SQL*Plus: Release 11.2.0.1.0 Production on Thu Jan 10 09:16:52 2013 
 
Copyright (c) 1982, 2009, Oracle.  All rights reserved. 
 
Enter user-name: 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
julian
Rank: Estagiário Sênior
Rank: Estagiário Sênior
Posts: 12
Joined: Tue, 27 Nov 2012 2:55 pm

Do I need to start a service?

I am only the customer, trying to connect to the server.
danielpbarros
Rank: Programador Sênior
Rank: Programador Sênior
Posts: 67
Joined: Sun, 15 Jan 2012 9:34 pm
Contact:
Daniel Barros

Check your tnsnames.ora and then if the services are active.
I spent once for this message that appears to you, and in my case the problem was in the Oracle directory in the Linux operating system (which is what you use).
Maybe you must recreate the folders.

is the tip.
Hugs.
Daniel.
Post Reply
  • Information
  • Who is online

    Users browsing this forum: No registered users and 3 guests