OraFAQ Forum: SQL & PL/SQL » ORA-00988: missing or invalid password(s)

Home » SQL & PL/SQL » SQL & PL/SQL » ORA-00988: missing or invalid password(s) (Oracle 11gr2,Linux 6)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ORA-00988: missing or invalid password(s) [message #601029]

Thu, 14 November 2013 21:20

Jack14
Messages: 497
Registered: December 2011
Location: INDIA

Senior Member

Hi,

When i try to reset application password in database, i get following error message.

Code: [Select all] [Show/ hide]

SQL> alter user jack identified by 'p!Al1234';
alter user jack identified by 'p!Al1234'
                                *
ERROR at line 1:
ORA-00988: missing or invalid password(s)

Kindly suggest how to fix ?

Thanks

Report message to a moderator

Re: ORA-00988: missing or invalid password(s) [message #601030 is a reply to message #601029]

Thu, 14 November 2013 21:26

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>Kindly suggest how to fix ?
only use valid password or enclose in double quote marks & then be prepared to do so everytime in the future.

BTW in V11 passwords default to be CaSeSenSiTiVe

Report message to a moderator

Re: ORA-00988: missing or invalid password(s) [message #601032 is a reply to message #601030]

Thu, 14 November 2013 23:20

Jack14
Messages: 497
Registered: December 2011
Location: INDIA

Senior Member

Thanks Blackswan,

Quote:

only use valid password or enclose in double quote marks & then be prepared to do so everytime in the future.

I am able to reset the password using double quote.Its working for me.

Quote:

BTW in V11 passwords default to be CaSeSenSiTiVe

Can you explain what it is ?

Report message to a moderator

Re: ORA-00988: missing or invalid password(s) [message #601056 is a reply to message #601032]

Fri, 15 November 2013 02:00

Littlefoot
Messages: 21824
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Earlier versions didn't care about letter case, so these three passwords were identical:
password = PASSWORD = PassWord

Since 11g, these three are different so you have to pay attention when creating a password and remembering how you wrote it (otherwise you won't be able to establish connection).

Report message to a moderator