Oracle user password contains special characters what should be done with ____oracle

Source: Internet
Author: User
Tags reserved sqlplus
Typically, we set the password to be more complex when setting the Oracle password, which usually consists of an alphanumeric special symbol.
However, when you have special symbols, you may have trouble modifying your password or importing the exported data, which is explained in the following context:
This article takes the special symbol "/" as an example
One, Linux environment, database for oracle10g
1, modify the password

[Oracle@olivenan oracle]$ sqlplus '/as sysdba '

Sql*plus:release 10.2.0.1.0-production on Wed 17 14:33:32 2006

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


Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0-production
With the partitioning, OLAP and Data Mining options
sql> alter user test identified by AA/AA;

Alter user test identified by AA/AA
*
ERROR at line 1:
ora-00922:missing or Invalid option

Here you should use the ""
sql> alter user test identified by "AA/AA";

User altered.

Sql>


[Oracle@olivenan oracle]$ exp TEST/AA/AA file=test.dmp buffer=65536

Export:release 10.2.0.1.0-production on Wed 17 14:32:10 2006

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


Exp-00004:invalid Username or password
Username:

You should escape using "process password, use '" to process user name and password

[Oracle@olivenan oracle]$ exp ' test/' AA/AA ' file=test.dmp buffer=65536

Export:release 10.2.0.1.0-production on Wed 17 14:32:52 2006

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


Connected to:oracle Database 10g Enterprise Edition Release 10.2.0.1.0-production
With the partitioning, OLAP and Data Mining options
Export done in We8iso8859p1 character set and Al16utf16 NCHAR character set

About to export specified users ...
. Exporting Pre-schema procedural objects and actions

...............

Export successful, omitted here

Second, under Windows XP, the database is oracle9i


C:\Documents and Settings\w>sqlplus/nolog

Sql*plus:release 9.2.0.1.0-production on Wed 17 14:56:34 2006

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

Sql> Connect Sys/olivenan as Sysdba
Connected.
sql> alter user test identified by AA/AA;
Alter user test identified by AA/AA
*
ERROR at line 1:
ora-00922:missing or Invalid option

Here, use the
sql> alter user test identified by "AA/AA";

User altered.

Sql>

Microsoft Windows XP [version 5.1.2600]
(C) Copyright 1985-2001 Microsoft Corp.

C:\Documents and Settings\w>exp Test/aa/aa file=aa.dmp buffer=65536

Export:release 9.2.0.1.0-production on Wed 17 14:58:50 2006

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.


Exp-00004:invalid Username or password
Username:
Password:
Exp-00056:oracle Error 1017 encountered
Ora-01017:invalid Username/password; Logon denied
Username: ^z^z

Exp-00030:unexpected End-of-file encountered while reading input
Exp-00000:export terminated unsuccessfully

Use "" "" "to process user passwords here

C:\Documents and Settings\w>exp test/"" "Aa/aa" "" File=aa.dmp buffer=65536

Export:release 9.2.0.1.0-production on Wed 17 14:59:10 2006

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.


Connected to:oracle9i Enterprise Edition release 9.2.0.1.0-production
With the partitioning, OLAP and Oracle Data Mining options
Jserver Release 9.2.0.1.0-production
Export done in We8iso8859p1 character set and Al16utf16 NCHAR character set
Server uses ZHS16GBK character set (possible charset conversion)

About to export specified users ...
. Exporting Pre-schema procedural objects and actions
. Exporting foreign function library names for user test
. Exporting public type synonyms
. Exporting private type synonyms
. Exporting object type definitions for user test
About to export test ' s objects ...
. Exporting database Links
. Exporting sequence Numbers

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.