Shulou(Shulou.com)05/31 Report--

This article mainly explains "oracle user password settings can not have special characters", interested friends may wish to take a look. The method introduced in this paper is simple, fast and practical. Let's let the editor take you to learn why oracle user password settings can't have special characters.

When oracle users have passwords such as @, $,! Some problems occur when waiting for special characters.

Take hr users as an example:

When oracle users have @ in their passwords:

SYS@ORCL > alter user hr identified by qwet@2017

Alter user hr identified by qwet@2017

*

ERROR at line 1:

ORA-00922: missing or invalid option

SYS@ORCL > alter user hr identified by 'qwet@2017'

Alter user hr identified by 'qwet@2017'

*

ERROR at line 1:

ORA-00988: missing or invalid password (s)

SYS@ORCL > alter user hr identified by "qwet@2017"

User altered.

To change the password, you need to use double quotes to include the password.

[oracle@hhu Desktop] $sqlplus hr/qwet@2017

SQL*Plus: Release 11.2.0.4.0 Production on Thu Sep 7 10:09:09 2017

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

ERROR:

ORA-12543: TNS:destination host unreachable

Enter user-name:

[oracle@hhu Desktop] $sqlplus' hr/ "qwet@2017"'

SQL*Plus: Release 11.2.0.4.0 Production on Thu Sep 7 10:08:28 2017

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

Connected to:

Oracle Database 11g Enterprise Edition Release 11.2.0.4.0-64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

HR@ORCL >

When you need to fill in a user name and password in a linux script or shell, modify it slightly in the following format

User name / password, plus a pair of single quotation marks and a pair of double quotation marks

When in use! When:

HR@ORCL > alter user hr identified by qwetbacks 2017

Alter user hr identified by qwet!2017

*

ERROR at line 1:

ORA-00922: missing or invalid option

HR@ORCL > alter user hr identified by "qwetbacks 2017"

User altered.

[oracle@hhu Desktop] $sqlplus' hr/ "qwetbacks 2017"

SQL*Plus: Release 11.2.0.4.0 Production on Thu Sep 7 10:01:38 2017

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

Connected to:

Oracle Database 11g Enterprise Edition Release 11.2.0.4.0-64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

HR@ORCL >

When using $:

HR@ORCL > alter user hr identified by qwet$2017

User altered.

HR@ORCL > conn hr/qwet$2017

Connected.

[oracle@hhu Desktop] $sqlplus hr/qwet$2017

SQL*Plus: Release 11.2.0.4.0 Production on Thu Sep 7 10:00:21 2017

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

ERROR:

ORA-01017: invalid username/password; logon denied

Enter user-name:

[oracle@hhu Desktop] $sqlplus hr/ "qwet$2017"

SQL*Plus: Release 11.2.0.4.0 Production on Thu Sep 7 10:00:35 2017

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

ERROR:

ORA-01017: invalid username/password; logon denied

Enter user-name:

[oracle@hhu Desktop] $sqlplus' hr/ "qwet$2017"'

SQL*Plus: Release 11.2.0.4.0 Production on Thu Sep 7 10:00:44 2017

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

Connected to:

Oracle Database 11g Enterprise Edition Release 11.2.0.4.0-64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

HR@ORCL >

At this point, I believe that everyone on the "oracle user password settings why can not have special characters" have a deeper understanding, might as well to the actual operation of it! Here is the website, more related content can enter the relevant channels to inquire, follow us, continue to learn!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.